Re: Bug? Query plans / EXPLAIN using gigabytes of memory - Mailing list pgsql-general

Toby Corkindale <toby.corkindale@strategicdata.com.au> writes:
> I'm still curious about why I can do a SELECT * FROM complexview without
> using much memory, but an UPDATE foo FROM complexview causes all the
> memory to get exhausted?

The former only requires the complexview to get planned once.

            regards, tom lane