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 >