pgsql-hackers since 2020-05-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

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31

May 20, 2020

Thread Author Time
Re: BUG #16147: postgresql 12.1 (from homebrew) - pg_restore -h localhost --jobs=2 crashes David Gilman 00:52
Re: pg_stat_wal_receiver and flushedUpto/writtenUpto Fujii Masao 01:19
Parallel Seq Scan vs kernel read ahead 📎 Thomas Munro 01:53
Re: Parallel Seq Scan vs kernel read ahead Amit Kapila 02:23
Re: Problem with pg_atomic_compare_exchange_u64 at 32-bit platformwd Noah Misch 03:05
Re: Parallel Seq Scan vs kernel read ahead Thomas Munro 03:08
Re: Warn when parallel restoring a custom dump without data offsets Justin Pryzby 03:26
Re: Trouble with hashagg spill I/O pattern and costing 📎 Jeff Davis 04:15
Re: Is it useful to record whether plans are generic or custom? Kyotaro Horiguchi 04:32
Re: MultiXact\SLRU buffers configuration Kyotaro Horiguchi 04:54
Re: Problem with pg_atomic_compare_exchange_u64 at 32-bit platformwd Andres Freund 05:10
Re: SyncRepLock acquired exclusively in default configuration Michael Paquier 05:38
Re: explicit_bzero for sslpassword Michael Paquier 05:56
Re: Expand the use of check_canonical_path() for more GUCs 📎 Michael Paquier 07:03
Re: Expand the use of check_canonical_path() for more GUCs Michael Paquier 07:13
Re: Problem with pg_atomic_compare_exchange_u64 at 32-bit platforms Konstantin Knizhnik 07:23
Re: Problem with pg_atomic_compare_exchange_u64 at 32-bit platforms Konstantin Knizhnik 07:32
Re: Problem with pg_atomic_compare_exchange_u64 at 32-bit platforms Noah Misch 07:36
Re: Problem with pg_atomic_compare_exchange_u64 at 32-bit platforms 📎 Konstantin Knizhnik 07:59
Re: Expand the use of check_canonical_path() for more GUCs Peter Eisentraut 08:05
Extensions not dumped when --schema is used Guillaume Lelarge 08:06
Re: explicit_bzero for sslpassword Peter Eisentraut 08:06
Re: [bug] Table not have typarray when created by single user mode shawn wang 08:15
Re: Extensions not dumped when --schema is used Laurenz Albe 08:45
Re: Extensions not dumped when --schema is used Daniel Gustafsson 09:26
Re: Extensions not dumped when --schema is used Guillaume Lelarge 09:38
pgindent vs dtrace on macos 📎 Peter Eisentraut 09:52
Re: Extensions not dumped when --schema is used Daniel Gustafsson 09:55
Re: pgindent vs dtrace on macos Daniel Gustafsson 10:01
Change JOIN tutorial to focus more on explicit joins PG Doc comments form 10:07
Re: Optimizer docs typos 📎 Etsuro Fujita 10:17
Re: Parallel Seq Scan vs kernel read ahead Ranier Vilela 11:02
Re: Add A Glossary Jürgen Purtz 11:17
Re: Add A Glossary Laurenz Albe 11:38
Hybrid Hash/Nested Loop joins and caching results from subplans 📎 David Rowley 11:44
SEARCH and CYCLE clauses 📎 Peter Eisentraut 11:46
Re: Subplan result caching David Rowley 11:47
Re: Warn when parallel restoring a custom dump without data offsets David Gilman 12:55
Re: Is it useful to record whether plans are generic or custom? Atsushi Torikoshi 12:56
Re: Hybrid Hash/Nested Loop joins and caching results from subplans Simon Riggs 12:56
Re: SEARCH and CYCLE clauses Vik Fearing 13:04
Re: pgindent vs dtrace on macos Tom Lane 13:56
Fwd: [PATCH] fix GIN index search sometimes losing results Pavel Borisov 14:04
Re: Extensions not dumped when --schema is used Tom Lane 14:39
Re: Warn when parallel restoring a custom dump without data offsets Tom Lane 14:48
Re: factorial function/phase out postfix operators? Robert Haas 16:32
Re: Two fsync related performance issues? Robert Haas 17:51
Re: Extension ownership and misuse of SET ROLE/SET SESSION AUTHORIZATION Robert Haas 17:54
Re: Adding missing object access hook invocations Robert Haas 17:57
Re: factorial function/phase out postfix operators? Tom Lane 18:24
Re: SEARCH and CYCLE clauses Vik Fearing 19:28
Re: factorial function/phase out postfix operators? Mark Dilger 20:18
Re: factorial function/phase out postfix operators? Tom Lane 20:29
Operator class parameters and sgml docs Peter Geoghegan 21:36
Re: Parallel Seq Scan vs kernel read ahead Thomas Munro 21:48
Re: factorial function/phase out postfix operators? Alvaro Herrera 21:54
Re: Change JOIN tutorial to focus more on explicit joins Thomas Munro 21:56
Re: PostgreSQL 13 Beta 1 Release Announcement Draft 📎 Jonathan S. Katz 22:11
Re: factorial function/phase out postfix operators? Tom Lane 22:21
Re: PostgreSQL 13 Beta 1 Release Announcement Draft Justin Pryzby 22:42
Re: PostgreSQL 13 Beta 1 Release Announcement Draft Jonathan S. Katz 22:44
Re: Parallel Seq Scan vs kernel read ahead Ranier Vilela 23:14
Re: Parallel Seq Scan vs kernel read ahead Thomas Munro 23:47
Re: Parallel Seq Scan vs kernel read ahead Ranier Vilela 23:50

