On Mar 13, 2006, at 5:25 PM, Casey Duncan wrote:
[..]
If I restart the postmaster, the query will complete in the expected
time.
Does the problem eventually start happening again? If so, after
how long? How did you determine that the restart is relevant? Do
you consistently see different (presumably better) performance after
a restart than if you don't restart?
I restarted postgres this morning and this time it didn't seem to help.
That query has been running for several hours now. I'm going to let it
go a while longer to see if it eventually completes, but I suspect it
won't. So perhaps the prior restart was just dumb luck.
I'll try some narrower queries as well.
-Casey
