stored procedure slower when called through c client than pgadmin

From: Bradley Russell <bradley(dot)russell(at)npcinternational(dot)com>
To: "PostgreSQL General (pgsql-general(at)postgresql(dot)org)" <pgsql-general(at)postgresql(dot)org>
Subject: stored procedure slower when called through c client than pgadmin
Date: 2013-03-08 16:11:13
Message-ID: 6254BDD3AD8F7A46B433130E685A4029485B80EA@CH1PRD0611MB431.namprd06.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Thanks,
Brad

Responses

Browse pgsql-general by date

  From Date Subject
Next Message akp geek 2013-03-08 16:53:48 Re: Replication stopped on 9.0.2 after making change to conf file
Previous Message Adrian Klaver 2013-03-08 15:30:09 Re: Grant - create schema permission for a user