pgsql-hackers since 2019-03-10 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

March 10, 2019

Thread Author Time
Re: Re: SQL:2011 PERIODS vs Postgres Ranges? 📎 Paul A Jungwirth 00:41
Re: Pluggable Storage - Andres's take Dmitry Dolgov 04:49
Re: Pluggable Storage - Andres's take Andres Freund 04:54
Re: SQL:2011 PERIODS vs Postgres Ranges? David Steele 06:42
Re: Feature: temporary materialized views David Steele 06:55
Re: Patch to document base64 encoding Fabien COELHO 07:15
what makes the PL cursor life-cycle must be in the same transaction? Andy Fan 08:14
Re: Performance issue in foreign-key-aware join estimation 📎 David Rowley 08:34
Re: Covering GiST indexes Alexander Korotkov 08:39
Re: Should we add GUCs to allow partition pruning to be disabled? David Rowley 09:53
Re: dropdb --force 📎 Filip Rembiałkowski 10:20
Re: jsonpath 📎 Alexander Korotkov 10:51
Re: Re: proposal: make NOTIFY list de-duplication optional 📎 Filip Rembiałkowski 10:53
Re: Performance issue in foreign-key-aware join estimation 📎 David Rowley 11:08
Re: using index or check in ALTER TABLE SET NOT NULL 📎 Sergei Kornilov 11:13
Re: [HACKERS] Re: [COMMITTERS] pgsql: Remove pgbench "progress" test pending solution of its timing is (fwd) 📎 Fabien COELHO 11:26
Re: Checksum errors in pg_stat_database Julien Rouhaud 12:13
Re: [HACKERS] PATCH: multivariate histograms and MCV lists Dean Rasheed 13:09
Re: Should we increase the default vacuum_cost_limit? Julien Rouhaud 13:10
Re: Should we increase the default vacuum_cost_limit? Julien Rouhaud 13:18
Re: Add missing CREATE TABLE IF NOT EXISTS table_name AS EXECUTE query; Ramanarayana 13:26
Re: Batch insert in CTAS/MatView code Paul Guo 13:55
Re: Making all nbtree entries unique by having heap TIDs participate in comparisons Heikki Linnakangas 14:09
Re: WIP: Avoid creation of the free space map for small tables 📎 John Naylor 14:16
Re: BUG #15572: Misleading message reported by "Drop function operation" on DB with functions having same name 📎 David Rowley 15:18
Re: Should we add GUCs to allow partition pruning to be disabled? Justin Pryzby 15:25
Re: Should we increase the default vacuum_cost_limit? Tom Lane 15:47
Re: Should we increase the default vacuum_cost_limit? Julien Rouhaud 15:56
Re: [HACKERS] PATCH: multivariate histograms and MCV lists Dean Rasheed 15:57
Re: Binary upgrade from <12 to 12 creates toast table for partitioned tables Alvaro Herrera 16:29
Re: proposal: plpgsql pragma statement 📎 Pavel Stehule 16:39
Re: GiST VACUUM 📎 Andrey Borodin 16:40
Re: Covering GiST indexes Andrey Borodin 16:42
Re: Why don't we have a small reserved OID range for patch revisions? 📎 John Naylor 17:11
Re: [HACKERS] PATCH: multivariate histograms and MCV lists Tomas Vondra 17:36
Re: monitoring CREATE INDEX [CONCURRENTLY] David Fetter 17:43
Re: subscriptionCheck failures on nightjar Andrew Dunstan 18:40
Re: Making all nbtree entries unique by having heap TIDs participate in comparisons Peter Geoghegan 18:53
Re: Batch insert in CTAS/MatView code David Fetter 18:58
pgsql: Include GUC's unit, if it has one, in out-of-range error message Tom Lane 19:18
Re: Making all nbtree entries unique by having heap TIDs participate in comparisons Heikki Linnakangas 19:53
Re: performance issue in remove_from_unowned_list() Alvaro Herrera 20:09
Re: Making all nbtree entries unique by having heap TIDs participate in comparisons Peter Geoghegan 20:11
Re: Should we increase the default vacuum_cost_limit? 📎 Tom Lane 20:58
Re: Segfault when restoring -Fd dump on current HEAD 📎 Dmitry Dolgov 21:38
Re: [HACKERS] PATCH: multivariate histograms and MCV lists David Rowley 22:27
Re: Add missing CREATE TABLE IF NOT EXISTS table_name AS EXECUTE query; Michael Paquier 22:42
Re: Fwd: Add tablespace tap test to pg_rewind Michael Paquier 22:50
Re: what makes the PL cursor life-cycle must be in the same transaction? Dagfinn Ilmari Mannsåker 23:07
Re: pgbench MAX_ARGS 📎 Dagfinn Ilmari Mannsåker 23:37
Add missing operator <->(box, point) 📎 Nikita Glukhov 23:49

