pgsql-hackers since 2017-07-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

July 28, 2017

Thread Author Time
Re: Patch: Write Amplification Reduction Method (WARM) Peter Geoghegan 00:27
Notice message of ALTER SUBSCRIPTION ... RERESH PUBLICATIION 📎 Yugo Nagata 00:51
A suspicious code in pgoutput_startup(). 📎 Yugo Nagata 00:52
Re: LP_DEAD hinting and not holding on to a buffer pin on leaf page (Was: [WIP] Zipfian distribution in pgbench) Robert Haas 01:26
Re: LP_DEAD hinting and not holding on to a buffer pin on leaf page (Was: [WIP] Zipfian distribution in pgbench) Peter Geoghegan 02:05
Re: LP_DEAD hinting and not holding on to a buffer pin on leaf page (Was: [WIP] Zipfian distribution in pgbench) Peter Geoghegan 02:40
PL_stashcache, or, what's our minimum Perl version? Tom Lane 02:48
Re: Incorrect comment of XLByteToSeg() and XLByteToPrevSeg() Tatsuo Ishii 03:03
Re: On Complex Source Code Reading Strategy Craig Ringer 03:23
Re: PL_stashcache, or, what's our minimum Perl version? Tom Lane 03:58
Re: Refreshing subscription relation state inside a transaction block Masahiko Sawada 04:13
Re: Patch: Write Amplification Reduction Method (WARM) Pavan Deolasee 04:39
Re: segfault in HEAD when too many nested functions call Noah Misch 04:46
Re: segfault in HEAD when too many nested functions call Andres Freund 04:49
Re: GSoC 2017: weekly progress reports (week 8) 📎 Shubham Barai 04:58
Re: segfault in HEAD when too many nested functions call Noah Misch 05:04
Re: map_partition_varattnos() and whole-row vars Noah Misch 05:06
Re: segfault in HEAD when too many nested functions call Andres Freund 05:08
Re: Quorum commit for multiple synchronous replication. Noah Misch 05:24
Re: Transactions involving multiple postgres foreign servers Masahiko Sawada 05:28
Re: [bug fix] PG10: libpq doesn't connect to alternative hosts when some errors occur Noah Misch 05:30
Re: map_partition_varattnos() and whole-row vars 📎 Amit Langote 05:47
Re: Missing comment for max_logical_replication_workers in postgresql.conf.sample Tatsuo Ishii 06:15
Re: [patch] pg_dump/pg_restore zerror() and strerror() mishap 📎 Kunshchikov Vladimir 08:29
Re: asynchronous execution Kyotaro HORIGUCHI 08:31
Re: pl/perl extension fails on Windows 📎 Ashutosh Sharma 09:00
Re: BUG #14758: Segfault with logical replication on a function index 📎 Masahiko Sawada 10:07
Re: GSoC 2017: Foreign Key Arrays Erik Rijkers 11:19
Re: map_partition_varattnos() and whole-row vars Amit Khandekar 11:46
Re: [HACKERS] BUG #14759: insert into foreign data partitions fail Etsuro Fujita 11:55
Re: psql's \d and \dt are sending their complaints to different output files Daniel Gustafsson 12:10
Re: Update comments in nodeModifyTable.c Etsuro Fujita 12:12
Re: PL_stashcache, or, what's our minimum Perl version? Andrew Dunstan 12:22
Re: LP_DEAD hinting and not holding on to a buffer pin on leaf page (Was: [WIP] Zipfian distribution in pgbench) Amit Kapila 13:27
Re: Adding support for Default partition in partitioning Ashutosh Bapat 13:30
Re: pl/perl extension fails on Windows Tom Lane 13:52
Re: Transactions involving multiple postgres foreign servers Michael Paquier 14:14
Clarification in pg10's pgupgrade.html step 10 (upgrading standby servers) Andreas Joseph Krogh 14:35
Re: UPDATE of partition key Robert Haas 14:40
Re: Patch: Write Amplification Reduction Method (WARM) Robert Haas 14:46
Re: [bug fix] PG10: libpq doesn't connect to alternative hosts when some errors occur Robert Haas 14:56
Re: pl/perl extension fails on Windows 📎 Ashutosh Sharma 16:16
Re: tab complete for psql pset pager values Jeff Janes 16:22
Re: [patch] pg_dump/pg_restore zerror() and strerror() mishap Alvaro Herrera 16:25
Re: LP_DEAD hinting and not holding on to a buffer pin on leaf page (Was: [WIP] Zipfian distribution in pgbench) Peter Geoghegan 16:26
Re: segfault in HEAD when too many nested functions call Noah Misch 16:29
Re: pl/perl extension fails on Windows Tom Lane 16:35
Re: segfault in HEAD when too many nested functions call Andres Freund 16:56
Re: pl/perl extension fails on Windows Ashutosh Sharma 17:04
Red-Black tree traversal tests 📎 Victor Drobny 17:39
Re: UPDATE of partition key Amit Khandekar 17:45
Re: segfault in HEAD when too many nested functions call Tom Lane 17:47
Re: [patch] pg_dump/pg_restore zerror() and strerror() mishap 📎 Vladimir Kunschikov 18:11
Re: [patch] pg_dump/pg_restore zerror() and strerror() mishap Alvaro Herrera 18:19
Re: pl/perl extension fails on Windows Tom Lane 18:35
Re: [patch] pg_dump/pg_restore zerror() and strerror() mishap Vladimir Kunschikov 18:41
Re: segfault in HEAD when too many nested functions call Robert Haas 18:42
Re: [GSOC] Eliminate O(N^2) scaling from rw-conflict tracking in serializable transactions Robert Haas 18:46
Re: map_partition_varattnos() and whole-row vars Robert Haas 18:54
Re: PL_stashcache, or, what's our minimum Perl version? Andrew Dunstan 19:01
Re: GSoC 2017: Foreign Key Arrays Mark Rofail 19:02
Re: map_partition_varattnos() and whole-row vars Peter Geoghegan 19:08
Re: map_partition_varattnos() and whole-row vars Tom Lane 19:26
Re: BUG #14758: Segfault with logical replication on a function index Scott Milliken 19:35
Re: pl/perl extension fails on Windows Ashutosh Sharma 19:47
Re: map_partition_varattnos() and whole-row vars Robert Haas 20:15
Re: pl/perl extension fails on Windows Tom Lane 21:14
Re: pl/perl extension fails on Windows Tom Lane 21:15
Re: PL_stashcache, or, what's our minimum Perl version? Tom Lane 21:24
Re: Adding support for Default partition in partitioning Robert Haas 21:25
Re: psql's \d and \dt are sending their complaints to different output files Tom Lane 21:46
In-place index updates and HOT (Was: Patch: Write Amplification Reduction Method (WARM)) Peter Geoghegan 23:32

