Re: Query planning read a large amount of buffers for partitioned tables

2025-01-16 Thread bruno vieira da silva
Hello, Thanks David. this pg test deployment. anyways I did a vacuum full on the db. and the number of buffers read increased a bit. On Wed, Jan 15, 2025 at 3:01 PM David Rowley wrote: > On Thu, 16 Jan 2025 at 07:29, bruno vieira da silva > wrote: > > On pg 17 now we have better visibility on

Re: Query planning read a large amount of buffers for partitioned tables

2025-01-15 Thread David Rowley
On Thu, 16 Jan 2025 at 07:29, bruno vieira da silva wrote: > On pg 17 now we have better visibility on the I/O required during query > planning. > so, as part of an ongoing design work for table partitioning I was analyzing > the performance implications of having more or less partitions. > In o

Re: Query planning read a large amount of buffers for partitioned tables

2025-01-15 Thread bruno vieira da silva
correction: Is there a way to have *visibility* on its usage? thanks On Wed, Jan 15, 2025 at 1:29 PM bruno vieira da silva wrote: > Hello All. > > On pg 17 now we have better visibility on the I/O required during query > planning. > so, as part of an ongoing design work for table partitioning I

Query planning read a large amount of buffers for partitioned tables

2025-01-15 Thread bruno vieira da silva
Hello All. On pg 17 now we have better visibility on the I/O required during query planning. so, as part of an ongoing design work for table partitioning I was analyzing the performance implications of having more or less partitions. In one of my tests of a table with 200 partitions using explain