[Spacewalk-list] Postgresql slowness

[John Hodrien]

On Thu, 21 Jul 2011, Jonathan Hoser wrote:


> My config lines:
> shared_buffers = 12GB
> temp_buffers = 64MB
> work_mem = 32MB
> maintainance_work_mem = 32GB
> fsync = off
> synchronous_commit = off
> checkpoint_segments = 30
>
>
> I have not set 'wal_buffers' and 'effective_cache_size' so I guess these
> are at default levels.
> Files reside on a software (LVM) Raid1 consisting of two 1TB SATA drives.

So you've got a beefy machine for postgres, and you don't particularly care
about corruption of the database?

I thought fsync = off was for people who don't really want a database all that
much?

jh