pgsql-hackers before 2019-12-01 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)
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

Nov. 27, 2019

Thread Author Time
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
Re: [HACKERS] WAL logging problem in 9.4.3? Noah Misch 22:23
Re: pglz performance Tomas Vondra 22:43
Re: checkpointer: PANIC: could not fsync file: No such file or directory Thomas Munro 23:34

Nov. 29, 2019

Thread Author Time
Re: Implementing Incremental View Maintenance Tatsuo Ishii 00:50
Re: progress report for ANALYZE Tatsuro Yamada 00:54
Re: Implementing Incremental View Maintenance Yugo Nagata 00:56
Re: progress report for ANALYZE Tatsuro Yamada 01:27
RE: WAL archive is lost [email protected] 01:44
Re: Proposal: Add more compile-time asserts to expose inconsistencies. 📎 Michael Paquier 02:11
Re: BUG #15383: Join Filter cost estimation problem in 10.5 Michael Paquier 02:18
Re: [PATCH] ltree, lquery, and ltxtquery binary protocol support Michael Paquier 02:29
Re: Write visibility map during CLUSTER/VACUUM FULL Michael Paquier 02:32
Re: PATCH: standby crashed when replay block which truncated in standby but failed to truncate in master node Michael Paquier 02:39
Re: A problem about partitionwise join Michael Paquier 03:03
Re: A problem about partitionwise join Richard Guo 03:07
Re: libpq sslpassword parameter and callback function Greg Nancarrow 03:25
Re: A problem about partitionwise join Etsuro Fujita 03:35
Re: [HACKERS] advanced partition matching algorithm for partition-wise join Etsuro Fujita 03:45
Re: Implementing Incremental View Maintenance Yugo Nagata 04:00
Re: Implementing Incremental View Maintenance Tatsuo Ishii 04:46
Re: pglz performance Andrey Borodin 05:18
Re: FETCH FIRST clause WITH TIES option Andrew Gierth 05:19
RE: [patch]socket_timeout in interfaces/libpq [email protected] 05:22
A rather hackish POC for alternative implementation of WITH TIES 📎 Andrew Gierth 05:39
Re: pgbench - add \aset to store results of a combined query Michael Paquier 05:56
Re: [PATCH] Incremental sort (was: PoC: Partial sort) Michael Paquier 06:01
Re: Improve search for missing parent downlinks in amcheck Michael Paquier 06:03
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view? Michael Paquier 06:19
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view? Michael Paquier 06:20
Re: dropdb --force Michael Paquier 06:30
Re: Implementing Incremental View Maintenance Amit Langote 06:34
Re: Implementing Incremental View Maintenance Yugo Nagata 06:45
Re: To Suggest a "DROP INCREMENTAL MATERIALIZED VIEW" in psql, but the syntax error when you run. Yugo Nagata 06:50
Increase footprint of %m and reduce strerror() Michael Paquier 06:51
Re: Implementing Incremental View Maintenance Takuma Hoshiai 07:10
Update minimum SSL version 📎 Peter Eisentraut 07:36
Re: fe-utils - share query cancellation code 📎 Fabien COELHO 07:44
Re: dropdb --force Juan José Santamaría Flecha 08:05
Re: pg_upgrade fails with non-standard ACL 📎 Artur Zakirov 08:07
Re: Remove page-read callback from XLogReaderState. 📎 Kyotaro Horiguchi 08:14
Re: Implementing Incremental View Maintenance Yugo Nagata 08:33
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view? Julien Rouhaud 08:39
Re: Option to dump foreign data in pg_dump 📎 Luis Carril 08:40
Re: progress report for ANALYZE 📎 Tatsuro Yamada 08:45
Re: progress report for ANALYZE Amit Langote 09:15
Re: Implementing Incremental View Maintenance Yugo Nagata 09:16
Re: Implementing Incremental View Maintenance Yugo Nagata 09:19
Re: allow_system_table_mods stuff Peter Eisentraut 09:30
Re: pgbench - add \aset to store results of a combined query 📎 Fabien COELHO 09:34
Re: dropdb --force Amit Kapila 10:01
Re: Update minimum SSL version Daniel Gustafsson 10:10
Re: Refactor parse analysis of EXECUTE command 📎 Peter Eisentraut 10:39
Re: dropdb --force 📎 vignesh C 11:12
Re: Do XID sequences need to be contiguous? 📎 Amit Kapila 12:09
Re: Update minimum SSL version Magnus Hagander 12:40
Re: Update minimum SSL version Michael Paquier 12:57
Re: pgbench -i progress output on terminal Fabien COELHO 13:13
Re: [HACKERS] Block level parallel vacuum Masahiko Sawada 13:41
Re: libpq sslpassword parameter and callback function 📎 Andrew Dunstan 14:27
Re: Update minimum SSL version Tom Lane 15:30
Re: pgbench -i progress output on terminal 📎 Amit Langote 17:26
Using XLogFileNameP in critical section 📎 Masahiko Sawada 17:44
Make autovacuum sort tables in descending order of xid_age 📎 David Fetter 18:01
Re: checkpointer: PANIC: could not fsync file: No such file or directory 📎 Thomas Munro 21:57
Re: Make autovacuum sort tables in descending order of xid_age 📎 David Fetter 22:21

Nov. 30, 2019

Thread Author Time
Re: range_agg 📎 Alvaro Herrera 02:10
Re: dropdb --force Michael Paquier 02:16
Re: Remove size limitations of vacuums dead_tuples array Michael Paquier 02:20
Re: Update minimum SSL version Michael Paquier 02:43
Re: BufFileRead() error signalling 📎 Thomas Munro 02:46
Re: [HACKERS] Block level parallel vacuum Amit Kapila 03:06
Re: Update minimum SSL version Tom Lane 03:06
Recovery vs. RelationTruncate(); skipFsync vs. unlogged rels 📎 Noah Misch 06:05
Re: pgbench -i progress output on terminal Fabien COELHO 07:27
Since '2001-09-09 01:46:40'::timestamp microseconds are lost when extracting epoch Petr Fedorov 09:28
Re: pgbench -i progress output on terminal 📎 Amit Langote 11:28
Re: log bind parameter values on error 📎 Alexey Bashtanov 12:35
Re: [HACKERS] Block level parallel vacuum Sergei Kornilov 13:48
Re: Since '2001-09-09 01:46:40'::timestamp microseconds are lost when extracting epoch Tom Lane 15:21
Re: BUG #15383: Join Filter cost estimation problem in 10.5 Tom Lane 17:32
Re: Make autovacuum sort tables in descending order of xid_age Mark Dilger 18:04
Re: Append with naive multiplexing of FDWs Bruce Momjian 19:26
Re: pgbench -i progress output on terminal Fabien COELHO 19:33
Re: [HACKERS] Block level parallel vacuum 📎 Mahendra Singh 21:10
Re: Make autovacuum sort tables in descending order of xid_age 📎 David Fetter 22:23
Re: Using multiple extended statistics for estimates Mark Dilger 23:01
Re: Should we add xid_current() or a int8->xid cast? Mark Dilger 23:22

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