May 21, 2020

Thread Author Time
Re: Parallel Seq Scan vs kernel read ahead Thomas Munro 00:02
Re: Trouble with hashagg spill I/O pattern and costing Tomas Vondra 00:12
Re: Operator class parameters and sgml docs Alexander Korotkov 00:17
Re: Adding missing object access hook invocations Michael Paquier 00:32
Re: Expand the use of check_canonical_path() for more GUCs Kyotaro Horiguchi 01:11
Re: Parallel Seq Scan vs kernel read ahead Ranier Vilela 01:37
Re: Subplan result caching Andy Fan 01:40
Re: Optimizer docs typos Kyotaro Horiguchi 02:25
Re: Parallel Seq Scan vs kernel read ahead Thomas Munro 02:31
Re: Warn when parallel restoring a custom dump without data offsets 📎 David Gilman 03:05
Re: Is it useful to record whether plans are generic or custom? Fujii Masao 03:18
Re: PostgreSQL 13 Beta 1 Release Announcement Draft John Naylor 04:12
Behaviour of failed Primary Santhosh Kumar 05:03
Re: Parallel Seq Scan vs kernel read ahead David Rowley 05:06
Re: WIP/PoC for parallel backup Ahsan Hadi 05:17
Re: WIP/PoC for parallel backup 📎 Rushabh Lathia 06:06
Schedule of commit fests for PG14 Michael Paquier 06:35
Re: Optimizer docs typos Etsuro Fujita 06:36
[Proposal] Page Compression for OLTP chenhj 06:36
Re: Schedule of commit fests for PG14 Julien Rouhaud 06:44
Re: Planning counters in pg_stat_statements (using pgss_store) Julien Rouhaud 06:49
Re: WIP/PoC for parallel backup Amit Kapila 06:53
speed up unicode normalization quick check 📎 John Naylor 07:12
Re: Planning counters in pg_stat_statements (using pgss_store) Michael Paquier 07:17
Re: [bug] Table not have typarray when created by single user mode 📎 wenjing zeng 07:28
Re: explicit_bzero for sslpassword Michael Paquier 07:29
Re: Planning counters in pg_stat_statements (using pgss_store) Julien Rouhaud 07:49
Re: [Proposal] Page Compression for OLTP Fabien COELHO 08:04
Re: Is it useful to record whether plans are generic or custom? 📎 Kyotaro Horiguchi 08:10
Re: [bug] Table not have typarray when created by single user mode Shawn Wang 08:10
Re: Is it useful to record whether plans are generic or custom? 📎 Tatsuro Yamada 08:43
Re: some grammar refactoring Rushabh Lathia 08:49
Re: pg13: xlogreader API adjust Kyotaro Horiguchi 08:50
Re: proposal: schema variables Pavel Stehule 10:10
Re: proposal: schema variables Amit Kapila 11:34
Re: [bug] Table not have typarray when created by single user mode Amit Kapila 11:37
Re: PostgreSQL 13 Beta 1 Release Announcement Draft Jonathan S. Katz 11:44
Re: proposal: schema variables 📎 Pavel Stehule 12:49
Re: factorial function/phase out postfix operators? Robert Haas 13:36
Re: Trouble with hashagg spill I/O pattern and costing Tomas Vondra 13:41
Re: WIP/PoC for parallel backup Robert Haas 13:41
Re: Schedule of commit fests for PG14 Tom Lane 14:02
Re: Schedule of commit fests for PG14 David Steele 14:13
Re: PostgreSQL 13 Beta 1 Release Announcement Draft Pantelis Theodosiou 14:20
Re: [PATCH] fix GIN index search sometimes losing results Pavel Borisov 14:25
Re: Trouble with hashagg spill I/O pattern and costing 📎 Tomas Vondra 14:30
Re: Behaviour of failed Primary Amit Kapila 14:30
Re: Trouble with hashagg spill I/O pattern and costing Tomas Vondra 14:45
Re: PostgreSQL 13 Beta 1 Release Announcement Draft Pantelis Theodosiou 14:50
Re: Trouble with hashagg spill I/O pattern and costing Robert Haas 17:05
Re: pg_bsd_indent and -Wimplicit-fallthrough Piotr Stefaniak 17:39
Re: POC: rational number type (fractions) Robert Haas 17:40
Re: Trouble with hashagg spill I/O pattern and costing Jeff Davis 18:19
Re: Trouble with hashagg spill I/O pattern and costing Tomas Vondra 18:34
Re: Trouble with hashagg spill I/O pattern and costing Tomas Vondra 18:54
Re: Trouble with hashagg spill I/O pattern and costing Jeff Davis 19:04
Re: Trouble with hashagg spill I/O pattern and costing Tomas Vondra 19:13
Re: Trouble with hashagg spill I/O pattern and costing Tomas Vondra 19:17
Re: Trouble with hashagg spill I/O pattern and costing Jeff Davis 19:40
Re: [PATCH] Keeps tracking the uniqueness with UniqueKey Dmitry Dolgov 19:51
Re: [PATCH] Keeps tracking the uniqueness with UniqueKey David Rowley 20:40
Re: [PATCH] Keeps tracking the uniqueness with UniqueKey David Rowley 20:51
Re: Trouble with hashagg spill I/O pattern and costing Tomas Vondra 21:02
Re: Trouble with hashagg spill I/O pattern and costing 📎 Jeff Davis 21:16
Re: pgindent && weirdness Piotr Stefaniak 21:33
Re: Trouble with hashagg spill I/O pattern and costing Tomas Vondra 21:41
Re: Parallel Seq Scan vs kernel read ahead David Rowley 21:59
Re: Parallel Seq Scan vs kernel read ahead Thomas Munro 22:27
Re: pgindent && weirdness Tom Lane 22:40
Re: [PATCH] Keeps tracking the uniqueness with UniqueKey Andy Fan 23:39
Re: [PATCH] Keeps tracking the uniqueness with UniqueKey Andy Fan 23:41
Re: [PATCH] Keeps tracking the uniqueness with UniqueKey Andy Fan 23:49
Re: Hybrid Hash/Nested Loop joins and caching results from subplans David Rowley 23:53

