Re: [GENERAL] Large Database & Indexes (Indices?)

On Tue, 8 Feb 2000, Brian Piatkus wrote:

> I am constructing a large ( by some standards) database where the largest table
> threatens to be about 6-10 Gb on a Linux system. I understand that postgresql
> splits the tables into manageable chunks & I have no problem with that as a
> workround for the 2 GB fs limit
> .. My question concerns the indexes ,the first of which looks to be around
> 40 % of the table size. How is this
> handled and how do I create subsequent indices on large tables given that I
> can't interrupt the process, move and symbolically link chunks ?

IIRC Indices you the same storage manager as tables, so they should split
at the same intervals as tables (default is 1Gb). Someone correct me if
I'm wrong.

Peter

--
Peter T Mount peter(at)retep(dot)org(dot)uk
Main Homepage: http://www.retep.org.uk
PostgreSQL JDBC Faq: http://www.retep.org.uk/postgres
Java PDF Generator: http://www.retep.org.uk/pdf