pgsql-hackers since 2019-07-20 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)

Advanced Search

Browse Archives

Prev | Next

July 20, 2019

Thread	Author	Time
Re: [PATCH] minor bugfix for pg_basebackup (9.6 ~ )	Michael Paquier	01:04
Re: Compile from source using latest Microsoft Windows SDK	Michael Paquier	01:10
Re: [HACKERS] [WIP] Effective storage of duplicates in B-tree index. 📎	Peter Geoghegan	02:24
Re: POC: Cleaning up orphaned files using undo logs	Dilip Kumar	03:49
Re: POC: Cleaning up orphaned files using undo logs	Dilip Kumar	04:14
Re: should there be a hard-limit on the number of transactions pending undo?	Amit Kapila	04:27
Re: should there be a hard-limit on the number of transactions pending undo?	Amit Kapila	05:17
Re: POC: Cleaning up orphaned files using undo logs	Amit Kapila	07:10
Re: [PATCH] get rid of StdRdOptions, use individual binary reloptions representation for each relation kind instead	Dent John	08:21
Re: POC: Cleaning up orphaned files using undo logs	Dilip Kumar	08:25
Re: pgsql: Sync our copy of the timezone library with IANA release tzcode20	Michael Paquier	09:17
Re: Compiler warnings with MinGW	Michael Paquier	09:19
thoughts on "prevent wraparound" vacuum	Michail Nikolaev	12:35
Re: [PATCH] Incremental sort (was: PoC: Partial sort) 📎	Tomas Vondra	13:22
Queries on QMF to POSTGRE	JVM .	13:56
Re: [PATCH] Incremental sort (was: PoC: Partial sort) 📎	James Coleman	14:33
Re: [sqlsmith] Crash in mcv_get_match_bitmap	Tomas Vondra	14:38
Re: [PATCH] Incremental sort (was: PoC: Partial sort)	Tomas Vondra	15:25
Re: [PATCH] Incremental sort (was: PoC: Partial sort)	James Coleman	16:12
Re: [PATCH] Incremental sort (was: PoC: Partial sort)	James Coleman	16:21
Re: [HACKERS] Block level parallel vacuum	Sergei Kornilov	16:44
Re: [PATCH] Incremental sort (was: PoC: Partial sort)	Tomas Vondra	16:59
Re: [Proposal] Table-level Transparent Data Encryption (TDE) and Key Management Service (KMS)	Tomas Vondra	17:30
Re: block-level incremental backup	vignesh C	17:52
Re: [RFC] Removing "magic" oids	Noah Misch	18:21
Re: Index Skip Scan	Dmitry Dolgov	18:30
Re: SQL/JSON path issues/questions	Alexander Korotkov	18:48
Re: [Proposal] Table-level Transparent Data Encryption (TDE) and Key Management Service (KMS)	Sehrope Sarkuni	19:39
Re: SQL/JSON path issues/questions	Steven Pousty	19:43
Re: [RFC] Removing "magic" oids	Andres Freund	19:56
Re: [RFC] Removing "magic" oids	Noah Misch	19:58
Re: thoughts on "prevent wraparound" vacuum	Andres Freund	20:02
Re: [RFC] Removing "magic" oids	Andres Freund	20:03
Re: benchmarking Flex practices	Tom Lane	20:14
Re: Support for jsonpath .datetime() method 📎	Alexander Korotkov	22:42
Re: [PATCH v2] Introduce spgist quadtree @<(point,circle) operator	Alexander Korotkov	23:07
Re: [PATCH] Incremental sort (was: PoC: Partial sort)	James Coleman	23:37

July 21, 2019

