| From: | "Nigel J(dot) Andrews" <nandrews(at)investsystems(dot)co(dot)uk> |
|---|---|
| To: | Kirill Ponazdyr <softlist(at)codeangels(dot)com> |
| Cc: | pg_general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Postgresql "FIFO" Tables, How-To ? |
| Date: | 2003-07-16 16:06:11 |
| Message-ID: | Pine.LNX.4.21.0307161705430.27661-100000@ponder.fairway2k.co.uk |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, 16 Jul 2003, Kirill Ponazdyr wrote:
> Hello,
>
> We are currently working on a project where we need to limit number of
> records in a table to a certain number. As soon as the number has been
> reached, for each new row the oldest row should be deleted (Kinda FIFO),
> thus keeping a total number of rows at predefined number.
>
> The actual limits would be anywhere from 250k to 10mil rows per table.
>
> It would be great if this could be achieved by RDBMS engine itself, does
> Postgres supports this kind of tables ? And if not, what would be the most
> elegant soluion to achieve our goal in your oppinion ?
>
An after insert trigger springs to mind.
--
Nigel Andrews
| From | Date | Subject | |
|---|---|---|---|
| Next Message | scott.marlowe | 2003-07-16 16:11:03 | Re: how to get table information from php client ? |
| Previous Message | Vivek Khera | 2003-07-16 16:03:40 | Re: Reverse compatibility |