Re: Pet Peeves? - Mailing list pgsql-general

From Gregory Stark
Subject Re: Pet Peeves?
Date
Msg-id 87y6wsldy9.fsf@oxford.xeocode.com
Whole thread Raw
In response to Re: Pet Peeves?  (rhubbell <Rhubbell@iHubbell.com>)
Responses Re: Pet Peeves?  (rhubbell <Rhubbell@iHubbell.com>)
Re: Pet Peeves?  (Bruce Momjian <bruce@momjian.us>)
Re: Pet Peeves?  (Ron Mayer <rm_pg@cheapcomplexdevices.com>)
List pgsql-general
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.

--
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com
  Ask me about EnterpriseDB's On-Demand Production Tuning

pgsql-general by date:

Previous
From: "Marc Mamin"
Date:
Subject: Re: complex custom aggregate function
Next
From: Tony Caduto
Date:
Subject: Re: PGSQL or other DB?