Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group