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.
