pgsql-hackers since 2022-08-01 17:08

The PostgreSQL developers team lives here. Discussion of current development issues, problems and bugs, and proposed new features. If your question cannot be answered by people in the other lists, and it is likely that only a developer will know the answer, you may re-post your question in this list. You must try elsewhere first!

Search the Archives

(enter a message-id to go directly to that message)
Advanced Search

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31

Aug. 1, 2022

Thread Author Time
Re: Avoid unecessary MemSet call (src/backend/utils/cache/relcache.c) 📎 Ranier Vilela 17:08
Re: [Commitfest 2022-07] Patch Triage: Waiting on Author Robert Haas 17:20
Re: pg_auth_members.grantor is bunk Robert Haas 17:33
Re: [Commitfest 2022-07] Patch Triage: Waiting on Author Tom Lane 17:33
Re: [Commitfest 2022-07] is Done! Alvaro Herrera 17:33
Re: pg_auth_members.grantor is bunk Tom Lane 17:38
fix typos 📎 Erik Rijkers 18:04
Re: fix typos 📎 Justin Pryzby 18:11
Re: using file cloning in create database / initdb 📎 Justin Pryzby 18:15
Re: Allow pageinspect's bt_page_stats function to return a set of rows instead of a single row Naeem Akhter 18:28
Re: enable/disable broken for statement triggers on partitioned tables Alvaro Herrera 18:58
Re: enable/disable broken for statement triggers on partitioned tables Tom Lane 19:13
Re: [feature]COPY FROM enable FORCE_NULL/FORCE_NOT_NULL on all columns Andrew Dunstan 19:50
Re: pg_auth_members.grantor is bunk 📎 Robert Haas 19:51
Re: Making Vars outer-join aware 📎 Tom Lane 19:51
Re: [feature]COPY FROM enable FORCE_NULL/FORCE_NOT_NULL on all columns Andrew Dunstan 19:53
PostgreSQL 15 minor fixes in protocol.sgml 📎 Ekaterina Kiryanova 20:00
Re: [Commitfest 2022-07] Patch Triage: Waiting on Author Robert Haas 20:01
Re: Checking pgwin32_is_junction() errors Andrew Dunstan 20:06
Re: The "char" type versus non-ASCII characters Andrew Dunstan 20:11
Re: The "char" type versus non-ASCII characters Tom Lane 20:16
Re: [PATCH] Implement INSERT SET syntax Jacob Champion 20:18
Re: A problem about partitionwise join Jacob Champion 20:24
Re: Making Vars outer-join aware Tom Lane 20:26
Re: Making Vars outer-join aware Zhihong Yu 20:28
Re: Strange behavior with polygon and NaN Jacob Champion 20:29
Re: [PATCH] New default role allowing to change per-role/database settings Jacob Champion 20:31
Re: Showing applied extended statistics in explain Jacob Champion 20:38
Re: Map WAL segment files on PMEM as WAL buffers Jacob Champion 20:40
Re: Improve logging when using Huge Pages Jacob Champion 20:45
Re: [PATCH] psql: \dn+ to show size of each schema (and \dA+ for AMs) Jacob Champion 20:47
Re: pgcrypto support for bcrypt $2b$ hashes Jacob Champion 20:51
Re: pg15b2: large objects lost on upgrade Jonathan S. Katz 21:17
Re: allow building trusted languages without the untrusted versions Jacob Champion 21:41
Re: Improving connection scalability (src/backend/storage/ipc/procarray.c) Jacob Champion 21:51
Re: Skip partition tuple routing with constant partition key David Rowley 21:58
Re: Can postgres ever delete the recycled future WAL files to free-up disk space if max_wal_size is reduced or wal_recycle is set to off? Jacob Champion 22:03
Re: Add test of pg_prewarm extenion Tom Lane 22:09
Re: using file cloning in create database / initdb Thomas Munro 22:13
Re: [Commitfest 2022-07] is Done! Jacob Champion 23:03
Re: Is select_outer_pathkeys_for_merge() too strict now we have Incremental Sorts? David Rowley 23:04
Re: [Commitfest 2022-07] is Done! Jacob Champion 23:08
[PATCH] postgresql.conf.sample comment alignment. 📎 Peter Smith 23:24
Re: Improving connection scalability (src/backend/storage/ipc/procarray.c) Ranier Vilela 23:27
Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size Andres Freund 23:27
[DOCS] Stats views and functions not in order? Peter Smith 23:40
Re: Table AM and DROP TABLE [ Was: Table AM and DDLs] Andres Freund 23:44

