pgsql-hackers since 2018-03-09 20:28

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

March 9, 2018

Thread Author Time
Re: JIT compiling with LLVM v11 Peter Eisentraut 20:28
Re: FOR EACH ROW triggers on partitioned tables 📎 Alvaro Herrera 20:41
Re: JIT compiling with LLVM v11 Peter Eisentraut 20:42
Re: JIT compiling with LLVM v11 Andres Freund 20:56
Re: using worker_spi as pattern Jeremy Finzel 21:03
Re: FOR EACH ROW triggers on partitioned tables 📎 Alvaro Herrera 21:05
Re: JIT compiling with LLVM v11 Andres Freund 21:08
Re: [PATCH] Verify Checksums during Basebackups 📎 Michael Banck 21:35
Re: PQHost() undefined behavior if connecting string contains both host and hostaddr types Peter Eisentraut 21:42
Re: csv format for psql Daniel Verite 22:18
Re: PATCH: Unlogged tables re-initialization tests Peter Eisentraut 22:23
Bogus use of canonicalize_qual Tom Lane 22:37

March 10, 2018

Thread Author Time
Re: [HACKERS] Lazy hash table for XidInMVCCSnapshot (helps Zipfian a bit) 📎 Yura Sokolov 02:11
Re: csv format for psql David G. Johnston 02:58
Re: constraint exclusion and nulls in IN (..) clause 📎 Tom Lane 04:40
Re: csv format for psql Fabien COELHO 06:45
Re: csv format for psql Fabien COELHO 06:49
Re: [HACKERS] GSoC 2017: weekly progress reports (week 4) and patch for hash index 📎 Amit Kapila 07:40
Re: [HACKERS] GSoC 2017: weekly progress reports (week 4) and patch for hash index 📎 Amit Kapila 07:53
Re: Fixes for missing schema qualifications Michael Paquier 08:14
Re: Fixes for missing schema qualifications Noah Misch 08:36
Re: using index or check in ALTER TABLE SET NOT NULL 📎 Sergei Kornilov 09:35
Re: [HACKERS] Restrict concurrent update/delete with UPDATE of partition key Amit Kapila 11:55
Re: remove pg_class.relhaspkey Tomas Vondra 12:52
Re: Online enabling of checksums Michael Banck 12:53
Re: Concurrency bug in UPDATE of partition-key Amit Kapila 13:03
Re: [HACKERS] PATCH: multivariate histograms and MCV lists Mark Dilger 13:08
Re: disable SSL compression? Craig Ringer 13:43
Google Summer of Code: Potential Applicant Christos Maris 13:46
Re: Sample values for pg_stat_statements Tomas Vondra 14:02
Re: [HACKERS] PATCH: multivariate histograms and MCV lists Tomas Vondra 14:05
Re: [WIP PATCH] Index scan offset optimisation using visibility map 📎 Michail Nikolaev 14:20
Re: [HACKERS] GUC for cleanup indexes threshold. 📎 Alexander Korotkov 14:49
Re: Online enabling of checksums Michael Banck 15:09
Re: [HACKERS] [PATCH] Incremental sort Alexander Korotkov 15:42
Re: [PROPOSAL] timestamp informations to pg_stat_statements legrand legrand 15:43
Re: [HACKERS] [PATCH] Incremental sort Alexander Korotkov 17:05
Re: [HACKERS] PATCH: multivariate histograms and MCV lists Alvaro Herrera 17:19
Re: FOR EACH ROW triggers on partitioned tables Alvaro Herrera 18:02
Re: Fixes for missing schema qualifications Alvaro Herrera 18:13
Re: All Taxi Services need Index Clustered Heap Append legrand legrand 18:32
Re: [HACKERS] PATCH: multivariate histograms and MCV lists Mark Dilger 18:43
Re: [RFC] What would be difficult to make data models pluggable for making PostgreSQL a multi-model database? Henry 19:39
Re: [PROPOSAL] timestamp informations to pg_stat_statements Tomas Vondra 20:12
Re: Bogus use of canonicalize_qual 📎 Tom Lane 20:21
Re: [HACKERS] PATCH: multivariate histograms and MCV lists 📎 Tomas Vondra 21:29
VACUUM FULL vs dropped columns Andrew Dunstan 22:37
Intermittent pg_ctl failures on Windows Tom Lane 22:48
Re: Parallel Aggregates for string_agg and array_agg Tomas Vondra 23:11
Re: VACUUM FULL vs dropped columns Tom Lane 23:19
Re: VACUUM FULL vs dropped columns Andrew Dunstan 23:24
Re: disable SSL compression? Peter Eisentraut 23:36

