[PoC] Implementation of distinct in Window Aggregates: take two

2023-08-27 Thread Ankit Pandey
Hi, This is reopening of thread: https://www.postgresql.org/message-id/flat/2ef6b491-1946-b606-f064-d9ea79d91463%40gmail.com#14e0bdb6872c0b26023d532eeb943d3e This is a PoC patch which implements distinct operation in window aggregates (without order by and for single column aggregation, final ver

[Question] pgwal increasing over max_wal_size

2023-06-02 Thread Ankit Pandey
Hi all, I am facing very unusual behaviour in our production postgres system running on pg15 and deployed on AWS. pgwal is mounted on a separate EBS drive with size of 100 GBs (on disk size as seen from df -hT). max_wal_size = 95 GB, min_wal_size = 1 GB, checkpoint_completion_target = 0.9 Issue i

[PoC] Implementation of distinct in Window Aggregates

2022-12-24 Thread Ankit Pandey
Hi, This is a PoC patch which implements distinct operation in window aggregates (without order by and for single column aggregation, final version may vary wrt these limitations). Purpose of this PoC is to get feedback on the approach used and corresponding implementation, any nitpicking as deeme