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@retep.org.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