Re: 10 missing features

> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-
> owner(at)postgresql(dot)org] On Behalf Of Radoslaw Smogura
> Sent: Tuesday, April 26, 2011 9:55 AM
> To: Leif Biberg Kristensen
> Cc: pgsql-general(at)postgresql(dot)org
> Subject: Re: [GENERAL] 10 missing features
>
>
> For example, having knowledge when particular query stuck may be great
> advantage for administrators and developers as well. Ofcourse each
> functionality gives some overhead, but from other hand, if you create
> important systems (like financials) "stability" and how it's easy to
> track errors is required.

For those types of systems - lack of a true audit log is probably a bigger barrier. The biggest "missing feature" are going to depend on your problem space.

> Form this what I was interested and saw:
> * I think he good pointed that logging indices, may be unneeded, as
> those can be recreated.

Whether this is acceptable depends on your system. Yes they can be recreated with a number of caveats

-performance for many systems will be poor until some (or all) indexes are back. If you have SLA's based around performance you can extend your outage until the indexes get rebuilt.
-Indexes are used to enforce primary keys. Are you comfortable running temporarily without your primary keys?
-Some replication engines rely on primary keys or unique indexes. Losing these could break replication for you.

I think if you could control this on a per-index basis though it could be a win.

Brad