July 29, 2017

Thread Author Time
[PATCH] Vacuum: Update FSM more frequently 📎 Claudio Freire 00:42
Re: AlterUserStmt anmd RoleSpec rules in grammar.y Robert Haas 00:56
Re: In-place index updates and HOT (Was: Patch: Write Amplification Reduction Method (WARM)) Claudio Freire 01:08
Memory leak fan yang 09:50
Re: Memory leak Tom Lane 14:06
Re: Memory leak Fan Yang 16:34
Re: segfault in HEAD when too many nested functions call 📎 Tom Lane 18:20
Re: segfault in HEAD when too many nested functions call Andres Freund 18:28
Re: Causal reads take II Dmitry Dolgov 19:07
Re: GSoC 2017: Foreign Key Arrays 📎 Mark Rofail 19:26
Re: segfault in HEAD when too many nested functions call 📎 Tom Lane 20:14
Re: GSoC 2017: Foreign Key Arrays Mark Rofail 21:14
Re: In-place index updates and HOT (Was: Patch: Write Amplification Reduction Method (WARM)) Peter Geoghegan 23:33
Re: GSoC 2017: Foreign Key Arrays Alvaro Herrera 23:59

July 30, 2017

Thread Author Time
Re: Adding support for Default partition in partitioning Jeevan Ladhe 02:37
Re: PL_stashcache, or, what's our minimum Perl version? Tom Lane 05:21
Re: GSoC 2017: Foreign Key Arrays Tom Lane 05:26
Re: Page Scan Mode in Hash Index 📎 Ashutosh Sharma 08:37
Re: PL_stashcache, or, what's our minimum Perl version? Tels 08:48
Re: PL_stashcache, or, what's our minimum Perl version? Noah Misch 15:48
Re: PL_stashcache, or, what's our minimum Perl version? Tom Lane 16:05
Re: PL_stashcache, or, what's our minimum Perl version? Tom Lane 16:22
Re: PL_stashcache, or, what's our minimum Perl version? Noah Misch 16:30
Re: PL_stashcache, or, what's our minimum Perl version? Tom Lane 16:50
Re: [GSOC] Eliminate O(N^2) scaling from rw-conflict tracking in serializable transactions Mengxing Liu 16:53
[GSOC][weekly report 8] Eliminate O(N^2) scaling from rw-conflict tracking in serializable transactions 📎 Mengxing Liu 16:54
Re: PL_stashcache, or, what's our minimum Perl version? Tels 17:45
PostgreSQL not setting OpenSSL session id context? Shay Rojansky 18:03
Re: PostgreSQL not setting OpenSSL session id context? Tom Lane 19:17
Re: PostgreSQL not setting OpenSSL session id context? Tom Lane 19:59
Re: PL_stashcache, or, what's our minimum Perl version? Tom Lane 20:35
Re: pl/perl extension fails on Windows Christoph Berg 21:14
Re: pl/perl extension fails on Windows Tom Lane 21:30
Re: PostgreSQL not setting OpenSSL session id context? Shay Rojansky 22:15
Re: PostgreSQL not setting OpenSSL session id context? 📎 Shay Rojansky 23:24
Re: segfault in HEAD when too many nested functions call Andres Freund 23:47

