pgsql-hackers since 2019-11-26 00:00

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

Nov. 26, 2019

Thread Author Time
RE: GROUPING SETS and SQL standard Phil Florent 00:16
Re: GROUPING SETS and SQL standard Tom Lane 00:39
Dynamic gathering the values for seq_page_cost/xxx_cost Andy Fan 00:59
[PATCH] Fix possible string overflow with sscanf (xlog.c) 📎 Ranier Vilela 01:51
Re: progress report for ANALYZE Tatsuro Yamada 02:32
Re: Problem while updating a foreign table pointing to a partitioned table on foreign server Etsuro Fujita 03:37
Re: progress report for ANALYZE Tatsuro Yamada 03:56
Re: checkpointer: PANIC: could not fsync file: No such file or directory Justin Pryzby 04:21
Re: Safeguards against incorrect fd flags for fsync() Michael Paquier 04:34
Re: checkpointer: PANIC: could not fsync file: No such file or directory Thomas Munro 04:55
Re: accounting for memory used for BufFile during hash joins Michael Paquier 04:59
Re: [HACKERS] Block level parallel vacuum Amit Kapila 05:01
Re: logical decoding : exceeded maxAllocatedDescs for .spill files Amit Kapila 05:19
Re: Ought to use heap_multi_insert() for pg_attribute/depend insertions? Michael Paquier 05:44
Re: logical decoding : exceeded maxAllocatedDescs for .spill files Amit Khandekar 05:48
Re: dropdb --force Amit Kapila 06:06
Re: logical decoding : exceeded maxAllocatedDescs for .spill files Amit Kapila 06:39
Re: Implementing Incremental View Maintenance 📎 Yugo Nagata 07:02
Re: Implementing Incremental View Maintenance Tatsuo Ishii 07:14
RE: GROUPING SETS and SQL standard Phil Florent 08:29
Re: pglz performance 📎 Tomas Vondra 09:43
Re: Attempt to consolidate reading of XLOG page Antonin Houska 10:40
Re: A problem about partitionwise join Etsuro Fujita 11:35
Re: benchmarking Flex practices 📎 John Naylor 11:38
[PATCH] Remove twice assignment with var pageop (nbtree.c). 📎 Ranier Vilela 12:13
Re: progress report for ANALYZE Alvaro Herrera 12:22
Re: [HACKERS] Block level parallel vacuum 📎 Amit Kapila 12:34
Re: [HACKERS] WAL logging problem in 9.4.3? 📎 Kyotaro Horiguchi 12:37
RE: [PATCH] Remove twice assignment with var pageop (nbtree.c). 📎 Ranier Vilela 13:45
ERROR: attribute number 6 exceeds number of columns 5 📎 Andreas Joseph Krogh 14:04
[PATCH] Increase the maximum value track_activity_query_size 📎 v.makarov 14:59
Re: FETCH FIRST clause WITH TIES option 📎 Alvaro Herrera 15:09
Re: benchmarking Flex practices Tom Lane 15:32
Re: ERROR: attribute number 6 exceeds number of columns 5 Tom Lane 15:49
Re: Copyright information in source files vignesh C 16:31
Re: CVE-2017-7484-induced bugs, or, btree cmp functions are not leakproof? 📎 Tom Lane 18:25
Re: pglz performance Peter Eisentraut 19:17
Re: [HACKERS] Block level parallel vacuum 📎 Masahiko Sawada 19:21
Re: pglz performance Tomas Vondra 20:05
Re: Remove configure --disable-float4-byval and --disable-float8-byval 📎 Peter Eisentraut 20:27
Re: Remove configure --disable-float4-byval and --disable-float8-byval Tom Lane 20:33
Re: Collation versions on Windows (help wanted, apply within) Thomas Munro 20:39
Re: Collation versioning Thomas Munro 20:43
Re: [HACKERS] Regression tests vs existing users in an installation Peter Eisentraut 21:10
Re: Collation versions on Windows (help wanted, apply within) Peter Eisentraut 21:38
Re: Allow CLUSTER, VACUUM FULL and REINDEX to change tablespace on the fly Masahiko Sawada 22:09
Re: [HACKERS] Regression tests vs existing users in an installation Tom Lane 22:32

Nov. 27, 2019

