pgsql-hackers since 2022-12-07 18:03

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

Dec. 7, 2022

Thread	Author	Time
Re: [BUG] Logical replica crash if there was an error in a function.	Andres Freund	18:03
Re: wake up logical workers after ALTER SUBSCRIPTION 📎	Nathan Bossart	18:11
Re: Transaction timeout	Andres Freund	18:23
Re: daitch_mokotoff module	Andres Freund	18:56
Re: Partial aggregates pushdown	Andres Freund	18:59
Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs)	Andres Freund	19:03
Re: [PoC] Federated Authn/z with OAUTHBEARER	Jacob Champion	19:06
[PATCH] psql: Add tab-complete for optional view parameters 📎	Christoph Heiss	19:44
Re: Error-safe user functions	Tom Lane	20:16
Re: [PATCH] pg_dump: lock tables in batches	Fabrízio de Royes Mello	21:14
Re: Transaction timeout 📎	Andrey Borodin	21:30
Re: [PATCH] pg_dump: lock tables in batches	Andres Freund	21:32
Re: Temporary tables versus wraparound... again	Greg Stark	22:02
Re: Error-safe user functions 📎	Tom Lane	22:32
fix and document CLUSTER privileges 📎	Nathan Bossart	22:39
Re: add \dpS to psql	Nathan Bossart	22:41
Re: [PATCH] pg_dump: lock tables in batches	Andres Freund	22:43
Re: Error-safe user functions	Andrew Dunstan	22:50
Re: [PATCH] pg_dump: lock tables in batches	Tom Lane	22:53
Re: Error-safe user functions	Tom Lane	22:56
Re: [PATCH] pg_dump: lock tables in batches	Jacob Champion	23:13
Re: [PoC] Federated Authn/z with OAUTHBEARER	Andrey Chudnovsky	23:22
Re: Error-safe user functions	Andres Freund	23:35
Re: [PATCH] pg_dump: lock tables in batches	Andres Freund	23:45
Re: PGDOCS - Logical replication GUCs - added some xrefs	samay sharma	23:49
Re: Error-safe user functions	Tom Lane	23:52

Dec. 8, 2022

