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
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
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
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