terrible performance in 6.1beta4

[Kris Kennaway]

On Thu, Mar 30, 2006 at 09:41:51PM +0200, usleepless at gmail.com wrote:
> Miguel,
> 
> > 3.0G
> 
> i looked at your top-screenshot, i have the impression you could
> dedicate far more memory to postgresql. maybe it would be usefull to
> post your postgresql.conf ( this is in fact a postgresql question, but
> i don't care ).
> 
> you might want to turn fsync off, my limited knowledge about this
> switch tells me it is only important in case of powerfailures.
> 
> you want to give postgresql as much memory as it needs, cause else it
> will underperform heavily. this might be one of the reasons it is not
> catching on as quick as i would like. postgresql is the best in OSS
> though.

Yes, this is my impression of the problem too.  Any time your process
is waiting on disk I/O it is going to perform terribly (on any OS -
disks are slow), and the way to fix this is to make sure it does as
little I/O as possible (by allowing everything to be cached in RAM).

Kris
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
Url : http://lists.freebsd.org/pipermail/freebsd-questions/attachments/20060330/0d17d9f3/attachment.pgp