Thread Author Time
Re: [HACKERS] [WIP] Effective storage of duplicates in B-tree index. 📎 Peter Geoghegan 01:28
Re: progress report for ANALYZE Tatsuro Yamada 02:01
Re: CVE-2017-7484-induced bugs, or, btree cmp functions are not leakproof? Amit Langote 02:03
Re: SegFault on 9.6.14 Amit Kapila 02:22
Re: progress report for ANALYZE Amit Langote 02:34
Re: pg_upgrade fails with non-standard ACL Artur Zakirov 02:35
Re: progress report for ANALYZE Amit Langote 02:38
Re: [HACKERS] Block level parallel vacuum Amit Kapila 02:44
Re: progress report for ANALYZE Alvaro Herrera 03:00
Re: ERROR: attribute number 6 exceeds number of columns 5 📎 Kyotaro Horiguchi 03:00
Re: Remove page-read callback from XLogReaderState. 📎 Kyotaro Horiguchi 03:09
Re: progress report for ANALYZE Tatsuro Yamada 03:14
Re: progress report for ANALYZE 📎 Tatsuro Yamada 03:45
Re: Allow CLUSTER, VACUUM FULL and REINDEX to change tablespace on the fly Michael Paquier 03:54
Re: Remove page-read callback from XLogReaderState. Michael Paquier 03:57
Re: Allow CLUSTER, VACUUM FULL and REINDEX to change tablespace on the fly Michael Paquier 04:05
Re: Remove page-read callback from XLogReaderState. Alvaro Herrera 04:11
Re: pg_upgrade fails with non-standard ACL Michael Paquier 04:22
Re: progress report for ANALYZE Michael Paquier 04:25
Re: Allow CLUSTER, VACUUM FULL and REINDEX to change tablespace on the fly Michael Paquier 04:28
Re: dropdb --force 📎 vignesh C 04:44
Re: psql - improve test coverage from 41% to 88% Michael Paquier 05:03
Re: checkpointer: PANIC: could not fsync file: No such file or directory Justin Pryzby 06:53
Re: Problem while updating a foreign table pointing to a partitioned table on foreign server Etsuro Fujita 07:30
missing estimation for coalesce function Pavel Stehule 07:47
Re: pglz performance Michael Paquier 08:01
Re: Psql patch to show access methods info Michael Paquier 08:05
Re: Run-time pruning for ModifyTable Michael Paquier 08:17
Re: [proposal] de-TOAST'ing using a iterator Michael Paquier 08:20
Re: Proposal: Make use of C99 designated initialisers for nulls/values arrays Michael Paquier 08:23
Re: allow_system_table_mods stuff Michael Paquier 08:26
Re: [patch]socket_timeout in interfaces/libpq Michael Paquier 08:31
Re: WIP/PoC for parallel backup Jeevan Chalke 08:38
Re: logical decoding : exceeded maxAllocatedDescs for .spill files Amit Khandekar 08:46
Re: FETCH FIRST clause WITH TIES option 📎 Surafel Temesgen 09:11
Re: psql - improve test coverage from 41% to 88% 📎 Fabien COELHO 09:14
Re: pg_basebackup ignores the existing data directory permissions Michael Paquier 09:14
Re: Batch insert in CTAS/MatView code Michael Paquier 09:18
Re: [patch]socket_timeout in interfaces/libpq Fabien COELHO 09:29
Re: pglz performance Tomas Vondra 09:42
How to prohibit parallel scan through tableam? Konstantin Knizhnik 11:33
RE: Proposal: Add more compile-time asserts to expose inconsistencies. Smith, Peter 11:50
[Incident report]Backend process crashed when executing 2pc transaction LIANGBO 11:52
Re: How to prohibit parallel scan through tableam? Rafia Sabih 12:12
RE: Proposal: Add more compile-time asserts to expose inconsistencies. 📎 Smith, Peter 12:23
Re: [HACKERS] Block level parallel vacuum 📎 Amit Kapila 12:25
Re: [HACKERS] Block level parallel vacuum Mahendra Singh 12:28
Re: Remove configure --disable-float4-byval and --disable-float8-byval Peter Eisentraut 12:30
Re: pglz performance Andrey Borodin 12:47
Re: How to prohibit parallel scan through tableam? Konstantin Knizhnik 13:10
Re: proposal: new polymorphic types - commontype and commontypearray 📎 Pavel Stehule 13:54
Re: pglz performance Tomas Vondra 15:28
Re: Invisible PROMPT2 📎 Maxence Ahlouche 15:30
Re: Why JIT speed improvement is so modest? Konstantin Knizhnik 15:38
Re: allow_system_table_mods stuff 📎 Peter Eisentraut 16:01
Re: Why JIT speed improvement is so modest? Tomas Vondra 16:05
Re: Invisible PROMPT2 Tom Lane 16:09
Re: Dynamic gathering the values for seq_page_cost/xxx_cost Tomas Vondra 16:48
Re: [HACKERS] Block level parallel vacuum 📎 Masahiko Sawada 17:43
Re: [HACKERS] Block level parallel vacuum Masahiko Sawada 17:45
Re: Allow CLUSTER, VACUUM FULL and REINDEX to change tablespace on the fly 📎 Alexey Kondratov 17:47
Re: [HACKERS] Block level parallel vacuum Mahendra Singh 18:20
Re: pglz performance 📎 Andrey Borodin 18:27
Re: pglz performance Alvaro Herrera 18:41
Re: WIP/PoC for parallel backup Robert Haas 19:57
Re: Collation versioning Robert Haas 21:09
Re: FETCH FIRST clause WITH TIES option Alvaro Herrera 21:36
Modernizing SQL functions' result type coercions 📎 Tom Lane 22:57
Re: Memory-Bounded Hash Aggregation 📎 Jeff Davis 22:58