March 11, 2019

Thread Author Time
Re: Making all nbtree entries unique by having heap TIDs participate in comparisons 📎 Peter Geoghegan 00:17
Re: pgsql: Removed unused variable, openLogOff. Michael Paquier 00:40
Re: what makes the PL cursor life-cycle must be in the same transaction? Andy Fan 00:54
RE: speeding up planning with partitions Imai, Yoshikazu 01:10
Re: pgsql: Include GUC's unit, if it has one, in out-of-range error message Michael Paquier 01:11
Re: Binary upgrade from <12 to 12 creates toast table for partitioned tables Andres Freund 01:11
Re: Copy function for logical replication slots 📎 Masahiko Sawada 01:16
Re: Should we add GUCs to allow partition pruning to be disabled? Amit Langote 01:33
Re: Should we add GUCs to allow partition pruning to be disabled? David Rowley 02:00
RE: ECPG regression with DECLARE STATEMENT support 📎 Kuroda, Hayato 02:03
Re: Should we add GUCs to allow partition pruning to be disabled? Amit Langote 02:13
Re: Should we add GUCs to allow partition pruning to be disabled? David Rowley 02:13
Re: Pluggable Storage - Andres's take Haribabu Kommi 02:17
RE: Timeout parameters Nagaura, Ryohei 02:24
Re: [HACKERS] WAL logging problem in 9.4.3? 📎 Noah Misch 02:27
Re: pgsql: tableam: introduce table AM infrastructure. 📎 Amit Kapila 02:51
Re: [HACKERS] advanced partition matching algorithm for partition-wise join Ashutosh Bapat 02:58
Re: [HACKERS] PATCH: multivariate histograms and MCV lists Tomas Vondra 02:59
Portability of strtod (was Re: pgsql: Include GUC's unit, if it has one, in out-of-range error message) Tom Lane 03:15
Re: using index or check in ALTER TABLE SET NOT NULL David Rowley 03:30
Re: Portability of strtod (was Re: pgsql: Include GUC's unit, if it has one, in out-of-range error message) Amit Kapila 03:54
Re: Oddity with parallel safety test for scan/join target in grouping_planner Etsuro Fujita 03:56
Re: Should we add GUCs to allow partition pruning to be disabled? Amit Langote 04:06
Re: Oddity with parallel safety test for scan/join target in grouping_planner Tom Lane 04:06
Re: Should we add GUCs to allow partition pruning to be disabled? Justin Pryzby 04:22
Re: Should we add GUCs to allow partition pruning to be disabled? Amit Langote 04:30
Re: Offline enabling/disabling of data checksums 📎 Michael Paquier 04:53
Re: Oddity with parallel safety test for scan/join target in grouping_planner Etsuro Fujita 05:08
Re: [HACKERS] advanced partition matching algorithm for partition-wise join amul sul 05:09
Re: Oddity with parallel safety test for scan/join target in grouping_planner Tom Lane 05:14
Re: Oddity with parallel safety test for scan/join target in grouping_planner Etsuro Fujita 05:29
Re: A separate table level option to control compression Masahiko Sawada 06:23
Re: BUG #15668: Server crash in transformPartitionRangeBounds 📎 Amit Langote 06:44
Re: BUG #15668: Server crash in transformPartitionRangeBounds 📎 Michael Paquier 07:21
Fix volatile vs. pointer confusion 📎 Peter Eisentraut 07:23
I have some troubles to run test_shm_mq; Andy Fan 07:59
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits Masahiko Sawada 08:03
Re: I have some troubles to run test_shm_mq; Thomas Munro 08:04
Re: psql show URL with help Peter Eisentraut 08:13
Re: [HACKERS] PATCH: multivariate histograms and MCV lists Dean Rasheed 08:15
Re: Problems with plan estimates in postgres_fdw Etsuro Fujita 08:19
Re: I have some troubles to run test_shm_mq; Andy Fan 08:30
Re: Fix volatile vs. pointer confusion Michael Paquier 08:31
Re: I have some troubles to run test_shm_mq; Andy Fan 08:34
Re: [HACKERS] PATCH: multivariate histograms and MCV lists Dean Rasheed 08:35
Re: I have some troubles to run test_shm_mq; Thomas Munro 09:01
Re: monitoring CREATE INDEX [CONCURRENTLY] Rahila Syed 09:02
Re: Should we increase the default vacuum_cost_limit? David Rowley 09:03
RE: Timeout parameters MikalaiKeida 09:07
Re: pgbench MAX_ARGS David Rowley 10:07
Re: Offline enabling/disabling of data checksums Michael Banck 10:11
Re: Offline enabling/disabling of data checksums Michael Banck 10:19
Re: Feature: temporary materialized views Andreas Karlsson 11:06
Re: I have some troubles to run test_shm_mq; Andy Fan 11:43
Re: Fwd: Add tablespace tap test to pg_rewind Shaoqi Bai 11:49
Re: Fix volatile vs. pointer confusion Alvaro Herrera 11:57
Re: Fix optimization of foreign-key on update actions 📎 Peter Eisentraut 11:57
Re: [Patch] Log10 and hyperbolic functions for SQL:2016 compliance 📎 Dean Rasheed 11:58
Re: monitoring CREATE INDEX [CONCURRENTLY] Alvaro Herrera 12:41
Re: Should we increase the default vacuum_cost_limit? Julien Rouhaud 12:57
Best way to keep track of a sliced TOAST Bruno Hass 13:27
Suggestions on message transfer among backends Andy Fan 13:36
Re: Suggestions on message transfer among backends Andy Fan 13:37
Re: Offline enabling/disabling of data checksums Sergei Kornilov 14:11
Re: [Patch] Log10 and hyperbolic functions for SQL:2016 compliance Tom Lane 14:29
Re: Adding a TAP test checking data consistency on standby with minRecoveryPoint Georgios Kokolatos 14:35
Re: Oddity with parallel safety test for scan/join target in grouping_planner Tom Lane 14:46
Re: GiST VACUUM 📎 Heikki Linnakangas 15:03
Re: Portability of strtod (was Re: pgsql: Include GUC's unit, if it has one, in out-of-range error message) Tom Lane 15:06
Re: ECPG regression with DECLARE STATEMENT support Michael Meskes 15:19
Re: pgbench MAX_ARGS Andrew Dunstan 15:59
Unaccent extension python script Issue in Windows Ramanarayana 16:24
Re: move hash_any to utils/hash/hashfn.c Alvaro Herrera 16:27
Re: proposal: variadic argument support for least, greatest function 📎 Andrew Dunstan 16:43
Re: [HACKERS] advanced partition matching algorithm for partition-wise join Ashutosh Bapat 16:43
Re: pgsql: tableam: introduce table AM infrastructure. Andres Freund 17:03
Re: pgbench MAX_ARGS Dagfinn Ilmari Mannsåker 17:04
Re: proposal: variadic argument support for least, greatest function David Steele 17:04
Re: pgbench MAX_ARGS Andrew Dunstan 17:20
Re: [PATCH] kNN for btree Alexander Korotkov 17:42
Re: monitoring CREATE INDEX [CONCURRENTLY] Robert Haas 19:12
Re: monitoring CREATE INDEX [CONCURRENTLY] Alvaro Herrera 19:18
Re: monitoring CREATE INDEX [CONCURRENTLY] Robert Haas 19:21
Re: monitoring CREATE INDEX [CONCURRENTLY] Alvaro Herrera 19:26
Re: monitoring CREATE INDEX [CONCURRENTLY] Robert Haas 19:28
Re: pgsql: Removed unused variable, openLogOff. Robert Haas 19:30
Re: Pluggable Storage - Andres's take 📎 Andres Freund 19:37
Re: monitoring CREATE INDEX [CONCURRENTLY] Alvaro Herrera 19:43
Re: proposal: variadic argument support for least, greatest function Pavel Stehule 19:47
Re: monitoring CREATE INDEX [CONCURRENTLY] Robert Haas 19:57
Re: Compressed TOAST Slicing Darafei Praliaskouski 20:22
Re: monitoring CREATE INDEX [CONCURRENTLY] Alvaro Herrera 20:24
Re: Compressed TOAST Slicing Alvaro Herrera 20:25
Re: Pluggable Storage - Andres's take Andres Freund 20:31
Re: Patch to document base64 encoding 📎 Karl O. Pinc 20:32
Re: insensitive collations 📎 Peter Eisentraut 20:36
Re: Compressed TOAST Slicing Regina Obe 20:38
Re: Pluggable Storage - Andres's take Andres Freund 21:29
Re: Why don't we have a small reserved OID range for patch revisions? 📎 Tom Lane 21:36
Re: proposal: variadic argument support for least, greatest function Tom Lane 22:07
Re: proposal: variadic argument support for least, greatest function Andrew Dunstan 22:25
Re: proposal: variadic argument support for least, greatest function David G. Johnston 22:26
Re: Suggestions on message transfer among backends Euler Taveira 23:53

March 12, 2019

Thread Author Time
Use nanosleep(2) in pg_usleep, if available? Tom Lane 00:03
Re: Suggestions on message transfer among backends Chapman Flack 00:07
Re: Special role for subscriptions Jeff Davis 01:32
[PATCH] remove repetitive characters in fdwhandler.sgml 📎 Zhang, Jie 01:37
RE: pg_upgrade: Pass -j down to vacuumdb 📎 Jamison, Kirk 01:37
RE: Timeout parameters Nagaura, Ryohei 01:39
Re: Offline enabling/disabling of data checksums 📎 Michael Paquier 02:20
Re: pgsql: Removed unused variable, openLogOff. Michael Paquier 02:23
Re: Fwd: Add tablespace tap test to pg_rewind Michael Paquier 02:27
Re: Unaccent extension python script Issue in Windows Michael Paquier 02:28
Re: Special role for subscriptions Michael Paquier 02:39
Re: Making all nbtree entries unique by having heap TIDs participate in comparisons 📎 Peter Geoghegan 02:47
Re: WIP: Avoid creation of the free space map for small tables Amit Kapila 02:52
Re: Offline enabling/disabling of data checksums Michael Paquier 02:53
Re: [Suspect SPAM] Re: Should we increase the default vacuum_cost_limit? 📎 Kyotaro HORIGUCHI 03:31
Re: [Suspect SPAM] Re: Should we increase the default vacuum_cost_limit? 📎 Kyotaro HORIGUCHI 03:45
Re: Why don't we have a small reserved OID range for patch revisions? 📎 Tom Lane 04:56
Re: Suggestions on message transfer among backends Kyotaro HORIGUCHI 05:01
Re: Adding a TAP test checking data consistency on standby with minRecoveryPoint Michael Paquier 05:19
Re: Compressed TOAST Slicing Andrey Borodin 05:22
Re: Compressed TOAST Slicing Michael Paquier 05:42
Re: Suggestions on message transfer among backends Andrey Lepikhov 05:59
Re: current_logfiles not following group access and instead follows log_file_mode permissions Michael Paquier 06:03
Re: Making all nbtree entries unique by having heap TIDs participate in comparisons Heikki Linnakangas 06:30
Re: Suggestions on message transfer among backends Andy Fan 06:36
GSOC Application pavan gudivada 07:01
Re: Making all nbtree entries unique by having heap TIDs participate in comparisons Peter Geoghegan 07:20
Re: Why don't we have a small reserved OID range for patch revisions? John Naylor 07:22
Re: Oddity with parallel safety test for scan/join target in grouping_planner Etsuro Fujita 07:44
pg_rewind : feature to rewind promoted standby is broken! 📎 Mithun Cy 07:53
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits Pavan Deolasee 07:54
Re: Suggestions on message transfer among backends Andy Fan 08:09
Re: speeding up planning with partitions 📎 Amit Langote 08:22
Re: Pluggable Storage - Andres's take Kyotaro HORIGUCHI 08:27
Re: Suggestions on message transfer among backends Antonin Houska 08:36
Re: pg_rewind : feature to rewind promoted standby is broken! 📎 Michael Paquier 09:23
Re: Offline enabling/disabling of data checksums Sergei Kornilov 10:06
Re: Offline enabling/disabling of data checksums Michael Banck 10:13
Re: Adding a TAP test checking data consistency on standby with minRecoveryPoint Arthur Zakirov 10:16
RE: Timeout parameters MikalaiKeida 10:27
Re: WIP: BRIN multi-range indexes 📎 Nikita Glukhov 10:33
Re: Adding a TAP test checking data consistency on standby with minRecoveryPoint Georgios Kokolatos 11:02
Re: Offline enabling/disabling of data checksums Sergei Kornilov 12:12
Re: Unaccent extension python script Issue in Windows Hugh Ranalli 12:30
Re: A separate table level option to control compression 📎 Andrew Dunstan 12:38
Re: Offline enabling/disabling of data checksums Michael Paquier 12:44

Browse Archives

Prev | Next