pgsql-hackers - August 2019

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

Aug. 1, 2019

Thread	Author	Time
RE: Multivariate MCV list vs. statistics target	Jamison, Kirk	00:15
Re: POC: converting Lists into arrays	Tom Lane	00:16
Re: POC: converting Lists into arrays	Tom Lane	00:25
Re: concerns around pg_lsn	Michael Paquier	00:46
Re: POC: converting Lists into arrays	Andres Freund	01:15
Re: Possible race condition in pg_mkdir_p()?	Ning Yu	01:15
Re: partition routing layering in nodeModifyTable.c	Amit Langote	01:32
Re: [PATCH] minor bugfix for pg_basebackup (9.6 ~ )	Ian Barwick	02:37
Re: concerns around pg_lsn	Craig Ringer	02:45
Re: Global temporary tables	Craig Ringer	03:10
Refactoring code stripping trailing \n and \r from strings 📎	Michael Paquier	03:18
Re: Commitfest 2019-07, the first of five* for PostgreSQL 13	Thomas Munro	04:10
More refactoring for BuildIndexInfo 📎	Michael Paquier	04:13
Re: refactoring - share str2*int64 functions	Michael Paquier	04:20
Re: Commitfest 2019-07, the first of five* for PostgreSQL 13	Robert Eckhardt	04:30
Re: Multivariate MCV list vs. statistics target	Thomas Munro	05:25
Re: Tid scan improvements	Edmund Horner	05:33
Re: Rearranging ALTER TABLE to avoid multi-operations bugs	Thomas Munro	05:44
Re: concerns around pg_lsn	Jeevan Ladhe	05:44
Re: Tid scan improvements	Thomas Munro	05:46
Re: Tid scan improvements	Edmund Horner	05:50
Re: Tid scan improvements	Thomas Munro	05:56
Re: concerns around pg_lsn	Jeevan Ladhe	05:59
Re: Remove HeapTuple and Buffer dependency for predicate locking functions	Kuntal Ghosh	06:01
Re: concerns around pg_lsn	Michael Paquier	06:01
Re: How to retain lesser paths at add_path()?	Kohei KaiGai	06:11
Re: complier warnings from ecpg tests	Michael Paquier	06:14
Re: Add client connection check during the execution of the query	Thomas Munro	06:23
Re: Allow an alias to be attached directly to a JOIN ... USING	Thomas Munro	06:33
Re: Avoid full GIN index scan when possible	Thomas Munro	06:42
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view?	Julien Rouhaud	06:45
Re: Contribution to Perldoc for TestLib module in Postgres	Thomas Munro	06:49
Re: SimpleLruTruncate() mutual exclusion 📎	Noah Misch	06:51
Re: pgbench - implement strict TPC-B benchmark	Fabien COELHO	06:52
Re: pgbench - implement strict TPC-B benchmark	Fabien COELHO	06:57
Re: refactoring - share str2*int64 functions	Fabien COELHO	07:00
Re: dropdb --force	Thomas Munro	07:02
Re: concerns around pg_lsn 📎	Jeevan Ladhe	07:09
Re: Commitfest 2019-07, the first of five* for PostgreSQL 13	Pavlo Golub	07:12
Re: How to retain lesser paths at add_path()?	Richard Guo	07:19
Partial join 📎	Arne Roland	08:07
Re: using explicit_bzero	Thomas Munro	08:08
Re: unlogged sequences	Thomas Munro	08:13
Re: Global temporary tables 📎	Konstantin Knizhnik	08:13
Re: concerns around pg_lsn	Michael Paquier	08:21
Re: Proposal to suppress errors thrown by to_reg*()	Thomas Munro	08:21
Re: refactoring - share str2*int64 functions	Michael Paquier	08:23
Re: Use relative rpath if possible	Thomas Munro	08:28
Re: Multivariate MCV list vs. statistics target	Kyotaro Horiguchi	08:29
Re: range_agg	Thomas Munro	08:34
Re: concerns around pg_lsn	Jeevan Ladhe	08:40
Re: Proposal to suppress errors thrown by to_reg*()	Takuma Hoshiai	08:42
Re: progress report for ANALYZE	Thomas Munro	08:44
Re: benchmarking Flex practices 📎	John Naylor	08:50
Re: pg_upgrade version checking questions	Thomas Munro	08:52
Re: Proposal to suppress errors thrown by to_reg*()	Thomas Munro	08:54
Re: proposal: type info support functions for functions that use "any" type	Thomas Munro	09:01
Re: allow online change primary_conninfo	Thomas Munro	09:06
Re: UCT (Re: pgsql: Update time zone data files to tzdata release 2019a.)	Shay Rojansky	09:09
Re: concerns around pg_lsn	Michael Paquier	09:12
Re: improve PQexec documentation	Thomas Munro	09:12
Re: allow online change primary_conninfo	Michael Paquier	09:13
Re: How to retain lesser paths at add_path()?	Kohei KaiGai	09:28
Store FullTransactionId in TwoPhaseFileHeader/GlobalTransactionData 📎	vignesh C	09:32
Re: refactoring - share str2*int64 functions	Fabien COELHO	09:34
Re: partition routing layering in nodeModifyTable.c 📎	Etsuro Fujita	09:38
Re: [PATCH] get rid of StdRdOptions, use individual binary reloptions representation for each relation kind instead	Thomas Munro	09:39
Re: idea: log_statement_sample_rate - bottom limit for sampling	Adrien Nayrat	09:47
Re: extension patch of CREATE OR REPLACE TRIGGER	Thomas Munro	09:49
Re: Proposal for Signal Detection Refactoring	Thomas Munro	09:53
Re: Global shared meta cache	Konstantin Knizhnik	10:00
Re: \describe*	Thomas Munro	10:03
Re: idea: log_statement_sample_rate - bottom limit for sampling	Tomas Vondra	10:04
Re: allow online change primary_conninfo	Sergei Kornilov	10:09
Re: Avoid full GIN index scan when possible 📎	Julien Rouhaud	10:13
Re: SQL:2011 PERIODS vs Postgres Ranges?	Thomas Munro	10:22
Re: How to retain lesser paths at add_path()?	Tomas Vondra	10:24
Re: Support for jsonpath .datetime() method	Thomas Munro	10:30
Re: Multivariate MCV list vs. statistics target	Tomas Vondra	10:30
Re: [HACKERS] advanced partition matching algorithm for partition-wise join	Etsuro Fujita	10:36
Re: Avoid full GIN index scan when possible	Julien Rouhaud	10:37
Re: Referential Integrity Checks with Statement-level Triggers	Thomas Munro	10:49
Re: [PATCH] Improve performance of NOTIFY over many databases (issue blocking on AccessExclusiveLock on object 0 of class 1262 of database 0)	Thomas Munro	10:53
Re: pg_waldump and PREPARE	Thomas Munro	11:05
Re: Ltree syntax improvement	Thomas Munro	11:11
Re: Partial join	Richard Guo	11:14
Re: block-level incremental backup 📎	Jeevan Chalke	11:36
Re: Partial join	Arne Roland	11:46
Re: refactoring - share str2*int64 functions	Michael Paquier	11:47
Re: Patch to document base64 encoding	Thomas Munro	11:47
Re: pg_waldump and PREPARE	Michael Paquier	11:51
Re: pg_waldump and PREPARE	Julien Rouhaud	11:57
Re: pg_waldump and PREPARE	Thomas Munro	11:57
Re: How to install login_hook in Postgres 10.5	legrand legrand	12:01
Re: Store FullTransactionId in TwoPhaseFileHeader/GlobalTransactionData	Thomas Munro	12:05
Re: How to retain lesser paths at add_path()?	Kohei KaiGai	12:14
Fix typos 📎	Sehrope Sarkuni	12:24
Re: FETCH FIRST clause PERCENT option 📎	Surafel Temesgen	12:54
Re: pgbench - implement strict TPC-B benchmark	Robert Haas	13:25
Re: Store FullTransactionId in TwoPhaseFileHeader/GlobalTransactionData	vignesh C	13:38
BUG #15938: Corrupted WAL segment after crash recovery	PG Bug reporting form	13:52
Re: UCT (Re: pgsql: Update time zone data files to tzdata release 2019a.)	Tom Lane	14:08
Re: Partial join	Tom Lane	14:14
Re: Avoid full GIN index scan when possible	Tom Lane	14:37
Re: Multivariate MCV list vs. statistics target	Dean Rasheed	14:42
Re: refactoring - share str2*int64 functions	Fabien COELHO	14:48
Re: Avoid full GIN index scan when possible	Julien Rouhaud	15:19
Re: Patch for SortSupport implementation on inet/cdir	Brandur Leach	15:34
Re: tableam vs. TOAST 📎	Robert Haas	16:23
Re: Partial join	Arne Roland	16:29
Re: UCT (Re: pgsql: Update time zone data files to tzdata release 2019a.)	Shay Rojansky	16:33
Re: Patch for SortSupport implementation on inet/cdir	Peter Geoghegan	16:41
Re: [Patch] pg_rewind: options to use restore_command from recovery.conf or command line 📎	Alexey Kondratov	16:53
Re: [HACKERS] Cached plans and statement generalization 📎	Konstantin Knizhnik	16:56
Re: using explicit_bzero	Andres Freund	17:06
Re: UCT (Re: pgsql: Update time zone data files to tzdata release 2019a.)	Andres Freund	17:19
Re: progress report for ANALYZE	Robert Haas	17:48
Re: pgbench - implement strict TPC-B benchmark	Andres Freund	17:50
Re: tableam vs. TOAST	Andres Freund	17:53
Re: Optimze usage of immutable functions as relation 📎	Anastasia Lubennikova	17:54
Re: tableam vs. TOAST	Robert Haas	17:55
Re: UCT (Re: pgsql: Update time zone data files to tzdata release 2019a.)	Tom Lane	17:59
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view?	Robert Haas	18:20
Re: UCT (Re: pgsql: Update time zone data files to tzdata release 2019a.)	Andres Freund	18:25
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view?	Andres Freund	18:36
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view?	Andres Freund	18:36
Re: [HACKERS] CLUSTER command progress monitor	Alvaro Herrera	18:43
Re: Batch insert in CTAS/MatView code	Heikki Linnakangas	18:54
Re: \describe*	Corey Huinker	18:57
Re: Avoid full GIN index scan when possible 📎	Tom Lane	18:59
Re: UCT (Re: pgsql: Update time zone data files to tzdata release 2019a.)	Tom Lane	19:13
Re: Avoid full GIN index scan when possible	Alexander Korotkov	19:15
Re: Avoid full GIN index scan when possible	Tom Lane	19:28
Re: Referential Integrity Checks with Statement-level Triggers	Corey Huinker	19:28
The unused_oids script should have a reminder to use the 8000-8999 OID range	Peter Geoghegan	20:36
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view?	Julien Rouhaud	20:42
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view?	Julien Rouhaud	20:49
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view?	Andres Freund	20:51
Re: The unused_oids script should have a reminder to use the 8000-8999 OID range	Julien Rouhaud	20:57
Re: Tid scan improvements	David Rowley	21:04
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view?	Andres Freund	21:05
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view?	Julien Rouhaud	21:08
Re: Speed up transaction completion faster after many relations are accessed in a transaction	Thomas Munro	22:15
Re: standby recovery fails (tablespace related) (tentative patch and discussion)	Thomas Munro	22:37
Re: [PATCH] kNN for btree	Thomas Munro	22:39
Re: Ought to use heap_multi_insert() for pg_attribute/depend insertions?	Thomas Munro	22:41
Re: Optimze usage of immutable functions as relation	Tom Lane	22:57
Re: NOT IN subquery optimization	Thomas Munro	22:57
Re: Data-only pg_rewind, take 2	Thomas Munro	23:07
Re: [PATCH] src/test/modules/dummy_index -- way to test reloptions from inside of access method	Thomas Munro	23:12
Re: [HACKERS] WAL logging problem in 9.4.3?	Thomas Munro	23:35
Re: benchmarking Flex practices	Thomas Munro	23:51
Re: Removing unneeded self joins	Thomas Munro	23:54