Aug. 2, 2022

Thread Author Time
Re: [PATCH] postgresql.conf.sample comment alignment. Tom Lane 00:03
Re: Cleaning up historical portability baggage 📎 Thomas Munro 00:18
Re: [PATCH] postgresql.conf.sample comment alignment. Peter Smith 00:28
Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size Andres Freund 00:39
Re: pg_buffercache: add sql test Dong Wook Lee 00:50
Re: Avoid unecessary MemSet call (src/backend/utils/cache/relcache.c) Peter Smith 01:19
pgstattuple: add test for coverage 📎 Dong Wook Lee 01:36
Re: enable/disable broken for statement triggers on partitioned tables Amit Langote 01:43
Re: Handle infinite recursion in logical replication setup Peter Smith 02:01
Re: add test: pg_rowlocks extension Dong Wook Lee 02:32
Missing CFI in iterate_word_similarity() 📎 Robins Tharakan 02:41
Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size Amit Langote 03:05
Re: Typo in pg_db_role_setting.h Richard Guo 03:06
RE: Support logical replication of DDLs 📎 [email protected] 03:20
Re: Typo in pg_db_role_setting.h John Naylor 04:13
Re: allow building trusted languages without the untrusted versions Nathan Bossart 04:29
COPY TO (FREEZE)? 📎 Kyotaro Horiguchi 04:30
Re: [Refactor]Avoid to handle FORCE_NOT_NULL/FORCE_NULL options when COPY TO Kyotaro Horiguchi 04:30
Re: Typo in pg_db_role_setting.h Japin Li 04:34
Re: Typo in pg_db_role_setting.h John Naylor 04:43
Re: Question about user/database-level parameters Kyotaro Horiguchi 05:01
Re: remove more archiving overhead 📎 Nathan Bossart 05:02
Re: fix typos John Naylor 05:28
Re: Question about user/database-level parameters Japin Li 05:33
Re: Question about user/database-level parameters Tom Lane 05:44
Re: pgstattuple: add test for coverage Tom Lane 05:47
Re: fix typos John Naylor 05:52
Re: Question about user/database-level parameters Japin Li 05:59
Re: Pluggable toaster 📎 Nikita Malakhov 06:15
Re: COPY TO (FREEZE)? Julien Rouhaud 06:17
Re: Progress report removal of temp files and temp relation files using ereport_startup_progress 📎 Bharath Rupireddy 06:22
Re: [BUG] Logical replication failure "ERROR: could not map filenode "base/13237/442428" to relation OID" with catalog modifying txns Kyotaro Horiguchi 06:30
Re: [Commitfest 2022-07] is Done! Alvaro Herrera 06:44
Re: Using each rel as both outer and inner for JOIN_ANTI Richard Guo 07:13
Re: Skip partition tuple routing with constant partition key Amit Langote 07:19
Generalize ereport_startup_progress infrastructure 📎 Bharath Rupireddy 07:25
Re: Typo in pg_db_role_setting.h Richard Guo 07:37
Re: Strange behavior with polygon and NaN Kyotaro Horiguchi 07:44
Re: Typo in pg_db_role_setting.h Daniel Gustafsson 07:45
Re: Typo in pg_db_role_setting.h Japin Li 07:58
Re: [Refactor]Avoid to handle FORCE_NOT_NULL/FORCE_NULL options when COPY TO 📎 Zhang Mingli 08:13
Re: COPY TO (FREEZE)? Kyotaro Horiguchi 08:17
Re: COPY TO (FREEZE)? Zhang Mingli 08:20
Re: [BUG] Logical replication failure "ERROR: could not map filenode "base/13237/442428" to relation OID" with catalog modifying txns Amit Kapila 08:24
RE: [BUG] Logical replication failure "ERROR: could not map filenode "base/13237/442428" to relation OID" with catalog modifying txns [email protected] 08:31
Re: fix typos Erik Rijkers 08:32
Re: Column Filtering in Logical Replication Amit Kapila 08:57
Fix obsoleted comments for function prototypes 📎 Richard Guo 09:06
RE: Handle infinite recursion in logical replication setup [email protected] 09:31
Re: POC: GROUP BY optimization Michael Paquier 10:21
support for SSE2 intrinsics John Naylor 10:22
Re: Fix obsoleted comments for function prototypes Michael Paquier 10:25
Re: [PATCH] Fix pg_upgrade test from v10 Michael Paquier 10:28
Re: Allow file inclusion in pg_hba and pg_ident files Michael Paquier 10:32
Re: Slow standby snapshot Simon Riggs 10:47
Re: PostgreSQL 15 minor fixes in protocol.sgml Michael Paquier 10:58
Re: POC: GROUP BY optimization David Rowley 11:14
Re: Add proper planner support for ORDER BY / DISTINCT aggregates David Rowley 11:21
Re: remove more archiving overhead David Steele 11:23
[PATCH] Add a inline function to eliminate duplicate code 📎 Junwang Zhao 11:27
Re: Slow standby snapshot Andrey Borodin 11:32
RE: Perform streaming logical transactions by background workers and parallel apply 📎 [email protected] 11:46
Re: Avoid unecessary MemSet call (src/backend/utils/cache/relcache.c) Ranier Vilela 11:55
Re: Handle infinite recursion in logical replication setup Amit Kapila 11:59
Re: add test: pg_rowlocks extension 📎 Dong Wook Lee 12:03
Re: Perform streaming logical transactions by background workers and parallel apply Amit Kapila 12:05
Re: Typo in "43.9.1. Reporting Errors and Messages"? Euler Taveira 12:49
Re: Avoid unecessary MemSet call (src/backend/utils/cache/relcache.c) mahendrakar s 13:17
Re: Add proper planner support for ORDER BY / DISTINCT aggregates Tom Lane 13:19
Re: Patch proposal: New hooks in the connection path Drouvot, Bertrand 13:23
Re: [PATCH] Add a inline function to eliminate duplicate code mahendrakar s 13:23
Re: Race between KeepFileRestoredFromArchive() and restartpoint David Steele 14:14
Re: Avoid unecessary MemSet call (src/backend/utils/cache/relcache.c) Ranier Vilela 14:18
Re: Race between KeepFileRestoredFromArchive() and restartpoint Noah Misch 14:37
Why is DEFAULT_FDW_TUPLE_COST so insanely low? 📎 David Rowley 14:56
Re: Add proper planner support for ORDER BY / DISTINCT aggregates David Rowley 14:59
Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size Andres Freund 15:00
Re: Race between KeepFileRestoredFromArchive() and restartpoint David Steele 15:01
Re: Slow standby snapshot 📎 Simon Riggs 15:18
Re: Pluggable toaster Andres Freund 15:37
Cutting test runtime for src/test/modules/snapshot_too_old 📎 Tom Lane 15:38
Re: support for SSE2 intrinsics Nathan Bossart 16:53
Re: pg15b2: large objects lost on upgrade Tom Lane 17:12
Re: Cutting test runtime for src/test/modules/snapshot_too_old Robert Haas 17:28
Re: pg_auth_members.grantor is bunk Jacob Champion 17:48
Re: [Proposal] Fully WAL logged CREATE DATABASE - No Checkpoints Justin Pryzby 17:50
Re: Cutting test runtime for src/test/modules/snapshot_too_old Tom Lane 17:50
Re: [PATCH] Add sortsupport for range types and btree_gist Jacob Champion 18:01
Re: Add proper planner support for ORDER BY / DISTINCT aggregates 📎 Zhihong Yu 18:02
Re: Add index scan progress to pg_stat_progress_vacuum Jacob Champion 18:06
Re: [PROPOSAL] Detecting plan changes with plan_id in pg_stat_activity Jacob Champion 18:11
Re: Parse CE and BCE in dates and times Jacob Champion 18:13
Re: Restructure ALTER TABLE notes to clarify table rewrites and verification scans Jacob Champion 18:17
Re: Finer grain log timestamps Jacob Champion 18:27
Re: Generalize ereport_startup_progress infrastructure Robert Haas 18:40
Re: Add LZ4 compression in pg_dump Jacob Champion 18:42
Re: TAP output format in pg_regress Jacob Champion 18:44
Re: Add last commit LSN to pg_last_committed_xact() Jacob Champion 18:50
Re: WaitLatchOrSocket seems to not count to 4 right... Jacob Champion 18:52
Re: Avoiding smgrimmedsync() during nbtree index builds Jacob Champion 18:54
Re: speed up a logical replica setup Jacob Champion 18:56
Re: [WIP] Allow pg_upgrade to copy segments of the same relfilenode in parallel Jacob Champion 18:58
Re: Speed up transaction completion faster after many relations are accessed in a transaction Jacob Champion 19:04
Re: pg15b2: large objects lost on upgrade Jonathan S. Katz 19:19
Re: pg15b2: large objects lost on upgrade Robert Haas 19:23
Re: pg15b2: large objects lost on upgrade Jonathan S. Katz 19:27
Re: pg15b2: large objects lost on upgrade Tom Lane 19:32
Re: Add proper planner support for ORDER BY / DISTINCT aggregates 📎 Zhihong Yu 19:38
Re: pg15b2: large objects lost on upgrade Tom Lane 19:39
Re: pg15b2: large objects lost on upgrade Jonathan S. Katz 19:44
Re: pg15b2: large objects lost on upgrade Tom Lane 19:51
Re: standby recovery fails (tablespace related) (tentative patch and discussion) Thomas Munro 19:58
Re: pg15b2: large objects lost on upgrade Jonathan S. Katz 20:20
Re: oat_post_create expected behavior Mary Xu 20:30
Re: pg15b2: large objects lost on upgrade 📎 Jonathan S. Katz 20:44
Re: libpq compression (part 2) Jacob Champion 20:53
Re: Per-table storage parameters for TableAM/IndexAM extensions Jacob Champion 20:56
Re: Parallelize correlated subqueries that execute within each worker Jacob Champion 20:57
Re: Push down time-related SQLValue functions to foreign server Jacob Champion 20:59
Re: [PATCH] Allow multiple recursive self-references Jacob Champion 21:01
Re: Patch to avoid orphaned dependencies Jacob Champion 21:03
Re: Race between KeepFileRestoredFromArchive() and restartpoint Don Seiler 21:03
Re: Consider parallel for lateral subqueries with limit Jacob Champion 21:05
Re: jsonpath syntax extensions Jacob Champion 21:14
Re: [Proposal] Fully WAL logged CREATE DATABASE - No Checkpoints Robert Haas 21:18
Re: [PATCH] minor reloption regression tests improvement Jacob Champion 21:26
Re: [Proposal] Fully WAL logged CREATE DATABASE - No Checkpoints Tom Lane 21:46
Re: Proposal: Support custom authentication methods using hooks Jacob Champion 21:48
Re: Add proper planner support for ORDER BY / DISTINCT aggregates David Rowley 21:48
Re: [PATCH] Expose port->authn_id to extensions and triggers Jacob Champion 21:57
Re: [Proposal] Fully WAL logged CREATE DATABASE - No Checkpoints Justin Pryzby 22:04
Re: Proposal: Support custom authentication methods using hooks samay sharma 22:05
Re: [PROPOSAL] new diagnostic items for the dynamic sql Jacob Champion 22:09
Re: optimize lookups in snapshot [sub]xip arrays 📎 Nathan Bossart 22:13
Re: [PROPOSAL] new diagnostic items for the dynamic sql Jacob Champion 22:13
Re: [Proposal] Fully WAL logged CREATE DATABASE - No Checkpoints Andres Freund 22:23
Re: [Commitfest 2022-07] is Done! Jacob Champion 22:31
Re: Column Filtering in Logical Replication Peter Smith 22:42
Re: [Commitfest 2022-07] is Done! Justin Pryzby 22:53
[PATCH] CF app: add "Returned: Needs more interest" 📎 Jacob Champion 22:55
Re: optimize lookups in snapshot [sub]xip arrays Andres Freund 22:55
Re: [PROPOSAL] new diagnostic items for the dynamic sql Tom Lane 22:55
Re: missing indexes in indexlist with partitioned tables 📎 Arne Roland 23:07
effective_multixact_freeze_max_age issue 📎 Peter Geoghegan 23:12
Re: optimize lookups in snapshot [sub]xip arrays Nathan Bossart 23:43
Re: Parallel Aggregates for string_agg and array_agg 📎 David Rowley 23:45
Re: Adding Support for Copy callback functionality on COPY TO api 📎 Nathan Bossart 23:49
collate not support Unicode Variation Selector 荒井元成 23:54

Aug. 3, 2022

Thread Author Time
RE: collate not support Unicode Variation Selector 荒井元成 00:09
Re: Parallel Aggregates for string_agg and array_agg Tom Lane 00:18
Re: collate not support Unicode Variation Selector Thomas Munro 00:41
Re: collate not support Unicode Variation Selector Tom Lane 00:56
Re: Slow standby snapshot Kyotaro Horiguchi 01:04

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31