Table size for partitioned setup

Поиск
Список
Период
Сортировка
От Mat Arye
Тема Table size for partitioned setup
Дата
Msg-id CADsUR0ApxPOOgiZBkrW5U_t9cZk-gsCTGAV=N9qTCj7c28=vgg@mail.gmail.com
обсуждение исходный текст
Ответы Re: Table size for partitioned setup  (Rob Sargent <robjsargent@gmail.com>)
Список pgsql-general
Hi All,

I am writing a program that needs time-series-based insert mostly workload. I need to make the system scaleable with many thousand of inserts/s. One of the techniques I plan to use is time-based table partitioning and I am trying to figure out how large to make my time tables.

Does anybody have any hints on optimal table sizes either in terms of rows or in terms of size? Any rule of thumbs I can use for table size in relation to amount of memory on the machine? Is the size of the index more important than the size of the table (if queries mostly use indexes)?

Basically, I am asking for pointers about how to think about this problem and any experiences people have had. 

Thanks, 
Mat

P.S. I am aware of limits listed here: http://www.postgresql.org/about/. I am asking about practical size limits for performance consideration. 

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

Предыдущее
От: Geoff Winkless
Дата:
Сообщение: More correlated (?) index woes
Следующее
От: Rob Sargent
Дата:
Сообщение: Re: Table size for partitioned setup