pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Justin Pryzby <pryzby@telsasoft.com>
Cc: Semen Yefimenko <semen.yefimenko@gmail.com>
Cc: Vijaykumar Jain <vijaykumarjain.github@gmail.com>
Cc: pgsql-performance@lists.postgresql.org
Subject: Re: Very slow Query compared to Oracle / SQL - Server
Date: Fri, 07 May 2021 12:28:42 -0400
Message-ID: <41316.1620404922@sss.pgh.pa.us> (raw)
In-Reply-To: <20210507161551.GT27406@telsasoft.com>
References: <CAKnyMoKUUSPiH=0QaM38GYm8UqVeR47HmX+MX+UpyL0mLERBrw@mail.gmail.com>
	<CAJnEWwmJg1aUbv5h2zsuWD2i0K-Jc052TTCGAspwv2BYejH3xQ@mail.gmail.com>
	<CAKnyMo+fqJk+0ASfonf4sLghr3R66FyFV5y1tv6tUh4SHKyykg@mail.gmail.com>
	<CAM+6J97Rcg3XOLjSoC0XXyA4SW=gqSzBJQQsGXwo1r2=5bcRGg@mail.gmail.com>
	<CAKnyMoKp9Mck1A2La+mcrwto9+T72ieUOc2Ubfr5C0VhcRAPHw@mail.gmail.com>
	<CAM+6J96ybUF4=bxh1Mc9VnYXfiJyZiHM_YxpasdF86cRHQMvAA@mail.gmail.com>
	<CAKnyMoJb=+hBwOG97zd2Jbumg1BZuYpEqTPWStaFFNmfArBvQA@mail.gmail.com>
	<20210507161551.GT27406@telsasoft.com>

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





view thread (25+ messages)  latest in thread

Message-ID: <41316.1620404922@sss.pgh.pa.us>
Permalink:  ../41316.1620404922@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/41316.1620404922@sss.pgh.pa.us

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: tgl@sss.pgh.pa.us, pryzby@telsasoft.com, semen.yefimenko@gmail.com, vijaykumarjain.github@gmail.com, pgsql-performance@lists.postgresql.org
  Subject: Re: Very slow Query compared to Oracle / SQL - Server
  In-Reply-To: <41316.1620404922@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox