Re: Very slow updates when using IN syntax subselect

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: pgsql-sql(at)postgresql(dot)org, Bryce Nesbitt <bryce1(at)obviously(dot)com>
Subject: Re: Very slow updates when using IN syntax subselect
Date: 2006-02-12 00:37:37
Message-ID: 744.1139704657@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> Bryce Nesbitt wrote:
>> They occur in fine time. That's good, thanks. But jeeze, can't
>> postgres figure this out for itself?

> I'm sure you wouldn't appreciate it if PostgreSQL did a full table scan
> before each query to figure out the total size of the involved tables.

It's also less than polite to complain about the behavior of
two-year-old releases, without making any effort to ascertain
whether more-current versions are smarter.

regards, tom lane

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Foster, Stephen 2006-02-12 22:27:48 Trigger/Sequence headache
Previous Message Bryce Nesbitt 2006-02-11 22:43:03 Re: Very slow updates when using IN syntax subselect