pgsql-hackers since 2019-06-28 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

June 28, 2019

Thread Author Time
Re: UCT (Re: pgsql: Update time zone data files to tzdata release 2019a.) Andrew Gierth 00:33
C testing for Postgres Adam Berlin 00:48
Re: An out-of-date comment in nodeIndexonlyscan.c Ashwin Agrawal 00:54
Re: Usage of epoch in txid_current Alexander Korotkov 01:12
Commitfest 2019-07, the first of five* for PostgreSQL 13 Thomas Munro 02:04
Re: Usage of epoch in txid_current Alexander Korotkov 02:15
Re: SQL/JSON path issues/questions Alexander Korotkov 02:50
Re: SQL/JSON path issues/questions Alexander Korotkov 03:47
Re: Obsolete comment in commands/analyze.c Etsuro Fujita 04:00
Re: SQL/JSON path issues/questions Alvaro Herrera 05:09
Re: An out-of-date comment in nodeIndexonlyscan.c Thomas Munro 05:36
Re: Hypothetical indexes using BRIN broken since pg10 Julien Rouhaud 05:49
Re: SQL/JSON path issues/questions Oleg Bartunov 06:00
Re: catalog files simplification Peter Eisentraut 06:53
Re: cleanup & refactoring on reindexdb.c 📎 Julien Rouhaud 07:25
Re: Commitfest 2019-07, the first of five* for PostgreSQL 13 Fabien COELHO 07:57
Re: Commitfest 2019-07, the first of five* for PostgreSQL 13 Sergei Kornilov 07:58
postgres_fdw: Minor improvement to postgresAcquireSampleRowsFunc 📎 Etsuro Fujita 09:38
Re: allow_system_table_mods stuff 📎 Peter Eisentraut 09:51
Re: postgres_fdw: Minor improvement to postgresAcquireSampleRowsFunc Julien Rouhaud 09:54
Re: POC: Cleaning up orphaned files using undo logs Amit Kapila 09:56
Re: Commitfest 2019-07, the first of five* for PostgreSQL 13 Peter Eisentraut 09:57
Re: C testing for Postgres Dmitry Dolgov 09:57
Re: Implementing Incremental View Maintenance Yugo Nagata 10:01
Re: postgres_fdw: Minor improvement to postgresAcquireSampleRowsFunc Etsuro Fujita 10:15
Re: Implementing Incremental View Maintenance 📎 Yugo Nagata 10:56
Re: Conflict handling for COPY FROM 📎 Surafel Temesgen 10:56
Re: [PATCH] Stop ALTER SYSTEM from making bad assumptions Amit Kapila 11:03
Re: Implementing Incremental View Maintenance Yugo Nagata 11:03
Re: [PATCH] Stop ALTER SYSTEM from making bad assumptions Amit Kapila 11:30
Re: SQL/JSON path issues/questions Alexander Korotkov 11:30
Re: Conflict handling for COPY FROM Alvaro Herrera 13:12
Re: C testing for Postgres Adam Berlin 13:42
Re: Avoid full GIN index scan when possible 📎 Julien Rouhaud 14:07
Superfluous libpq-be.h include in GSSAPI code 📎 Daniel Gustafsson 14:37
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view? 📎 Julien Rouhaud 14:39
Option to dump foreign data in pg_dump 📎 Luis Carril 14:49
proposal - patch: psql - sort_by_size 📎 Pavel Stehule 15:12
Re: Option to dump foreign data in pg_dump Pavel Stehule 15:16
Re: Option to dump foreign data in pg_dump Daniel Gustafsson 15:17
Re: subscriptionCheck failures on nightjar Tom Lane 15:17
Re: Option to dump foreign data in pg_dump Pavel Stehule 15:20
Re: Option to dump foreign data in pg_dump Tom Lane 15:30
Re: [HACKERS] Regression tests vs existing users in an installation Stephen Frost 15:41
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view? 📎 Julien Rouhaud 15:46
Re: Commitfest 2019-07, the first of five* for PostgreSQL 13 Stephen Frost 15:52
Re: Option to dump foreign data in pg_dump Pavel Stehule 15:53
Re: Avoid full GIN index scan when possible Tomas Vondra 16:10
NOT IN subquery optimization 📎 Li, Zheng 16:18
Re: Avoid full GIN index scan when possible Julien Rouhaud 16:43
Re: SimpleLruTruncate() mutual exclusion 📎 Noah Misch 17:06
Re: Commitfest 2019-07, the first of five* for PostgreSQL 13 Tom Lane 17:15
Re: Option to dump foreign data in pg_dump Luis Carril 17:55
Re: [HACKERS] Regression tests vs existing users in an installation 📎 Tom Lane 18:42
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view? Peter Geoghegan 18:46
Re: Superfluous libpq-be.h include in GSSAPI code Julien Rouhaud 18:47
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view? Peter Geoghegan 18:49
Re: Avoid full GIN index scan when possible Tom Lane 19:03
Re: Avoid full GIN index scan when possible Tomas Vondra 19:54
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits Amit Kapila 19:56
Re: Avoid full GIN index scan when possible Tom Lane 20:16
Re: Comment typo in tableam.h Amit Kapila 20:47
Re: BUG #15293: Stored Procedure Triggered by Logical Replication is Unable to use Notification Events Alvaro Herrera 21:22
Re: BUG #15383: Join Filter cost estimation problem in 10.5 Alvaro Herrera 21:26
Re: BUG #15858: could not stat file - over 4GB 📎 Juan José Santamaría Flecha 21:34
Re: Commitfest 2019-07, the first of five* for PostgreSQL 13 David Steele 21:47
Re: C testing for Postgres David Fetter 21:54
Re: BUG #15383: Join Filter cost estimation problem in 10.5 Tom Lane 22:05
Re: BUG #15383: Join Filter cost estimation problem in 10.5 Alvaro Herrera 22:10
Re: Avoid full GIN index scan when possible Julien Rouhaud 22:23
Re: [PATCH] Implement uuid_version() Peter Geoghegan 22:24
Re: Avoid full GIN index scan when possible 📎 Nikita Glukhov 22:50
Re: Avoid full GIN index scan when possible Tomas Vondra 22:54
Re: [HACKERS] WAL logging problem in 9.4.3? Amit Kapila 23:46

