Re: [PERFORM] Postgresql is very slow

> System Specification: > OS :- CentOs 5 > Postgresql 8.1.8 > RAM :- 1 GB > SWAP 2 GB [Greg says] How much memory is actually free, can you include the output from the command "free" in your reply? What else runs on this server? What is the system load before and during your query? While it'

Re: [PERFORM] file system and raid performance

I recently ran some tests on Ubuntu Hardy Server (Linux) comparing JFS, XFS, and ZFS+FUSE. It was all 32-bit and on old hardware, plus I only used bonnie++, so the numbers are really only useful for my hardware. What parameters were used to create the XFS partition in these tests? And, what optio

Re: [PERFORM] file system and raid performance

> From: Mark Kirkwood [mailto:[EMAIL PROTECTED] > Mark Wong wrote: > > On Mon, Aug 4, 2008 at 10:56 PM, Gregory S. Youngblood > <[EMAIL PROTECTED]> wrote: > > > >> I recently ran some tests on Ubuntu Hardy Server (Linux) comparing > JFS, XFS, > >

Re: [PERFORM] file system and raid performance

> -Original Message- > From: Mark Wong [mailto:[EMAIL PROTECTED] > Sent: Thursday, August 07, 2008 12:37 PM > To: Mario Weilguni > Cc: Mark Kirkwood; [EMAIL PROTECTED]; [EMAIL PROTECTED]; pgsql- > [EMAIL PROTECTED]; Gabrielle Roth > Subject: Re: [PERFORM] file system and raid performance >

Re: [PERFORM] select on 22 GB table causes "An I/O error occured while sending to the backend." exception

Gregory Williamson wrote: >Bill Moran wrote: >> In response to Greg Smith <[EMAIL PROTECTED]>: >> >> >> >> I don't know, Greg. First off, the solution of making the postmaster >> immune to the OOM killer seems better than disabling overcommit to me >> anyway; and secondly, I don't understand why