Re: [PERFORM] temporary indexes

2006-02-28 Thread Tom Lane
"Kevin Grittner" <[EMAIL PROTECTED]> writes: > It struck me that it would be outstanding if the planner could > recognize this sort of situation, and build a temporary index based on > the snapshot of the data visible to the transaction. I don't think that's an appropriate solution at all. What i

[PERFORM] temporary indexes

2006-02-28 Thread Kevin Grittner
Just a "wouldn't it be nice if" sort of feature request. I'm not sure how practical it is. Someone in our organization wrote a data fix query, which has sort of odd logic, but it does what they need. The problem is that it ran for 14 hours in a test against a copy of the data. I looked at it an