Re: Out of memory on vacuum analyze - Mailing list pgsql-general

From Jim Nasby
Subject Re: Out of memory on vacuum analyze
Date
Msg-id 5982FDC4-A0A8-4A3B-98C1-D0FE9E55485D@decibel.org
Whole thread Raw
In response to Re: Out of memory on vacuum analyze  (Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>)
List pgsql-general
On Feb 21, 2007, at 12:58 AM, Stefan Kaltenbrunner wrote:
> Have you actually measured a performance improvment going beyond
> 250-350MB(that seemed about to be the sweet spot last I tested) or so
> for index creation and friends ?

To be honest, no; I just set it high to play on the safe side. But I
have seen reports of large in-memory sorts actually being slower than
tape sorts in some cases, so I probably am leaving some performance
on the table.
--
Jim Nasby                                            jim@nasby.net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)



pgsql-general by date:

Previous
From: Jim Nasby
Date:
Subject: Re: postgresql vs mysql
Next
From: Guido Neitzer
Date:
Subject: Re: How would you handle updating an item and related stuff all at once?