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 <[EMAIL PROTECTED]> PGP Key: http://www.rbt.ca/rbtpub.asc
signature.asc
Description: This is a digitally signed message part
