Re: Gist fastbuild and performances

2021-10-08 Thread talk to ben
On Fri, Oct 8, 2021 at 4:33 PM Francisco Olarte 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 f

Re: Gist fastbuild and performances

2021-10-08 Thread Francisco Olarte
Ben: On Fri, 8 Oct 2021 at 15:52, talk to ben wrote: > I ran the same scipt on both sides at first. > Then I switched to a COPY because the CREATE TABLE generates random data. Logical, just pointing that you missed one side is generating, the other is copying. Since I read a lot of things about

Re: Gist fastbuild and performances

2021-10-08 Thread talk to ben
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

Re: Gist fastbuild and performances

2021-10-08 Thread Francisco Olarte
Ben: On Fri, 8 Oct 2021 at 13:14, talk to ben wrote: > I am playing around with the gist fast build and comparing the result between > v13 and v14. ... > When I compare the performance with the following script, I get a lot more > data read into the buffers in v14 and a little slower query. ...

Gist fastbuild and performances

2021-10-08 Thread talk to ben
Hi, I am playing around with the gist fast build and comparing the result between v13 and v14. The space gain and speed increase are really awesome. When I compare the performance with the following script, I get a lot more data read into the buffers in v14 and a little slower query. Is it expec