> So the question is why on a relatively simple proc and I getting a query
> performance delta between 3549ms and 7ms?
What version of PG is it?
I had such problems in a pseudo-realtime app I use here with Postgres, and
they went away when I moved to 8.1 (from 7.4). I guess it is better shared
buffer management code (don`t You see a
big_query_searching_through_half_the_db just before You get this slow
insert? ) .
In response to
pgsql-performance by date
|Next:||From: Matthew Schumacher||Date: 2006-09-28 15:18:37|
|Subject: Re: Problems with inconsistant query performance.|
|Previous:||From: Jignesh K. Shah||Date: 2006-09-28 12:35:36|
|Subject: Re: slow i/o|