On 10/06/2012 08:45 AM, Liam Caffrey wrote:
Hi,
If I run a CTE does that materialize the resulting data in the same (or
a similar) way as if I created a temp table and referred to that
instead? Or does the CTE keep the set in memory?
Really good question, I too would be interested in this.
I'd expect it'd materialize to RAM if the result is within `work_mem`
but I'd love to know for sure.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
