pgsql-hackers since 2019-12-25 21:45

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)

Browse Archives

Prev | Next

Dec. 25, 2019

Thread Author Time
Re: proposal: schema variables 📎 Pavel Stehule 21:45

Dec. 26, 2019

Thread Author Time
Re: [HACKERS] WAL logging problem in 9.4.3? 📎 Noah Misch 00:15
Re: Implementing Incremental View Maintenance Tatsuo Ishii 00:26
Re: unsupportable composite type partition keys Amit Langote 01:41
Re: Avoid full GIN index scan when possible Alexander Korotkov 01:59
Re: Implementing Incremental View Maintenance 📎 Takuma Hoshiai 02:03
Re: Implementing Incremental View Maintenance Yugo Nagata 02:36
Re: [HACKERS] WAL logging problem in 9.4.3? Kyotaro Horiguchi 03:46
Re: [HACKERS] WAL logging problem in 9.4.3? Noah Misch 04:22
Re: [HACKERS] WAL logging problem in 9.4.3? Kyotaro Horiguchi 05:45
Re: unsupportable composite type partition keys 📎 Amit Langote 05:47
Re: table partition and column default Fujii Masao 06:11
table partitioning and access privileges Fujii Masao 06:37
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions Masahiko Sawada 07:05
Re: error context for vacuum to include block number Michael Paquier 08:06
Re: Expose lock group leader pid in pg_stat_activity Guillaume Lelarge 08:08
Re: Physical replication slot advance is not persistent 📎 Kyotaro Horiguchi 08:33
Re: Expose lock group leader pid in pg_stat_activity 📎 Julien Rouhaud 08:51
Fix comment typos. 📎 Kyotaro Horiguchi 08:59
Re: [HACKERS] WAL logging problem in 9.4.3? Kyotaro Horiguchi 09:03
Re: [HACKERS] Restricting maximum keep segments by repslots Kyotaro Horiguchi 09:08
Re: Expose lock group leader pid in pg_stat_activity Guillaume Lelarge 09:19
Re: table partition and column default Julien Rouhaud 09:21
Re: Expose lock group leader pid in pg_stat_activity Julien Rouhaud 09:26
Re: Expose lock group leader pid in pg_stat_activity Guillaume Lelarge 09:31
Calling PLpgSQL function with composite type fails with an error: "ERROR: could not open relation with OID ..." Ashutosh Sharma 10:27
Re: Minimal logical decoding on standbys 📎 Amit Khandekar 11:05
Re: Expose lock group leader pid in pg_stat_activity Sergei Kornilov 11:18
Re: Calling PLpgSQL function with composite type fails with an error: "ERROR: could not open relation with OID ..." Ashutosh Sharma 11:32
Re: Expose lock group leader pid in pg_stat_activity Julien Rouhaud 12:11
Re: Disallow cancellation of waiting for synchronous replication 📎 Maksim Milyutin 13:14
Re: Building infrastructure for B-Tree deduplication that recognizes when opclass equality is also equivalence Anastasia Lubennikova 13:26
Re: Fix comment typos. Michael Paquier 13:27
Re: Physical replication slot advance is not persistent 📎 Alexey Kondratov 13:35
Re: Assert failure due to "drop schema pg_temp_3 cascade" for temporary tables and \d+ is not showing any info after drooping temp table schema 📎 Michael Paquier 13:53
Re: standby recovery fails (tablespace related) (tentative patch and discussion) 📎 Anastasia Lubennikova 14:45
Re: Assert failure due to "drop schema pg_temp_3 cascade" for temporary tables and \d+ is not showing any info after drooping temp table schema Mahendra Singh 14:50
Re: error context for vacuum to include block number 📎 Justin Pryzby 15:57
Re: unsupportable composite type partition keys Tom Lane 16:20
[PATCH] fix a performance issue with multiple logical-decoding walsenders 📎 Pierre Ducroquet 16:42
Re: Rearranging ALTER TABLE to avoid multi-operations bugs 📎 Tom Lane 17:47
Re: Assert failure due to "drop schema pg_temp_3 cascade" for temporary tables and \d+ is not showing any info after drooping temp table schema Tom Lane 17:51
Re: proposal: schema variables 📎 Pavel Stehule 18:13
Re: Add support for automatically updating Unicode derived files 📎 Peter Eisentraut 18:38
Re: MSYS2 support Peter Eisentraut 18:42
Re: Assert failure due to "drop schema pg_temp_3 cascade" for temporary tables and \d+ is not showing any info after drooping temp table schema Mahendra Singh 19:03
Re: [PATCH] fix a performance issue with multiple logical-decoding walsenders Julien Rouhaud 19:18
Re: table partitioning and access privileges Tom Lane 19:25
Re: [HACKERS] Block level parallel vacuum Mahendra Singh 19:27
Re: Libpq support to connect to standby server as priority Alvaro Herrera 20:07
Re: Libpq support to connect to standby server as priority Alvaro Herrera 20:15
Re: Libpq support to connect to standby server as priority Dave Cramer 20:17
Re: Calling PLpgSQL function with composite type fails with an error: "ERROR: could not open relation with OID ..." Tom Lane 20:29
Re: planner support functions: handle GROUP BY estimates ? 📎 Justin Pryzby 21:32
Re: Libpq support to connect to standby server as priority Alvaro Herrera 21:58
Re: pgsql: Superuser can permit passwordless connections on postgres_fdw Andrew Dunstan 22:51
Re: Duplicate Workers entries in some EXPLAIN plans Maciek Sakrejda 23:31
Re: [Patch] Invalid permission check in pg_stats for functional indexes 📎 Tom Lane 23:46
use CLZ instruction in AllocSetFreeIndex() 📎 John Naylor 23:49

