Tom Lane wrote:
> Kai Hessing <[EMAIL PROTECTED]> writes:
>> No one any idea? *sigh*
>
> What makes you think it's a deadlock and not a very slow query? I'd be
> checking if the tables were all ANALYZEd and comparing EXPLAIN output
> to the old database ...
*hmm* the difference of 5 seconds on 8.0.8 compared to killing the
process after 40 hours?
All databases are ANALYZEd and EXPLAIN output cannot be compared because
it hangs also up on 8.0.8.
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org