Re: Insert performance, what should I expect?
Steinar H. Gunderson <sgunderson@bigfoot.com>
From: "Steinar H. Gunderson" <sgunderson@bigfoot.com>
To: pgsql-performance@postgresql.org
Date: 2004-10-23T11:15:30Z
Lists: pgsql-performance
On Sat, Oct 23, 2004 at 12:31:32PM +0200, Gaetano Mendola wrote: >> Any comments/suggestions would be appreciated. > Tune also the disk I/O elevator. > > look at this: http://www.varlena.com/varlena/GeneralBits/49.php Mm, interesting. I've heard somewhere that the best for database-like loads on Linux is to disable the anticipatory I/O scheduler (http://kerneltrap.org/node/view/567), which should probably influence the numbers for elvtune also -- anybody know whether this is true or not for PostgreSQL? /* Steinar */ -- Homepage: http://www.sesse.net/