Re: Referential integrity Freeze - Mailing list pgsql-sql

From Rudi Starcevic
Subject Re: Referential integrity Freeze
Date
Msg-id 3DC70DE8.1080506@oasis.net.au
Whole thread Raw
In response to Re: Referential integrity Freeze  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-sql
Stephan,

Thanks for your reply.
No I don't have indexes on the *_id fields in bus_pc_idc. Now that you 
point it out it make perfect sense why this query would
take a while and give the impression it's hanging - it's all those seq 
scans.

Thank you kindly, I really appreicate it.
Regards
Rudi.




pgsql-sql by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Referential integrity Freeze
Next
From:
Date:
Subject: query optimization question