Search Postgresql Archives

Re: Pet Peeves?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux