Re: Referential integrity Freeze

From: Rudi Starcevic <rudi(at)oasis(dot)net(dot)au>
To: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Referential integrity Freeze
Date: 2002-11-05 00:16:40
Message-ID: 3DC70DE8.1080506@oasis.net.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message terry 2002-11-05 00:19:46 query optimization question
Previous Message Stephan Szabo 2002-11-05 00:05:41 Re: Referential integrity Freeze