Re: Monthly table partitioning for fast purges?

Поиск
Список
Период
Сортировка
От Jean-Luc Lachance
Тема Re: Monthly table partitioning for fast purges?
Дата
Msg-id 3F2FCD1B.C01DD910@nsd.ca
обсуждение исходный текст
Ответ на Re: Monthly table partitioning for fast purges?  ("Shridhar Daithankar" <shridhar_daithankar@persistent.co.in>)
Ответы Re: Monthly table partitioning for fast purges?  (Ron Johnson <ron.l.johnson@cox.net>)
Список pgsql-general
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.


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                                                      |
> +-----------------------------------------------------------------+
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

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

Предыдущее
От: "scott.marlowe"
Дата:
Сообщение: Re: like performance w/o wildcards.
Следующее
От: Tom Lane
Дата:
Сообщение: Re: like performance w/o wildcards.