Dec. 27, 2019

Thread Author Time
Re: pgsql: Superuser can permit passwordless connections on postgres_fdw Tom Lane 00:07
RE: Libpq support to connect to standby server as priority tsunakawa.takay@fujitsu.com 01:26
Re: Avoid full GIN index scan when possible Nikita Glukhov 01:36
Re: [HACKERS] Block level parallel vacuum Tomas Vondra 02:24
doc: vacuum full, fillfactor, and "extra space" 📎 Justin Pryzby 02:31
Re: Calling PLpgSQL function with composite type fails with an error: "ERROR: could not open relation with OID ..." Ashutosh Sharma 02:32
Re: Autovacuum on partitioned table 📎 yuzuko 03:37
Re: Calling PLpgSQL function with composite type fails with an error: "ERROR: could not open relation with OID ..." Tom Lane 03:50
Re: ALTER INDEX fails on partitioned index 📎 Justin Pryzby 03:51
Re: Autovacuum on partitioned table Masahiko Sawada 05:01
Re: Duplicate Workers entries in some EXPLAIN plans Julien Rouhaud 06:29
Re: Asymmetric partition-wise JOIN 📎 Kohei KaiGai 07:34
Re: Reorderbuffer crash during recovery 📎 vignesh C 08:20
RE: problem with read-only user ROS Didier 08:56
Re: Expose lock group leader pid in pg_stat_activity Sergei Kornilov 09:01
Re: Assert failure due to "drop schema pg_temp_3 cascade" for temporary tables and \d+ is not showing any info after drooping temp table schema Michael Paquier 09:06
Re: Expose lock group leader pid in pg_stat_activity Julien Rouhaud 09:15
Re: doc: vacuum full, fillfactor, and "extra space" Fabien COELHO 10:58
Re: Calling PLpgSQL function with composite type fails with an error: "ERROR: could not open relation with OID ..." Ashutosh Sharma 11:15
Re: Libpq support to connect to standby server as priority Alvaro Herrera 13:08
Re: use CLZ instruction in AllocSetFreeIndex() Alvaro Herrera 13:21
Re: use CLZ instruction in AllocSetFreeIndex() Tom Lane 14:54
Re: Reorderbuffer crash during recovery Alvaro Herrera 15:07
Re: use CLZ instruction in AllocSetFreeIndex() John Naylor 15:47
Re: use CLZ instruction in AllocSetFreeIndex() Tom Lane 16:05
Remove libpq.rc, use win32ver.rc for libpq 📎 Peter Eisentraut 16:25
Re: use CLZ instruction in AllocSetFreeIndex() Alvaro Herrera 16:29
Re: use CLZ instruction in AllocSetFreeIndex() David Fetter 16:37
Re: use CLZ instruction in AllocSetFreeIndex() Tom Lane 16:43
Re: [PATCH v1] pg_ls_tmpdir to show directories Justin Pryzby 17:02
aggregate crash 📎 Teodor Sigaev 17:13
Re: Allow cluster owner to bypass authentication 📎 Peter Eisentraut 17:20
Re: Allow cluster owner to bypass authentication Peter Eisentraut 17:32
Re: Allow cluster owner to bypass authentication Stephen Frost 17:35
Re: Allow cluster owner to bypass authentication Stephen Frost 17:49
Re: [PATCH v1] pg_ls_tmpdir to show directories Fabien COELHO 17:50
Re: Allow cluster owner to bypass authentication Tom Lane 17:59
Re: Allow cluster owner to bypass authentication Tom Lane 18:08
Re: Improvement to psql's connection defaults Alvaro Herrera 19:13
Re: Allow cluster owner to bypass authentication Stephen Frost 19:17
Re: Allow cluster owner to bypass authentication Stephen Frost 19:20
Re: BUG #16059: Tab-completion of filenames in COPY commands removes required quotes 📎 Tom Lane 19:27
Re: Allow cluster owner to bypass authentication Tom Lane 19:35
Re: xact_start for walsender & logical decoding not updated 📎 Alvaro Herrera 19:46
Re: weird libpq GSSAPI comment Stephen Frost 19:48
Re: Allow cluster owner to bypass authentication Tom Lane 19:56
Re: Allow cluster owner to bypass authentication Stephen Frost 19:57
Re: [PATCH v1] pg_ls_tmpdir to show directories Justin Pryzby 19:59
Re: BUG #16059: Tab-completion of filenames in COPY commands removes required quotes Alvaro Herrera 20:03
Re: Allow cluster owner to bypass authentication Stephen Frost 20:22
Re: weird libpq GSSAPI comment Alvaro Herrera 20:23
Re: BUG #16059: Tab-completion of filenames in COPY commands removes required quotes 📎 Tom Lane 22:36
Re: Memory-Bounded Hash Aggregation 📎 Jeff Davis 23:35
Re: Implementing Incremental View Maintenance legrand legrand 23:42

