On Thu, 2003-06-12 at 08:48, R C wrote:
> Will PostgreSQL has a plan to support
> table fragmentation in nearby future?
> This will increase the performance when
> query a huge database. Most of commercial
> database products have this feature.
You will probably find nearly as big of a performance gain by splitting
your index up.
Take a look at partial indexes (with the WHERE clause).
http://www.postgresql.org/docs/view.php?version=7.3&idoc=1&file=sql-createindex.html
--
Rod Taylor <rbt@rbt.ca>
PGP Key: http://www.rbt.ca/rbtpub.asc