Re: Enabling deduplication with system catalog indexes

2021-10-02 Thread Peter Geoghegan
On Fri, Oct 1, 2021 at 2:35 PM Bossart, Nathan wrote: > On 9/30/21, 3:44 PM, "Peter Geoghegan" wrote: > > I will commit this patch in a few days, barring objections. > > +1 Okay, pushed. Thanks -- Peter Geoghegan

Re: Enabling deduplication with system catalog indexes

2021-10-01 Thread Bossart, Nathan
On 9/30/21, 3:44 PM, "Peter Geoghegan" wrote: > On Wed, Sep 29, 2021 at 3:32 PM Peter Geoghegan wrote: >> I decided to run a simple experiment, to give us some idea of what >> benefits my proposal gives users: I ran "make installcheck" on a newly >> initdb'd database (master branch), and then wit

Re: Enabling deduplication with system catalog indexes

2021-09-30 Thread Peter Geoghegan
On Wed, Sep 29, 2021 at 3:32 PM Peter Geoghegan wrote: > I decided to run a simple experiment, to give us some idea of what > benefits my proposal gives users: I ran "make installcheck" on a newly > initdb'd database (master branch), and then with the attached patch > (which enables deduplication

Re: Enabling deduplication with system catalog indexes

2021-09-29 Thread Peter Geoghegan
On Wed, Sep 29, 2021 at 11:27 AM Peter Geoghegan wrote: > I would like to enable deduplication within system catalog indexes for > Postgres 15. I decided to run a simple experiment, to give us some idea of what benefits my proposal gives users: I ran "make installcheck" on a newly initdb'd databa

Enabling deduplication with system catalog indexes

2021-09-29 Thread Peter Geoghegan
System catalog indexes do not support deduplication as a matter of policy. I chose to do things that way during the Postgres 13 development cycle due to the restriction on using storage parameters with system catalog indexes. At the time I felt that *forcing* the use of deduplication with system ca