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 15:09:51 |
Message-ID: | CAPE8EZ6PEstN7huVs---bWxrjE4CA3kfHP+4ruv2RV3CuZma7g@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Fri, Oct 8, 2021 at 4:33 PM Francisco Olarte <folarte(at)peoplecall(dot)com>
wrote:
> If you do not run the same sequences, you do not know. Note I do not
> know what exact sequences you have tested, I write with only what I
> have read as as input.
>
I ran this on both versions on fresh instances / clusters with the data
from a previous run :
\timing on
CREATE TABLE gist_fastbuild(pt point);
COPY gist_fastbuild FROM '/tmp/gist_fastbuild.copy';
CREATE INDEX ON gist_fastbuild USING gist (pt);
VACUUM ANALYZE gist_fastbuild;
\di+ gist_fastbuild_pt_idx
EXPLAIN (ANALYZE, BUFFERS) SELECT pt FROM gist_fastbuild WHERE pt <@
box(point(.5,.5), point(.75,.75));
I get the same results as before.
From | Date | Subject | |
---|---|---|---|
Next Message | Stephen Frost | 2021-10-08 19:08:19 | Re: LDAP authorization with postgresql |
Previous Message | Francisco Olarte | 2021-10-08 14:33:53 | Re: Gist fastbuild and performances |