Re: Fixed width rows faster?

Поиск
Список
Период
Сортировка
Искать
От
Eric Jain
Тема
Re: Fixed width rows faster?
Дата
Msg-id
004101c404f1$537989c0$c300000a@caliente
Список
Дерево обсуждения
Fixed width rows faster? Jeff <threshar@torgo.978.org>
Re: Fixed width rows faster? Bill Moran <wmoran@potentialtech.com>
Re: Fixed width rows faster? Josh Berkus <josh@agliodbs.com>
Re: Fixed width rows faster? Mike Nolan <nolan@gw.tssi.com>
Re: Fixed width rows faster? Rod Taylor <pg@rbt.ca>
Re: Fixed width rows faster? Mike Nolan <nolan@gw.tssi.com>
Re: Fixed width rows faster? Rod Taylor <pg@rbt.ca>
Re: Fixed width rows faster? Neil Conway <neilc@samurai.com>
Re: Fixed width rows faster? Mike Nolan <nolan@gw.tssi.com>
Re: Fixed width rows faster? Rod Taylor <pg@rbt.ca>
Re: Fixed width rows faster? Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Re: Fixed width rows faster? Mike Nolan <nolan@gw.tssi.com>
Re: Fixed width rows faster? Tom Lane <tgl@sss.pgh.pa.us>
Re: Fixed width rows faster? Tom Lane <tgl@sss.pgh.pa.us>
Re: Fixed width rows faster? Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Re: Fixed width rows faster? Dennis Bjorklund <db@zigo.dhs.org>
Re: Fixed width rows faster? Josh Berkus <josh@agliodbs.com>
> This is bogus reasoning.  The limit on index entry length will not
> change when you rebuild the index.

What I meant by 'rebuilding' was not issuing a REINDEX command, but
creating a new index after having dropped the index and inserted
whatever records. Building indexes can be slow, and I'd rather not have
the operation fail after several hours because record #98556761 is
deemed to be too long for indexing...

While we are busy complaining, it's a pity Postgres doesn't allow us to
disable and later recreate all indexes on a table using a single command
;-)

В списке pgsql-performance по дате отправления
От: Dennis Bjorklund
Дата:
Сообщение: Re: simple query join
От: Andrew Sullivan
Дата:
FAQ