At what point does a big table start becoming too big?

Поиск
Список
Период
Сортировка
От Nick
Тема At what point does a big table start becoming too big?
Дата
Msg-id 9d6e16a5-7ff5-4873-9afe-60ec330dfdb3@googlegroups.com
обсуждение исходный текст
Ответы Re: At what point does a big table start becoming too big?  ("Martin French" <Martin.French@romaxtech.com>)
Re: At what point does a big table start becoming too big?  (Chris Travers <chris.travers@gmail.com>)
Re: At what point does a big table start becoming too big?  (Merlin Moncure <mmoncure@gmail.com>)
Re: At what point does a big table start becoming too big?  (Jeff Janes <jeff.janes@gmail.com>)
Re: At what point does a big table start becoming too big?  (Gavin Flower <GavinFlower@archidevsys.co.nz>)
Список pgsql-general
Дерево обсуждения 
I have a table with 40 million rows and haven't had any performance issues yet.

Are there any rules of thumb as to when a table starts getting too big?

For example, maybe if the index size is 6x the amount of ram, if the table is 10% of total disk space, etc?

В списке pgsql-general по дате отправления:

Предыдущее
От: Thomas Kellerer
Дата:
Сообщение: Re: What text format is this and can I import it into Postgres?
Следующее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: Alternatives to very large tables with many performance-killing indicies?