Postgres Pro
Downloads
Home   >   mailing lists

Re: Using CTE vs temporary tables - Mailing list pgsql-general

From Adam Brusselback
Subject Re: Using CTE vs temporary tables
Date
Msg-id CAMjNa7dH=Wg1t0JdxMU=OZetZ_Dm0sRrY9rxMbuMcQ7mKpsxEA@mail.gmail.com
Whole thread Raw
In response to Re: Using CTE vs temporary tables  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
Tree view
One thing to note, if this is a query you would like to run on a replica, temp tables are a non-starter.

I really wish that wasn't the case. I have quite a few analytical queries I had to optimize with temp tables and indexes, and I really wish I could run on my hot standby.

I in most cases I can't refactor them to use a CTE for performance reasons.

Anyways, my 2¢.
- Adam

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Using CTE vs temporary tables
Next
From: "Igal @ Lucee.org"
Date:
Subject: How to tell which event was fired in Trigger function