Re: Query performance on session table

On Jun 28, 2007, at 22:28 , Burak Seydioglu wrote:

> This query is really fast as you can see in my original post.

Ah. I should have referred to your original email.

> The garbage collector (DELETE FROM session WHERE session_expires <
> timestamp) has to do the same sequential scan.

You may find benefit from putting an index on the session_expires
column, though of course to maintain the index with a lot of updates,
you may see update performance degrade because the update requires
the index to be updated as well. The only way to find out is by
benchmarking your app and see what happens. With such a small number
of rows, the planner may determine that a sequential scan is still
faster than an index scan, so you'd end up with the same performance
on DELETE that you have now.

> Thank you for you input.

Well, we're both learning together :)

Michael Glaesemann
grzm seespotcode net