nevermind. The query plan was done on test data with 50 partitions.
Sorry for the confusion.
On Mon, Feb 17, 2025 at 3:25 PM bruno vieira da silva
wrote:
> Well, the query plans were generated with pg 17.3. and the buffer usage
> was half.
> did pg 17.3 had any fixes to reduce the planning buffe
Well, the query plans were generated with pg 17.3. and the buffer usage was
half.
did pg 17.3 had any fixes to reduce the planning buffer usage?
On Mon, Feb 17, 2025 at 3:18 PM bruno vieira da silva
wrote:
> Hello, I did a more comprehensive test with a different number of
> partitions and I fou
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 Partitions: 12,828 (100MB)
100 Partitions: 9,329 (72MB)
50 Partitions: 3,305 (2
