From: Marcin Mank <marcin.mank@gmail.com>
To: Matthew Schumacher <matt.s@aptalaska.net>
To: pgsql-performance@postgresql.org
Subject: Re: Problems with inconsistant query performance.
Date: Thu, 28 Sep 2006 14:42:32 +0200
Message-ID: <1c9501c6e2fb$91e30200$0c67a8c0@maniek> (raw)
References: <451AC4E2.90106@aptalaska.net>
> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: marcin.mank@gmail.com, matt.s@aptalaska.net
Subject: Re: Problems with inconsistant query performance.
In-Reply-To: <1c9501c6e2fb$91e30200$0c67a8c0@maniek>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox