Hello 2013/3/8 Bradley Russell <bradley.russ...@npcinternational.com>: > 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 pgadmin it runs in around 10 – 15 > minutes. > > > > When we run the same stored procedure through our c++ program that is using > libpq it takes 1 hour. > > > > Anyone have some insight on what could be the difference? >
It is really strange - I never seen this issue. Can you send a test example or can you send source code? Regards Pavel Stehule > > > Thanks, > Brad -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
