| From: | Kostas Papadopoulos <kostas(at)methodosit(dot)com(dot)cy> |
|---|---|
| To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
| Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Same query, same data different plan |
| Date: | 2022-10-11 06:06:43 |
| Message-ID: | 14b38f31-452c-22d6-6a4f-bd79e2e026b5@methodosit.com.cy |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi Adrian,
On 10/10/2022 20:59, Adrian Klaver wrote:
> Information needed:
>
> 1) The query and its EXPLAIN ANALYZE for both slow/fast cases.
>
> 2) Postgres version.
>
> 3) What database are the developers workstation pointing at?
>
> 4) What is the test db and is it the same as 3)?
>
> 5) What clients are you using to run the query?
>
Thanks for the interest. I was just looking for pointers on what to look at next. Got
that from Tom (table bloat) and Imre (different random sample of analyze).
Regards
kostas
| From | Date | Subject | |
|---|---|---|---|
| Next Message | gzh | 2022-10-11 08:01:41 | Re:Re: Re: Re: Re: Different execution plan between PostgreSQL 8.4 and 12.11 |
| Previous Message | Pavel Stehule | 2022-10-11 05:24:12 | Re: Re: Re: Re: Different execution plan between PostgreSQL 8.4 and 12.11 |