| From: | Adam Brusselback <adambrusselback(at)gmail(dot)com> |
|---|---|
| To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
| Cc: | Ravi Krishna <sravikrishna3(at)gmail(dot)com>, hmidi slim <hmidi(dot)slim2(at)gmail(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Using CTE vs temporary tables |
| Date: | 2018-07-11 16:59:42 |
| Message-ID: | CAMjNa7dH=Wg1t0JdxMU=OZetZ_Dm0sRrY9rxMbuMcQ7mKpsxEA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Igal @ Lucee.org | 2018-07-11 17:36:49 | How to tell which event was fired in Trigger function |
| Previous Message | David G. Johnston | 2018-07-11 16:41:09 | Re: Using CTE vs temporary tables |