Re: optimize lookups in snapshot [sub]xip arrays

Поиск
Список
Период
Сортировка
Искать
От
Nathan Bossart
Тема
Re: optimize lookups in snapshot [sub]xip arrays
Дата
Msg-id
20220808223254.GA1393216@nathanxps13
Ответ на
Список
Дерево обсуждения
optimize lookups in snapshot [sub]xip arrays Nathan Bossart <nathandbossart@gmail.com>
Re: optimize lookups in snapshot [sub]xip arrays Andres Freund <andres@anarazel.de>
Re: optimize lookups in snapshot [sub]xip arrays Nathan Bossart <nathandbossart@gmail.com>
Re: optimize lookups in snapshot [sub]xip arrays Nathan Bossart <nathandbossart@gmail.com>
Re: optimize lookups in snapshot [sub]xip arrays Andres Freund <andres@anarazel.de>
Re: optimize lookups in snapshot [sub]xip arrays Nathan Bossart <nathandbossart@gmail.com>
Re: optimize lookups in snapshot [sub]xip arrays John Naylor <john.naylor@enterprisedb.com>
Re: optimize lookups in snapshot [sub]xip arrays Nathan Bossart <nathandbossart@gmail.com>
Re: optimize lookups in snapshot [sub]xip arrays Nathan Bossart <nathandbossart@gmail.com>
Re: optimize lookups in snapshot [sub]xip arrays Andres Freund <andres@anarazel.de>
Re: optimize lookups in snapshot [sub]xip arrays Nathan Bossart <nathandbossart@gmail.com>
Re: optimize lookups in snapshot [sub]xip arrays Andres Freund <andres@anarazel.de>
Re: optimize lookups in snapshot [sub]xip arrays Nathan Bossart <nathandbossart@gmail.com>
Re: optimize lookups in snapshot [sub]xip arrays John Naylor <john.naylor@enterprisedb.com>
Re: optimize lookups in snapshot [sub]xip arrays Nathan Bossart <nathandbossart@gmail.com>
Re: optimize lookups in snapshot [sub]xip arrays John Naylor <john.naylor@enterprisedb.com>
Re: optimize lookups in snapshot [sub]xip arrays Nathan Bossart <nathandbossart@gmail.com>
Re: optimize lookups in snapshot [sub]xip arrays Andres Freund <andres@anarazel.de>
Re: optimize lookups in snapshot [sub]xip arrays Nathan Bossart <nathandbossart@gmail.com>
Re: optimize lookups in snapshot [sub]xip arrays Nathan Bossart <nathandbossart@gmail.com>
Re: optimize lookups in snapshot [sub]xip arrays John Naylor <john.naylor@enterprisedb.com>
Re: optimize lookups in snapshot [sub]xip arrays Nathan Bossart <nathandbossart@gmail.com>
Re: optimize lookups in snapshot [sub]xip arrays Masahiko Sawada <sawada.mshk@gmail.com>
Re: optimize lookups in snapshot [sub]xip arrays Nathan Bossart <nathandbossart@gmail.com>
Re: optimize lookups in snapshot [sub]xip arrays John Naylor <john.naylor@enterprisedb.com>
Re: optimize lookups in snapshot [sub]xip arrays Nathan Bossart <nathandbossart@gmail.com>
Re: optimize lookups in snapshot [sub]xip arrays Nathan Bossart <nathandbossart@gmail.com>
Re: optimize lookups in snapshot [sub]xip arrays John Naylor <john.naylor@enterprisedb.com>
Re: optimize lookups in snapshot [sub]xip arrays Nathan Bossart <nathandbossart@gmail.com>
Re: optimize lookups in snapshot [sub]xip arrays John Naylor <john.naylor@enterprisedb.com>
Re: optimize lookups in snapshot [sub]xip arrays Nathan Bossart <nathandbossart@gmail.com>
Re: optimize lookups in snapshot [sub]xip arrays Masahiko Sawada <sawada.mshk@gmail.com>
Re: optimize lookups in snapshot [sub]xip arrays Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: optimize lookups in snapshot [sub]xip arrays Nathan Bossart <nathandbossart@gmail.com>
Re: optimize lookups in snapshot [sub]xip arrays Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: optimize lookups in snapshot [sub]xip arrays Nathan Bossart <nathandbossart@gmail.com>
Re: optimize lookups in snapshot [sub]xip arrays Tom Lane <tgl@sss.pgh.pa.us>
Re: optimize lookups in snapshot [sub]xip arrays John Naylor <john.naylor@enterprisedb.com>
Re: optimize lookups in snapshot [sub]xip arrays Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: optimize lookups in snapshot [sub]xip arrays John Naylor <john.naylor@enterprisedb.com>
Re: optimize lookups in snapshot [sub]xip arrays Nathan Bossart <nathandbossart@gmail.com>
Re: optimize lookups in snapshot [sub]xip arrays Zhang Mingli <zmlpostgres@gmail.com>
Re: optimize lookups in snapshot [sub]xip arrays Yura Sokolov <y.sokolov@postgrespro.ru>
Re: optimize lookups in snapshot [sub]xip arrays Zhang Mingli <zmlpostgres@gmail.com>
Re: optimize lookups in snapshot [sub]xip arrays Nathan Bossart <nathandbossart@gmail.com>
Re: optimize lookups in snapshot [sub]xip arrays Zhang Mingli <zmlpostgres@gmail.com>
Re: optimize lookups in snapshot [sub]xip arrays Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: optimize lookups in snapshot [sub]xip arrays Nathan Bossart <nathandbossart@gmail.com>
On Mon, Aug 08, 2022 at 01:46:48PM +0700, John Naylor wrote:
> Okay, I think it's basically in good shape. Since it should be a bit
> faster than a couple versions ago, would you be up for retesting with
> the original test having 8 to 512 writers?

Sure thing.  The results are similar.  As before, the improvements are most
visible when the arrays are large.

	writers  head  patch
	8        672   680
	16       639   664
	32       701   689
	64       705   703
	128      628   653
	256      576   627
	512      530   584
	768      450   536
	1024     350   494

> And also add the const
> markers we discussed upthread?

Oops, sorry about that.  This is done in v9.

> Aside from that, I plan to commit this
> week unless there is further bikeshedding.

Great, thanks.

-- 
Nathan Bossart
Amazon Web Services: https://aws.amazon.com
В списке pgsql-hackers по дате отправления
От: Euler Taveira
Дата:
От: Thomas Munro
Дата:
FAQ