On Fri, Jun 08, 2007 at 05:08:26PM -0500, MC Moisei wrote: > Yes all the connection are coming from within the box so no network > latency.Well, isn't the swap can be because too many process > postmaster are requiring more memory. But why are they requring more memory? Do you maybe have (e.g.) work_mem set too high, and that's what is causing your problem? Or shared buffers too big? This is a common error, and on a smaller set of data, it won't hurt; but when the data gets to a point, you lose. A -- Andrew Sullivan | ajs@xxxxxxxxxxxxxxx A certain description of men are for getting out of debt, yet are against all taxes for raising money to pay it off. --Alexander Hamilton