Toby Corkindale <toby.corkindale@xxxxxxxxxxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general