June 29, 2019

Thread Author Time
Re: [bug fix] Produce a crash dump before main() on Windows Amit Kapila 00:10
Re: Superfluous libpq-be.h include in GSSAPI code Michael Paquier 02:23
Re: cleanup & refactoring on reindexdb.c Michael Paquier 02:24
Re: BUG #15858: could not stat file - over 4GB Michael Paquier 02:30
Re: C testing for Postgres Jesse Zhang 05:11
Re: SQL/JSON: JSON_TABLE Pavel Stehule 05:40
Re: errbacktrace Jaime Casanova 05:40
Re: BUG #15858: could not stat file - over 4GB Juan José Santamaría Flecha 06:19
Re: TM format can mix encodings in to_char() Juanjo Santamaria Flecha 06:21
Re: proposal - patch: psql - sort_by_size Fabien COELHO 07:32
Re: Commitfest 2019-07, the first of five* for PostgreSQL 13 Thomas Munro 08:05
Re: proposal - patch: psql - sort_by_size Pavel Stehule 08:19
Re: [Proposal] Table-level Transparent Data Encryption (TDE) and Key Management Service (KMS) 📎 Masahiko Sawada 08:55
Re: Avoid full GIN index scan when possible Julien Rouhaud 09:10
Re: Commitfest 2019-07, the first of five* for PostgreSQL 13 Magnus Hagander 09:55
Re: Avoid full GIN index scan when possible Tomas Vondra 10:25
Re: Multivariate MCV list vs. statistics target 📎 Tomas Vondra 10:41
Re: Avoid full GIN index scan when possible Julien Rouhaud 12:50
Re: Choosing values for multivariate MCV lists 📎 Tomas Vondra 13:01
Re: Avoid full GIN index scan when possible Tomas Vondra 13:11
Re: Avoid full GIN index scan when possible Julien Rouhaud 13:28
Re: Optimize partial TOAST decompression Andrey Borodin 13:48
Re: TM format can mix encodings in to_char() Tom Lane 13:58
Re: mcvstats serialization code is still shy of a load 📎 Tomas Vondra 14:13
Re: Avoid full GIN index scan when possible Tomas Vondra 14:27
Re: Fix runtime errors from -fsanitize=undefined didier 16:16
Re: Avoid full GIN index scan when possible Alexander Korotkov 17:06
Re: [HACKERS] Regression tests vs existing users in an installation 📎 Tom Lane 17:21
Re: Avoid full GIN index scan when possible Alexander Korotkov 17:27
Re: Avoid full GIN index scan when possible Alexander Korotkov 17:28
base backup client as auxiliary backend process 📎 Peter Eisentraut 20:05
Increasing default value for effective_io_concurrency? 📎 Tomas Vondra 20:15
Where is SSPI auth username determined for TAP tests? Tom Lane 20:36
Re: UCT (Re: pgsql: Update time zone data files to tzdata release 2019a.) Robert Haas 20:48
Re: Usage of epoch in txid_current Robert Haas 21:06