Thread	Author	Time
Re: Catching missing Datum conversions	Corey Huinker	01:10
Re: contrib make check-world fail if data have been modified and there's vpath	Tom Lane	01:15
Fix typos and inconsistencies for HEAD (take 7) 📎	Alexander Lakhin	05:28
Re: Performance issue in foreign-key-aware join estimation	David Rowley	05:43
Re: thoughts on "prevent wraparound" vacuum	Michail Nikolaev	05:46
Re: Speed up transaction completion faster after many relations are accessed in a transaction 📎	David Rowley	09:37
Re: [PATCH] Incremental sort (was: PoC: Partial sort)	Tomas Vondra	11:34
Re: Performance issue in foreign-key-aware join estimation	Andreas Seltenreich	12:44
Re: Psql patch to show access methods info	Alexander Korotkov	12:54
Re: Compile from source using latest Microsoft Windows SDK	Andrew Dunstan	13:25
Re: POC: converting Lists into arrays 📎	David Rowley	13:32
Re: Compiler warnings with MinGW	Michael Paquier	13:47
Re: Performance issue in foreign-key-aware join estimation	David Rowley	13:50
Re: POC: converting Lists into arrays	Tom Lane	14:45
Re: Fix typos and inconsistencies for HEAD (take 7)	Tom Lane	16:34
Re: Bad canonicalization for dateranges with 'infinity' bounds	Stephen Frost	18:25
Re: POC: converting Lists into arrays 📎	Tom Lane	20:01
Re: The flinfo->fn_extra question, from me this time.	Chapman Flack	20:44
Re: The flinfo->fn_extra question, from me this time.	Tom Lane	21:54
Re: Performance issue in foreign-key-aware join estimation	David Rowley	22:35
Re: new function for tsquery creartion	Where is Where	23:28

July 22, 2019

