Re: Big 7.1 open items

>     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