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

Thread Author Time
Re: [HACKERS] PATCH: multivariate histograms and MCV lists David Rowley 00:17
Re: SQL statement PREPARE does not work in ECPG Michael Meskes 01:03
Re: The two "XML Fixes" patches still in need of review 📎 Chapman Flack 01:21
Re: Pluggable Storage - Andres's take Andres Freund 01:26
Re: CPU costs of random_zipfian in pgbench Tomas Vondra 03:06
Re: Pluggable Storage - Andres's take 📎 Andres Freund 03:16
Re: Pluggable Storage - Andres's take Andres Freund 03:18
Re: Fix foreign key constraint check for partitioned tables Edmund Horner 03:26
Re: CPU costs of random_zipfian in pgbench Tomas Vondra 03:33
Re: [HACKERS] proposal: schema variables 📎 Pavel Stehule 05:57
Re: [HACKERS] PATCH: multivariate histograms and MCV lists Dean Rasheed 07:36
Re: [GSoC] application ideas Andrey Borodin 09:12
Re: [HACKERS] proposal: schema variables Erik Rijkers 09:25
Re: [HACKERS] proposal: schema variables Pavel Stehule 09:32
Re: Ordered Partitioned Table Scans David Rowley 10:00
Re: Ordered Partitioned Table Scans 📎 David Rowley 10:05
Re: Planning counters in pg_stat_statements (using pgss_store) Julien Rouhaud 10:24
Avoid full GIN index scan when possible 📎 Julien Rouhaud 10:52
Assert failure when validating foreign keys David Rowley 10:54
Re: chained transactions Peter Eisentraut 11:04
Re: BUG #15708: RLS 'using' running as wrong user when called from a view 📎 Dean Rasheed 11:19
Re: pg_basebackup ignores the existing data directory permissions 📎 Haribabu Kommi 11:30
Re: Planning counters in pg_stat_statements (using pgss_store) Julien Rouhaud 12:10
Re: current_logfiles not following group access and instead follows log_file_mode permissions Michael Paquier 12:16
Re: current_logfiles not following group access and instead follows log_file_mode permissions Michael Paquier 12:26
Re: Adding a TAP test checking data consistency on standby with minRecoveryPoint Michael Paquier 12:47
Re: Error message inconsistency Amit Kapila 13:02
Re: Connections hang indefinitely while taking a gin index's LWLock buffer_content lock Alexander Korotkov 13:35
Re: Error message inconsistency Greg Steiner 13:41
Re: CPU costs of random_zipfian in pgbench Fabien COELHO 14:12
Re: CPU costs of random_zipfian in pgbench 📎 Fabien COELHO 14:34
Re: chained transactions Fabien COELHO 14:41
Re: jsonpath Andres Freund 16:44
Re: GiST VACUUM Andrey Borodin 16:50
Re: [HACKERS] CLUSTER command progress monitor 📎 Tattsu Yama 16:55
Re: warning to publication created and wal_level is not set to logical David Fetter 17:54
Re: CPU costs of random_zipfian in pgbench 📎 Fabien COELHO 18:05
Re: warning to publication created and wal_level is not set to logical Tom Lane 18:06
Re: jsonpath Alexander Korotkov 18:09
Re: Error message inconsistency Simon Riggs 18:23
Re: CPU costs of random_zipfian in pgbench Tom Lane 18:27
Re: CPU costs of random_zipfian in pgbench 📎 Fabien COELHO 20:21
Re: monitoring CREATE INDEX [CONCURRENTLY] Rahila Syed 20:42

March 25, 2019

