Re: Fixed width rows faster? - Mailing list pgsql-performance

From Eric Jain
Subject Re: Fixed width rows faster?
Date
Msg-id 004101c404f1$537989c0$c300000a@caliente
Whole thread Raw
In response to Fixed width rows faster?  (Jeff <threshar@torgo.978.org>)
List pgsql-performance
> 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 by date:

Previous
From: Dennis Bjorklund
Date:
Subject: Re: simple query join
Next
From: Andrew Sullivan
Date:
Subject: Re: Using bigint needs explicit cast to use the index