Re: Daily Rotated Insertion

Поиск
Список
Период
Сортировка
От Sergey Konoplev
Тема Re: Daily Rotated Insertion
Дата
Msg-id CAL_0b1sTAbkyUQUzKfnY6+yHQqSgZ9JVbBV6HH6KC6tu6zH5fA@mail.gmail.com
обсуждение исходный текст
Ответ на Daily Rotated Insertion  (Haifeng Liu <liuhaifeng@live.com>)
Ответы Re: Daily Rotated Insertion  (Haifeng Liu <liuhaifeng@live.com>)
Список pgsql-admin
Hi,

On Mon, Mar 26, 2012 at 9:39 AM, Haifeng Liu <liuhaifeng@live.com> wrote:
> Well, I can create a trigger to redirect insertion to 'yesterday', 'today' and 'tomorrow', but I am still expecting a
moresimple and more fast solution. 

You can use partitioning by date
http://www.postgresql.org/docs/9.1/interactive/ddl-partitioning.html.

>
> Any idea is appreciated. Thanks in advance.
>
>
> Best regards.
> liuhaifeng
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin



--
Sergey Konoplev

Blog: http://gray-hemp.blogspot.com
LinkedIn: http://ru.linkedin.com/in/grayhemp
JID/GTalk: gray.ru@gmail.com Skype: gray-hemp

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

Предыдущее
От: Haifeng Liu
Дата:
Сообщение: Daily Rotated Insertion
Следующее
От: Haifeng Liu
Дата:
Сообщение: Re: Daily Rotated Insertion