Hi all,
Our system has a postgres database that has a table for statistic which is
updated every hour by about 10K clients. Each client only make update to its
own row in the table. So far I am only seeing one core out of eight cores on
my server being active which tells me that the update is bein
GE plpgsql VOLATILE
COST 100;
On Fri, Mar 18, 2011 at 12:06 PM, Kevin Grittner <
kevin.gritt...@wicourts.gov> wrote:
> [rearranged - please don't top-post]
>
> [also, bringing this back to the list - please keep the list copied]
>
> Red Maple wrote:
> > Kev
Hi,
I have found the bug in my code that made the update to the same row in the
table instead of two different row. Now I have all cores up and running
100%.
Thank you for all your help.
On Fri, Mar 18, 2011 at 3:21 PM, Kevin Grittner wrote:
> Red Maple wrote:
>
> > Here is my fu