Re: Queries never returning...

From: Ian Harding <harding(dot)ian(at)gmail(dot)com>
To: John McCawley <nospam(at)hardgeus(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Queries never returning...
Date: 2005-12-28 20:16:03
Message-ID: 725602300512281216q762be82eq7e90a18f9beb6bc7@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 12/28/05, John McCawley <nospam(at)hardgeus(dot)com> wrote:
> I am currently having a problem with a query never finishing (or at
> least not in a reasonable amount of time.) I have had similar problems
> to this in Postgres over the past several years, and I have always found
> workarounds. This time I'd like to actually understand what is happening.
>

I bet it would go faster if you dropped the RI constraints and any
other triggers first.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2005-12-28 20:31:56 Re: importing an Oracle database into Postgres
Previous Message Matthew Hixson 2005-12-28 20:12:06 importing an Oracle database into Postgres