Re: slow query

Поиск
Список
Период
Сортировка
От Robert Treat
Тема Re: slow query
Дата
Msg-id 1046186882.1015.377.camel@camel
обсуждение исходный текст
Ответ на Re: slow query  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: slow query  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
On Mon, 2003-02-24 at 15:50, Tom Lane wrote:
> You'll
> particularly get burnt by indexes that are on OIDs or sequentially
> assigned ID numbers, since the set of IDs in use just naturally tends to
> migrate higher over time.  I don't think that the update rate per se has
> much to do with this, it's the insertion of new IDs and deletion of old
> ones that causes the statistical shift.

Would it be safe to say that tables with high update rates where the
updates do not change the indexed value would not suffer from index
bloat? For example updates to non-index columns or updates that
overwrite, but don't change the value of indexed columns; do these even
need to touch the index?

Robert Treat


В списке pgsql-performance по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Query not using the index
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: Superfluous merge/sort