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

From Dmitry Tkach
Subject Re: Postgresql "FIFO" Tables, How-To ?
Date
Msg-id 3F158ED9.2070505@openratings.com
Whole thread Raw
In response to Re: Postgresql "FIFO" Tables, How-To ?  ("Kirill Ponazdyr" <softlist@codeangels.com>)
List pgsql-general
>
>
>
>Ouch, this means that for every insert we would have to trigger a
>procedure which will:
>
>COUNT
>IF > Limit
>DELETE OLDEST
>
>This would be pretty much damn ressource intensive on a table with million
>of records, would not it ?
>
>

You can keep the count in a table on the side, and have it updated by
the same trigger (after insert or delete)...

Dima



pgsql-general by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: ODBC query problem
Next
From: "Maksim Likharev"
Date:
Subject: Re: ODBC query problem