Postgres Pro
Downloads
Home   >   mailing lists

Table Size/Performance - Mailing list pgsql-general

From dennis@zserve.com
Subject Table Size/Performance
Date
Msg-id 200107111947.f6BJliW11370@mail.ldssingles.com
Whole thread Raw
List pgsql-general
Tree view 
Is there a way to figure out which file represents which table?

IE:  I have a file 21691 and I want to know what table it is.

Also, I've heard that pg splits tables when they get to about 1 gig.

I have a table that could grow to that.  It is 700+ megs now.  Will
performance/indexes be effected if/when it's size is split.

Thanks
Dennis

pgsql-general by date:

Previous
From: "Thalis A. Kalfigopoulos"
Date:
Subject: Re: changing partial data
Next
From: Adam Manock
Date:
Subject: Re: Performance tuning for linux, 1GB RAM, dual CPU?