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).
Rod Taylor <rbt(at)rbt(dot)ca>
PGP Key: http://www.rbt.ca/rbtpub.asc
In response to
pgadmin-hackers by date
|Next:||From: Jean-Michel POURE||Date: 2003-06-12 13:23:27|
|Subject: Suse 82 package|
|Previous:||From: Jean-Michel POURE||Date: 2003-06-12 13:17:10|
|Subject: Infinite loop in pgAdmin3|
pgadmin-support by date
|Next:||From: Marc Cuypers||Date: 2003-06-12 13:37:20|
|Subject: database migration wizard|
|Previous:||From: R C||Date: 2003-06-12 12:48:02|
|Subject: Table fragmentation?|