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 по дате отправления