Re: optimize lookups in snapshot [sub]xip arrays
От
Nathan Bossart
Тема
Re: optimize lookups in snapshot [sub]xip arrays
Дата
Msg-id
20220808223254.GA1393216@nathanxps13
Ответ на
Re: optimize lookups in snapshot [sub]xip arrays (John Naylor)
Список
Дерево обсуждения
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 по дате отправления