Skip site navigation (1) Skip section navigation (2)

Re: Postgres performance Linux vs FreeBSD

From: Andrew - Supernews <andrew+nonews(at)supernews(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Postgres performance Linux vs FreeBSD
Date: 2007-02-27 17:56:25
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
On 2007-02-21, Mark Kirkwood <markir(at)paradise(dot)net(dot)nz> wrote:
> With respect to 'select count(*) from ...' being slower on FreeBSD, 
> there are a number of things to try to make FreeBSD faster for this sort 
> of query. Two I'm currently using are:
> - setting sysctl vfs.read_max to 16 or 32
> - rebuilding the relevant filesystem with 32K blocks and 4K frags

Be aware that increasing the filesystem block size above 16k is _known_
to tickle kernel bugs - there is a workaround involving increasing
BKVASIZE, but this isn't a config parameter and therefore you have to
patch the sources.

The symptom to look for is: largescale filesystem deadlocks with many
processes (especially syncer) blocked in "nbufkv" state.

Andrew, Supernews - individual and corporate NNTP services

In response to

pgsql-performance by date

Next:From: Jim C. NasbyDate: 2007-02-27 18:26:22
Subject: [ Progress on scaling of FreeBSD on 8 CPU systems]
Previous:From: Scott MarloweDate: 2007-02-27 17:56:07
Subject: Re: Opinions on Raid

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group