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

Re: Pet Peeves?

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Gregory Stark <stark(at)enterprisedb(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Pet Peeves?
Date: 2009-01-30 13:26:45
Message-ID: 49830015.8070604@gmx.net (view raw or flat)
Thread:
Lists: pgsql-general
Gregory Stark wrote:
> So, what do people say? Is Postgres perfect in your world or does it do some
> things which rub you the wrong way?

* No offer of anything-but-CVS on pgfoundry.org

* Lack of REINDEX CONCURRENTLY

* Too many obscure configuration options: memory management, autovacuum 
management, freespace map, background writer, WAL.

* Writing robust scripts with psql is difficult and bizarre.

* Default postgresql.conf is too long and verbose.

* Default logging configuration is too minimal.

* Difficult to trace nested things, e.g., nested PL/pgSQL calls, 
cascaded foreign key actions.

* No basic health checking: Answering the question, "Is this system 
configured reasonably and running smoothly" takes two days of training 
and half a day of work.

* Too much accumulated historical garbage that is never cleared out.

In response to

  • Pet Peeves? at 2009-01-29 13:16:17 from Gregory Stark

Responses

pgsql-general by date

Next:From: Daniel VeriteDate: 2009-01-30 13:32:00
Subject: Re: Pet Peeves?
Previous:From: Sean DavisDate: 2009-01-30 13:02:20
Subject: Re: [INTERFACES] PGSQL and Javascript

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