Re: [GENERAL] Questions about Partitioning

2011-04-21 Thread Craig Ringer
On 19/04/11 23:56, Phoenix Kiula wrote: > While I fix some bigger DB woes, I have learned a lesson. Huge indexes > and tables are a pain. > > Which makes me doubly keen on looking at partitioning. > > Most examples I see online are partitioned by date. As in months, or > quarter, and so on. This

Re: [GENERAL] Questions about Partitioning

2011-04-19 Thread Steve Crawford
On 04/19/2011 08:56 AM, Phoenix Kiula wrote: While I fix some bigger DB woes, I have learned a lesson. Huge indexes and tables are a pain. Which makes me doubly keen on looking at partitioning. Before jumping into partitioning it would be useful to know specifically what pain you are having wit

[GENERAL] Questions about Partitioning

2011-04-19 Thread Phoenix Kiula
While I fix some bigger DB woes, I have learned a lesson. Huge indexes and tables are a pain. Which makes me doubly keen on looking at partitioning. Most examples I see online are partitioned by date. As in months, or quarter, and so on. This doesn't work for me as I don't have too much logic req