Re: Including Snapshot Info with Indexes - Mailing list pgsql-hackers

From Gregory Stark
Subject Re: Including Snapshot Info with Indexes
Date
Msg-id 87fy0du8d4.fsf@oxford.xeocode.com
Whole thread Raw
In response to Re: Including Snapshot Info with Indexes  ("Gokulakannan Somasundaram" <gokul007@gmail.com>)
Responses Re: Including Snapshot Info with Indexes
List pgsql-hackers
"Gokulakannan Somasundaram" <gokul007@gmail.com> 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.

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


pgsql-hackers by date:

Previous
From: "Gokulakannan Somasundaram"
Date:
Subject: Re: Including Snapshot Info with Indexes
Next
From: "Trevor Talbot"
Date:
Subject: Re: Including Snapshot Info with Indexes