[PERFORM] Checkpoint tuning on 8.2.4

2008-06-05 Thread Greg Smith
One of the things to hit my mailbox this week is from someone who is frustrated not only by their database server but by issues sending messages to this list; I'm forwarding to here for them, please reply to all so they get a copy. Here's the basic server information: PostgreSQL version - 8.

Re: [PERFORM] query performance question

2008-06-05 Thread Dan Harris
Kenneth Marshall wrote: Dan, Did you try this with 8.3 and its new HOT functionality? Ken I did not. I had to come up with the solution before we were able to move to 8.3. But, Tom did mention that the HOT might help and I forgot about that when writing the prior message. I'm in the

Re: [PERFORM] query performance question

2008-06-05 Thread Kenneth Marshall
Dan, Did you try this with 8.3 and its new HOT functionality? Ken On Thu, Jun 05, 2008 at 09:43:06AM -0600, Dan Harris wrote: > [EMAIL PROTECTED] wrote: >> >> 3) Build a table with totals or maybe subtotals, updated by triggers. This >> requires serious changes in application as well as in data

Re: [PERFORM] query performance question

2008-06-05 Thread Dan Harris
[EMAIL PROTECTED] wrote: 3) Build a table with totals or maybe subtotals, updated by triggers. This requires serious changes in application as well as in database, but solves issues of 1) and may give you even better results. Tomas I have tried this. It's not a magic bullet. We do our bil