Nov. 28, 2019

Thread Author Time
Re: libpq sslpassword parameter and callback function 📎 Andrew Dunstan 00:06
Re: format of pg_upgrade loadable_libraries warning Bruce Momjian 01:26
pgbench -i progress output on terminal 📎 Amit Langote 01:41
Re: progress report for ANALYZE Amit Langote 01:59
Re: Implementing Incremental View Maintenance 📎 Tatsuo Ishii 02:26
Re: [Patch] Invalid permission check in pg_stats for functional indexes Michael Paquier 02:28
Re: Converting NOT IN to anti-joins during planning Michael Paquier 02:30
Re: row filtering for logical replication Michael Paquier 02:32
Re: jsonb_set() strictness considered harmful to data Michael Paquier 02:35
Re: pglz performance Michael Paquier 02:39
Re: Patch: New GUC prepared_statement_limit to limit memory used by prepared statements Michael Paquier 02:42
Re: POC: Cleaning up orphaned files using undo logs Michael Paquier 02:45
Re: pgbench -i progress output on terminal Michael Paquier 02:51
Re: missing estimation for coalesce function David Fetter 02:56
Re: POC: Cleaning up orphaned files using undo logs Thomas Munro 03:01
Re: [HACKERS] Restricting maximum keep segments by repslots Michael Paquier 03:09
RE: [Patch] Optimize dropping of relation buffers using dlist 📎 [email protected] 03:18
Re: dropdb --force Amit Kapila 03:23
Re: pg_upgrade fails with non-standard ACL Artur Zakirov 03:29
Re: jsonb_set() strictness considered harmful to data Andrew Dunstan 03:45
Re: missing estimation for coalesce function Pavel Stehule 03:48
Re: Add a GUC variable that control logical replication Michael Paquier 03:53
Re: amcheck verification for GiST Michael Paquier 03:57
To Suggest a "DROP INCREMENTAL MATERIALIZED VIEW" in psql, but the syntax error when you run. nuko yokohama 04:00
Re: psql - improve test coverage from 41% to 88% Michael Paquier 04:01
Re: To Suggest a "DROP INCREMENTAL MATERIALIZED VIEW" in psql, but the syntax error when you run. Michael Paquier 04:05
Re: Replication & recovery_min_apply_delay Michael Paquier 04:11
Re: SQL:2011 PERIODS vs Postgres Ranges? Michael Paquier 04:14
Re: abs function for interval Michael Paquier 04:17
Re: [Incident report]Backend process crashed when executing 2pc transaction Amit Langote 04:24
Re: [Incident report]Backend process crashed when executing 2pc transaction Michael Paquier 04:47
Re: Collation versioning Michael Paquier 04:50
答复: [Incident report]Backend process crashed when executing 2pc transaction LIANGBO 05:00
Re: [Incident report]Backend process crashed when executing 2pc transaction Amit Langote 05:18
Re: dropdb --force 📎 vignesh C 05:23
Re: proposal: type info support functions for functions that use "any" type 📎 Pavel Stehule 05:29
Re: Do we have a CF manager for November? Michael Paquier 07:02
Re: Why JIT speed improvement is so modest? Konstantin Knizhnik 07:08
Re: pgbench -i progress output on terminal Fabien COELHO 07:35
Re: Why JIT speed improvement is so modest? guangnan he 07:36
Re: pgbench -i progress output on terminal Amit Langote 07:43
Re: missing estimation for coalesce function Pavel Stehule 07:45
Re: fe-utils - share query cancellation code 📎 Michael Paquier 07:52
Re: [HACKERS] Block level parallel vacuum Masahiko Sawada 08:01
Re: [Incident report]Backend process crashed when executing 2pc transaction Marco Slot 08:01
Re: Implementing Incremental View Maintenance Yugo Nagata 08:10
Re: format of pg_upgrade loadable_libraries warning Daniel Gustafsson 08:58
Re: [Incident report]Backend process crashed when executing 2pc transaction Amit Langote 09:01
Yet another vectorized engine Hubert Zhang 09:23
Re: Why JIT speed improvement is so modest? Konstantin Knizhnik 09:25
Re: Planner chose a much slower plan in hashjoin, using a large table as the inner table. Andy Fan 09:45
Re: [HACKERS] Block level parallel vacuum Mahendra Singh 10:40
Re: progress report for ANALYZE Tatsuro Yamada 10:55
Re: [HACKERS] Block level parallel vacuum Amit Kapila 10:56
Re: Parallel grouping sets 📎 Pengzhou Tang 11:07
Re: Planner chose a much slower plan in hashjoin, using a large table as the inner table. Jinbao Chen 11:18
Re: [HACKERS] WAL logging problem in 9.4.3? 📎 Kyotaro Horiguchi 11:56
Re: [HACKERS] WAL logging problem in 9.4.3? 📎 Kyotaro Horiguchi 12:35
Re: Remove page-read callback from XLogReaderState. Kyotaro Horiguchi 12:37
Re: Collation versioning Julien Rouhaud 13:08
Re: How to prohibit parallel scan through tableam? Rafia Sabih 13:23
Re: FETCH FIRST clause WITH TIES option 📎 Surafel Temesgen 13:37
Re: progress report for ANALYZE Alvaro Herrera 13:37
Re: Implementing Incremental View Maintenance Alvaro Herrera 14:03
Re: checkpointer: PANIC: could not fsync file: No such file or directory Thomas Munro 14:13
Re: Option to dump foreign data in pg_dump Alvaro Herrera 14:31
remove useless returns 📎 Alvaro Herrera 14:46
Re: FETCH FIRST clause WITH TIES option Alvaro Herrera 14:49
Re: missing estimation for coalesce function Laurenz Albe 14:51
Re: Planner chose a much slower plan in hashjoin, using a large table as the inner table. Andy Fan 15:21
Re: remove useless returns Tom Lane 15:26
Re: Yet another vectorized engine Konstantin Knizhnik 16:08
Re: allow_system_table_mods stuff Tom Lane 16:11
RE: [Incident report]Backend process crashed when executing 2pc transaction Ranier Vilela 17:37
Re: Memory-Bounded Hash Aggregation Tomas Vondra 17:46
Re: missing estimation for coalesce function Pavel Stehule 18:47
Do XID sequences need to be contiguous? 📎 Mark Dilger 18:51
pg_upgrade fails to preserve old versions of the predefined collations Alexander Lakhin 20:08
Re: pg_upgrade fails to preserve old versions of the predefined collations Thomas Munro 20:25
Re: pg_upgrade fails to preserve old versions of the predefined collations Alexander Lakhin 20:58
Re: Do XID sequences need to be contiguous? Tom Lane 21:25
Re: checkpointer: PANIC: could not fsync file: No such file or directory 📎 Thomas Munro 21:50
Re: checkpointer: PANIC: could not fsync file: No such file or directory Justin Pryzby 22:14
Re: Implementing Incremental View Maintenance Tatsuo Ishii 22:19

Browse Archives

Prev | Next