June 30, 2019

Thread Author Time
Re: Where is SSPI auth username determined for TAP tests? Michael Paquier 01:42
Re: [HACKERS] proposal: schema variables 📎 Pavel Stehule 03:10
Re: Custom table AMs need to include heapam.h because of BulkInsertState David Rowley 05:54
Re: Avoiding deadlock errors in CREATE INDEX CONCURRENTLY Goel, Dhruv 07:30
Re: Multivariate MCV list vs. statistics target David Rowley 07:34
Re: make \d pg_toast.foo show its indices ; and, \d toast show its main table ; and \d relkind=I show its partitions (and tablespace) Fabien COELHO 08:26
Re: proposal - patch: psql - sort_by_size 📎 Pavel Stehule 08:47
Re: check_recovery_target_lsn() does a PG_CATCH without a throw Peter Eisentraut 09:06
Add parallelism and glibc dependent only options to reindexdb 📎 Julien Rouhaud 09:45
Re: check_recovery_target_lsn() does a PG_CATCH without a throw Michael Paquier 12:35
Fix typos and inconsistencies for HEAD 📎 Alexander Lakhin 13:06
Re: [PATCH] Implement uuid_version() Fabien COELHO 13:50
Re: Where is SSPI auth username determined for TAP tests? Tom Lane 16:09
Re: [PATCH] Implement uuid_version() Tomas Vondra 18:26
Re: Dead encoding conversion functions 📎 Tom Lane 21:30
Re: Fix up grouping sets reorder Andrew Gierth 23:00

July 1, 2019