Aug. 2, 2019

Thread	Author	Time
Re: Commitfest 2019-07, the first of five* for PostgreSQL 13	Thomas Munro	00:18
Re: complier warnings from ecpg tests	Michael Paquier	00:55
Re: Commitfest 2019-07, the first of five* for PostgreSQL 13	Michael Paquier	01:03
Re: Fix typos	Michael Paquier	01:06
Re: Problem with default partition pruning	Amit Langote	01:30
Re: The unused_oids script should have a reminder to use the 8000-8999 OID range	Peter Geoghegan	01:59
Re: Commitfest 2019-07, the first of five* for PostgreSQL 13	Tom Lane	02:13
Re: Fix typos	Tom Lane	02:18
Re: The unused_oids script should have a reminder to use the 8000-8999 OID range	Tom Lane	02:21
Re: Fix typos	Alvaro Herrera	03:01
PostgreSQL 12 Beta 3 Release: 2019-08-08	Michael Paquier	04:03
Re: How to install login_hook in Postgres 10.5	Michael Paquier	04:07
Re: Fix typos	Michael Paquier	04:11
Re: The unused_oids script should have a reminder to use the 8000-8999 OID range	Michael Paquier	04:20
Re: Commitfest 2019-07, the first of five* for PostgreSQL 13	Amit Langote	04:55
Re: Replication & recovery_min_apply_delay	Michael Paquier	05:44
Re: Commitfest 2019-07, the first of five* for PostgreSQL 13	Julien Rouhaud	05:54
Re: [HACKERS] WAL logging problem in 9.4.3?	Kyotaro Horiguchi	06:32
Re: pgbench - implement strict TPC-B benchmark	Fabien COELHO	06:38
Re: WIP: Data at rest encryption	Shawn Wang	06:40
Re: Memory-Bounded Hash Aggregation	Adam Lee	06:44
Proposal: Clean up RangeTblEntry nodes after query preparation	Daniel Migowski	07:01
Re: Hash join explain is broken	Andres Freund	07:05
Re: [proposal] de-TOAST'ing using a iterator	John Naylor	07:12
Re: complier warnings from ecpg tests	Sergei Kornilov	07:33
Re: idea: log_statement_sample_rate - bottom limit for sampling	Adrien Nayrat	07:53
Re: [HACKERS] Cached plans and statement generalization	Daniel Migowski	08:25
Re: pgbench - implement strict TPC-B benchmark	Fabien COELHO	08:34
Re: The unused_oids script should have a reminder to use the 8000-8999 OID range 📎	Julien Rouhaud	08:42
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view?	Julien Rouhaud	08:54
Re: [HACKERS] Cached plans and statement generalization	Konstantin Knizhnik	08:57
Re: [HACKERS] Cached plans and statement generalization	Daniel Migowski	09:01
A couple of random BF failures in kerberosCheck	Thomas Munro	09:32
Re: Partial join	Richard Guo	09:33
Re: Partial join	Richard Guo	10:00
Re: Store FullTransactionId in TwoPhaseFileHeader/GlobalTransactionData 📎	Thomas Munro	10:36
Re: Fix typos 📎	Sehrope Sarkuni	10:37
Re: Should we add xid_current() or a int8->xid cast?	Thomas Munro	10:42
Re: Fix typos	Sehrope Sarkuni	10:45
Re: Built-in connection pooler 📎	Konstantin Knizhnik	11:05
Re: Store FullTransactionId in TwoPhaseFileHeader/GlobalTransactionData	Robert Haas	12:06
Re: Commitfest 2019-07, the first of five* for PostgreSQL 13 📎	Fabien COELHO	12:11
Re: Index Skip Scan	Dmitry Dolgov	12:14
Recent failures in IsolationCheck deadlock-hard	Thomas Munro	12:25
Re: block-level incremental backup	vignesh C	13:12
Re: pglz performance	Konstantin Knizhnik	13:45
Re: Recent failures in IsolationCheck deadlock-hard	Tom Lane	14:11

Browse Archives

Prev | Next