March 11, 2018

Thread Author Time
Re: [HACKERS] MERGE SQL Statement for PG11 Peter Geoghegan 03:57
Re: [HACKERS] MERGE SQL Statement for PG11 Pavan Deolasee 05:22
Re: Faster inserts with mostly-monotonically increasing values Pavan Deolasee 05:27
Re: [HACKERS] MERGE SQL Statement for PG11 Peter Geoghegan 05:48
Re: Parallel Aggregates for string_agg and array_agg 📎 David Rowley 06:31
initdb help message about WAL segment size 📎 Magnus Hagander 07:23
Re: disable SSL compression? Magnus Hagander 08:00
Re: initdb help message about WAL segment size Michael Paquier 09:08
Re: Bogus use of canonicalize_qual Dean Rasheed 09:09
Re: PATCH: Unlogged tables re-initialization tests Michael Paquier 09:11
Re: MCV lists for highly skewed distributions 📎 Dean Rasheed 09:23
Re: [WIP PATCH] Index scan offset optimisation using visibility map Andrey Borodin 09:29
Parallel index creation does not properly cleanup after error David Rowley 10:22
Re: Parallel Aggregates for string_agg and array_agg Tomas Vondra 11:10
Re: [HACKERS] GUC for cleanup indexes threshold. 📎 Alexander Korotkov 11:19
Re: [HACKERS] why not parallel seq scan for slow functions 📎 Amit Kapila 12:19
Re: disable SSL compression? 📎 Peter Eisentraut 13:05
Re: [bug fix] pg_rewind creates corrupt WAL files, and the standby cannot catch up the primary 📎 Michael Paquier 14:04
Inconsistent behavior in serializable snapshot Kuntal Ghosh 14:22
Re: [bug fix] pg_rewind creates corrupt WAL files, and the standby cannot catch up the primary Justin Pryzby 14:56
Re: ALTER TABLE ADD COLUMN fast default David Rowley 14:59
[GSOC 18] Performance Farm Project——Initialization Project 📎 Hongyuan Ma 15:12
Re: Faster inserts with mostly-monotonically increasing values Claudio Freire 15:48
Re: disable SSL compression? Magnus Hagander 16:07
GSOC 2018 proposal Charles Cui 16:12
Re: JIT compiling with LLVM v11 Peter Eisentraut 17:19
Re: JIT compiling with LLVM v11 Peter Eisentraut 17:21
Re: Bogus use of canonicalize_qual Tom Lane 17:23
Re: disable SSL compression? Tom Lane 17:28
Re: JIT compiling with LLVM v11 Andres Freund 18:25
Re: [GSOC 18] Performance Farm Project——Initialization Project Dave Page 18:26
Re: [HACKERS] GSoC 2017: weekly progress reports (week 4) and patch for hash index Alexander Korotkov 18:32
Re: [HACKERS] GSoC 2017: weekly progress reports (week 4) and patch for hash index Alexander Korotkov 18:48
Using JIT for VACUUM, COPY, ANALYZE Pavel Stehule 19:31
Re: [HACKERS] advanced partition matching algorithm for partition-wise join Dmitry Dolgov 19:34
Re: Sample values for pg_stat_statements Greg Stark 19:36
Re: Using JIT for VACUUM, COPY, ANALYZE Andres Freund 19:38
Re: Parallel index creation does not properly cleanup after error 📎 Peter Geoghegan 19:41
Re: Using JIT for VACUUM, COPY, ANALYZE Andres Freund 20:51
Re: [HACKERS] GSoC 2017: weekly progress reports (week 6) Alexander Korotkov 20:54
Re: [bug fix] pg_rewind creates corrupt WAL files, and the standby cannot catch up the primary Michael Paquier 22:39

March 12, 2018

