Postgres Pro
Downloads
Home   >   mailing lists

Re: followup to SELECT/INSERT problem - Mailing list pgsql-general

From Tom Lane
Subject Re: followup to SELECT/INSERT problem
Date
Msg-id 18729.961776031@sss.pgh.pa.us
Whole thread Raw
In response to followup to SELECT/INSERT problem  (Jim Mercer <jim@reptiles.org>)
Responses Re: followup to SELECT/INSERT problem  (Jim Mercer <jim@reptiles.org>)
List pgsql-general
Tree view 
Jim Mercer <jim@reptiles.org> writes:
> it appears that each call to UPDATE seems to be taking a long, long time to
> complete.

Poor choice of plan, maybe?  What does EXPLAIN say about how a typical
example of the UPDATE will be executed?

            regards, tom lane

pgsql-general by date:

Previous
From: Lamar Owen
Date:
Subject: Re: Show tables!
Next
From: Thomas Lockhart
Date:
Subject: Re: boolean isn't boolean?