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
Views: Raw Message | Whole Thread | Download mbox
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

Browse pgsql-general by date

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