Re: Very slow Query compared to Oracle / SQL - Server

Justin Pryzby <pryzby@telsasoft.com> writes:
> On Fri, May 07, 2021 at 05:57:19PM +0200, Semen Yefimenko wrote:
>> For testing purposes I set up a separate postgres 13.2 instance on windows.
>> To my surprise, it works perfectly fine. Also indexes, have about 1/4 of
>> the size they had on 12.6.

> In pg13, indexes are de-duplicated by default.
> But I suspect the performance is better because data was reload, and the
> smaller indexes are a small, additional benefit.

Index bloat is often a consequence of inadequate vacuuming.  You might
need to dial up autovacuum's aggressiveness to keep their sizes in check.

			regards, tom lane