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?
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
regards, tom lane
In response to
pgsql-performance by date
|Next:||From: Robert Creager||Date: 2005-07-18 13:41:00|
|Subject: Re: Huge performance problem between 7.4.1 and 8.0.3 - CS|
|Previous:||From: Dawid Kuroczko||Date: 2005-07-18 07:51:41|
|Subject: Re: slow joining very large table to smaller ones|