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: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin

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

> 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:

Sergey Konoplev

JID/GTalk: gray(dot)ru(at)gmail(dot)com Skype: gray-hemp

In response to


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-2017 The PostgreSQL Global Development Group