Re: [GENERAL] stored procedure slower when called through c client than pgadmin

2013-03-08 Thread Bradley Russell
, 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

Re: [GENERAL] stored procedure slower when called through c client than pgadmin

2013-03-08 Thread Pavel Stehule
Message- > From: Pavel Stehule [mailto:pavel.steh...@gmail.com] > Sent: Friday, March 08, 2013 10:56 AM > To: Bradley Russell > Cc: PostgreSQL General (pgsql-general@postgresql.org) > Subject: Re: [GENERAL] stored procedure slower when called through c client > than pgadmin > >

Re: [GENERAL] stored procedure slower when called through c client than pgadmin

2013-03-08 Thread Bradley Russell
.steh...@gmail.com] Sent: Friday, March 08, 2013 10:56 AM To: Bradley Russell Cc: PostgreSQL General (pgsql-general@postgresql.org) Subject: Re: [GENERAL] stored procedure slower when called through c client than pgadmin Hello 2013/3/8 Bradley Russell : > We have a stored procedure that takes two int

Re: [GENERAL] stored procedure slower when called through c client than pgadmin

2013-03-08 Thread Pavel Stehule
Hello 2013/3/8 Bradley Russell : > 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