stored procedure slower when called through c client than pgadmin

Поиск
Список
Период
Сортировка
От Bradley Russell
Тема stored procedure slower when called through c client than pgadmin
Дата
Msg-id 6254BDD3AD8F7A46B433130E685A4029485B80EA@CH1PRD0611MB431.namprd06.prod.outlook.com
обсуждение исходный текст
Ответы Re: stored procedure slower when called through c client than pgadmin
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Grant - create schema permission for a user
Следующее
От: akp geek
Дата:
Сообщение: Re: Replication stopped on 9.0.2 after making change to conf file