| From: | Semen Yefimenko <semen(dot)yefimenko(at)gmail(dot)com> |
|---|---|
| To: | didier <did447(at)gmail(dot)com> |
| Cc: | pgsql-performance <pgsql-performance(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Very slow Query compared to Oracle / SQL - Server |
| Date: | 2021-05-08 12:06:11 |
| Message-ID: | CAKnyMoLVas9bcV=wLZi+o1-Kfjka5+emBcOhe-gzDJjLKipWKw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
>
> Unless I'm overlooking something obvious one result has 500 000 rows the
> other 7 000.
You are right, it wasn't. I have 2 datasets, one containing 12 mil entries
and the other 14 mil entries. I accidentally used the one with 12 mil
entries in that table which actually only contains 7000~ entries for that
sql query.
For now I have tested the 12.6 Postgres with default values and it finished
in 12 seconds. I'll do some thorough testing and let you know once I
finish, sorry for the confusion.
Am Sa., 8. Mai 2021 um 00:17 Uhr schrieb didier <did447(at)gmail(dot)com>:
> Are you sure you're using the same data det ?
>
> Unless I'm overlooking something obvious one result has 500 000 rows the
> other 7 000.
>
>
>
>>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2021-05-08 16:39:33 | Re: [PATCH] force_parallel_mode and GUC categories |
| Previous Message | didier | 2021-05-07 22:17:02 | Re: Very slow Query compared to Oracle / SQL - Server |