Re: Daily Rotated Insertion - Mailing list pgsql-admin

From Sergey Konoplev
Subject Re: Daily Rotated Insertion
Date
Msg-id CAL_0b1sTAbkyUQUzKfnY6+yHQqSgZ9JVbBV6HH6KC6tu6zH5fA@mail.gmail.com
Whole thread Raw
In response to Daily Rotated Insertion  (Haifeng Liu <liuhaifeng@live.com>)
Responses Re: Daily Rotated Insertion  (Haifeng Liu <liuhaifeng@live.com>)
List 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 by date:

Previous
From: Haifeng Liu
Date:
Subject: Daily Rotated Insertion
Next
From: Haifeng Liu
Date:
Subject: Re: Daily Rotated Insertion