In my limited experience ext4 as presented by Karmic is not db friendly. I had to carve my swap partition into a swap partition and an xfs partition to get better db performance. Try fsync=off first, but if that doesn't work then try a mini xfs.
On Thu, Dec 10, 2009 at 5:09 PM, Andres Freund <and...@anarazel.de> wrote: > Hi, > > On Thursday 10 December 2009 23:01:08 Michael Clemmons wrote: > > Im not sure what that means ppl in my office with slower hd speeds using > > 8.4 can create a db in 2s vs my 8-12s. > - Possibly their config is different - they could have disabled the "fsync" > parameter which turns the database to be not crashsafe anymore but much > faster > in some circumstances. > > - Possibly you have much data in your template1 database? > You could check whether > > CREATE DATABASE speedtest TEMPLATE template1; takes more time than > CREATE DATABASE speedtest TEMPLATE template0;. > > You should issue both multiple times to ensure caching on the template > database doesnt play a role. > > > Could using md5 instead of ident do it? > Seems unlikely. > Is starting psql near-instantaneus? Are you using "createdb" or are you > issuing "CREATE DATABASE ..."? > > Andres > > -- > Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-performance >
