Thank you. Now I see that page consists of record pointers list build
from offset and length so there is no benefit of having constant
length here.
On Fri, Aug 19, 2011 at 17:03, Merlin Moncure mmonc...@gmail.com wrote:
On Fri, Aug 19, 2011 at 4:03 AM, Krzysztof Chodak
thank you, it is a great article.
the current on 8.1 checkpoint_segments = 3.
it looks too low for me , but I'm not tuning the 8.1 schema.
I'm looking for a generic approach of improving that beast while moving it
to 8.4
I'm trying to understand the internals for Views vs. Functions
there
Thank you. I'll set work_mem back to 16MB and see what happens from there.
-Midge
- Original Message -
From: Scott Marlowe
To: Midge Brown
Cc: pgsql-performance@postgresql.org
Sent: Saturday, August 20, 2011 9:01 PM
Subject: Re: [PERFORM] settings input for upgrade
On
Thank you so much for the input, and the detail provided.
I'll be making the configuration changes, probably over the course of the week,
checking the affect after each (as reminded by Scott Marlowe). I was pushed to
put the new version into production over the weekend, which at least may
On 08/22/2011 12:48 PM, Midge Brown wrote:
I was pushed to put the new version into production over the weekend,
which at least may provide me with some accurate feedback, and so will
see what happens for a bit before addressing the disk/drive layout.
The good news is that deploying onto the
I'm buying a bunch of new machines (all will run an application that heavily
writes to PG). These machines will have 2 spindle groups in a RAID-1 config.
Drives will be either 15K SAS, or 10K SATA (I haven't decided if it is
better
to buy the faster drives, or drives that are identical to the
I am in the progress of an 8.3 to 8.4 upgrade for a customer. I seem to
have stumbled upon what looks like a regression. The two databases
(8.3.14 and 8.4.8) have identical tuning parameters (where that makes
sense) and run on identical hardware. Both databases are regularly
vacuumed and
On Mon, Aug 22, 2011 at 8:42 PM, David Boreham david_l...@boreham.org wrote:
I'm buying a bunch of new machines (all will run an application that heavily
writes to PG). These machines will have 2 spindle groups in a RAID-1 config.
Drives will be either 15K SAS, or 10K SATA (I haven't decided