Table Size/Performance

Поиск
Список
Период
Сортировка
От dennis@zserve.com
Тема Table Size/Performance
Дата
Msg-id 200107111947.f6BJliW11370@mail.ldssingles.com
обсуждение исходный текст
Список pgsql-general
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 по дате отправления:

Предыдущее
От: "Thalis A. Kalfigopoulos"
Дата:
Сообщение: Re: changing partial data
Следующее
От: Adam Manock
Дата:
Сообщение: Re: Performance tuning for linux, 1GB RAM, dual CPU?