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. It

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 completely

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 away. That seems