Re: Gist fastbuild and performances

From: talk to ben <blo(dot)talkto(at)gmail(dot)com>
To: Francisco Olarte <folarte(at)peoplecall(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Gist fastbuild and performances
Date: 2021-10-08 13:52:04
Message-ID: CAPE8EZ7pvW4aSkGiXKP_Ae8anSbp0HoYawKW+SVnMTrBCknG3Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi, thanks for the answer.

I ran the same scipt on both sides at first.
Then I switched to a COPY because the CREATE TABLE generates random data.
Since I got weird results, I wanted to be sure I had the same data on both
versions.

I ran the tests several times (and even asked a collegue to do it on his
laptop) with the same results.

I totally agree that the query time are small and difficult to compare (but
they are consistent across runs).
I am just surprised that we have to access x17 pages for the same result on
version 14. On bigger queries
it could count. I just wanted to know if it's a know tradeoff of this new
feature.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Francisco Olarte 2021-10-08 14:33:53 Re: Gist fastbuild and performances
Previous Message Keith Brown 2021-10-08 12:56:37 LDAP authorization with postgresql