Re: Postgresql "FIFO" Tables, How-To ? - Mailing list pgsql-general

From Thomas Kellerer
Subject Re: Postgresql "FIFO" Tables, How-To ?
Date
Msg-id bf4ffd$kju$1@main.gmane.org
Whole thread Raw
In response to Re: Postgresql "FIFO" Tables, How-To ?  (Sean Chittenden <sean@chittenden.org>)
Responses Re: Postgresql "FIFO" Tables, How-To ?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Sean Chittenden schrieb:
> That doesn't help you limit the number of rows in the table though
> because what row is going to get "pushed out" of the table?  The nifty
> thing about using a wrapping sequence is that the id's are sequential
> across transactions, which correctly maps to the progression of time,
> which obviates the need for relying on any kind of a date column for
> doing syslog message ordering.
>
But isn't that exactly the problem? Once the sequence wraps around how do I
know that id=1 is actually later then id=2 without a date column?

Thomas


pgsql-general by date:

Previous
From: Sean Chittenden
Date:
Subject: Re: Postgresql "FIFO" Tables, How-To ?
Next
From: nolan@celery.tssi.com
Date:
Subject: Re: Anyone used pgHoster.com?