How indexes are updated

Поиск
Список
Период
Сортировка
От Bob Powell
Тема How indexes are updated
Дата
Msg-id sef0945e.007@grpwise.hotchkiss.org
обсуждение исходный текст
Ответы Re: How indexes are updated  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: How indexes are updated  (Steve Crawford <scrawford@pinpointresearch.com>)
Список 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 по дате отправления:

Предыдущее
От:
Дата:
Сообщение: A View to Share
Следующее
От: Michael Meskes
Дата:
Сообщение: Re: postgreSQL on NAS/SAN?