On 10/14/07, Gregory Stark <[EMAIL PROTECTED]> wrote:
> "Gokulakannan Somasundaram" <[EMAIL PROTECTED]> writes:
> > So Indexes with snapshots will be degrading the performance only for
> deletes
> > and only those updates, which are updating the index tuple.
> Deletes never update indexes in Postgres. Increasing the size of the index
> would affect vacuum, inserts, and index accesses.

In the new proposal, deletes are going to update indexes. So  its a
trade-off between  selects and deletes, since selects may not need to goto
the table for checking visibility. You may go through this thread, to get
more details.

>   Gregory Stark
>   EnterpriseDB          http://www.enterprisedb.com

Reply via email to