| From: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
|---|---|
| To: | Gregory Stark <stark(at)enterprisedb(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Pet Peeves? |
| Date: | 2009-01-29 17:22:28 |
| Message-ID: | 20090129172228.GA10314@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Gregory Stark wrote:
>
> I'm putting together a talk on "PostgreSQL Pet Peeves" for discussion at
> FOSDEM 2009 this year. I have a pretty good idea what some them are of course,
> but I would be interested to hear if people have any complaints from personal
> experience. What would be most interesting is if you can explain an example of
> when the problem caused real inconvenience to you, since sometimes it's hard
> to see from a theoretical description where the real harm lies.
>
> So, what do people say? Is Postgres perfect in your world or does it do some
> things which rub you the wrong way?
No foreign keys in inheritance trees
No true clustered indexes
Lazy vacuum is not able to release free pages in the middle of a table
No concurrent reindex
Cross-column stats problems
No integrated job agent ;-)
--
Alvaro Herrera http://www.amazon.com/gp/registry/DXLWNGRJD34J
"La tristeza es un muro entre dos jardines" (Khalil Gibran)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Fetter | 2009-01-29 17:22:35 | Re: Pet Peeves? |
| Previous Message | Gregory Stark | 2009-01-29 17:19:46 | Re: Pet Peeves? |