"Bobbie van der Westhuizen" <Bobbie(at)idpi1(dot)agric(dot)za> writes:
>> If I had to bet at this point I'd bet on inefficient foreign-key checks,
>> but since we haven't seen any schema details that's purely
>> speculation.
> There are no foreign-keys in this table. What schema details do you
> need, then I can give it to you. I am a new user of postgreSQL so I am
> not clude-up with all of the stuff.
"pg_dump -s" is the easiest way of exhibiting the schema of a database.
regards, tom lane