postgresql-performance using sysbench

[Darcy Buskermolen]

On Monday 28 January 2008 09:25:13 Ivan Voras wrote:
> Claus Guttesen wrote:
> > Ubuntu 7.10:
> >
> > grep "transactions:" sysbench-clients-24|sort
> > transactions:                        10000  (2354.49 per sec.)
> > transactions:                        10001  (2126.28 per sec.)
> > transactions:                        10001  (2215.52 per sec.)
> > transactions:                        10001  (2236.03 per sec.)
> >
> > FreeBSD 7.0 stable as of Jan. 28'th:
> >
> > grep "transactions:" sysbench-clients-24|sort
> > transactions:                        10001  (1600.36 per sec.)
> > transactions:                        10002  (1963.95 per sec.)
> > transactions:                        10005  (1973.17 per sec.)
> >
> > In other runs FreeBSD also seems to trail Ubuntu. Are there any knobs
> > I could try on FreeBSD?
>
> I think the excellent results Kris got with FreeBSD were significantly
> helped by patching postgresql to remove setproctitle(). 

You don;t need to patch postgresql for that, all you need to do is turn that 
off. 

update_process_title = off in postgresql.conf and then restart the daemon.

> Other than that, 
>   from the sysbench line I see this is OLTP benchmark which should mean
> a lot of write transactions, and I've consistently seen much better file
> system write performance on Linux than on FreeBSD. No tuning can help here.



-- 
Darcy Buskermolen
Command Prompt, Inc.
+1.503.667.4564 X 102
http://www.commandprompt.com/
PostgreSQL solutions since 1997