Re: Postgresql "FIFO" Tables, How-To ?

Поиск
Список
Период
Сортировка
От Thomas Kellerer
Тема Re: Postgresql "FIFO" Tables, How-To ?
Дата
Msg-id bf4ffd$kju$1@main.gmane.org
обсуждение исходный текст
Ответ на Re: Postgresql "FIFO" Tables, How-To ?  (Sean Chittenden <sean@chittenden.org>)
Ответы Re: Postgresql "FIFO" Tables, How-To ?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Sean Chittenden
Дата:
Сообщение: Re: Postgresql "FIFO" Tables, How-To ?
Следующее
От: nolan@celery.tssi.com
Дата:
Сообщение: Re: Anyone used pgHoster.com?