Re: [PERFORM] Desperate: View not using indexes (very slow)

2006-01-29 Thread Tom Lane
Jen Sale <[EMAIL PROTECTED]> writes: > can someone please tell me what we did wrong? Joins against union subqueries aren't handled very well at the moment. (As it happens, I'm working on that exact problem right now for 8.2, but that won't help you today.) The plan indicates that you are using UN

[PERFORM] Desperate: View not using indexes (very slow)

2006-01-29 Thread Jen Sale
We recently segmented a large table into calendar month slices and were going to to replace the original, but we are not getting the results we think it should... Everything is vacuumed, and we are using 8.0.3 on amd64. Anything anyone can suggest would be appreciated, our backs against the wal