We have a stored procedure that takes two integers as parameters, a start date
and a stop date.
It runs some calculations on a table and updates some columns in the same table.
The table being updated is partitioned.
The server version is 9.1.8.
When we run this stored procedure through pgadmi
. We can
see the query running in server status on the server for the entire hour.
We have also tried it in different orders so we don't believe it is a caching
effect.
Thanks,
Bradley Russell
Programmer
NPC International
-Original Message-
From: Pavel Stehule [mailto:pavel
, March 08, 2013 11:09 AM
To: Bradley Russell
Cc: PostgreSQL General (pgsql-general@postgresql.org)
Subject: Re: [GENERAL] stored procedure slower when called through c client
than pgadmin
2013/3/8 Bradley Russell :
> I will see if I can strip the code down more to a smaller sample. It is part
unk:1996
Date/time type storage: floating-point numbers
Maximum length of locale name:128
LC_COLLATE: English_United States.1252
LC_CTYPE: English_United States.1252
Thanks,
Bradley Russell
Programmer
NPC International
-
We had the same problem recently on our data warehouse.
Check out the reindex and cluster commands.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Schwenker,
Stephen
Sent: Monday, December 04, 2006 9:56 AM
To: pgsql-general@PostgreSQL.org
Subject: [G