Thread Author Time
Re: Problem with default partition pruning Amit Langote 00:21
Re: selecting from partitions and constraint exclusion Amit Langote 00:31
Re: [HACKERS] CLUSTER command progress monitor 📎 Tatsuro Yamada 01:01
Re: Fix XML handling with DOCTYPE Ryan Lambert 01:04
ALTER TABLE with ADD COLUMN and ADD PRIMARY KEY USING INDEX throws spurious "column contains null values" 📎 Zhang, Jie 01:31
RE: speeding up planning with partitions 📎 Imai, Yoshikazu 01:47
Re: Fix XML handling with DOCTYPE Chapman Flack 01:49
RE: Problem with default partition pruning Yuzuko Hosoya 02:03
RE: Protect syscache from bloating with negative cache entries Ideriha, Takeshi 02:03
Re: Error message inconsistency Amit Kapila 03:15
Re: Fix XML handling with DOCTYPE Tom Lane 03:18
Re: Error message inconsistency Amit Kapila 03:23
Re: Usage of epoch in txid_current 📎 Thomas Munro 04:01
Re: Removing unneeded self joins 📎 David Rowley 04:07
RE: Timeout parameters 📎 Nagaura, Ryohei 05:26
Re: reorder pg_rewind control file sync Michael Paquier 07:14
Re: current_logfiles not following group access and instead follows log_file_mode permissions Haribabu Kommi 07:19
Re: Re: make installcheck-world in a clean environment David Steele 07:25
Re: make installcheck-world in a clean environment Alexander Lakhin 07:30
Re: Re: shared-memory based stats collector David Steele 07:31
Re: Re: proposal: plpgsql pragma statement David Steele 07:38
Re: Re: Log a sample of transactions David Steele 07:43
Re: Re: proposal: plpgsql pragma statement Pavel Stehule 07:50
Re: Re: using index or check in ALTER TABLE SET NOT NULL David Steele 07:51
Re: Re: Reduce amount of WAL generated by CREATE INDEX for gist, gin and sp-gist David Steele 07:57
Re: Fix handling of unlogged tables in FOR ALL TABLES publications 📎 Peter Eisentraut 08:04
Re: Re: libpq compression David Steele 08:06
Re: Libpq support to connect to standby server as priority 📎 Haribabu Kommi 08:07
Re: Re: Tid scan improvements David Steele 08:11
Re: Re: [PATCH] kNN for btree David Steele 08:17
Re: Re: Copy function for logical replication slots David Steele 08:26
Re: Re: allow online change primary_conninfo David Steele 08:32
Re: Re: [PATCH][PROPOSAL] Add enum releation option type David Steele 08:39
Re: Re: reloption to prevent VACUUM from truncating empty pages at the end of relation David Steele 08:44
Re: Re: Conflict handling for COPY FROM David Steele 08:50
Re: Re: FETCH FIRST clause PERCENT option David Steele 08:53
Re: Re: FETCH FIRST clause WITH TIES option David Steele 08:55
Re: libpq compression Konstantin Knizhnik 09:04
Re: Reporting script runtimes in pg_regress Peter Eisentraut 09:06
Re: reorder pg_rewind control file sync Fabien COELHO 09:29
Re: Reduce amount of WAL generated by CREATE INDEX for gist, gin and sp-gist Heikki Linnakangas 10:21
Re: libpq compression David Steele 10:38
Re: Speed up transaction completion faster after many relations are accessed in a transaction Peter Eisentraut 10:44
Re: libpq compression Dmitry Dolgov 10:48
Re: Usage of epoch in txid_current 📎 Thomas Munro 10:49
Re: psql display of foreign keys Peter Eisentraut 11:04
Feature: Add Greek language fulltext search 📎 Panagiotis Mavrogiorgos 11:04
Re: speeding up planning with partitions 📎 Amit Langote 11:34
RE: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view? legrand legrand 11:36
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view? Julien Rouhaud 11:43
Re: Speed up transaction completion faster after many relations are accessed in a transaction David Rowley 11:48
RE: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view? legrand legrand 11:49
Re: libpq compression 📎 Konstantin Knizhnik 12:12
Re: [HACKERS] WAL logging problem in 9.4.3? 📎 Kyotaro HORIGUCHI 12:32
pgsql: Get rid of backtracking in jsonpath_scan.l Alexander Korotkov 12:44
Re: ALTER TABLE with ADD COLUMN and ADD PRIMARY KEY USING INDEX throws spurious "column contains null values" Sergei Kornilov 12:45
Re: pgsql: Get rid of backtracking in jsonpath_scan.l Robert Haas 12:55
Re: pgsql: Get rid of backtracking in jsonpath_scan.l Alexander Korotkov 12:58
Re: pg_basebackup ignores the existing data directory permissions Robert Haas 13:08
pg_malloc0() instead of pg_malloc()+memset() 📎 Daniel Gustafsson 13:18
Re: GiST VACUUM Heikki Linnakangas 13:20
Re: warning to publication created and wal_level is not set to logical Lucas Viecelli 13:20
Re: Transaction commits VS Transaction commits (with parallel) VS query mean time Haribabu Kommi 13:25
Re: Protect syscache from bloating with negative cache entries Robert Haas 13:28
Re: Removing unneeded self joins Alexander Kuzmenkov 13:45
Re: Feature: Add Greek language fulltext search Tom Lane 13:53
Re: warning to publication created and wal_level is not set to logical David Fetter 14:15
Re: Usage of epoch in txid_current Heikki Linnakangas 14:23
Re: Assert failure when validating foreign keys Andres Freund 14:24
Re: Fix XML handling with DOCTYPE Ryan Lambert 14:40
Re: [HACKERS] CLUSTER command progress monitor Robert Haas 15:02
Re: Re: using index or check in ALTER TABLE SET NOT NULL Robert Haas 15:09
Re: Removing unneeded self joins 📎 Alexander Kuzmenkov 15:13
renaming ExecStoreWhateverTuple Robert Haas 15:20
Re: selecting from partitions and constraint exclusion Robert Haas 15:21
Re: Removing \cset from pgbench Alvaro Herrera 15:22
Re: REINDEX CONCURRENTLY 2.0 📎 Peter Eisentraut 15:23
Re: renaming ExecStoreWhateverTuple Alvaro Herrera 15:27
Re: [PATCH] kNN for btree 📎 Nikita Glukhov 15:29
Re: renaming ExecStoreWhateverTuple Robert Haas 15:30
Re: renaming ExecStoreWhateverTuple Alvaro Herrera 15:49
Re: renaming ExecStoreWhateverTuple Andres Freund 15:57
Re: renaming ExecStoreWhateverTuple Robert Haas 16:05
Re: [HACKERS] Re: [COMMITTERS] pgsql: Remove pgbench "progress" test pending solution of its timing is (fwd) Heikki Linnakangas 16:09
Re: Error message inconsistency Robert Haas 16:11
Re: renaming ExecStoreWhateverTuple Andres Freund 16:32
Re: renaming ExecStoreWhateverTuple Tom Lane 16:33
Re: renaming ExecStoreWhateverTuple Andres Freund 16:36
Re: renaming ExecStoreWhateverTuple Tom Lane 16:45
Re: monitoring CREATE INDEX [CONCURRENTLY] 📎 Alvaro Herrera 16:53
Re: renaming ExecStoreWhateverTuple Andres Freund 17:20
Re: renaming ExecStoreWhateverTuple Robert Haas 17:22
Re: warning to publication created and wal_level is not set to logical Robert Haas 17:39
Re: warning to publication created and wal_level is not set to logical Tom Lane 17:53
Re: Assert failure when validating foreign keys 📎 Andres Freund 18:04
Re: warning to publication created and wal_level is not set to logical Andres Freund 18:06
Re: [HACKERS] Re: [COMMITTERS] pgsql: Remove pgbench "progress" test pending solution of its timing is (fwd) 📎 Fabien COELHO 18:13
Re: warning to publication created and wal_level is not set to logical Tom Lane 18:19
Re: Fix foreign key constraint check for partitioned tables 📎 Hadi Moshayedi 18:57
Re: [HACKERS] proposal: schema variables Erik Rijkers 19:40
Re: MSVC Build support with visual studio 2019 Andrew Dunstan 19:44
Re: [HACKERS] Removing [Merge]Append nodes which contain a single subpath Tom Lane 20:00
Re: Ordered Partitioned Table Scans Julien Rouhaud 20:03
Re: BUG #15708: RLS 'using' running as wrong user when called from a view Stephen Frost 20:27
Re: Planning counters in pg_stat_statements (using pgss_store) legrand legrand 20:30
Re: MSVC Build support with visual studio 2019 Andrew Dunstan 21:32
Re: Tid scan improvements Andres Freund 21:48
Re: Tid scan improvements Andres Freund 21:52
Re: pg_upgrade: Pass -j down to vacuumdb Tom Lane 21:57
Re: Fix XML handling with DOCTYPE Ryan Lambert 22:03
Re: reorder pg_rewind control file sync Michael Paquier 22:37
Re: psql display of foreign keys 📎 Alvaro Herrera 22:38
Re: pg_basebackup ignores the existing data directory permissions Michael Paquier 22:44
Re: MacPorts support for "extra" tests Thomas Munro 22:45
Re: Fix XML handling with DOCTYPE Chapman Flack 22:52
Re: Tid scan improvements Tom Lane 22:53
Re: Fix XML handling with DOCTYPE Tom Lane 22:56
Re: pg_upgrade version checking questions 📎 Daniel Gustafsson 23:12
Re: [HACKERS] Removing [Merge]Append nodes which contain a single subpath David Rowley 23:29
Re: [HACKERS] PATCH: multivariate histograms and MCV lists 📎 Tomas Vondra 23:36
Re: [HACKERS] PATCH: multivariate histograms and MCV lists Tomas Vondra 23:39
Re: Usage of epoch in txid_current Thomas Munro 23:58

