Re: keeping last 30 entries of a log table

From: "Dirk Jagdmann" <jagdmann(at)gmail(dot)com>
To: "Daniel CAUNE" <d(dot)caune(at)free(dot)fr>
Cc: "Jeff Frost" <jeff(at)frostconsultingllc(dot)com>, pgsql-sql(at)postgresql(dot)org
Subject: Re: keeping last 30 entries of a log table
Date: 2006-06-20 13:48:02
Message-ID: 5d0f60990606200648m3ff1e8b1h79e6fdb86ec97ac8@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

> Column id should be indexed indeed. Anyway, I'm not sure about any performance improvement using that last method, as the most consuming operation might be the DELETE operation, not really the SELECT operation, when dealing with a huge volume of 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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Jeff Frost 2006-06-20 14:12:41 Re: keeping last 30 entries of a log table
Previous Message satheesh Gnanasekaran 2006-06-20 06:25:03 Doubt in stored procedure