July 31, 2017

Thread Author Time
Re: segfault in HEAD when too many nested functions call Julien Rouhaud 00:09
Re: BUG #14758: Segfault with logical replication on a function index Masahiko Sawada 00:40
Re: Refreshing subscription relation state inside a transaction block Masahiko Sawada 00:42
Re: [HACKERS] BUG #14759: insert into foreign data partitions fail 📎 Amit Langote 00:58
10 beta docs: different replication solutions 📎 Steve Singer 01:34
Re: Missing comment for max_logical_replication_workers in postgresql.conf.sample Tatsuo Ishii 02:32
Re: Partition-wise join for join between (declaratively) partitioned tables Robert Haas 03:02
Re: pl/perl extension fails on Windows Ashutosh Sharma 03:48
Re: On Complex Source Code Reading Strategy Zeray Kalayu 05:03
Re: Adding support for Default partition in partitioning Ashutosh Bapat 05:49
Re: Causal reads take II 📎 Thomas Munro 05:49
Persistent wait event sets and socket changes Craig Ringer 06:08
Re: pl/perl extension fails on Windows Ashutosh Sharma 06:11
Re: Adding support for Default partition in partitioning Ashutosh Bapat 06:22
Re: pl/perl extension fails on Windows 📎 Christoph Berg 08:40
Re: [PATCH v3] pg_progress() SQL function to monitor progression of long running SQL queries/utilities Remi Colinet 09:09
Re: [PATCH v3] pg_progress() SQL function to monitor progression of long running SQL queries/utilities Remi Colinet 09:20
Re: asynchronous execution Kyotaro HORIGUCHI 09:42
Re: map_partition_varattnos() and whole-row vars 📎 Amit Langote 09:56
Re: [PATCH v3] pg_progress() SQL function to monitor progression of long running SQL queries/utilities Pavel Stehule 10:10
Re: PostgreSQL - Weak DH group 📎 Heikki Linnakangas 11:27
Minor comment update in partition.c 📎 Beena Emerson 11:53
Re: PostgreSQL not setting OpenSSL session id context? Heikki Linnakangas 11:54
Re: Partition-wise join for join between (declaratively) partitioned tables Ashutosh Bapat 11:59
Re: Default Partition for Range 📎 Beena Emerson 12:28
Re: [PROPOSAL] Temporal query processing with range types 📎 Peter Moser 12:53
Re: 10 beta docs: different replication solutions Merlin Moncure 13:00
Re: Partition-wise join for join between (declaratively) partitioned tables 📎 Ashutosh Bapat 13:07
Re: pl/perl extension fails on Windows Tom Lane 13:39
Re: GSoC 2017: Foreign Key Arrays Alvaro Herrera 15:18
Re: Persistent wait event sets and socket changes Andres Freund 15:41
Lazy hash table for XidInMVCCSnapshot (helps Zipfian a bit) 📎 Sokolov Yura 15:56
Re: Update comments in nodeModifyTable.c Robert Haas 16:03
[GOSC' 17][Performance report] Eliminate O(N^2) scaling from rw-conflict tracking in serializable transactions 📎 Mengxing Liu 16:11
Re: Clarification in pg10's pgupgrade.html step 10 (upgrading standby servers) Robert Haas 16:13
Crash report for some ICU-52 (debian8) COLLATE and work_mem values Daniel Verite 16:21
Re: Transactions involving multiple postgres foreign servers Robert Haas 16:40
Re: pl/perl extension fails on Windows Christoph Berg 16:45
pgsql: Record full paths of programs sought by "configure". Tom Lane 17:02
Re: Transactions involving multiple postgres foreign servers Robert Haas 17:03
Re: Increase Vacuum ring buffer. Sokolov Yura 17:11
Re: GSoC 2017: Foreign Key Arrays Mark Rofail 17:20
Re: Transactions involving multiple postgres foreign servers Alvaro Herrera 17:27
Re: LP_DEAD hinting and not holding on to a buffer pin on leaf page (Was: [WIP] Zipfian distribution in pgbench) Robert Haas 17:28
Re: Crash report for some ICU-52 (debian8) COLLATE and work_mem values Peter Geoghegan 17:37
Re: PL_stashcache, or, what's our minimum Perl version? Tom Lane 17:53
Re: LP_DEAD hinting and not holding on to a buffer pin on leaf page (Was: [WIP] Zipfian distribution in pgbench) Peter Geoghegan 17:54
Re: Transactions involving multiple postgres foreign servers Robert Haas 18:43
Re: PL_stashcache, or, what's our minimum Perl version? Peter Eisentraut 18:49
Re: LP_DEAD hinting and not holding on to a buffer pin on leaf page (Was: [WIP] Zipfian distribution in pgbench) Robert Haas 18:51
Re: PL_stashcache, or, what's our minimum Perl version? Tom Lane 18:55
Re: pg_stop_backup(wait_for_archive := true) on standby server Robert Haas 19:10
Re: pg_stop_backup(wait_for_archive := true) on standby server Stephen Frost 19:13
Re: PL_stashcache, or, what's our minimum Perl version? Peter Eisentraut 19:17
Re: PL_stashcache, or, what's our minimum Perl version? Peter Eisentraut 19:37
Re: PL_stashcache, or, what's our minimum Perl version? Tom Lane 19:38
Re: PostgreSQL - Weak DH group Heikki Linnakangas 19:48
[PATCH] Pattern based listeners for asynchronous messaging (LISTEN/NOTIFY) 📎 Markus Sintonen 20:13
Re: PL_stashcache, or, what's our minimum Perl version? Peter Eisentraut 20:22
Re: [PATCH] Pattern based listeners for asynchronous messaging (LISTEN/NOTIFY) Peter Eisentraut 20:30
Inconsistencies in from_char_parse_int_len() Douglas Doole 20:39
Re: PG 10 release notes Thomas Munro 20:53
Re: PL_stashcache, or, what's our minimum Perl version? Tom Lane 20:54
Re: Inconsistencies in from_char_parse_int_len() Tom Lane 20:57
Re: POC: Sharing record typmods between backends Andres Freund 21:08
Re: Another comment typo in execMain.c Peter Eisentraut 21:09
Re: Fix a typo in pg_upgrade/info.c Peter Eisentraut 21:23
Re: A bug in mapping attributes in ATExecAttachPartition() Robert Haas 21:26
Re: PostgreSQL not setting OpenSSL session id context? Tom Lane 21:26
Re: building libpq.a static library Peter Eisentraut 21:27
Re: Parallel Hash take II Andres Freund 21:28
Re: building libpq.a static library Tom Lane 21:36
Re: BUG #14759: insert into foreign data partitions fail David G. Johnston 21:41
Re: LP_DEAD hinting and not holding on to a buffer pin on leaf page (Was: [WIP] Zipfian distribution in pgbench) Peter Geoghegan 22:13
Re: pg_dump does not handle indirectly-granted permissions properly 📎 Stephen Frost 22:26
Re: PL_stashcache, or, what's our minimum Perl version? Tom Lane 22:54
Re: Incorrect comment of XLByteToSeg() and XLByteToPrevSeg() Tatsuo Ishii 23:11
Re: [PATCH] Pattern based listeners for asynchronous messaging (LISTEN/NOTIFY) Chapman Flack 23:13
Re: PostgreSQL 10 (latest beta) and older ICU Peter Eisentraut 23:42
Re: Parallel Hash take II Thomas Munro 23:55

Aug. 1, 2017

Thread Author Time
Re: 10 beta docs: different replication solutions 📎 Steve Singer 00:09
Re: PL_stashcache, or, what's our minimum Perl version? 📎 Tom Lane 00:17
Re: Fix a typo in pg_upgrade/info.c Masahiko Sawada 00:22
Re: BUG #14759: insert into foreign data partitions fail 📎 Amit Langote 00:42
Re: AlterUserStmt anmd RoleSpec rules in grammar.y 📎 Peter Eisentraut 00:42
Re: PL_stashcache, or, what's our minimum Perl version? Peter Eisentraut 00:54
Re: BUG #14759: insert into foreign data partitions fail David G. Johnston 01:10
Re: Parallel Hash take II Andres Freund 01:11
Re: BUG #14758: Segfault with logical replication on a function index Andres Freund 01:14
Re: BUG #14759: insert into foreign data partitions fail 📎 Amit Langote 01:18
Re: Constraint exclusion for partitioned tables Robert Haas 01:47
Re: Partitioning vs ON CONFLICT Robert Haas 01:52

Browse Archives

Prev | Next