pgsql-hackers since 2018-01-31 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

Jan. 31, 2018

Thread Author Time
Re: [HACKERS] MERGE SQL Statement for PG11 Peter Geoghegan 00:02
RE: Temporary tables prevent autovacuum, leading to XID wraparound Tsunakawa, Takayuki 00:04
Re: [HACKERS] GnuTLS support Andreas Karlsson 00:36
Re: Regarding drop index Peter Eisentraut 00:36
Re: FOR EACH ROW triggers on partitioned tables Peter Eisentraut 00:44
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Andreas Karlsson 00:48
Re: [Sender Address Forgery]Re: FOR EACH ROW triggers on partitioned tables Amit Langote 00:50
Re: User defined data types in Logical Replication Masahiko Sawada 01:38
Re: JIT compiling with LLVM v9.0 Thomas Munro 01:42
Re: [HACKERS] GUC for cleanup indexes threshold. Masahiko Sawada 01:43
Re: JIT compiling with LLVM v9.0 Andres Freund 02:05
Re: [HACKERS] postgres_fdw bug in 9.6 Etsuro Fujita 02:17
Re: JIT compiling with LLVM v9.0 Thomas Munro 02:48
Re: JIT compiling with LLVM v9.0 Andres Freund 02:55
Re: Wait for parallel workers to attach Amit Kapila 03:10
Re: Wait for parallel workers to attach Robert Haas 03:16
Re: [HACKERS] [PATCH]make pg_rewind to not copy useless WAL files Michael Paquier 03:18
Re: Wait for parallel workers to attach Amit Kapila 03:29
[PATCH] Add missing type conversion functions for PL/Python 📎 Haozhou Wang 03:57
Re: [HACKERS] [PATCH] Improve geometric types Kyotaro HORIGUCHI 04:09
A typo in error message 📎 Alexander Lakhin 05:47
Re: A typo in error message Michael Paquier 05:53
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions Masahiko Sawada 06:53
Re: [HACKERS] path toward faster partition pruning 📎 Amit Langote 08:03
Re: JIT compiling with LLVM v9.0 Konstantin Knizhnik 08:03
Re: [HACKERS] [PATCH] Lockable views 📎 Yugo Nagata 08:26
Re: [HACKERS] [PATCH] Improve geometric types Kyotaro HORIGUCHI 08:33
Re: Wait for parallel workers to attach 📎 Amit Kapila 08:57
Re: Transform for pl/perl Arthur Zakirov 10:36
Re: Help needed in using 'on_dsm_detach' callback Gaddam Sai Ram 10:51
Re: WINDOW RANGE patch versus leakproofness Dean Rasheed 10:52
BUG #15039: some question about hash index code PG Bug reporting form 11:34
Re: csv format for psql Daniel Verite 11:39
Re: BUG #15039: some question about hash index code Amit Kapila 12:06
Re:Re: BUG #15039: some question about hash index code 自己 12:27
Re: Re: BUG #15039: some question about hash index code Amit Kapila 12:44
Re: [HACKERS] Why forcing Hot_standby_feedback to be enabled when creating a logical decoding slot on standby sanyam jain 12:51
Re: csv format for psql Daniel Verite 12:58
Re: csv format for psql Pavel Stehule 13:09
Re: [HACKERS] generated columns Michael Paquier 13:18
Re: [HACKERS] MERGE SQL Statement for PG11 Robert Haas 15:17
Re: JIT compiling with LLVM v9.0 Peter Eisentraut 15:22
Re: Wait for parallel workers to attach 📎 Robert Haas 16:23
CURRENT OF causes an error when IndexOnlyScan is used 📎 Yugo Nagata 16:33
Re: CURRENT OF causes an error when IndexOnlyScan is used 📎 Yugo Nagata 16:44
Re: [HACKERS] Can ICU be used for a database's default sort order? Vladimir Borodin 16:48
Re: JIT compiling with LLVM v9.0 Robert Haas 16:53
Re: [HACKERS] Bug in to_timestamp(). Dmitry Dolgov 16:53
Re: JIT compiling with LLVM v9.0 Robert Haas 16:56
Re: Temporary tables prevent autovacuum, leading to XID wraparound Robert Haas 17:01
Re: [HACKERS] MERGE SQL Statement for PG11 Peter Geoghegan 18:07
Re: JIT compiling with LLVM v9.0 Andres Freund 18:34
Re: JIT compiling with LLVM v9.0 Andres Freund 18:37
Re: [HACKERS] Partition-wise aggregation/grouping Robert Haas 19:41
Re: JIT compiling with LLVM v9.0 Robert Haas 19:45
Interesting paper: Contention-Aware Lock Scheduling Thomas Munro 19:48
Re: JIT compiling with LLVM v9.0 Andres Freund 19:49
Re: JIT compiling with LLVM v9.0 Robert Haas 20:00
Re: autoprewarm is fogetting to register a tranche. Robert Haas 20:18
Re: list partition constraint shape Robert Haas 21:08
Re: Documentation of pgcrypto AES key sizes Robert Haas 21:36
Re: A typo in error message Robert Haas 21:47
Re: WINDOW RANGE patch versus leakproofness Robert Haas 21:51
pgsql: doc: clearify trigger behavior for inheritance Bruce Momjian 22:00
Re: pgsql: doc: clearify trigger behavior for inheritance Robert Haas 22:13
[WIP PATCH] Index scan offset optimisation using visibility map 📎 Michail Nikolaev 22:17
Re: proposal: alternative psql commands quit and exit Bruce Momjian 22:51
Re: pgsql: doc: clearify trigger behavior for inheritance Bruce Momjian 22:53
Re: WINDOW RANGE patch versus leakproofness Dean Rasheed 23:19
Re: [HACKERS] path toward faster partition pruning 📎 David Rowley 23:57