May 22, 2020

Thread Author Time
Re: [Proposal] Page Compression for OLTP chenhj 00:07
Re: Hybrid Hash/Nested Loop joins and caching results from subplans Andy Fan 00:11
Re: Parallel Seq Scan vs kernel read ahead Soumyadeep Chakraborty 01:14
Re: Parallel Seq Scan vs kernel read ahead Thomas Munro 02:26
More tests with USING INDEX replident and dropped indexes 📎 Michael Paquier 03:50
Re: race condition when writing pg_control 📎 Thomas Munro 04:51
Re: POC: rational number type (fractions) Noah Misch 05:53
Re: Planning counters in pg_stat_statements (using pgss_store) Andy Fan 06:02
Re: WIP/PoC for parallel backup 📎 Suraj Kharage 06:03
Re: Planning counters in pg_stat_statements (using pgss_store) Andy Fan 06:10
Re: [Proposal] Page Compression for OLTP chenhj 06:15
Re: Problem with pg_atomic_compare_exchange_u64 at 32-bit platforms Noah Misch 06:24
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions Amit Kapila 06:24
Re: Optimizer docs typos Etsuro Fujita 06:53
About reducing EXISTS sublink Richard Guo 08:26
Re: Optimizer docs typos Richard Guo 08:29
Re: some grammar refactoring Peter Eisentraut 08:48
Re: SEARCH and CYCLE clauses Peter Eisentraut 09:24
Re: pgindent vs dtrace on macos Peter Eisentraut 09:29
Re: SEARCH and CYCLE clauses Pavel Stehule 09:33
Re: SEARCH and CYCLE clauses Vik Fearing 10:40
Re: Failed rpm package signature checks with reposync mkruk 10:46
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions Amit Kapila 11:16
Getting ERROR with FOR UPDATE/SHARE for partitioned table. Rajkumar Raghuwanshi 11:30
Re: Getting ERROR with FOR UPDATE/SHARE for partitioned table. amul sul 12:08
Re: SEARCH and CYCLE clauses Peter Eisentraut 12:32
snowball release Peter Eisentraut 12:40
password_encryption default Peter Eisentraut 12:45
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions 📎 Dilip Kumar 12:51
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions Dilip Kumar 12:51
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions Dilip Kumar 12:52
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions Dilip Kumar 12:52
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions Dilip Kumar 12:52
Re: Planning counters in pg_stat_statements (using pgss_store) Fujii Masao 13:51
Re: snowball release Tom Lane 14:11
Re: password_encryption default Tom Lane 14:13
Re: password_encryption default Magnus Hagander 14:31
Re: Add explanations which are influenced by track_io_timing Fujii Masao 14:37
Re: password_encryption default Stephen Frost 14:46
Re: password_encryption default Tom Lane 14:59
Re: About reducing EXISTS sublink David G. Johnston 14:59
Re: password_encryption default Stephen Frost 15:14
Re: password_encryption default Tom Lane 15:34
Re: password_encryption default Stephen Frost 15:44
Re: password_encryption default Tom Lane 15:50
Re: password_encryption default Stephen Frost 15:54
Re: race condition when writing pg_control Fujii Masao 16:00
Re: pg_bsd_indent and -Wimplicit-fallthrough Julien Rouhaud 16:43
Re: Planning counters in pg_stat_statements (using pgss_store) Julien Rouhaud 16:48
Re: some grammar refactoring Mark Dilger 16:53
Re: Policy on cross-posting to multiple lists Stephen Frost 17:48
Re: Policy on cross-posting to multiple lists Julien Rouhaud 17:54
Re: Parallel Seq Scan vs kernel read ahead Robert Haas 18:30
Re: Parallel Seq Scan vs kernel read ahead Robert Haas 18:31
Re: Policy on cross-posting to multiple lists Tom Lane 19:04
Re: password_encryption default Jonathan S. Katz 19:09
Re: Planning counters in pg_stat_statements (using pgss_store) legrand legrand 19:27
Re: password_encryption default Vik Fearing 20:12
Re: xid wraparound danger due to INDEX_CLEANUP false Peter Geoghegan 20:40
Re: password_encryption default Tom Lane 21:21
Re: password_encryption default Jonathan S. Katz 21:23
Re: segmentation fault using currtid and partitioned tables Alvaro Herrera 23:32

May 23, 2020

Thread Author Time
Re: xid wraparound danger due to INDEX_CLEANUP false Peter Geoghegan 00:25

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31