want hacked - Search results in mailing lists

2025-06-30 16:36:12 | Adding wait events statistics (Bertrand Drouvot)

hackers, Wait events are useful to know what backends are waiting for when there is/was a performance issue: for this we can sample pg_stat_activity at regular intervals and record historical data. That

2025-06-25 21:21:56 | Re: Add \pset options for boolean value display (David G. Johnston)

want this hack in psql. It fits with pset formats and affects our \d and other

2025-06-19 08:59:04 | Support for 8-byte TOAST values (aka the TOAST infinite loop problem) (Michael Paquier)

want to propose a new varatt_external dedicated to zstandard-compressed external pointers, but that's not for this thread. Please find attached a patch set I have finished with while poking at the problem

2025-06-09 23:27:07 | Improve tab completion for various SET/RESET forms (Dagfinn Ilmari Mannsåker)

hackers, I noticed that psql tab-completes every possible session-settable variable after RESET, not just the ones that have actually been set in the current session. However, as I was fixing that I noticed

2025-06-02 08:24:44 | SQL:2011 Application Time Update & Delete (Paul Jungwirth)

Hackers, Here is a new thread for the next part of SQL:2011 Application Time: UPDATE and DELETE commands with FOR PORTION OF. This continues the long-running thread that ended with

2025-05-12 21:05:03 | Re: Useless LEFT JOIN breaks MIN/MAX optimization (Tom Lane)

want. (I'm a bit surprised that it hasn't visibly broken existing test cases.) It might be possible to move preprocess_minmax_aggregates to happen after join removal, but I fear it'd require

2025-05-07 01:05:42 | Prolonged truncation phase during vacuum on toast table with repeated interruptions by lock waiters and (Shayon Mukherjee)

hackers, I'd like to discuss an issue we observed where the truncation phase of autovacuum can become significantly prolonged on toast tables of busy systems due to repeated interruptions by lock waiters, leading

2025-05-05 10:52:46 | Fix a race condition in ConditionVariableTimedSleep() (Bertrand Drouvot)

hackers, While working on wait event related stuff I observed a failed assertion: " TRAP: failed Assert("node->next == 0 && node->prev == 0"), File: "../../../../src/include/storage/proclist.h", Line: 91 " during pg_regress/database. To reproduce, add an ereport

2025-05-05 08:32:45 | RFC: Command Restrictions by INI file with Audit Logging (DROP/TRUNCATE/DELETE) (ADRIANO BOLLER)

Hackers, I'd like to propose a lightweight security enhancement feature to PostgreSQL, focused on environments where additional command restrictions are required — such as production databases with compliance constraints. ### Proposal Summary The idea

2025-05-04 08:47:53 | PATCH: pg_dump to support "on conflict do update" (Tanin Na Nakorn)

hackers, Here's the patch (against the latest master) that will make pg_dump support "on conflict do update" . I've used this patch on v16 for our company's CI (on Github Actions

2025-05-04 01:31:51 | Re: PG 18 release notes draft committed (Alexander Borisov)

hackers, I'm not sure, but I'll ask. I have significantly improved the handling of Unicode Case in PostgreSQL. The improvements affect important functions such as lower(), upper(), casefold(). Specifically, the patch has significantly

2025-05-02 16:00:29 | Small fixes needed by high-availability tools (Andrey Borodin)

hackers! I want to revive attempts to fix some old edge cases of physical quorum

2025-04-30 20:27:31 | Improve explicit cursor handling in pg_stat_statements (Sami Imseih)

hackers, I recently looked into a workload that makes heavy use of explicit cursors, and I found that pg_stat_statements can become a bottleneck. The application in question declares hundreds of cursors

2025-04-13 14:01:56 | Call for Posters: PGConf.dev 2025 (Andrey Borodin)

hackers, As we prepare for the PostgreSQL Development Conference 2025 (PGConf.dev 2025), scheduled for May 13–16 in Montreal, Canada, we are excited to host a poster session showcasing the contributions and projects within