Re: Huge query stalls at PARSE/BIND stage (2)

From: Matt Carter <mjc(at)philips(dot)org(dot)uk>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Huge query stalls at PARSE/BIND stage (2)
Date: 2005-11-17 15:38:15
Message-ID: 1132241895.1877.94.camel@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

I've been investigating this problem further.

I've tried adding first just 2, then 4 more FULL JOINs to the statement.
This works and the statement
gets to INSERT and completes successfully.

If I add 16 further FULL JOINs however, it does not.

Regards,
Matt

P.S. Apologies for the grammar errors in the previous email. I was
exhausted yesterday.

***********************************************
IMPORTANT: This email and any attachments may be confidential and/or privileged. Everything is intended for use of the addressee only. If you are not the named addressee you must not disseminate, distribute or copy this email. If you receive this email in error please notify the sender by replying to this email or by telephoning (+44)(0)1325 383876 then delete this message from your system. Philips Collection Services Ltd. ("Philips") routinely monitors the content of email sent and received on its network, to ensure compliance with its policies and procedures. Although Philips have taken reasonable precautions to ensure no viruses are present in this email or any files attached to it, it cannot accept any responsibility for any loss or damage arising from the use of this email or its attachments and advises you to carry out appropriate virus checks. Philips are not responsible for any changes made to the message after it has been sent nor any files attached to it after it wa
s sent. Emails that contain encrypted material, program files, are obscene, inflammatory, criminal, offensive, in breach of copyright, contain a virus or threat to computer systems, appear to be a threat to the company or in breach of company policy may be intercepted and/or deleted. Philips does not accept any liability for any statements made which are clearly the sender's own and not made on behalf of Philips.
***********************************************

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2005-11-17 15:53:16 Re: Autovacuum deadlock - bug or not?
Previous Message Mikael Carneholm 2005-11-17 15:20:44 Re: Autovacuum deadlock - bug or not?