Thread Author Time
RE: [bug fix] Produce a crash dump before main() on Windows Tsunakawa, Takayuki 00:04
RE: Commitfest 2019-07, the first of five* for PostgreSQL 13 Tsunakawa, Takayuki 00:11
Re: mcvstats serialization code is still shy of a load 📎 Tom Lane 00:30
Re: Fix typos and inconsistencies for HEAD Michael Paquier 01:02
Re: BUG #15383: Join Filter cost estimation problem in 10.5 David Rowley 02:14
RE: Zedstore - compressed in-core columnar storage Tsunakawa, Takayuki 02:59
Re: Minimal logical decoding on standbys 📎 Amit Khandekar 05:34
Re: Protect syscache from bloating with negative cache entries 📎 Kyotaro Horiguchi 07:02
Re: POC: Cleaning up orphaned files using undo logs 📎 Thomas Munro 07:53
Re: Superfluous libpq-be.h include in GSSAPI code Daniel Gustafsson 08:29
Re: POC: Cleaning up orphaned files using undo logs Thomas Munro 08:46
Re: Add parallelism and glibc dependent only options to reindexdb Michael Paquier 08:54
Re: [PATCH] Add support for ON UPDATE/DELETE actions on ALTER CONSTRAINT Thomas Munro 09:20
Re: Re: [PATCH][PROPOSAL] Add enum releation option type Thomas Munro 09:25
Re: Option to dump foreign data in pg_dump Daniel Gustafsson 09:29
Re: [HACKERS] advanced partition matching algorithm for partition-wise join Thomas Munro 09:49
Re: [HACKERS] Cached plans and statement generalization Thomas Munro 09:51
Re: Attempt to consolidate reading of XLOG page Thomas Munro 09:54
Re: MSVC Build support with visual studio 2019 Haribabu Kommi 09:56
Re: Built-in connection pooler Thomas Munro 09:57
Re: Libpq support to connect to standby server as priority 📎 Haribabu Kommi 10:09
Re: [HACKERS] Custom compression methods Thomas Munro 10:21
Re: Add parallelism and glibc dependent only options to reindexdb Julien Rouhaud 10:30
Re: FETCH FIRST clause WITH TIES option Thomas Munro 10:30
Re: [PATCH] kNN for btree Thomas Munro 10:41
Re: make installcheck-world in a clean environment Thomas Munro 10:47
Re: [HACKERS] Custom compression methods Alexander Korotkov 10:47
Re: Optimization of some jsonb functions Thomas Munro 10:50
RE: [PATCH] Speedup truncates of relation forks Jamison, Kirk 10:55
Re: Choosing values for multivariate MCV lists Dean Rasheed 11:02
Re: How to estimate the shared memory size required for parallel scan? 📎 Thomas Munro 11:03
Re: Psql patch to show access methods info Thomas Munro 11:06
logical replication slot and publication alter Jinhua Luo 11:12
Re: [HACKERS] advanced partition matching algorithm for partition-wise join Etsuro Fujita 11:16
Re: shared-memory based stats collector Thomas Munro 11:19
Re: Converting NOT IN to anti-joins during planning 📎 David Rowley 11:23
Re: Tid scan improvements Thomas Munro 11:29
Re: Planning counters in pg_stat_statements (using pgss_store) 📎 Julien Rouhaud 11:31
Re: [HACKERS] Transactions involving multiple postgres foreign servers, take 2 Thomas Munro 11:32
Re: allow online change primary_conninfo 📎 Sergei Kornilov 11:33
Re: Two pg_rewind patches (auto generate recovery conf and ensure clean shutdown) Thomas Munro 11:34
Re: [PROPOSAL] Temporal query processing with range types Thomas Munro 11:44
Re: [PATCH] get rid of StdRdOptions, use individual binary reloptions representation for each relation kind instead Thomas Munro 11:52
Re: extension patch of CREATE OR REPLACE TRIGGER Thomas Munro 11:57
Re: [Patch] pg_rewind: options to use restore_command from recovery.conf or command line Thomas Munro 12:02
Re: Change ereport level for QueuePartitionConstraintValidation 📎 Sergei Kornilov 12:17
Re: Commitfest 2019-07, the first of five* for PostgreSQL 13 Thomas Munro 12:20
Re: Custom table AMs need to include heapam.h because of BulkInsertState David Rowley 13:26
Re: Optimize partial TOAST decompression 📎 Binguo Bao 13:46
Re: Add parallelism and glibc dependent only options to reindexdb Alvaro Herrera 13:51
Re: Add parallelism and glibc dependent only options to reindexdb Tom Lane 14:10
Re: [Patch] pg_rewind: options to use restore_command from recovery.conf or command line 📎 Alexey Kondratov 14:20
Re: [HACKERS] Custom compression methods Alvaro Herrera 14:51
Re: Built-in connection pooler 📎 Konstantin Knizhnik 15:11
Fix two issues after moving to unified logging system for command-line utils 📎 Alexey Kondratov 15:18
Re: [HACKERS] Custom compression methods Alexander Korotkov 15:28
Re: [HACKERS] Cached plans and statement generalization 📎 Konstantin Knizhnik 15:29
Re: Error message inconsistency Alvaro Herrera 15:40
Re: Avoid full GIN index scan when possible Marc Cousin 15:56
Re: Two pg_rewind patches (auto generate recovery conf and ensure clean shutdown) Alvaro Herrera 15:57
Re: Cleanup/remove/update references to OID column Justin Pryzby 15:59
Re: Cleanup/remove/update references to OID column Tom Lane 16:13
Re: Add parallelism and glibc dependent only options to reindexdb Julien Rouhaud 16:14
Re: Add parallelism and glibc dependent only options to reindexdb Julien Rouhaud 16:28
Re: Support for jsonpath .datetime() method 📎 Alexander Korotkov 16:28
Re: POC: converting Lists into arrays Jesper Pedersen 16:58
Re: FETCH FIRST clause WITH TIES option 📎 Surafel Temesgen 17:38
Re: [PATCH] kNN for btree 📎 Nikita Glukhov 17:45
Change atoi to strtol in same place 📎 Surafel Temesgen 17:48
Re: [PATCH] get rid of StdRdOptions, use individual binary reloptions representation for each relation kind instead Alvaro Herrera 18:02
Re: [PATCH][PROPOSAL] Add enum releation option type Alvaro Herrera 18:06
Re: POC: converting Lists into arrays 📎 Tom Lane 18:44
Re: Zedstore - compressed in-core columnar storage Ashwin Agrawal 19:08
Memory-Bounded Hash Aggregation Jeff Davis 19:13
Re: Zedstore - compressed in-core columnar storage Ashwin Agrawal 19:14

Browse Archives

Prev | Next