Re: Pet Peeves? - Mailing list pgsql-general

From Bruce Momjian
Subject Re: Pet Peeves?
Date
Msg-id 200901302132.n0ULWj302990@momjian.us
Whole thread Raw
In response to Re: Pet Peeves?  (Gregory Stark <stark@enterprisedb.com>)
List pgsql-general
Gregory Stark wrote:
>
> rhubbell <Rhubbell@iHubbell.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@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

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

pgsql-general by date:

Previous
From: Sam Mason
Date:
Subject: Re: Pet Peeves?
Next
From: Greg Smith
Date:
Subject: Re: PGSQL or other DB?