Feb. 1, 2018

Thread Author Time
Re: Add RANGE with values and exclusions clauses to the Window Functions Tom Lane 00:06
Re: [HACKERS] Surjective functional indexes Simon Riggs 00:10
Re: [HACKERS] [PATCH] Lockable views Thomas Munro 00:30
Re: Temporary tables prevent autovacuum, leading to XID wraparound Masahiko Sawada 00:37
Re: [HACKERS] [PATCH] Lockable views Tatsuo Ishii 00:48
Re: [HACKERS] Refactoring identifier checks to consistently use strcmp Michael Paquier 00:56
Re: list partition constraint shape Amit Langote 01:05
Re: [HACKERS] [PATCH] Lockable views Yugo Nagata 01:31
Re: Add RANGE with values and exclusions clauses to the Window Functions David G. Johnston 01:46
Re: CURRENT OF causes an error when IndexOnlyScan is used Tom Lane 02:12
Re: Wait for parallel workers to attach Amit Kapila 03:08
Re: [HACKERS] why not parallel seq scan for slow functions Amit Kapila 04:48
Re: WIP Patch: Precalculate stable functions, infrastructure v1 📎 Marina Polyakova 05:01
Re: [HACKERS] generated columns 📎 Michael Paquier 05:03
Re: Changing WAL Header to reduce contention during ReserveXLogInsertLocation() Michael Paquier 05:35
Re: CURRENT OF causes an error when IndexOnlyScan is used Yugo Nagata 05:57
Re: Changing WAL Header to reduce contention during ReserveXLogInsertLocation() Pavan Deolasee 06:00
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Michael Paquier 06:21
Re: STATISTICS retained in CREATE TABLE ... LIKE (INCLUDING ALL)? David Rowley 06:26
Re: [HACKERS] Cache lookup errors with functions manipulation object addresses 📎 Michael Paquier 06:32
Re: [HACKERS] WIP: Restricting pg_rewind to data/wal dirs Michael Paquier 06:41
Re: [HACKERS] taking stdbool.h into use Michael Paquier 06:47
Re: Re: BUG #15039: some question about hash index code 📎 Amit Kapila 06:51
constraint exclusion and nulls in IN (..) clause 📎 Amit Langote 06:56
Re: constraint exclusion and nulls in IN (..) clause Ashutosh Bapat 07:40
Re: [HACKERS] Creating backup history files for backups taken from standbys Michael Paquier 08:20
IndexJoin memory problem using spgist and boxes 📎 Anton Dignös 08:43
Re: STATISTICS retained in CREATE TABLE ... LIKE (INCLUDING ALL)? Tomas Vondra 08:45
Re: [HACKERS] Surjective functional indexes Konstantin Knizhnik 08:49
Re: constraint exclusion and nulls in IN (..) clause 📎 Amit Langote 08:53
Re: [HACKERS] Surjective functional indexes Simon Riggs 09:32
Re: [HACKERS] [PATCH] Improve geometric types Emre Hasegeli 09:35
Re: [HACKERS] [PATCH] Improve geometric types Emre Hasegeli 09:36
Re: no partition pruning when partitioning using array type 📎 Amit Langote 09:42
Re: [HACKERS] GnuTLS support Christoph Berg 10:08
Re: Built-in connection pooling Konstantin Knizhnik 10:24
Re: [HACKERS] Bug in to_timestamp(). 📎 Arthur Zakirov 10:24
Query running for very long time (server hanged) with parallel append Rajkumar Raghuwanshi 10:29
Re: proposal: alternative psql commands quit and exit Daniel Verite 11:01
Re: [HACKERS] MERGE SQL Statement for PG11 Simon Riggs 11:07
line_perp() (?-|) is broken. 📎 Kyotaro HORIGUCHI 11:51
Re: [HACKERS] [PATCH] Improve geometric types Kyotaro HORIGUCHI 11:52
Re: Query running for very long time (server hanged) with parallel append Amit Khandekar 11:53
Re: Built-in connection pooling Vladimir Sitnikov 12:21
Re: Built-in connection pooling Konstantin Knizhnik 12:44
Re: [HACKERS] MERGE SQL Statement for PG11 Simon Riggs 12:45
Re: proposal: alternative psql commands quit and exit Bruce Momjian 12:47
Re: proposal: alternative psql commands quit and exit Bruce Momjian 13:10
Re: MCV lists for highly skewed distributions Simon Riggs 13:16
[PoC PATCH] Parallel dump to /dev/null 📎 Michael Banck 13:24
Re: proposal: alternative psql commands quit and exit Bruce Momjian 13:32
Re: Built-in connection pooling Vladimir Sitnikov 13:33
Re: proposal: alternative psql commands quit and exit Bruce Momjian 13:38
Re: JIT compiling with LLVM v9.0 Peter Eisentraut 13:42
Re: JIT compiling with LLVM v9.0 Peter Eisentraut 13:46
Re: ALTER TABLE ADD COLUMN fast default Andres Freund 13:54
Re: [HACKERS] Partition-wise aggregation/grouping 📎 Jeevan Chalke 13:59
Re: JIT compiling with LLVM v9.0 Andres Freund 14:01
Re: proposal: alternative psql commands quit and exit Daniel Verite 14:01
Re: [HACKERS] taking stdbool.h into use Peter Eisentraut 14:04
Re: [HACKERS] Can ICU be used for a database's default sort order? Peter Eisentraut 14:09
Re: [HACKERS] generated columns Peter Eisentraut 14:29
Re: [HACKERS] make async slave to wait for lsn to be replayed Simon Riggs 14:47
Re: JIT compiling with LLVM v9.0 Merlin Moncure 14:51
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions Peter Eisentraut 14:51
Re: FOR EACH ROW triggers on partitioned tables Peter Eisentraut 15:04
Re: unique indexes on partitioned tables Peter Eisentraut 15:05
Re: Built-in connection pooling Konstantin Knizhnik 15:07
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail 15:17
Re: no partition pruning when partitioning using array type Robert Haas 15:20
Re: [HACKERS] MERGE SQL Statement for PG11 📎 Simon Riggs 15:21
Re: Temporary tables prevent autovacuum, leading to XID wraparound Robert Haas 15:31
Re: Wait for parallel workers to attach Robert Haas 15:39
Re: [HACKERS] Creating backup history files for backups taken from standbys Fujii Masao 15:47
git instructions 📎 Magnus Hagander 15:54
Re: Jsonb transform for pl/python Peter Eisentraut 16:06
Re: git instructions Chapman Flack 16:20
CALL stmt, ERROR: unrecognized node type: 113 bug Pavel Stehule 16:33
Re: git instructions Magnus Hagander 16:35
Re: MCV lists for highly skewed distributions 📎 Dean Rasheed 17:21
Re: JIT compiling with LLVM v9.0 Jeff Davis 17:32
Re: MCV lists for highly skewed distributions Robert Haas 17:49
Re: [HACKERS] why not parallel seq scan for slow functions 📎 Robert Haas 18:45
Re: Changing WAL Header to reduce contention during ReserveXLogInsertLocation() Robert Haas 18:55
Re: [HACKERS] Refactoring identifier checks to consistently use strcmp Robert Haas 19:03
Re: [HACKERS] MERGE SQL Statement for PG11 Peter Geoghegan 19:39
Re: [HACKERS] Partition-wise aggregation/grouping Robert Haas 20:11
Re: [HACKERS] [PATCH] Lockable views Robert Haas 20:16
Re: Built-in connection pooling Vladimir Sitnikov 20:28
Re: Re: BUG #15039: some question about hash index code Robert Haas 20:33
Re: Cancelling parallel query leads to segfault 📎 Peter Eisentraut 22:13
Re: Query running for very long time (server hanged) with parallel append Thomas Munro 22:20
Re: [Patch] Checksums for SLRU files Thomas Munro 22:37
Re: [HACKERS] path toward faster partition pruning Robert Haas 22:38
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions Tomas Vondra 22:50
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions Tomas Vondra 22:51

