| From: | Jehan-Guillaume de Rorthais <jgdr(at)dalibo(dot)com> |
|---|---|
| To: | Frank Millman <frank(at)chagford(dot)com> |
| Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: SELECT is faster on SQL Server |
| Date: | 2021-03-19 15:32:05 |
| Message-ID: | 20210319163205.2b86c71d@firost |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, 19 Mar 2021 14:28:27 +0200
Frank Millman <frank(at)chagford(dot)com> wrote:
> [...]
> Execution of my main query has improved from 50ms to 33ms. Sql Server
> takes 25ms, but this is much better than it was.
>
> [...]
>
> Here is the new EXPLAIN ANALYSE -
>
> QUERY PLAN
> --------------------------------------------------------------------
> Merge Left Join (...) (actual time=1.566..1.581 rows=5 loops=1)
1.581ms to output the very last row of this plan. This is in contradiction with
the 33ms you are referencing above.
What do I miss here? Maybe your 33ms comes yet from another set of data? Could
you share an explain analyze actually showing this 33ms total execution time?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Laurenz Albe | 2021-03-19 15:58:55 | Re: postgresql order lowercase before uppercase |
| Previous Message | asli cokay | 2021-03-19 15:03:57 | Re: WAL-G shipping to the cloud |