> -----Original Message-----
> From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-
> owner@postgresql.org] On Behalf Of Radoslaw Smogura
> Sent: Tuesday, April 26, 2011 9:55 AM
> To: Leif Biberg Kristensen
> Cc: pgsql-general@postgresql.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
goingto 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
performanceyou 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