Re: full table...

Felson <felson123@yahoo.com> writes:
> I am on 7.0 I am plaing an upgade at the end of the
> week as I am getting a new server to put it on. As for
> rules, there are a number of indexs, and 2 forign key
> rules.

Ah-hah.  I bet your problem is the foreign key rules.  Make sure you
have indexes on both ends of each foreign-key reference (ie, both the
referencing and referenced columns need indexes).  Also, vacuum analyze
both tables.  Then start a fresh backend and see if it's any better.
(You need a fresh backend because the plans for foreign-key check
queries are cached.)

            regards, tom lane