Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

Next:From: Mark RobertsDate: 2008-07-30 18:04:21
Subject: Re: Database size Vs performance degradation
Previous:From: Guillaume LelargeDate: 2008-07-30 17:51:47
Subject: Re: Database size Vs performance degradation

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group