Hello.
Suppose I perform 1000 RANDOM writes into a file. These writes are saved
into Linux writeback buffer and are flushed to the disc asynchronously,
that's OK.
The question is: will physical writes be performed later in the sequence of
physical SECTOR position on the disc (minimizing head
if synchronous_commit is off and there are
no locking between transactions? In which cases these operations lost their
deterministic time (in theory) and may slowdown in 100-1000 times?
On Wed, Jan 7, 2009 at 10:54 PM, da...@lang.hm wrote:
On Wed, 7 Jan 2009, Dmitry Koterov wrote:
Hello.
Suppose
INSERT/UPDATE time or, at least, make it
more predictable.
Could you please give an advice how to achieve this?
On Mon, Dec 29, 2008 at 1:04 AM, Greg Smith gsm...@gregsmith.com wrote:
On Fri, 26 Dec 2008, Dmitry Koterov wrote:
checkpoint_timeout = 1min
Your system is having a checkpoint every
Hello.
(Sorry, I have sent this letter to pgsql-general@ first and only then -
noticed that there is a special performance mailing list. So I post it here
now.)
I am trying to tune PostgreSQL write parameters to make writing operation
fast on a heavy-loaded database (a lot of inserts/updates).