Skip site navigation (1) Skip section navigation (2)

Re: Table fragmentation?

From: Rod Taylor <rbt(at)rbt(dot)ca>
To: R C <raymond(dot)chui(at)noaa(dot)gov>
Cc: pgadmin-support(at)postgresql(dot)org, pgadmin-hackers(at)postgresql(dot)org
Subject: Re: Table fragmentation?
Date: 2003-06-12 13:22:08
Message-ID: 1055424127.64954.2.camel@jester (view raw or flat)
Thread:
Lists: pgadmin-hackerspgadmin-support
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(at)rbt(dot)ca>

PGP Key: http://www.rbt.ca/rbtpub.asc

In response to

pgadmin-hackers by date

Next:From: Jean-Michel POUREDate: 2003-06-12 13:23:27
Subject: Suse 82 package
Previous:From: Jean-Michel POUREDate: 2003-06-12 13:17:10
Subject: Infinite loop in pgAdmin3

pgadmin-support by date

Next:From: Marc CuypersDate: 2003-06-12 13:37:20
Subject: database migration wizard
Previous:From: R CDate: 2003-06-12 12:48:02
Subject: Table fragmentation?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group