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

Re: Pet Peeves?

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Gregory Stark <stark(at)enterprisedb(dot)com>
Cc: rhubbell <Rhubbell(at)iHubbell(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Pet Peeves?
Date: 2009-01-30 21:32:44
Message-ID: 200901302132.n0ULWj302990@momjian.us (view raw or flat)
Thread:
Lists: pgsql-general
Gregory Stark wrote:
> 
> rhubbell <Rhubbell(at)iHubbell(dot)com> writes:
> 
> > What's your list look like?  Or maybe you want everyone else to do your work
> > for you and don't have anything to share.
> 
> Heh, fair enough. Perhaps I should just say you should come to FOSDEM though
> :)
> 
> The usual bugaboos are things like having to do a dump/restore to upgrade,
> weak support for partitioning, no index-only-scans, etc. Things which have
> been mentioned several times.
> 
> One thing which has *not* been mentioned which i find positively shocking is
> VACUUM. This was once our single biggest source of user complaints. Between
> Autovacuum improvements and HOT previously and the free space map in 8.4 the
> situation will be much improved. However there are still some common usage
> patterns where people run into problems.

Yes, that is surprising, and something most database product struggle
with.

-- 
  Bruce Momjian  <bruce(at)momjian(dot)us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

In response to

pgsql-general by date

Next:From: Greg SmithDate: 2009-01-30 21:48:16
Subject: Re: PGSQL or other DB?
Previous:From: Sam MasonDate: 2009-01-30 21:25:35
Subject: Re: Pet Peeves?

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