Dec. 28, 2019

Thread Author Time
Re: use CLZ instruction in AllocSetFreeIndex() 📎 John Naylor 00:02
Re: Duplicate Workers entries in some EXPLAIN plans Maciek Sakrejda 01:11
Re: use CLZ instruction in AllocSetFreeIndex() David Fetter 02:16
Re: Server crash with Master-Slave configuration. Robert Haas 02:46
Allow WHEN in INSTEAD OF triggers 📎 David Fetter 03:01
Re: Allow WHEN in INSTEAD OF triggers Alvaro Herrera 03:12
Re: Allow WHEN in INSTEAD OF triggers Tom Lane 03:29
Re: use CLZ instruction in AllocSetFreeIndex() 📎 John Naylor 03:44
PostgreSQL 12.1 patch for "private_modify" table creation option for data validation reinforcement 📎 Abdul Yadi AH-2 04:33
Re: [PATCH v1] pg_ls_tmpdir to show directories Fabien COELHO 06:52
Re: [PATCH v1] pg_ls_tmpdir to show directories 📎 Justin Pryzby 10:16
Re: Implementing Incremental View Maintenance Julien Rouhaud 11:05
Re: [PATCH] fix a performance issue with multiple logical-decoding walsenders 📎 Pierre Ducroquet 12:55
Re: use CLZ instruction in AllocSetFreeIndex() 📎 John Naylor 14:50
Re: [PATCH v1] pg_ls_tmpdir to show directories Fabien COELHO 15:02
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions 📎 Tomas Vondra 16:03
Re: Allow WHEN in INSTEAD OF triggers David Fetter 16:29
Re: Allow WHEN in INSTEAD OF triggers 📎 David Fetter 16:45
Greatest Common Divisor 📎 Vik Fearing 16:58
Re: ALTER TABLE support for dropping generation expression 📎 Peter Eisentraut 17:05
Recognizing superuser in pg_hba.conf 📎 Vik Fearing 17:19
Re: PostgreSQL 12.1 patch for "private_modify" table creation option for data validation reinforcement Tom Lane 17:56
Re: Recognizing superuser in pg_hba.conf Tom Lane 18:07
Re: Greatest Common Divisor Fabien COELHO 18:15
Re: Recognizing superuser in pg_hba.conf Vik Fearing 19:02
TAP testing for psql's tab completion code 📎 Tom Lane 19:52
Incremental View Maintenance: ERROR: out of shared memory legrand legrand 20:15
Re: [PATCH v1] pg_ls_tmpdir to show directories 📎 Justin Pryzby 21:09
Re: TAP testing for psql's tab completion code Fabien COELHO 21:16
Re: Disallow cancellation of waiting for synchronous replication Robert Haas 21:55
Re: Greatest Common Divisor 📎 Vik Fearing 22:03
Re: use CLZ instruction in AllocSetFreeIndex() 📎 Tom Lane 22:33
Re: TAP testing for psql's tab completion code Tom Lane 22:52
Re: Disallow cancellation of waiting for synchronous replication Maksim Milyutin 23:19
Re: xact_start for walsender & logical decoding not updated Tomas Vondra 23:34
Re: Disallow cancellation of waiting for synchronous replication Robert Haas 23:54
Re: Building infrastructure for B-Tree deduplication that recognizes when opclass equality is also equivalence Robert Haas 23:56

