Re: updates (postgreSQL) very slow - Mailing list pgsql-general

From Tom Lane
Subject Re: updates (postgreSQL) very slow
Date
Msg-id 19945.1079018788@sss.pgh.pa.us
Whole thread Raw
In response to Re: updates (postgreSQL) very slow  ("Bobbie van der Westhuizen" <Bobbie@irene.agric.za>)
List pgsql-general
"Bobbie van der Westhuizen" <Bobbie@idpi1.agric.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

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: updates (postgreSQL) very slow
Next
From: Tom Lane
Date:
Subject: Re: "make check" fails for 7.4.2 checked out from CVS