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

Re: Database size Vs performance degradation

From: Mark Roberts <mailing_lists(at)pandapocket(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
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 18:04:21
Message-ID: 1217441061.6288.47.camel@localhost (view raw or flat)
Thread:
Lists: pgsql-performance
On Wed, 2008-07-30 at 13:51 -0400, Tom Lane wrote:
> 
> 
> Huh?  Vacuum doesn't block writes.
> 
>                         regards, tom lane
> 

Of course, you are correct.  I was thinking of Vacuum full, which is
recommended for use when you're deleting the majority of rows in a
table.

http://www.postgresql.org/docs/8.1/interactive/sql-vacuum.html

-Mark


In response to

Responses

pgsql-performance by date

Next:From: Dennis BrakhaneDate: 2008-07-30 18:34:16
Subject: Re: how does pg handle concurrent queries and same queries
Previous:From: Tom LaneDate: 2008-07-30 17:51:49
Subject: Re: Database size Vs performance degradation

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