Thread Author Time
Re: FOR EACH ROW triggers on partitioned tables Thomas Munro 02:13
Re: Foreign keys and partitioned tables 📎 Alvaro Herrera 02:40
Re: Fixes for missing schema qualifications Michael Paquier 02:59
Re: inserts into partitioned table may cause crash 📎 Etsuro Fujita 03:25
Re: [HACKERS] advanced partition matching algorithm for partition-wise join 📎 Ashutosh Bapat 05:00
WARNING in parallel index creation. Jeff Janes 05:15
Re: [HACKERS] Restrict concurrent update/delete with UPDATE of partition key amul sul 06:15
Re: Inconsistent behavior in serializable snapshot Kuntal Ghosh 06:21
Re: [HACKERS] GSoC 2017: weekly progress reports (week 6) Andrey Borodin 06:47
Re: [HACKERS] proposal: schema variables Pavel Luzanov 06:49
Re: [HACKERS] proposal: schema variables Pavel Stehule 06:54
Re: PATCH: Configurable file mode mask Michael Paquier 07:28
Re: [HACKERS] Another oddity in handling of WCO constraints in postgres_fdw Etsuro Fujita 07:55
Fix error in ECPG while connection handling 📎 Jeevan Ladhe 08:07
Re: Transform for pl/perl 📎 Anthony Bykov 08:08
Re: GSOC 2018 proposal Aleksander Alekseev 08:25
Re: Protect syscache from bloating with negative cache entries 📎 Kyotaro HORIGUCHI 08:34
Re: Protect syscache from bloating with negative cache entries 📎 Kyotaro HORIGUCHI 08:36
Re: Concurrency bug in UPDATE of partition-key 📎 Amit Khandekar 08:52
Re: All Taxi Services need Index Clustered Heap Append Konstantin Knizhnik 08:55
Re: [WIP PATCH] Index scan offset optimisation using visibility map Michail Nikolaev 09:01
Re: Failed to request an autovacuum work-item in silence Ildar Musin 09:26
[HACKERS] Commitfest 2018-9 duplicate patch deletion request. Shinoda, Noriyoshi 10:12
Re: pg_serial early wraparound Anastasia Lubennikova 11:26
Re: Prefix operator for text and spgist support 📎 Ildus Kurbangaliev 11:36
RE: Intermittent pg_ctl failures on Windows Badrul Chowdhury 11:55
Re: [HACKERS] MERGE SQL Statement for PG11 Pavan Deolasee 12:13
Re: [HACKERS] Partition-wise aggregation/grouping 📎 Ashutosh Bapat 12:37
Re: [WIP PATCH] Index scan offset optimisation using visibility map Andrey Borodin 12:40
Re: [HACKERS] Restrict concurrent update/delete with UPDATE of partition key 📎 amul sul 13:03
Re: [HACKERS] [FEATURE PATCH] pg_stat_statements with plans (v02) Julian Markwort 13:11
Re: [HACKERS] Partition-wise aggregation/grouping Jeevan Chalke 13:20
Re: [HACKERS] Commitfest 2018-9 duplicate patch deletion request. David Steele 13:24
Corrupted data due to system power failure 📎 Enzo Diletti 13:27
Re: FOR EACH ROW triggers on partitioned tables Peter Eisentraut 13:39
Re: [HACKERS] GSoC 2017: weekly progress reports (week 4) and patch for hash index Amit Kapila 13:48
Re:Re: [GSOC 18] Performance Farm Project——Initialization Project Hongyuan Ma 13:57
Re: Google Summer of Code: Potential Applicant Aleksander Alekseev 13:58
Re:Google Summer of Code: Potential Applicant Hongyuan Ma 14:08
Re: [HACKERS] Partition-wise aggregation/grouping 📎 Jeevan Chalke 14:19
Re: WIP: a way forward on bootstrap data 📎 John Naylor 14:25
Re: FOR EACH ROW triggers on partitioned tables Peter Eisentraut 14:31
Re: Cast jsonb to numeric, int, float, bool Darafei Komяpa Praliaskouski 14:34
Re: [patch] BUG #15005: ANALYZE can make pg_class.reltuples inaccurate. Tom Lane 14:43
Re: Cast jsonb to numeric, int, float, bool Tom Lane 15:00
Re: Transform for pl/perl Pavel Stehule 15:06
Re: JIT compiling with LLVM v11 Peter Eisentraut 15:21
Re: Cast jsonb to numeric, int, float, bool Darafei Komяpa Praliaskouski 15:24
Re: Jsonb transform for pl/python 📎 Nikita Glukhov 15:26
Re: PATCH: Unlogged tables re-initialization tests Peter Eisentraut 15:27
Re: PATCH: Unlogged tables re-initialization tests David Steele 15:33
Re: [HACKERS] proposal: schema variables Pavel Luzanov 15:38
Re: pgsql: Local partitioned indexes Alvaro Herrera 15:53
Re: PATCH: Unlogged tables re-initialization tests Dagfinn Ilmari =?utf-8?Q?Manns=C3=A5ker?= 15:59
Re: pgsql: Allow UNIQUE indexes on partitioned tables Alvaro Herrera 16:02
Re: [HACKERS] proposal: schema variables Pavel Stehule 16:13
Re: [patch] BUG #15005: ANALYZE can make pg_class.reltuples inaccurate. 📎 Tom Lane 16:21
Ambigous Plan - Larger Table on Hash Side Narendra Pradeep U U 16:32
Re: pgsql: Allow UNIQUE indexes on partitioned tables Alvaro Herrera 16:34
Re: Cast jsonb to numeric, int, float, bool Tom Lane 16:43
Re: Ambigous Plan - Larger Table on Hash Side Tom Lane 16:52
Additional Statistics Hooks Mat Arye 17:03
Re: JIT compiling with LLVM v11 Andres Freund 17:05
Re: All Taxi Services need Index Clustered Heap Append stalkthetiger 17:21
Re: Ambigous Plan - Larger Table on Hash Side Andres Freund 17:43
Re: CURRENT OF causes an error when IndexOnlyScan is used Tom Lane 17:56
Re: Ambigous Plan - Larger Table on Hash Side Tom Lane 18:06
Re: PATCH: Unlogged tables re-initialization tests David Steele 18:33
Re: Function to track shmem reinit time Grigory Smolkin 18:51
Re: Additional Statistics Hooks Euler Taveira 18:52
Re: Re: [GSOC 18] Performance Farm Project——Initialization Project Dave Page 19:03
Re: PATCH: Configurable file mode mask Stephen Frost 19:14
Re: JIT compiling with LLVM v11 Peter Eisentraut 19:25
Re: [WIP PATCH] Index scan offset optimisation using visibility map Tom Lane 19:55
Re: JIT compiling with LLVM v11 Andres Freund 21:04
Re: JIT compiling with LLVM v11 Tom Lane 21:14
Re: JIT compiling with LLVM v11 Andres Freund 21:19
Re: Additional Statistics Hooks Mat Arye 21:27
Re: Google Summer of Code: Potential Applicant Christos Maris 21:34
Re: [patch] BUG #15005: ANALYZE can make pg_class.reltuples inaccurate. 📎 Tom Lane 22:05
explain with costs in subselect.sql Andres Freund 22:20
Re: explain with costs in subselect.sql Tom Lane 22:25
Re: explain with costs in subselect.sql Andres Freund 22:28
Re: Additional Statistics Hooks Tom Lane 22:44
Re: unique indexes on partitioned tables Alvaro Herrera 22:50
Re: Fix error in ECPG while connection handling Michael Meskes 22:57

