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

Re: Pet Peeves?

From: Reg Me Please <regmeplease(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Cc: Peter Eisentraut <peter_e(at)gmx(dot)net>, Gregory Stark <stark(at)enterprisedb(dot)com>
Subject: Re: Pet Peeves?
Date: 2009-01-30 13:37:13
Message-ID: 200901301437.14048.regmeplease@gmail.com (view raw or flat)
Thread:
Lists: pgsql-general
On Friday 30 January 2009 14:26:45 Peter Eisentraut wrote:
> 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.

* No builtin crosstab a-la 
http://www.postgresql.org/docs/8.3/interactive/tablefunc.html

* No builtin time intervals a-la http://temporal.projects.postgresql.org/

* LIMIT and OFFSET don't accept non-constant (or non function) values


-- 
Fahrbahn ist ein graues Band
weisse Streifen, grüner Rand

In response to

Responses

pgsql-general by date

Next:From: Grzegorz JaśkiewiczDate: 2009-01-30 13:52:45
Subject: Re: Pet Peeves?
Previous:From: Grzegorz JaśkiewiczDate: 2009-01-30 13:33:25
Subject: Re: Pet Peeves?

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