Feb. 2, 2018

Thread Author Time
Re: Changing WAL Header to reduce contention during ReserveXLogInsertLocation() Simon Riggs 00:21
Re: [HACKERS] [PATCH] Vacuum: Update FSM more frequently Masahiko Sawada 00:34
BUG #15044: materialized views incompatibility with logical replication in postgres 10 PG Bug reporting form 00:56
Re: JIT compiling with LLVM v9.0 Andres Freund 01:05
Re: [HACKERS] [PATCH] Lockable views Tatsuo Ishii 01:09
BUG #15044: materialized views incompatibility with logical replication in postgres 10 David G. Johnston 01:16
Re: Cancelling parallel query leads to segfault Andres Freund 01:35
Re: BUG #15044: materialized views incompatibility with logical replication in postgres 10 Chad Trabant 01:39
Re: [HACKERS] MERGE SQL Statement for PG11 Peter Geoghegan 01:59
Re: JIT compiling with LLVM v9.0 Thomas Munro 02:16
Re: Changing WAL Header to reduce contention during ReserveXLogInsertLocation() Michael Paquier 02:17
Re: [HACKERS] generated columns Michael Paquier 02:25
Re: Re: BUG #15039: some question about hash index code Amit Kapila 02:46
[bug fix] ECPG: freeing memory for pgtypes crashes on Windows 📎 Tsunakawa, Takayuki 02:47
Re: Wait for parallel workers to attach Amit Kapila 02:48
Re: proposal: alternative psql commands quit and exit Bruce Momjian 03:28
Re: JIT compiling with LLVM v9.0 Thomas Munro 04:11
Re: [HACKERS] Refactoring identifier checks to consistently use strcmp Michael Paquier 04:13
Re: [HACKERS] taking stdbool.h into use Michael Paquier 04:16
Re: [PoC PATCH] Parallel dump to /dev/null Michael Paquier 04:22
Re: [HACKERS] Creating backup history files for backups taken from standbys 📎 Michael Paquier 05:06
Re: JIT compiling with LLVM v9.0 📎 Thomas Munro 05:22
Re: proposal: alternative psql commands quit and exit Bruce Momjian 05:39
Re: [HACKERS] path toward faster partition pruning 📎 Amit Langote 06:04
Re: JIT compiling with LLVM v9.0 Jeff Davis 06:06
Re: JIT compiling with LLVM v9.0 Thomas Munro 06:09
Re: JIT compiling with LLVM v9.0 Jeff Davis 06:20
Re: Temporary tables prevent autovacuum, leading to XID wraparound Masahiko Sawada 06:27
RE: Temporary tables prevent autovacuum, leading to XID wraparound Tsunakawa, Takayuki 06:37
Re: Query running for very long time (server hanged) with parallel append Amit Khandekar 06:43
Re: CALL stmt, ERROR: unrecognized node type: 113 bug Michael Paquier 07:01
Re: CALL stmt, ERROR: unrecognized node type: 113 bug Michael Paquier 07:07
Re: [HACKERS] Restrict concurrent update/delete with UPDATE of partition key 📎 amul sul 08:41
Re: [HACKERS] make async slave to wait for lsn to be replayed Simon Riggs 08:46

Browse Archives

Prev | Next