Le 31/07/09 08:37, Zdenek Kotala a écrit :
Hello,
The main problem with databasases on ZFS is that ZFS does not like
synchronous writes. If you want to use ZFS for PostgreSQL or any other
database you need tune ZFS and PostgreSQL configuration
Thanks for your kind attention, I already red some of these posts and I
did some tweaking, maybe wrongly ?
I have installed postgresql data on two different datasets :
NAME TYPE USED AVAIL REFER RECSIZE
MOUNTPOINT
data/postgres84 filesystem 440M 650G 148M 128K
/data/postgres84
data/postgres84/8k filesystem 205M 650G 119M 8K
/data/postgres84/8k
The tables I'm querying are on a tablespace on the 8k recsize dataset
I changed some parameters in postgresql.conf, namely :
shared_buffers = 128MB # default 32MB
wal_buffers = 128kB # default 64kB
checkpoint_segments = 32 # default 3
Fsync is on.
The performance was much better, more or less the same as my laptop. But
no better !
Any ideas ?
Bruno
_______________________________________________
opensolaris-discuss mailing list
opensolaris-discuss@opensolaris.org
