Postgres Pro
Downloads
Home   >   mailing lists

CTE materializing sets? - Mailing list pgsql-general

From Liam Caffrey
Subject CTE materializing sets?
Date
Msg-id CAM3RZT7xOkZ+UAANhzGiQ+q6HALr5BzoWpYLXMKCx=B=dg3dXw@mail.gmail.com
Whole thread Raw
Responses Re: CTE materializing sets?  (Craig Ringer <ringerc@ringerc.id.au>)
List pgsql-general
Tree view
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?

Regards

Liam

pgsql-general by date:

Previous
From: Shashank Tripathi
Date:
Subject: Re: [Pgbouncer-general] Again, problem with pgbouncer
Next
From: Johnny Tan
Date:
Subject: Re: [Pgbouncer-general] Again, problem with pgbouncer