Re: [HACKERS] [COMMITTERS] pgsql: Reduce the size of memoryallocations by lazy vacuum when

2007-09-24 Thread Gregory Stark
"Heikki Linnakangas" <[EMAIL PROTECTED]> writes: > Simon Riggs wrote: >> On Mon, 2007-09-24 at 10:02 +0100, Heikki Linnakangas wrote: >>> How about just using MaxHeapTuplesPerPage? With the default 8K block >>> size, it's not that much more than 200, but makes the above gripes >>> completely go aw

Re: [HACKERS] [COMMITTERS] pgsql: Reduce the size of memoryallocations by lazy vacuum when

2007-09-24 Thread Simon Riggs
On Mon, 2007-09-24 at 10:39 +0100, Heikki Linnakangas wrote: > Simon Riggs wrote: > > On Mon, 2007-09-24 at 10:02 +0100, Heikki Linnakangas wrote: > >> How about just using MaxHeapTuplesPerPage? With the default 8K block > >> size, it's not that much more than 200, but makes the above gripes > >> c

Re: [HACKERS] [COMMITTERS] pgsql: Reduce the size of memoryallocations by lazy vacuum when

2007-09-24 Thread Heikki Linnakangas
Simon Riggs wrote: > On Mon, 2007-09-24 at 10:02 +0100, Heikki Linnakangas wrote: >> How about just using MaxHeapTuplesPerPage? With the default 8K block >> size, it's not that much more than 200, but makes the above gripes >> completely go away. That seems like the safest option at this point. >