Re: Pgsql (and mysql) benchmark on T2000/Solaris and some - Mailing list pgsql-performance

From Florian Weimer
Subject Re: Pgsql (and mysql) benchmark on T2000/Solaris and some
Date
Msg-id 8764k3uc22.fsf@mid.deneb.enyo.de
Whole thread Raw
In response to Re: Pgsql (and mysql) benchmark on T2000/Solaris and some  ("Jignesh K. Shah" <J.K.Shah@Sun.COM>)
List pgsql-performance
* Jignesh K. Shah:

> * llseek is high which means you can obviously gain a bit with the
> right file system/files tuning by caching them right.

It might also make sense to switch from lseek-read/write to
pread/pwrite.  It shouldn't be too hard to hack this into the virtual
file descriptor module.

pgsql-performance by date:

Previous
From: "Gregory S. Williamson"
Date:
Subject: Re: [HACKERS] Big IN() clauses etc : feature proposal
Next
From: "Olivier Andreotti"
Date:
Subject: Benchmarck PostgreSQL 8.1.4 MySQL 5.0.20 and Oracle 10g2