Re: Database size Vs performance degradation - Mailing list pgsql-performance

From Tom Lane
Subject Re: Database size Vs performance degradation
Date
Msg-id 1240.1217440309@sss.pgh.pa.us
Whole thread Raw
In response to Re: Database size Vs performance degradation  (Mark Roberts <mailing_lists@pandapocket.com>)
Responses Re: Database size Vs performance degradation  (Mark Roberts <mailing_lists@pandapocket.com>)
List pgsql-performance
Mark Roberts <mailing_lists@pandapocket.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

pgsql-performance by date:

Previous
From: "Dave North"
Date:
Subject: Re: Database size Vs performance degradation
Next
From: Guillaume Lelarge
Date:
Subject: Re: Database size Vs performance degradation