| From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
|---|---|
| To: | Bradley Russell <bradley(dot)russell(at)npcinternational(dot)com> |
| Cc: | "PostgreSQL General (pgsql-general(at)postgresql(dot)org)" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: stored procedure slower when called through c client than pgadmin |
| Date: | 2013-03-08 16:56:01 |
| Message-ID: | CAFj8pRAim0po+VOub_yOgzaG-9BJR0damWqyqQo5NsHh939x-A@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hello
2013/3/8 Bradley Russell <bradley(dot)russell(at)npcinternational(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bradley Russell | 2013-03-08 17:03:41 | Re: stored procedure slower when called through c client than pgadmin |
| Previous Message | akp geek | 2013-03-08 16:53:48 | Re: Replication stopped on 9.0.2 after making change to conf file |