Thread	Author	Time
RE: Speed up transaction completion faster after many relations are accessed in a transaction	Tsunakawa, Takayuki	00:47
Re: Fix typos and inconsistencies for HEAD (take 7)	Michael Paquier	01:05
Re: POC: converting Lists into arrays	David Rowley	01:15
Re: Speed up transaction completion faster after many relations are accessed in a transaction	David Rowley	01:21
Re: pg_receivewal documentation	Michael Paquier	01:48
RE: Speed up transaction completion faster after many relations are accessed in a transaction	Tsunakawa, Takayuki	02:21
[Patch] PQconnectPoll() is blocked if target_session_attrs is read-write 📎	Matsumura, Ryo	02:28
Re: Speed up transaction completion faster after many relations are accessed in a transaction	David Rowley	02:29
Re: Psql patch to show access methods info	Alvaro Herrera	03:29
Re: Add parallelism and glibc dependent only options to reindexdb	Michael Paquier	04:11
Re: Fix typos and inconsistencies for HEAD (take 7)	Tom Lane	04:14
Re: Fix typos and inconsistencies for HEAD (take 7)	Alexander Lakhin	04:31
RE: Speed up transaction completion faster after many relations are accessed in a transaction	Tsunakawa, Takayuki	04:34
Re: POC: converting Lists into arrays	Tom Lane	04:37
Re: POC: converting Lists into arrays	David Rowley	04:46
Re: Speed up transaction completion faster after many relations are accessed in a transaction	David Rowley	04:50
Re: POC: converting Lists into arrays	Tom Lane	04:54
Re: Fix typos and inconsistencies for HEAD (take 7)	Alexander Lakhin	05:00
Re: Index Skip Scan	David Rowley	05:44
Re: progress report for ANALYZE 📎	Tatsuro Yamada	06:02
Re: Tid scan improvements	David Rowley	07:24
Re: [PATCH] minor bugfix for pg_basebackup (9.6 ~ )	Michael Paquier	07:36
Re: Tid scan improvements	Edmund Horner	07:44
Re: Compile from source using latest Microsoft Windows SDK	Peifeng Qiu	08:01
Re: Compile from source using latest Microsoft Windows SDK	Michael Paquier	08:23
Re: Memory Accounting	Heikki Linnakangas	08:30
Re: progress report for ANALYZE	Kyotaro Horiguchi	08:30
Re: POC: converting Lists into arrays	David Rowley	08:34
Re: pg_upgrade version checking questions	Peter Eisentraut	08:46
Re: POC: Cleaning up orphaned files using undo logs	Amit Kapila	08:51
Re: [Patch] PQconnectPoll() is blocked if target_session_attrs is read-write	Kyotaro Horiguchi	10:08
Re: Identity columns should own only one sequence	Peter Eisentraut	10:17
Re: POC: Cleaning up orphaned files using undo logs	Dilip Kumar	10:21
Re: Speed up transaction completion faster after many relations are accessed in a transaction	David Rowley	11:14
Re: should there be a hard-limit on the number of transactions pending undo?	Thomas Munro	11:14
Re: Commitfest 2019-07, the first of five* for PostgreSQL 13	Thomas Munro	11:32
Re: psql - add SHOW_ALL_RESULTS option	Peter Eisentraut	11:35
RE: extension patch of CREATE OR REPLACE TRIGGER 📎	[email protected]	11:45
Re: make libpq documentation navigable between functions 📎	Peter Eisentraut	12:10
Re: Cleaning up and speeding up string functions	David Rowley	12:16
Re: Add parallelism and glibc dependent only options to reindexdb 📎	Julien Rouhaud	12:40
Re: Psql patch to show access methods info	Alexander Korotkov	12:58
Re: GiST VACUUM 📎	Heikki Linnakangas	13:09
Re: initdb recommendations	Peter Eisentraut	13:21
Re: Cleaning up and speeding up string functions	Dagfinn Ilmari Mannsåker	13:32
Re: psql - add SHOW_ALL_RESULTS option	Fabien COELHO	13:33
Re: initdb recommendations	Tom Lane	14:11
Re: POC: converting Lists into arrays	Tom Lane	14:50
Re: POC: Cleaning up orphaned files using undo logs	Amit Khandekar	15:08
Re: Add parallelism and glibc dependent only options to reindexdb	Alvaro Herrera	15:11
Re: POC: Cleaning up orphaned files using undo logs	Amit Khandekar	15:13
Re: Add parallelism and glibc dependent only options to reindexdb 📎	Alvaro Herrera	15:18
Re: Add parallelism and glibc dependent only options to reindexdb	Julien Rouhaud	15:23
Re: Add parallelism and glibc dependent only options to reindexdb	Alvaro Herrera	15:33
Re: Cleaning up and speeding up string functions 📎	Dagfinn Ilmari Mannsåker	15:37
Re: Cleaning up and speeding up string functions	Alvaro Herrera	15:41
Re: Add parallelism and glibc dependent only options to reindexdb	Tom Lane	15:57
Re: Cleaning up and speeding up string functions	Dagfinn Ilmari Mannsåker	16:00
Re: Speed up transaction completion faster after many relations are accessed in a transaction	Andres Freund	16:07
Re: POC: Cleaning up orphaned files using undo logs	Andres Freund	16:08
Re: Memory Accounting	Tomas Vondra	16:16
Re: initdb recommendations	Tom Lane	16:25
Re: Memory Accounting	Jeff Davis	16:33
Re: initdb recommendations	Tom Lane	16:39
Re: [PATCH] minor bugfix for pg_basebackup (9.6 ~ )	Alvaro Herrera	16:58
Re: initdb recommendations	Andrew Dunstan	17:02
Re: Add parallelism and glibc dependent only options to reindexdb	Alvaro Herrera	17:05
Re: Index Skip Scan	Jesper Pedersen	17:10
Re: pg_receivewal documentation 📎	Jesper Pedersen	17:25
Re: POC: converting Lists into arrays	Alvaro Herrera	17:29
Re: Psql patch to show access methods info	Andres Freund	17:37
Re: initdb recommendations	Andres Freund	17:40
Re: POC: converting Lists into arrays	Tom Lane	17:46
Re: using explicit_bzero	Peter Eisentraut	18:11
Re: using explicit_bzero	Peter Eisentraut	18:17
Re: errbacktrace 📎	Peter Eisentraut	18:19
Re: using explicit_bzero	Tom Lane	18:35
Re: Add CREATE DATABASE LOCALE option 📎	Peter Eisentraut	18:36
Re: Broken defenses against dropping a partitioning column	Tom Lane	19:02
Re: initdb recommendations	Tom Lane	19:15
Re: initdb recommendations	Andrew Dunstan	19:16
Re: initdb recommendations	Andrew Dunstan	19:20
Re: Broken defenses against dropping a partitioning column	Alvaro Herrera	19:34
Re: errbacktrace	Alvaro Herrera	19:37
Re: errbacktrace	Tom Lane	20:05
Re: errbacktrace	Tom Lane	20:10
Re: Psql patch to show access methods info 📎	Nikita Glukhov	20:23
Re: Broken defenses against dropping a partitioning column	Manuel Rigger	20:53
Re: make libpq documentation navigable between functions 📎	Fabien COELHO	20:56
Re: Broken defenses against dropping a partitioning column	Tom Lane	21:17
Re: initdb recommendations	Tom Lane	22:08
Re: Add CREATE DATABASE LOCALE option	Fabien COELHO	22:18
Re: getting ERROR "relation 16401 has no triggers" with partition foreign key alter 📎	Alvaro Herrera	22:18
Re: initdb recommendations	Jonathan S. Katz	22:48
Re: Psql patch to show access methods info	Alexander Korotkov	22:57
Re: errbacktrace	Thomas Munro	23:25

