> There are also disadvantages.
>
> You can run out of space even if there are plenty GB's
> free on your disks. You have to create tablespaces
> explicitly.
>
> If you've choosen inadequate extent size parameters, you
> end up with high fragmented tables (slowing down) or get
> stuck with running against maxextents, where only a reorg
> (export/import) helps.
Also, Tom Lane pointed out to me that file system read-ahead does not
help if your table is spread around in tablespaces.
-- Bruce Momjian | http://www.op.net/~candle pgman@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026