Hello, Your explanation aligns with the idea I had that having more
shared_buffers and connection pooling are very important in the context of
the partitioned tables.
Thanks. Regards.
On Tue, Feb 18, 2025 at 7:16 AM David Rowley wrote:
> On Tue, 18 Feb 2025 at 09:18, bruno vieira da silva
> wr
On Tue, 18 Feb 2025 at 09:18, bruno vieira da silva
wrote:
>
> Hello, I did a more comprehensive test with a different number of partitions
> and I found this:
>
> Summary buffers usage for the first call vs second call on the same session.
>
> Query 200, 100, 50, and 10 partitions:
> 200 Partiti
