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

Re: Pet Peeves?

From: "Greg Sabino Mullane" <greg(at)turnstep(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Pet Peeves?
Date: 2009-02-08 02:57:16
Message-ID: 938a826ad457340566749a8c1190ad25@biglumber.com (view raw or flat)
Thread:
Lists: pgsql-general
-----BEGIN PGP SIGNED MESSAGE-----
Hash: RIPEMD160


> * Letter options in psql, pg_dump[all], pg_restore aren't consistent
>   and can easily steer you very wrong.  I'm looking at you, -d.

Amen!

> So, what do people say?  Is Postgres perfect in your world or does
> it do some things which rub you the wrong way?

You can check the archives for more things I've found annoying in the past,
but might as well put out a quick list here for posterity:

* We're using md5 as the default hash function. Lame.

* We don't have any other builtin encryption/hash stuff other than md5.

* Many more things should be built-in, rather than as contrib or worse. Make them
'installable' like procedural languages if you must, but they have to go in
easier.

* pgfoundry is still a mess. 'nuff said.

* We lost years worth of community shared knowledge when planetpostgresql went down
and the owner won't let people restore their links (e.g. a simple Apache redirect).

* psql is not backwards compatible

* In-place upgrade. Regular dump/restore could be better too.

* The resistance to changing the name officially back to "Postgres".

* The way patches must often be fought for before acceptance.

* The community is scared of change. Exhibit A: git

* Lack of pragmatism at times: real-world DBA work vs. ivory tower pontification.

* Deferred constraints

* psql doesn't do multi-line readline

* The horrible defaults in postgresql.conf

* The horrible commenting in postgresql.conf

* The crappy 8kb GUC unit sizes

* Slow pace of libpq: no binary, no partial result sets

* Logging could be a lot more flexible and fine-grained. Imagine being able to
have slow queries from database X go to a separate log file.

* Horrible bike shedding and making simple solutions complicated.

* Would like to see information_schema expanded.

- --
Greg Sabino Mullane greg(at)turnstep(dot)com
PGP Key: 0x14964AC8 200902072156
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----

iEYEAREDAAYFAkmOSfMACgkQvJuQZxSWSsgNIQCgtp9rDWLVyeTDjIvFw+lPWyju
B9kAn0e3mvpaKcu19qZS1qdJdA+vLBfT
=KYSj
-----END PGP SIGNATURE-----



In response to

Responses

pgsql-general by date

Next:From: rhubbellDate: 2009-02-08 03:09:51
Subject: Re: Pet Peeves?
Previous:From: Greg Sabino MullaneDate: 2009-02-08 02:28:40
Subject: Re: Pet Peeves?

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