Re: [Patch] Make block and file size for WAL and relations defined at cluster creation

2018-01-04 Thread Remi Colinet
2018-01-03 22:04 GMT+01:00 Robert Haas : > On Wed, Jan 3, 2018 at 3:43 PM, Remi Colinet > wrote: > > Justifications are: > > I think this is all missing the point. If varying the block size (or > whatever) is beneficial, then having it configurable at initdb is > clearly

Re: [Patch v2] Make block and file size for WAL and relations defined at cluster creation

2018-01-04 Thread Remi Colinet
2018-01-03 23:11 GMT+01:00 Alvaro Herrera : > Remi Colinet wrote: > > Hello, > > > > This is version 2 of the patch to make the file and block sizes for WAL > and > > relations, run-time configurable at initdb. > > I don't think this works, since we

Re: [Patch] Make block and file size for WAL and relations defined at cluster creation

2018-01-03 Thread Remi Colinet
Hello, 2018-01-03 21:51 GMT+01:00 Andres Freund : > Hi, > > On 2018-01-03 21:43:51 +0100, Remi Colinet wrote: > > - we may test different combinations of file and block sizes, for the > > relation and the WAL in order to have the better performances of the > server. &g

Re: [Patch] Make block and file size for WAL and relations defined at cluster creation

2018-01-03 Thread Remi Colinet
2018-01-02 22:26 GMT+01:00 Robert Haas : > On Sun, Dec 31, 2017 at 12:00 PM, Remi Colinet > wrote: > > Below patch makes block and file sizes defined at cluster creation for > both > > the WAL and the relations. This avoids having different server builds for > > each po