Re: Monthly table partitioning for fast purges?
От | Ron Johnson |
---|---|
Тема | Re: Monthly table partitioning for fast purges? |
Дата | |
Msg-id | 1060101003.4756.7.camel@haggis обсуждение исходный текст |
Ответ на | Re: Monthly table partitioning for fast purges? (Jean-Luc Lachance <jllachan@nsd.ca>) |
Список | pgsql-general |
On Tue, 2003-08-05 at 10:28, Jean-Luc Lachance wrote: > I second that. > I have discussed adding partitioning tables almost a year ago... > No need to partition a functional index or anything like that. > Just partition on a specific field. Well..... If you're going to partition a *huge* table by, say, a date field, and there's also an index on that date field, partitioning the index on that same field may have some advantages. > Ron Johnson wrote: > >[...] > > Partitioning "should" be put on the TODO list soon after tablespaces > > (or DBA-defined directories) is implemented. -- +-----------------------------------------------------------------+ | Ron Johnson, Jr. Home: ron.l.johnson@cox.net | | Jefferson, LA USA | | | | "I'm not a vegetarian because I love animals, I'm a vegetarian | | because I hate vegetables!" | | unknown | +-----------------------------------------------------------------+
В списке pgsql-general по дате отправления: