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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

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: Wed, 30 Jul 2008 11:04:21 -0700
  • Message-id: <1217441061.6288.47.camel@localhost> <text/plain>
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
Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group