Thread	Author	Time
Re: [PATCH] pg_dump: lock tables in batches	Tom Lane	00:03
Re: fix and document CLUSTER privileges	Justin Pryzby	02:25
Re: [DOCS] Stats views and functions not in order? 📎	Peter Smith	02:30
Re: add \dpS to psql	Justin Pryzby	02:39
Re: Assertion failure in SnapBuildInitialSnapshot() 📎	Masahiko Sawada	02:46
Re: moving extraUpdatedCols out of RangeTblEntry (into ModifyTable) 📎	Amit Langote	02:47
Re: Error-safe user functions	Corey Huinker	03:37
Re: allow segment size to be set to < 1GiB	Andres Freund	03:37
Re: fix and document CLUSTER privileges	Nathan Bossart	04:13
Re: add \dpS to psql	Nathan Bossart	04:19
Re: [PoC] Federated Authn/z with OAUTHBEARER	Andrey Chudnovsky	04:25
Re: add \dpS to psql	Tom Lane	04:25
Re: add \dpS to psql	Nathan Bossart	04:43
Re: add \dpS to psql	Isaac Morland	04:48
Re: Perform streaming logical transactions by background workers and parallel apply	Amit Kapila	04:51
Re: Avoid streaming the transaction which are skipped (in corner cases)	Amit Kapila	04:53
Re: ANY_VALUE aggregate	Vik Fearing	05:00
Re: Support logical replication of DDLs	vignesh C	05:07
Re: add \dpS to psql	Nathan Bossart	05:07
Re: pg_stat_bgwriter.buffers_backend is pretty meaningless (and more?)	Maciek Sakrejda	05:09
Re: RFC: Logging plan of the running query 📎	torikoshia	05:10
Re: add \dpS to psql	Isaac Morland	05:12
Re: add \dpS to psql	Tom Lane	05:15
Re: PGDOCS - Logical replication GUCs - added some xrefs 📎	Peter Smith	05:20
Re: ANY_VALUE aggregate	David G. Johnston	05:48
Re: Collation version tracking for macOS 📎	Jeff Davis	05:56
Re: WAL Insertion Lock Improvements (was: Re: Avoid LWLockWaitForVar() for currently held WAL insertion lock in WaitXLogInsertionsToFinish())	Bharath Rupireddy	06:59
RE: Perform streaming logical transactions by background workers and parallel apply 📎	[email protected]	07:07
Re: Perform streaming logical transactions by background workers and parallel apply	Masahiko Sawada	07:10
Re: Perform streaming logical transactions by background workers and parallel apply	Masahiko Sawada	07:11
Re: postgres_fdw: batch inserts vs. before row triggers	Etsuro Fujita	07:39
Re: Perform streaming logical transactions by background workers and parallel apply	Amit Kapila	07:42
Re: Allow batched insert during cross-partition updates 📎	Amit Langote	07:59
Re: Perform streaming logical transactions by background workers and parallel apply	Masahiko Sawada	08:43
Aggregate node doesn't include cost for sorting	David Geier	09:06
Re: on placeholder entries in view rule action query's range table	Alvaro Herrera	09:12
Re: refactor ExecGrant_*() functions 📎	Peter Eisentraut	09:26
Re: refactor ExecGrant_*() functions	Peter Eisentraut	09:27
Supporting MERGE on updatable views 📎	Dean Rasheed	10:03
Re: Aggregate node doesn't include cost for sorting	David Rowley	10:40
Re: Allow batched insert during cross-partition updates	Etsuro Fujita	11:01
Re: add \dpS to psql	Pavel Luzanov	11:03
Re: Minimal logical decoding on standbys 📎	Drouvot, Bertrand	11:07
Re: fix and document CLUSTER privileges	Pavel Luzanov	11:15
Re: Non-decimal integer literals 📎	Peter Eisentraut	11:16
Re: [PATCH] psql: Add tab-complete for optional view parameters	Melih Mutlu	11:19
Add PL/pgSQL extra check no_data_found 📎	Sergey Shinderuk	11:29
Re: add \dpS to psql	Alvaro Herrera	11:35
Re: Error-safe user functions	Alvaro Herrera	12:00
Re: Aggregate node doesn't include cost for sorting	David Geier	12:11
Re: fix and document CLUSTER privileges	Andrew Dunstan	12:20
Re: ANY_VALUE aggregate	Vik Fearing	12:32
Re: Creating HeapTuple from char and date values	Ashutosh Bapat	13:15
Re: Checksum errors in pg_stat_database	Drouvot, Bertrand	13:34
Re: Add tracking of backend memory allocated to pg_stat_activity 📎	Reid Thompson	14:09
Re: Aggregate node doesn't include cost for sorting	Tom Lane	14:38
Documenting MERGE INTO ONLY ... 📎	Dean Rasheed	15:26
Re: Error-safe user functions	Tom Lane	16:31
Re: add \dpS to psql	Nathan Bossart	17:15
Re: fix and document CLUSTER privileges	Nathan Bossart	18:13
allow granting CLUSTER, REFRESH MATERIALIZED VIEW, and REINDEX 📎	Nathan Bossart	18:37
Re: add \dpS to psql	Nathan Bossart	18:39
Re: Documenting MERGE INTO ONLY ...	Nathan Bossart	19:08
sendFileWithContent() does not advance the source pointer 📎	Antonin Houska	19:44
Re: Aggregate node doesn't include cost for sorting	David Rowley	20:56
Re: Error-safe user functions	Robert Haas	21:00
Re: fix and document CLUSTER privileges	Robert Haas	21:08
Re: Aggregate node doesn't include cost for sorting	David Rowley	21:24
Re: sendFileWithContent() does not advance the source pointer	Andres Freund	21:53
[PATCH] random_normal function 📎	Paul Ramsey	21:53
Re: Error-safe user functions	Andres Freund	21:58
Re: [PATCH] random_normal function	David G. Johnston	22:40
Re: [PATCH] random_normal function	Justin Pryzby	22:46
Re: Error-safe user functions 📎	Tom Lane	22:57
Re: [PATCH] random_normal function 📎	Paul Ramsey	22:57
Re: [PATCH] random_normal function	Paul Ramsey	22:58
Re: [PATCH] Add `verify-system` sslmode to use system CA pool for server cert 📎	Jacob Champion	23:10
Re: [PATCH] random_normal function 📎	Paul Ramsey	23:25

