On Wed, Apr 26, 2006 at 10:43:48AM -0400, Michael Stone wrote:
>patch a 512k blocksize would get ~100MB/s. I'm now watching to see how
>it does over a couple of days on real-world workloads.
I've got one DB where the VACUUM ANALYZE generally takes 11M-12M ms;
with the patch the job took 1.7M ms. Another VACUUM that normally takes
between 300k-500k ms took 150k. Definately a promising addition.
In response to
pgsql-performance by date
|Next:||From: andremachado||Date: 2006-04-27 12:32:31|
|Subject: Firebird 1.5.3 X Postgresql 8.1.3 (linux Firebird 1.5.3 X Postgresql 8.1.3 (linux and and windows)]|
|Previous:||From: Guillaume Smet||Date: 2006-04-27 09:26:18|
|Subject: Re: how unsafe (or worst scenarios) when setting fsync OFF for postgresql|