July 23, 2019

Thread	Author	Time
Re: pg_receivewal documentation	Michael Paquier	00:08
RE: [Patch] PQconnectPoll() is blocked if target_session_attrs is read-write 📎	Matsumura, Ryo	00:40
Re: Change ereport level for QueuePartitionConstraintValidation	David Rowley	02:22
Re: Psql patch to show access methods info	Andres Freund	02:40
Re: Psql patch to show access methods info	Andres Freund	02:41
Re: POC: Cleaning up orphaned files using undo logs	Amit Kapila	03:18
"Attachment not found" by CF-app	Kyotaro Horiguchi	03:26
Re: SegFault on 9.6.14	Thomas Munro	03:40
RE: Speed up transaction completion faster after many relations are accessed in a transaction	Tsunakawa, Takayuki	03:46
Re: Introduce timeout capability for ConditionVariableSleep	Thomas Munro	04:50
Re: progress report for ANALYZE 📎	Tatsuro Yamada	04:51
Re: Queries on QMF to POSTGRE	Oleksandr Shulgin	05:30
Re: Add parallelism and glibc dependent only options to reindexdb	Michael Paquier	05:32
Re: Queries on QMF to POSTGRE	Ron	05:42
Re: Speed up transaction completion faster after many relations are accessed in a transaction 📎	David Rowley	06:11
Re: initdb recommendations	Peter Eisentraut	06:12
Re: Race conditions with TAP test for syncrep	Noah Misch	06:45
Re: Possible race condition in pg_mkdir_p()? 📎	Ning Yu	06:54
query1 followed by query2 at maximum distance vs current fixed distance	Wh isere	06:55
Re: make \d pg_toast.foo show its indices ; and, \d toast show its main table ; and \d relkind=I show its partitions	Fabien COELHO	07:19
Re: Add parallelism and glibc dependent only options to reindexdb 📎	Michael Paquier	07:38
Re: pgbench - add pseudo-random permutation function 📎	Fabien COELHO	07:44
Re: Race conditions with TAP test for syncrep 📎	Michael Paquier	08:04
Re: [PATCH] minor bugfix for pg_basebackup (9.6 ~ )	Michael Paquier	08:10
Re: Berserk Autovacuum (let's save next Mandrill)	Masahiko Sawada	08:21
Re: Runtime pruning problem 📎	David Rowley	08:49
Re: Optimze usage of immutable functions as relation 📎	Anastasia Lubennikova	11:36
Re: [bug fix] Produce a crash dump before main() on Windows	Kyotaro Horiguchi	11:45
Re: SegFault on 9.6.14	Amit Kapila	11:58
[GSoC] Second period status report for the de-TOAST iterator	Binguo Bao	11:59
Re: pg_receivewal documentation 📎	Jesper Pedersen	12:00
Re: Add CREATE DATABASE LOCALE option	Peter Eisentraut	13:00
Re: Support for jsonpath .datetime() method	Peter Eisentraut	13:44
Re: SQL/JSON: JSON_TABLE 📎	Pavel Stehule	13:58
Re: POC: Cleaning up orphaned files using undo logs	Amit Khandekar	14:41
Re: [PATCH] Improve performance of NOTIFY over many databases (issue blocking on AccessExclusiveLock on object 0 of class 1262 of database 0)	Martijn van Oosterhout	14:46
Re: pg_upgrade version checking questions 📎	Daniel Gustafsson	15:30
Fetching timeline during recovery 📎	Jehan-Guillaume de Rorthais	16:05
Re: Speed up transaction completion faster after many relations are accessed in a transaction	Tom Lane	16:13
stress test for parallel workers	Justin Pryzby	16:27
Re: Change ereport level for QueuePartitionConstraintValidation	Alvaro Herrera	16:35
Re: [bug fix] Produce a crash dump before main() on Windows	Tom Lane	17:06
Re: [PATCH] Improve performance of NOTIFY over many databases (issue blocking on AccessExclusiveLock on object 0 of class 1262 of database 0)	Tom Lane	17:21
Re: stress test for parallel workers	Tom Lane	17:28
Re: [bug fix] Produce a crash dump before main() on Windows	Alvaro Herrera	17:31
Re: stress test for parallel workers	Justin Pryzby	17:42

Browse Archives

Prev | Next