Re: Huge performance problem between 7.4.1 and 8.0.3 - CS

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Robert Creager <Robert_Creager(at)LogicalChaos(dot)org>
Cc: PGPerformance <pgsql-performance(at)postgresql(dot)org>, Andy Hewitt <Andy_Hewitt(at)StorageTek(dot)com>
Subject: Re: Huge performance problem between 7.4.1 and 8.0.3 - CS
Date: 2005-07-18 13:23:11
Message-ID: 2466.1121692991@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Robert Creager <Robert_Creager(at)LogicalChaos(dot)org> writes:
> Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> confessed:
>> The context swap problem was no worse in 8.0 than in prior versions,
>> so that hardly seems like a good explanation. Have you tried reverting
>> to the cron-based vacuuming method you used in 7.4?

> I've "vacuum_cost_delay = 10" in the conf file for 803.

Hmm, did you read this thread?
http://archives.postgresql.org/pgsql-performance/2005-07/msg00088.php

It's still far from clear what's going on there, but it might be
interesting to see if turning off the vacuum delay changes your results
with 8.0.

regards, tom lane

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Robert Creager 2005-07-18 13:41:00 Re: Huge performance problem between 7.4.1 and 8.0.3 - CS
Previous Message Dawid Kuroczko 2005-07-18 07:51:41 Re: slow joining very large table to smaller ones