March 13, 2018

Thread Author Time
RE: [HACKERS] Commitfest 2018-9 duplicate patch deletion request. Shinoda, Noriyoshi 00:56
RE: unique indexes on partitioned tables Shinoda, Noriyoshi 00:58
Re: Google Summer of Code: Potential Applicant Craig Ringer 01:20
Re: Google Summer of Code: Potential Applicant Craig Ringer 01:21
Re: [HACKERS] Partition-wise aggregation/grouping Ashutosh Bapat 03:42
Re: WARNING in parallel index creation. Peter Geoghegan 03:44
Re: ALTER TABLE ADD COLUMN fast default 📎 Andrew Dunstan 04:10
Re: [HACKERS] Another oddity in handling of WCO constraints in postgres_fdw Ashutosh Bapat 04:11
Re: GSOC 2018 proposal Charles Cui 04:29
Re: parallel append vs. simple UNION ALL 📎 Ashutosh Bapat 04:35
Re: [HACKERS] why not parallel seq scan for slow functions Ashutosh Bapat 05:03
Re: [patch] BUG #15005: ANALYZE can make pg_class.reltuples inaccurate. 📎 David Gould 06:14
Re: PATCH: Unlogged tables re-initialization tests Michael Paquier 06:31
Re: [WIP PATCH] Index scan offset optimisation using visibility map Andrey Borodin 06:37
Re: PATCH: Configurable file mode mask Michael Paquier 06:46
Re: Ambigous Plan - Larger Table on Hash Side Ashutosh Bapat 07:12
Re: [patch] BUG #15005: ANALYZE can make pg_class.reltuples inaccurate. David Gould 07:14
Re: Problem while setting the fpw with SIGHUP Michael Paquier 08:04
RE: Temporary tables prevent autovacuum, leading to XID wraparound 📎 Tsunakawa, Takayuki 08:08
Re: MCV lists for highly skewed distributions John Naylor 08:39
Re: proposal: schema variables Pavel Luzanov 09:54

Browse Archives

Prev | Next