March 26, 2019

Thread Author Time
Re: selecting from partitions and constraint exclusion Amit Langote 00:36
setLastTid() and currtid() Andres Freund 00:44
RE: Re: Log a sample of transactions Kuroda, Hayato 00:54
Re: [HACKERS] CLUSTER command progress monitor Tatsuro Yamada 01:04
Re: BUG #15668: Server crash in transformPartitionRangeBounds Michael Paquier 01:15
Re: [HACKERS] Block level parallel vacuum Haribabu Kommi 01:19
Re: BUG #15668: Server crash in transformPartitionRangeBounds Amit Langote 01:24
Re: psql display of foreign keys 📎 Alvaro Herrera 01:57
Re: psql display of foreign keys Amit Langote 01:58
Re: monitoring CREATE INDEX [CONCURRENTLY] Amit Langote 02:02
Misleading errors with column references in default expressions and partition bounds 📎 Michael Paquier 02:08
Re: monitoring CREATE INDEX [CONCURRENTLY] Alvaro Herrera 02:11
Re: Ordered Partitioned Table Scans 📎 David Rowley 02:12
Re: [HACKERS] CLUSTER command progress monitor Michael Paquier 02:15
Re: monitoring CREATE INDEX [CONCURRENTLY] Andres Freund 02:18
Re: pg_upgrade: Pass -j down to vacuumdb Michael Paquier 02:20
Re: pg_basebackup ignores the existing data directory permissions Michael Paquier 02:26
Re: Special role for subscriptions Michael Paquier 02:29
Re: REINDEX CONCURRENTLY 2.0 Michael Paquier 02:35
Re: monitoring CREATE INDEX [CONCURRENTLY] Alvaro Herrera 02:39
Re: psql display of foreign keys 📎 Alvaro Herrera 02:42
RE: Timeout parameters Jamison, Kirk 02:48
Re: pg_basebackup ignores the existing data directory permissions Haribabu Kommi 03:59
Re: Refactoring the checkpointer's fsync request queue 📎 Thomas Munro 04:19
RE: Timeout parameters 📎 Nagaura, Ryohei 05:34
Re: [HACKERS] proposal: schema variables 📎 Pavel Stehule 05:40
Re: [HACKERS] proposal: schema variables Pavel Stehule 05:41
Re: partitioned tables referenced by FKs Amit Langote 06:06
Re: Tid scan improvements Edmund Horner 06:11
Re: Tid scan improvements David Steele 06:24
Re: Re: Copy function for logical replication slots 📎 Masahiko Sawada 06:37
Re: speeding up planning with partitions 📎 Amit Langote 07:16
Re: [HACKERS] WAL logging problem in 9.4.3? 📎 Kyotaro HORIGUCHI 07:35
Re: Re: FETCH FIRST clause WITH TIES option 📎 Surafel Temesgen 07:46
Re: [HACKERS] Block level parallel vacuum Kyotaro HORIGUCHI 07:46

Browse Archives

Prev | Next