Skip site navigation (1) Skip section navigation (2)

Re: Problems with inconsistant query performance.

From: "Marcin Mank" <marcin(dot)mank(at)gmail(dot)com>
To: "Matthew Schumacher" <matt(dot)s(at)aptalaska(dot)net>,<pgsql-performance(at)postgresql(dot)org>
Subject: Re: Problems with inconsistant query performance.
Date: 2006-09-28 12:42:32
Message-ID: 1c9501c6e2fb$91e30200$0c67a8c0@maniek (view raw or flat)
Thread:
Lists: pgsql-performance
> 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? ) .

Greetings
Marcin


In response to

Responses

pgsql-performance by date

Next:From: Matthew SchumacherDate: 2006-09-28 15:18:37
Subject: Re: Problems with inconsistant query performance.
Previous:From: Jignesh K. ShahDate: 2006-09-28 12:35:36
Subject: Re: slow i/o

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group