Dec. 29, 2019

Thread Author Time
Re: error context for vacuum to include block number Robert Haas 00:21
Re: Consolidate 'unique array values' logic into a reusable function? 📎 Noah Misch 07:02
Re: TAP testing for psql's tab completion code Fabien COELHO 07:11
Re: Greatest Common Divisor Fabien COELHO 07:30
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions Dilip Kumar 08:04
Re: Disallow cancellation of waiting for synchronous replication Andrey Borodin 09:13
remove some STATUS_* symbols 📎 Peter Eisentraut 10:33
Re: pgbench - use pg logging capabilities Michael Paquier 11:11
Re: Incremental View Maintenance: ERROR: out of shared memory Tatsuo Ishii 11:24
Re: Physical replication slot advance is not persistent 📎 Alexey Kondratov 12:12
Re: [PATCH] fix a performance issue with multiple logical-decoding walsenders Julien Rouhaud 12:32
Re: Assert failure due to "drop schema pg_temp_3 cascade" for temporary tables and \d+ is not showing any info after drooping temp table schema Robert Haas 12:37
Re: ALTER INDEX fails on partitioned index Robert Haas 12:43
Re: [HACKERS] Block level parallel vacuum 📎 Masahiko Sawada 13:06
Re: let's make the list of reportable GUCs configurable (was Re: Add %r substitution for psql prompts to show recovery status) Dave Cramer 13:35
Re: Greatest Common Divisor 📎 Vik Fearing 13:58
Re: Recognizing superuser in pg_hba.conf Robert Haas 16:16
Re: let's make the list of reportable GUCs configurable (was Re: Add %r substitution for psql prompts to show recovery status) Robert Haas 16:19
Re: Recognizing superuser in pg_hba.conf Tom Lane 16:31
Re: Recognizing superuser in pg_hba.conf Robert Haas 16:48
Re: Greatest Common Divisor Chapman Flack 16:50
Re: Greatest Common Divisor Fabien COELHO 17:13
Re: TAP testing for psql's tab completion code Tom Lane 17:13
Re: Incremental View Maintenance: ERROR: out of shared memory Tom Lane 17:27
Re: TAP testing for psql's tab completion code Fabien COELHO 17:42
Re: [PATCH] Increase the maximum value track_activity_query_size Jeff Janes 17:46
Re: TAP testing for psql's tab completion code Tom Lane 17:53
Re: vacuum verbose detail logs are unclear (show debug lines at *start* of each stage?) Jeff Janes 18:15
Re: TAP testing for psql's tab completion code Fabien COELHO 18:52
Re: TAP testing for psql's tab completion code Tom Lane 19:22
Re: error context for vacuum to include block number (atomic progress update) Justin Pryzby 20:17
Re: [HACKERS] Block level parallel vacuum Tomas Vondra 21:23
Re: Recognizing superuser in pg_hba.conf 📎 Vik Fearing 22:10

Dec. 30, 2019

Thread Author Time
Re: [HACKERS] Block level parallel vacuum Amit Kapila 02:55
Re: Avoiding hash join batch explosions with extreme skew and weird stats 📎 Melanie Plageman 03:34
Re: [HACKERS] Block level parallel vacuum Amit Kapila 05:10
Re: Reorderbuffer crash during recovery Amit Kapila 05:47
Re: Yet another fast GiST build 📎 Andrey Borodin 06:43
comment regarding double timestamps; and, infinite timestamps and NaN 📎 Justin Pryzby 07:47
Re: Windows v readline Peter Eisentraut 09:08
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions 📎 Dilip Kumar 09:40
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions Amit Kapila 10:13
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions Amit Kapila 10:19
Re: TAP testing for psql's tab completion code Fabien COELHO 10:49
Re: Recognizing superuser in pg_hba.conf 📎 Vik Fearing 10:56
Re: [PATCH] fix a performance issue with multiple logical-decoding walsenders Pierre Ducroquet 11:13
Re: [HACKERS] Block level parallel vacuum Tomas Vondra 13:07
Re: [HACKERS] Block level parallel vacuum Tomas Vondra 13:16
Re: Windows v readline Tom Lane 13:28
Re: comment regarding double timestamps; and, infinite timestamps and NaN Tom Lane 14:05

Browse Archives

Prev | Next