pgsql-hackers - February 2018

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

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
Re: [HACKERS] Surjective functional indexes Simon Riggs 08:49
Re: JIT compiling with LLVM v9.0 Andres Freund 08:50
Re: JIT compiling with LLVM v9.0 Andres Freund 08:53
Re: [HACKERS] make async slave to wait for lsn to be replayed Stephen Frost 09:02
Re: Boolean partitions syntax Amit Langote 09:39
Re: [PoC PATCH] Parallel dump to /dev/null Michael Banck 09:44
Re: JIT compiling with LLVM v9.1 📎 Pierre Ducroquet 09:48
Re: [HACKERS] path toward faster partition pruning Amit Langote 10:03
Re: JIT compiling with LLVM v9.0 Andres Freund 10:08
Re: [PoC PATCH] Parallel dump to /dev/null Andrey Borodin 10:25
Re: [HACKERS] Add support for tuple routing to foreign partitions Etsuro Fujita 10:33
Re: [PoC PATCH] Parallel dump to /dev/null Vladimir Borodin 10:36
Re: JIT compiling with LLVM v9.1 📎 Pierre Ducroquet 10:40
Re: [HACKERS] Adding column_constraint description in ALTER TABLE synopsis Stephen Frost 10:41
Re: [HACKERS] Add support for tuple routing to foreign partitions Etsuro Fujita 10:43
Re: non-bulk inserts and tuple routing Etsuro Fujita 10:56
Re: [HACKERS] Can ICU be used for a database's default sort order? Andrey Borodin 12:22
Re: [HACKERS] Re: Improve OR conditions on joined columns (common star schema problem) Tomas Vondra 12:41
Re: [HACKERS] Partition-wise aggregation/grouping Jeevan Chalke 13:25
Re: [HACKERS] GnuTLS support Robert Haas 13:47
Re: [HACKERS] Partition-wise aggregation/grouping Robert Haas 13:59
Re: Wait for parallel workers to attach Robert Haas 14:11
Re: [HACKERS] [PATCH] Vacuum: Update FSM more frequently Claudio Freire 14:13
Re: Flexible configuration for full-text search 📎 Aleksandr Parfenov 14:24
Re: [HACKERS] Re: Improve OR conditions on joined columns (common star schema problem) Tom Lane 14:26
Re: [HACKERS] path toward faster partition pruning Robert Haas 14:33
Prefix operator for text and spgist support 📎 Ildus Kurbangaliev 15:03
Re: [HACKERS] [PATCH] Lockable views Robert Haas 15:12
Re: Query running for very long time (server hanged) with parallel append Robert Haas 15:16
Re: Changing WAL Header to reduce contention during ReserveXLogInsertLocation() Robert Haas 15:37
Re: [HACKERS] Bug in to_timestamp(). Robert Haas 15:40
Re: Wait for parallel workers to attach Peter Geoghegan 16:11
Re: [HACKERS] Can ICU be used for a database's default sort order? Peter Geoghegan 16:14
Re: [HACKERS] Parallel tuplesort (for parallel B-Tree index creation) 📎 Peter Geoghegan 16:16
Re: Add RANGE with values and exclusions clauses to the Window Functions 📎 Oliver Ford 16:26
Re: Built-in connection pooling Konstantin Knizhnik 16:28
Re: Built-in connection pooling 📎 Konstantin Knizhnik 16:36
Re: Temporary tables prevent autovacuum, leading to XID wraparound Robert Haas 16:48
Re: Add RANGE with values and exclusions clauses to the Window Functions David G. Johnston 16:57
Re: Add RANGE with values and exclusions clauses to the Window Functions 📎 Oliver Ford 17:31
pgsql: Support parallel btree index builds. Robert Haas 18:37
Re: [HACKERS] Parallel tuplesort (for parallel B-Tree index creation) Robert Haas 18:37
Re: [HACKERS] Parallel tuplesort (for parallel B-Tree index creation) Peter Geoghegan 18:38
Re: [HACKERS] make async slave to wait for lsn to be replayed Robert Haas 18:46
Re: [HACKERS] make async slave to wait for lsn to be replayed Simon Riggs 19:41
Re: ERROR: too many dynamic shared memory segments Tom Lane 20:01
Re: ERROR: too many dynamic shared memory segments Robert Haas 20:19
Re: Built-in connection pooling Vladimir Sitnikov 20:20
Re: [HACKERS] Parallel tuplesort (for parallel B-Tree index creation) Peter Geoghegan 20:23
Re: [HACKERS] Parallel tuplesort (for parallel B-Tree index creation) Robert Haas 20:30
Re: [HACKERS] Parallel tuplesort (for parallel B-Tree index creation) Peter Geoghegan 20:35
Re: [HACKERS] Parallel tuplesort (for parallel B-Tree index creation) Robert Haas 20:49
Re: [HACKERS] Bug in to_timestamp(). Dmitry Dolgov 20:54
Re: ERROR: too many dynamic shared memory segments Tom Lane 20:56
Re: [HACKERS] path toward faster partition pruning Robert Haas 21:05
RelOptInfo -> Relation Robert Haas 21:21
Re: [HACKERS] Parallel tuplesort (for parallel B-Tree index creation) Peter Geoghegan 21:35
Re: Boolean partitions syntax Peter Eisentraut 21:40
Re: [HACKERS] Parallel tuplesort (for parallel B-Tree index creation) Andres Freund 21:58
Re: Boolean partitions syntax Tom Lane 22:00
Re: [HACKERS] proposal: schema variables 📎 Pavel Stehule 22:06
Draft release notes for 10.2 et al Tom Lane 22:15
Re: Boolean partitions syntax Robert Haas 22:17
Re: [HACKERS] Restrict concurrent update/delete with UPDATE of partition key Robert Haas 22:34
Re: [HACKERS] Vacuum: allow usage of more than 1GB of work mem Claudio Freire 22:52
Re: Boolean partitions syntax Tom Lane 23:04
Re: Query running for very long time (server hanged) with parallel append David Kohn 23:17

Feb. 3, 2018

Thread Author Time
Re: RelOptInfo -> Relation Tom Lane 00:06
Re: [HACKERS] Parallel tuplesort (for parallel B-Tree index creation) Peter Geoghegan 00:31
pie-in-sky idea: 'sensitive' function parameters Chapman Flack 00:37

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