Re: Same query, same data different plan - Mailing list pgsql-general

From Kostas Papadopoulos
Subject Re: Same query, same data different plan
Date
Msg-id 14b38f31-452c-22d6-6a4f-bd79e2e026b5@methodosit.com.cy
Whole thread Raw
In response to Re: Same query, same data different plan  (Adrian Klaver <adrian.klaver@aklaver.com>)
List 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



pgsql-general by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: Re: Re: Re: Different execution plan between PostgreSQL 8.4 and 12.11
Next
From: gzh
Date:
Subject: Re:Re: Re: Re: Re: Different execution plan between PostgreSQL 8.4 and 12.11