Re: 7.4 - FK constraint performance - Mailing list pgsql-sql

From Tom Lane
Subject Re: 7.4 - FK constraint performance
Date
Msg-id 26131.1076555535@sss.pgh.pa.us
Whole thread Raw
In response to 7.4 - FK constraint performance  (ow <oneway_111@yahoo.com>)
List pgsql-sql
ow <oneway_111@yahoo.com> writes:
> When I try to delete record, it takes > 3 min. Why is it taking so long if 
> practically the same select query (see (2)) is running very quickly. Anything
> that can be done to fix it?

What are those column datatypes?
        regards, tom lane


pgsql-sql by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: 7.4 - FK constraint performance
Next
From: "boyd (remove_) tb_moore_@bealenet_.com"
Date:
Subject: Re: max timestamp