Mike Glover <[EMAIL PROTECTED]> writes:
> Tom Lane <[EMAIL PROTECTED]> wrote:
>> It seems unlikely that the raw row inserts and updating the single
>> index could be quite that slow --- perhaps you have a foreign key
>> or trigger performance problem?
>There are no foreign keys or triggers for
Tom-
Thanks for the quick response. More details are inline.
-mike
On Thu, 01 Jan 2004 23:06:11 -0500
Tom Lane <[EMAIL PROTECTED]> wrote:
> Mike Glover <[EMAIL PROTECTED]> writes:
> AFAICS these plans are identical, and therefore the difference in
> runtime must be ascribed to the time spe
Mike Glover <[EMAIL PROTECTED]> writes:
> I want to run the following query, but it takes a *very* long time.
> Like this:
> bookshelf=> explain analyze update summary set price_min=0,
> availability=2, condition=9 where isbn = inventory.isbn and price_min =
> inventory.price;
I have these two tables:
Table "de.summary"
Column|Type | Modifiers
--+-+---
isbn | character varying(10) | not null
source | character varying(20) | not null
