On Thursday 31 January 2008 07:08, jiniusatwork-postgresql@xxxxxxxxx wrote: > [Following up on my own message.] > > > Also, > > > let > > > > us > > > > know > > > > your > > > > wal > > > > tunning > > > > parameters > > > > like > > > > commit_delay, > > > > fsync. > > I haven't done any tuning as of yet. I'm running with the default settings > produced by initdb. > Don't even bother trying to tune zfs untill after you've tuned postgres, otherwise your wasting your time. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match