Dec. 9, 2022

Thread	Author	Time
tests against running server occasionally fail, postgres_fdw & tenk1	Andres Freund	00:15
Re: tests against running server occasionally fail, postgres_fdw & tenk1	Andres Freund	00:36
Re: [PoC] Federated Authn/z with OAUTHBEARER	Jacob Champion	00:41
Re: [PATCH] random_normal function 📎	Paul Ramsey	00:44
Re: [PoC] Improve dead tuple storage for lazy vacuum	Masahiko Sawada	01:19
Re: postgres_fdw uninterruptible during connection establishment / ProcSignalBarrier 📎	Andres Freund	02:08
Re: Perform streaming logical transactions by background workers and parallel apply	Peter Smith	02:15
Re: Error-safe user functions	Andrew Dunstan	02:15
Re: Error-safe user functions	Andres Freund	02:33
Re: Error-safe user functions	Tom Lane	02:59
Re: Support logical replication of DDLs	li jie	03:27
Re: Support logical replication of DDLs	li jie	03:31
Re: Allow tests to pass in OpenSSL FIPS mode	Michael Paquier	04:16
Re: [PATCH] random_normal function	Michael Paquier	04:29
Re: add \dpS to psql	Michael Paquier	04:36
Re: [PATCH] Backport perl tests for pg_upgrade from 322becb60	Michael Paquier	05:19
RE: Time delayed LR (WAS Re: logical replication restrictions)	Hayato Kuroda (Fujitsu)	05:19
Re: Perform streaming logical transactions by background workers and parallel apply	Amit Kapila	06:05
Re: on placeholder entries in view rule action query's range table 📎	Amit Langote	06:07
RE: Time delayed LR (WAS Re: logical replication restrictions)	Hayato Kuroda (Fujitsu)	06:38
Re: Add PL/pgSQL extra check no_data_found	Pavel Stehule	06:46
Re: on placeholder entries in view rule action query's range table 📎	Amit Langote	06:50
Re: Perform streaming logical transactions by background workers and parallel apply	Amit Kapila	07:14
static assert cleanup 📎	Peter Eisentraut	07:46
Re: Perform streaming logical transactions by background workers and parallel apply	Masahiko Sawada	08:00
Re: generic plans and "initial" pruning	Amit Langote	08:26
Re: Add PL/pgSQL extra check no_data_found	Sergey Shinderuk	08:27
Re: [PoC] Improve dead tuple storage for lazy vacuum	John Naylor	08:53
Improve WALRead() to suck data directly from WAL buffers when possible 📎	Bharath Rupireddy	09:03
Check lateral references within PHVs for memoize cache keys 📎	Richard Guo	09:16
Re: XID formatting and SLRU refactorings (was: Add 64-bit XIDs into PostgreSQL 15) 📎	Aleksander Alekseev	09:50
Re: generic plans and "initial" pruning	Alvaro Herrera	09:52
Re: static assert cleanup	John Naylor	10:01
Re: Documenting MERGE INTO ONLY ...	Alvaro Herrera	10:02
Re: Documenting MERGE INTO ONLY ...	Dean Rasheed	10:09
Re: Allow placeholders in ALTER ROLE w/o superuser	Alexander Korotkov	10:23
Re: [PATCH] psql: Add tab-complete for optional view parameters 📎	Christoph Heiss	10:31
Re: generic plans and "initial" pruning	Amit Langote	10:34
Re: Support logical replication of DDLs	Amit Kapila	10:36
Re: generic plans and "initial" pruning	Alvaro Herrera	10:49
Raising the SCRAM iteration count 📎	Daniel Gustafsson	10:55
Re: generic plans and "initial" pruning	Amit Langote	11:02
Re: generic plans and "initial" pruning	Alvaro Herrera	11:37
Re: Allow placeholders in ALTER ROLE w/o superuser 📎	Pavel Borisov	11:52
Re: Allow placeholders in ALTER ROLE w/o superuser	Pavel Borisov	11:56
Re: Allow placeholders in ALTER ROLE w/o superuser	Alexander Korotkov	12:30
回复: Add 64-bit XIDs into PostgreSQL 15	adherent postgres	12:34
Re: WIN32 pg_import_system_collations 📎	Juan José Santamaría Flecha	12:48
Re: Add 64-bit XIDs into PostgreSQL 15	Aleksander Alekseev	12:49
Authentication fails for md5 connections if ~/.postgresql/postgresql.{crt and key} exist 📎	Jim Jones	12:55
Re: Error-safe user functions	Andrew Dunstan	13:06
Re: [PoC] Improve dead tuple storage for lazy vacuum	Masahiko Sawada	13:32
Re: XID formatting and SLRU refactorings (was: Add 64-bit XIDs into PostgreSQL 15) 📎	Aleksander Alekseev	13:42
Re: Add 64-bit XIDs into PostgreSQL 15	Pavel Borisov	13:46
Re: Meson add host_system to PG_VERSION_STR	Juan José Santamaría Flecha	13:53
Re: CREATE INDEX CONCURRENTLY on partitioned index	Ilya Gladyshev	13:53
Re: Add 64-bit XIDs into PostgreSQL 15	adherent postgres	13:54
Re: Add 64-bit XIDs into PostgreSQL 15	Maxim Orlov	14:12
Re: Add 64-bit XIDs into PostgreSQL 15	Pavel Borisov	14:13
Re: POC PATCH: copy from ... exceptions to: (was Re: VLDB Features)	Danil Anisimow	14:25
回复: Add 64-bit XIDs into PostgreSQL 15	adherent postgres	14:27
Re: Add 64-bit XIDs into PostgreSQL 15	Maxim Orlov	14:29
Re: Add the ability to limit the amount of memory that can be allocated to backends. 📎	Reid Thompson	15:05
RE: Time delayed LR (WAS Re: logical replication restrictions)	Takamichi Osumi (Fujitsu)	15:08
Re: Error-safe user functions	Tom Lane	15:16
Re: Error-safe user functions	Andrew Dunstan	15:37
Re: Raising the SCRAM iteration count	Heikki Linnakangas	15:50
Is there a way to use exported snapshots in autocommit mode ?	Hannu Krosing	16:07
Re: Error-safe user functions	Amul Sul	16:16
Re: Meson add host_system to PG_VERSION_STR	Andres Freund	16:58
Re: [PATCH] random_normal function	Paul Ramsey	17:17
Re: PGDOCS - Logical replication GUCs - added some xrefs	samay sharma	18:10
RFC: logical publication via inheritance root?	Jacob Champion	18:21
Re: [PATCH] random_normal function	Mark Dilger	18:39
Re: add \dpS to psql	Nathan Bossart	18:40
Re: add \dpS to psql	Nathan Bossart	18:44
Re: [PATCH] random_normal function	Paul Ramsey	18:51
Re: [PATCH] random_normal function	Joe Conway	19:01
Re: [PATCH] random_normal function	Paul Ramsey	19:10
Re: [PATCH] random_normal function	Paul Ramsey	19:11
Re: Error-safe user functions	Corey Huinker	22:54
Re: [PATCH] random_normal function 📎	Paul Ramsey	23:20
Re: Raising the SCRAM iteration count	Michael Paquier	23:21

Dec. 10, 2022

Thread	Author	Time
Re: Raising the SCRAM iteration count	Andres Freund	00:15
Re: Error-safe user functions	Tom Lane	01:28
Re: Generate pg_stat_get_* functions with Macros	Tom Lane	02:43
-Wunreachable-code-generic-assoc warnings on elver	Tom Lane	02:50
Re: Generate pg_stat_get_* functions with Macros	Michael Paquier	03:52
Re: Generate pg_stat_get_* functions with Macros 📎	Nathan Bossart	03:55
Re: slab allocator performance issues 📎	David Rowley	04:01
Re: Generate pg_stat_get_* functions with Macros	Michael Paquier	04:07
Re: Force streaming every change in logical decoding	Dilip Kumar	05:48
Re: Force streaming every change in logical decoding	Dilip Kumar	06:03
Speedup generation of command completion tags 📎	David Rowley	07:32
Re: Generate pg_stat_get_* functions with Macros	Drouvot, Bertrand	08:06
Re: Minimal logical decoding on standbys 📎	Drouvot, Bertrand	08:09

Browse Archives

Prev | Next