Re: Simulating Clog Contention - Mailing list pgsql-hackers

From Merlin Moncure
Subject Re: Simulating Clog Contention
Date
Msg-id CAHyXU0zknDE9nwq=+9uPNfu471_ip1BD8hfVf4GhiZ8Oja3m0Q@mail.gmail.com
Whole thread Raw
In response to Re: Simulating Clog Contention  (Abhijit Menon-Sen <ams@toroid.org>)
Responses Re: Simulating Clog Contention  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
On Thu, Jan 26, 2012 at 8:18 AM, Abhijit Menon-Sen <ams@toroid.org> wrote:
> This is just to confirm that the patch applies and builds and works
> fine (though of course it does take a long time… pity there doesn't
> seem to be any easy way to add progress indication like -i has).

On any non server grade hardware you'd probably want to disable
synchronous_commit while loading.  FWIW, this is a great addition to
pgbench.

merlin


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Different error messages executing CREATE TABLE or ALTER TABLE to create a column "xmin"
Next
From: Abhijit Menon-Sen
Date:
Subject: Re: Should we add crc32 in libpgport?