Re: Same query, same data different plan

On 10/10/2022 16:44, Ron wrote:
> How identical is "identical"?
>
> For example, does diff says that "pg_dump --schema-only" of DB1 and DB2 are perfectly
> identical?
>
> And are the table counts identical?

I created the second database using pg_dump from the first, so they should be exactly
the same.

>
> On 10/10/22 08:15, Kostas Papadopoulos wrote:
>> Hi,
>>
>> Thank you for responding. My question is not about the performance of a specific
>> query. As I wrote, that is already solved.
>>
>> My question is "how can it be that the same query run in two exactly the same
>> databases can have different plans."
>>
>>
>> Kostas Papadopoulos
>>
>> On 10/10/2022 16:12, Julien Rouhaud wrote:
>>> On Mon, Oct 10, 2022 at 04:05:42PM +0300, Kostas Papadopoulos wrote:
>>>> Hi,
>>>>
>>>> Yes, I ran ANALYZE in both databases.
>>>
>>> Please look at https://wiki.postgresql.org/wiki/Slow_Query_Questions to provide
>>> more information.
>>
>>
>