Jeroen T. Vermeulen [EMAIL PROTECTED] writes:
So I suppose the planner has a good reason to ignore the index at that
point. I'm assuming that this is something to do with the correlation
between the index and the column's statistics degrading in some way.
Best to post explain analyze query
On Mon, July 2, 2007 18:15, Gregory Stark wrote:
So I suppose the planner has a good reason to ignore the index at that
point. I'm assuming that this is something to do with the correlation
between the index and the column's statistics degrading in some way.
Best to post explain analyze
Jeroen T. Vermeulen [EMAIL PROTECTED] writes:
Actually, come to think of it, I don't think I'd want any vacuums at all
on this particular table. Just the analyze on the primary key, no
vacuums, no statistics on anything else. Unfortunately it's not just one
table, but a set of tables that
On Mon, July 2, 2007 22:17, Gregory Stark wrote:
The way you described it there were records being inserted and later
deleted.
Why wouldn't you need vacuums?
Or are all the records eventually deleted and then the table truncated or
dropped before the next batch of inserts?
In a nuthshell,