keeping last 30 entries of a log table

Поиск
Список
Период
Сортировка
От Jeff Frost
Тема keeping last 30 entries of a log table
Дата
Msg-id Pine.LNX.4.64.0606161924550.27250@glacier.frostconsultingllc.com
обсуждение исходный текст
Ответы Re: keeping last 30 entries of a log table  (Daniel CAUNE <d.caune@free.fr>)
Re: keeping last 30 entries of a log table  ("Ben K." <bkim@coe.tamu.edu>)
Список pgsql-sql
I need to write a function which inserts a log entry in a log table and only 
keeps the last 30 records.  I was thinking of using a subquery similar to the 
following:

insert into log (account_id, message) values (1, 'this is a test);
delete from log where account_id = 1 and id not in ( select id from log  where account_id = 1 order by timestamp desc
limit30);
 

I'm wondering if there is a more performance oriented method of doing the 
delete that I'm not thinking of.

-- 
Jeff Frost, Owner     <jeff@frostconsultingllc.com>
Frost Consulting, LLC     http://www.frostconsultingllc.com/
Phone: 650-780-7908    FAX: 650-649-1954


В списке pgsql-sql по дате отправления:

Предыдущее
От: PFC
Дата:
Сообщение: Re: sessions and prepared statements
Следующее
От: "sathish kumar shanmugavelu"
Дата:
Сообщение: Re: concurrency problem