Re: Database size Vs performance degradation

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Mark Roberts <mailing_lists(at)pandapocket(dot)com>
Cc: Matthew Wakeling <matthew(at)flymine(dot)org>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Database size Vs performance degradation
Date: 2008-07-30 17:51:49
Message-ID: 1240.1217440309@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Mark Roberts <mailing_lists(at)pandapocket(dot)com> writes:
> On Wed, 2008-07-30 at 17:16 +0100, Matthew Wakeling wrote:
>> Anyway, surely it's much safer to just run VACUUM manually?

> Generally, you would think so. The problem comes from Vacuum blocking
> the application process' writes.

Huh? Vacuum doesn't block writes.

regards, tom lane

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Mark Roberts 2008-07-30 18:04:21 Re: Database size Vs performance degradation
Previous Message Guillaume Lelarge 2008-07-30 17:51:47 Re: Database size Vs performance degradation