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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general