My short list is:

* in-place upgrade
* named parameters in SQL functions
* native jobs
* timestamptz that preserves original timezone (not offset but
political timezone !!!! like America/New_York)
* I hate:  "select * from dblink(...) as WHY(I_NEED int4, TO_SPECIFY
int4, THIS text)"
* ability to call set-returning plpgsql function in SELECT, not in
FROM
* stat collector is really greedy by definition even when system is
idle, when you have really really many relations
* lost space when dropping toasted column - can be recovered only by
reindexing table (are there other such a strange cases ??)

In response to

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

Responses

• Re: Pet Peeves? at 2009-02-02 19:23:45 from Bruce Momjian

pgsql-general by date

Next:	From: Oleg Bartunov	Date: 2009-02-02 18:10:29
	Subject: Re: Fulltext search configuration
Previous:	From: Scara Maccai	Date: 2009-02-02 17:48:37
	Subject: I: arrays and block size