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