Re: Daily Rotated Insertion

From: Sergey Konoplev <gray(dot)ru(at)gmail(dot)com>
To: Haifeng Liu <liuhaifeng(at)live(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Daily Rotated Insertion
Date: 2012-03-27 04:42:45
Message-ID: CAL_0b1sTAbkyUQUzKfnY6+yHQqSgZ9JVbBV6HH6KC6tu6zH5fA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

On Mon, Mar 26, 2012 at 9:39 AM, Haifeng Liu <liuhaifeng(at)live(dot)com> wrote:
> Well, I can create a trigger to redirect insertion to 'yesterday', 'today' and 'tomorrow', but I am still expecting a more simple 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(at)postgresql(dot)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(dot)ru(at)gmail(dot)com Skype: gray-hemp

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Haifeng Liu 2012-03-27 06:02:11 Re: Daily Rotated Insertion
Previous Message Haifeng Liu 2012-03-26 05:39:01 Daily Rotated Insertion