How indexes are updated - Mailing list pgsql-general

From Bob Powell
Subject How indexes are updated
Date
Msg-id sef0945e.007@grpwise.hotchkiss.org
Whole thread Raw
Responses Re: How indexes are updated  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: How indexes are updated  (Steve Crawford <scrawford@pinpointresearch.com>)
List pgsql-general
To whom it may concern:

I think I have proven to myself that when a new record is added to a table it is added to the end of the table.  Also,
whena record in a table is updated it is also moved to the bottom of the table.   

Can someone tell me when the indexes on the columns in the table are updated.  Is the insertion of an index record
insertedbefore the new record is added to the bottom of the table?  Or is the new record added to the table  first and
thenthe databse figures out the insertion in the index?  Thanks in advance.  

Bob Powell



pgsql-general by date:

Previous
From:
Date:
Subject: A View to Share
Next
From: Michael Meskes
Date:
Subject: Re: postgreSQL on NAS/SAN?