On Mon, 26 Jun 2023 at 12:55, Ranier Vilela wrote:
>
> Em dom., 25 de jun. de 2023 às 17:49, David Rowley
> escreveu:
>>
>> There's no reason in the world
>> that those will speed up Bitmapsets, so why include them?
>
> Of course optimization is the most important thing,
> but since you're going
On Mon, 26 Jun 2023 at 12:55, Ranier Vilela wrote:
> Have you seen bms_compare?
> For some reason someone thought it would be better to loop backward the array.
That's nothing to do with efficiency. It's related to behaviour. Have
a look at the function's header comment, it's trying to find the s
B ==
/usr/local/pgsql/bin/psql -U postgres -f
/home/ranier/Documentos/benchmarks/bitmapset/create-tables-b.sql
/usr/local/pgsql/bin/psql -U postgres -f
/home/ranier/Documentos/benchmarks/bitmapset/query-b.sql
patched v4:
Time: 1581,317 ms (00:01,581)
Time: 1568,371 ms (00:01,568)
Time: 1468,036 ms (00:01,468)
Time: 1445,698 ms (00:01,446)
patched v8:
Time: 1437,997 ms (00:01,438)
Time: 1437,435 ms (00:01,437)
Time: 1440,422 ms (00:01,440)
Time: 1436,112 ms (00:01,436)
regards,
Ranier Vilela
speeding-up-bitmapset-v8.patch
Description: Binary data
On Mon, 26 Jun 2023 at 00:29, Ranier Vilela wrote:
> Yuya Watari presented a series of patches, with the objective of improving
> the Bitmapset [1].
> After reading through the patches, I saw a lot of good ideas and thought I'd
> help.
> Unfortunately, my suggestions were not well received.
For
1777,995 ms (00:01,778)
Time: 1786,364 ms (00:01,786)
Time: 1778,891 ms (00:01,779)
patched v7 (forward)
Time: 2521,442 ms (00:02,521)
Time: 2452,695 ms (00:02,453)
Time: 2449,300 ms (00:02,449)
Time: 2439,535 ms (00:02,440)
speeding-up-bitmapset-v7.patch
Description: Binary data
create-tables-a.
