From: | Casey Duncan <casey(at)pandora(dot)com> |
---|---|
To: | Michael Fuhr <mike(at)fuhr(dot)org> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Possible infinite loop in query using bitmap scans |
Date: | 2006-03-14 21:42:34 |
Message-ID: | a95e9969321f2c6a5c4eb1705d7aabfc@pandora.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Mar 14, 2006, at 1:31 PM, Casey Duncan wrote:
> 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.
Interestingly, I can only narrow the query by about an hour (i.e., a 23
hour span) before the plan changes to a simple index scan. That may
explain why this only started hanging recently since it probably only
started using the bitmap scan for a day interval recently.
Let me know if there is anything I should do or any info you need to
further pin this down.
In the mean time I will disable bitmap scans for this query.
Thanks.
-Casey
From | Date | Subject | |
---|---|---|---|
Next Message | Wes | 2006-03-14 21:53:02 | Re: Build failures on RedHat 3.0 with openssl/kerberos |
Previous Message | Casey Duncan | 2006-03-14 21:31:16 | Re: Possible infinite loop in query using bitmap scans |