Re: [WIP PATCH] Index scan offset optimisation using visibility map

From: Andrey Borodin <x4mmm(at)yandex-team(dot)ru>
To: Michail Nikolaev <michail(dot)nikolaev(at)gmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Tels <nospam-pg-abuse(at)bloodgate(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [WIP PATCH] Index scan offset optimisation using visibility map
Date: 2018-05-22 10:30:52
Message-ID: F1D1EEF9-E788-442F-AB99-03C762C15A6E@yandex-team.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi, Michail!

> 21 мая 2018 г., в 20:43, Michail Nikolaev <michail(dot)nikolaev(at)gmail(dot)com> написал(а):
> This letter related to “Extended support for index-only-scan” from my previous message in the thread.
This is great that you continue your work in this direction! The concept of scan that you propose looks interesting.
I have few questions:
1. Charts are measured in percents of pgbench TPS, right?
2. For example, is 97% actually 3% degrade?
3. The results are obtained on actual "sort of TPC-B" script?

Best regards, Andrey Borodin.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Christoph Berg 2018-05-22 11:18:46 plperl fails with perl 5.28
Previous Message Heikki Linnakangas 2018-05-22 10:26:28 Re: Update backend/lib/README