Re: Gist fastbuild and performances

Поиск
Список
Период
Сортировка
От talk to ben
Тема Re: Gist fastbuild and performances
Дата
Msg-id CAPE8EZ6PEstN7huVs---bWxrjE4CA3kfHP+4ruv2RV3CuZma7g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Gist fastbuild and performances  (Francisco Olarte <folarte@peoplecall.com>)
Список pgsql-general
On Fri, Oct 8, 2021 at 4:33 PM Francisco Olarte <folarte@peoplecall.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.

В списке pgsql-general по дате отправления:

Предыдущее
От: Francisco Olarte
Дата:
Сообщение: Re: Gist fastbuild and performances
Следующее
От: Stephen Frost
Дата:
Сообщение: Re: LDAP authorization with postgresql