Postgres Pro
Downloads
Home   >   mailing lists

Re: keeping last 30 entries of a log table - Mailing list pgsql-sql

From Dirk Jagdmann
Subject Re: keeping last 30 entries of a log table
Date
Msg-id 5d0f60990606200648m3ff1e8b1h79e6fdb86ec97ac8@mail.gmail.com
Whole thread Raw
In response to Re: keeping last 30 entries of a log table  (Daniel CAUNE <d.caune@free.fr>)
Responses Re: keeping last 30 entries of a log table
List pgsql-sql
Tree view 
> Column id should be indexed indeed.  Anyway, I'm not sure about any performance improvement using that last method,
asthe most consuming operation might be the DELETE operation, not really the SELECT operation, when dealing with a huge
volumeof data.
 

why worry, there are a maximum of 30 Entries in this table anyway. So
even the most unoptimized select and delete combinations should be
very fast...

-- 
---> Dirk Jagdmann
----> http://cubic.org/~doj
-----> http://llg.cubic.org

pgsql-sql by date:

Previous
From: Daniel CAUNE
Date:
Subject: Re: keeping last 30 entries of a log table
Next
From: Jeff Frost
Date:
Subject: Re: keeping last 30 entries of a log table