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?
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.
--
Angular momentum makes the world go 'round.
