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

Feb. 7, 2020

Thread	Author	Time
typedef SegmentNumber 📎	Thomas Munro	00:00
Re: typedef SegmentNumber	Thomas Munro	00:01
Re: Improve errors when setting incorrect bounds for SSL protocols 📎	Michael Paquier	00:33
Re: Getting rid of some more lseek() calls	Andres Freund	00:37
Re: table partitioning and access privileges 📎	Amit Langote	01:39
Re: pgsql: Prevent running pg_basebackup as root	Michael Paquier	01:55
Re: pgsql: Prevent running pg_basebackup as root	Andres Freund	02:07
Re: Prevent pg_basebackup running as root	Andres Freund	02:08
Re: [HACKERS] [WIP] Effective storage of duplicates in B-tree index. 📎	Peter Geoghegan	02:18
Re: Internal key management system	Masahiko Sawada	02:18
Re: pgsql: Prevent running pg_basebackup as root	Ian Barwick	02:23
Re: Internal key management system	Andres Freund	02:36
Re: typos in comments and user docs	Amit Kapila	03:03
Re: typos in comments and user docs	Justin Pryzby	03:11
[PATCH] Support built control file in PGXS VPATH builds 📎	Craig Ringer	03:14
Re: Tid scan increments value of pg_stat_all_tables.seq_scan. (but not seq_tup_read) 📎	Kasahara Tatsuhito	03:27
Re: Expose lock group leader pid in pg_stat_activity	Michael Paquier	03:47
Re: SyncRepGetSyncStandbysPriority() vs. SIGHUP 📎	Kyotaro Horiguchi	03:52
Re: typos in comments and user docs	Amit Kapila	03:56
Re: typos in comments and user docs 📎	Justin Pryzby	04:17
Re: Tid scan increments value of pg_stat_all_tables.seq_scan. (but not seq_tup_read)	Kyotaro Horiguchi	04:26
Re: Tid scan increments value of pg_stat_all_tables.seq_scan. (but not seq_tup_read) 📎	Kasahara Tatsuhito	06:07
Re: WIP: expression evaluation improvements	Andres Freund	06:28
Re: WIP: expression evaluation improvements	Andres Freund	06:35
Re: Adding a test for speculative insert abort case	Andres Freund	07:02
Re: In PG12, query with float calculations is slower than PG11	keisuke kuroda	07:42
Re: In PG12, query with float calculations is slower than PG11	Andres Freund	07:53
Re: Tid scan increments value of pg_stat_all_tables.seq_scan. (but not seq_tup_read)	Fujii Masao	08:01
Re: In PG12, query with float calculations is slower than PG11	Amit Langote	08:17
Re: setLastTid() and currtid()	Fujii Masao	08:24
Re: Tid scan increments value of pg_stat_all_tables.seq_scan. (but not seq_tup_read) 📎	Kasahara Tatsuhito	08:28
Re: Tid scan increments value of pg_stat_all_tables.seq_scan. (but not seq_tup_read)	Kyotaro Horiguchi	08:34
Re: ALTER tbl rewrite loses CLUSTER ON index	Amit Langote	08:42
Re: Assumptions about the number of parallel workers	Antonin Houska	08:44
Re: In PG12, query with float calculations is slower than PG11	Amit Langote	08:54
Re: [HACKERS] WIP: Aggregation push-down	Antonin Houska	09:05
Fix comment for max_cached_tuplebufs definition 📎	Kuntal Ghosh	09:19
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view? 📎	Julien Rouhaud	10:12
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions	Dilip Kumar	10:48
Re: ERROR: subtransaction logged without previous top-level txn record	Amit Kapila	10:59
Re: typedef SegmentNumber	Julien Rouhaud	11:40
Re: Internal key management system	Masahiko Sawada	11:44
Re: logical decoding : exceeded maxAllocatedDescs for .spill files 📎	Kuntal Ghosh	12:01
Re: [HACKERS] advanced partition matching algorithm for partition-wise join	Etsuro Fujita	12:53
Re: [HACKERS] advanced partition matching algorithm for partition-wise join	Etsuro Fujita	12:57
Re: Tid scan increments value of pg_stat_all_tables.seq_scan. (but not seq_tup_read)	Fujii Masao	13:09
control max length of parameter values logged 📎	Alexey Bashtanov	13:56
Re: Is custom MemoryContext prohibited?	Robert Haas	14:17
Re: Tid scan increments value of pg_stat_all_tables.seq_scan. (but not seq_tup_read)	Kasahara Tatsuhito	14:25
Re: In PG12, query with float calculations is slower than PG11	Emre Hasegeli	14:30
Re: Is custom MemoryContext prohibited?	Robert Haas	14:31
Re: ALTER tbl rewrite loses CLUSTER ON index (consider moving indisclustered to pg_class) 📎	Justin Pryzby	14:39
Re: In PG12, query with float calculations is slower than PG11 📎	Emre Hasegeli	14:42
Re: [Proposal] Global temporary tables	Robert Haas	15:15
Re: Assumptions about the number of parallel workers	Robert Haas	15:18
Re: improve transparency of bitmap-only heap scans 📎	Alexey Bashtanov	15:22
Re: [PATCH] Erase the distinctClause if the result is unique by definition	Ashutosh Bapat	15:54
Does recovery write to backup_label ?	Chapman Flack	16:08
Re: proposal: schema variables 📎	Pavel Stehule	16:09
Re: Index Skip Scan 📎	Dmitry Dolgov	16:25
Re: [HACKERS] emergency outage requiring database restart	Merlin Moncure	16:44
Re: [Proposal] Global temporary tables	Konstantin Knizhnik	17:28
allow frontend use of the backend's core hashing functions 📎	Robert Haas	17:30
Re: Global temporary tables 📎	Konstantin Knizhnik	17:31
Re: [Proposal] Global temporary tables	Robert Haas	17:31
Re: Portal->commandTag as an enum 📎	Mark Dilger	17:36
Re: In PG12, query with float calculations is slower than PG11 📎	Tels	17:55
Re: In PG12, query with float calculations is slower than PG11	Andres Freund	18:13
Re: Internal key management system	Andres Freund	18:24
Re: Assumptions about the number of parallel workers	Andres Freund	18:28
Re: logical decoding : exceeded maxAllocatedDescs for .spill files	Andres Freund	18:33
Re: [Proposal] Global temporary tables	Pavel Stehule	18:37
Re: logical decoding : exceeded maxAllocatedDescs for .spill files	Andres Freund	18:40
Re: [HACKERS] Moving relation extension locks out of heavyweight lock manager	Mahendra Singh Thalor	18:57
Re: logical decoding : exceeded maxAllocatedDescs for .spill files	Tomas Vondra	19:02
Re: pgsql: Prevent running pg_basebackup as root	Stephen Frost	19:22
Re: logical decoding : exceeded maxAllocatedDescs for .spill files 📎	Andres Freund	19:34
Re: logical decoding : exceeded maxAllocatedDescs for .spill files	Andres Freund	19:47
Re: Does recovery write to backup_label ?	Andres Freund	19:55
pg_basebackup and snapshots	Stephen Frost	19:56
Re: Does recovery write to backup_label ?	Chapman Flack	20:05
Re: pg_basebackup and snapshots	Andres Freund	20:21
Re: Reducing WaitEventSet syscall churn 📎	Thomas Munro	21:00
Re: pg_basebackup and snapshots	Stephen Frost	21:13
Re: Reducing WaitEventSet syscall churn	Thomas Munro	21:15
Re: improve transparency of bitmap-only heap scans	Tomas Vondra	21:35
Draft release notes are up for review	Tom Lane	21:56
Re: Draft release notes are up for review	Daniel Gustafsson	22:13
Re: Dumping/restoring fails on inherited generated column	Tom Lane	22:16
Re: Draft release notes are up for review	Tom Lane	22:18

Feb. 8, 2020

Thread	Author	Time
Re: Adding a test for speculative insert abort case 📎	Andres Freund	00:40
Re: error context for vacuum to include block number 📎	Justin Pryzby	01:01
Re: Marking some contrib modules as trusted extensions 📎	Tom Lane	01:40
Re: Implementing Incremental View Maintenance	nuko yokohama	02:15
Postgres 32 bits client compilation fail. Win32 bits client is supported?	Ranier Vilela	02:34
Re: Does recovery write to backup_label ?	Fujii Masao	03:06
POC: rational number type (fractions) 📎	Joe Nelson	04:25
Re: Internal key management system	Masahiko Sawada	05:48
Re: [PATCH] Erase the distinctClause if the result is unique by definition 📎	Andy Fan	07:22
Re: POC: rational number type (fractions)	legrand legrand	09:54
Re: Index Skip Scan	Tomas Vondra	13:11
Re: Marking some contrib modules as trusted extensions	Stephen Frost	13:54
Re: Index Skip Scan	Tomas Vondra	14:22
Re: Index Skip Scan	Tomas Vondra	14:56
ALTER TABLE rewrite to use clustered order 📎	Justin Pryzby	15:04
Re: Internal key management system	Tomas Vondra	15:08
Re: Internal key management system	Tomas Vondra	15:16
Re: Index Skip Scan	Dmitry Dolgov	15:24
Re: Internal key management system	Andres Freund	15:47
Re: Internal key management system	Tomas Vondra	16:53
Re: ALTER TABLE rewrite to use clustered order	Tom Lane	16:57
Re: Index Skip Scan	Tomas Vondra	16:59
Re: Internal key management system	Tom Lane	17:07
Re: Marking some contrib modules as trusted extensions	Tom Lane	17:34
Re: Index Skip Scan	James Coleman	18:31

Feb. 9, 2020

Thread	Author	Time
Re: Internal key management system	Masahiko Sawada	01:11
Re: Building infrastructure for B-Tree deduplication that recognizes when opclass equality is also equivalence	Peter Geoghegan	02:50
Re: logical decoding : exceeded maxAllocatedDescs for .spill files	Amit Kapila	03:48
Re: ERROR: subtransaction logged without previous top-level txn record	Amit Kapila	07:27
Re: Postgres 32 bits client compilation fail. Win32 bits client is supported?	Amit Kapila	07:35
Re: [Proposal] Global temporary tables	Konstantin Knizhnik	12:05
Re: [Proposal] Global temporary tables	Pavel Stehule	12:53
Re: ERROR: subtransaction logged without previous top-level txn record 📎	Arseny Sher	16:07
logical copy_replication_slot issues	Arseny Sher	16:28
Just for fun: Postgres 20?	Jose Luis Tallon	18:28
Re: Just for fun: Postgres 20?	Vik Fearing	18:54
Re: Just for fun: Postgres 20?	Tom Lane	19:25
Re: improve transparency of bitmap-only heap scans	Alexey Bashtanov	22:59
Re: Add %x to PROMPT1 and PROMPT2	Vik Fearing	23:16
RE: Just for fun: Postgres 20?	[email protected]	23:44

Feb. 10, 2020

Thread	Author	Time
Re: MSVC installs too much stuff?	Andrew Dunstan	00:18
RE: Internal key management system	[email protected]	00:23
Re: Invisible PROMPT2	Thomas Munro	00:30
Re: Add %x to PROMPT1 and PROMPT2	Michael Paquier	00:45
Re: WIP: expression evaluation improvements	Soumyadeep Chakraborty	01:28
Re: WIP: expression evaluation improvements	Soumyadeep Chakraborty	01:29
Re: Implementing Incremental View Maintenance	Yugo NAGATA	01:37
Re: Identifying user-created objects 📎	Masahiko Sawada	03:24
subplan resets wrong hashtable	Justin Pryzby	03:25
Re: Implementing Incremental View Maintenance	nuko yokohama	03:34
Re: Parallel grouping sets	Pengzhou Tang	03:37
Re: Identifying user-created objects	Amit Langote	03:54
Re: Postgres 32 bits client compilation fail. Win32 bits client is supported?	Craig Ringer	03:55
Re: subplan resets wrong hashtable	Andres Freund	04:01
Re: subplan resets wrong hashtable	Justin Pryzby	04:05
Re: Identifying user-created objects	Masahiko Sawada	04:06
Re: typos in comments and user docs	Amit Kapila	04:06
Re: Identifying user-created objects	Amit Langote	04:16
Re: subplan resets wrong hashtable	Justin Pryzby	04:53
Re: Is custom MemoryContext prohibited?	Craig Ringer	04:53
Re: Does recovery write to backup_label ?	David Steele	04:53
Re: Implementing Incremental View Maintenance 📎	Yugo NAGATA	04:58
Re: logical copy_replication_slot issues 📎	Masahiko Sawada	05:01
Re: Identifying user-created objects	Michael Paquier	05:09
Re: In PG12, query with float calculations is slower than PG11	Amit Langote	05:10
Re: Identifying user-created objects	Masahiko Sawada	05:22
Re: logical decoding : exceeded maxAllocatedDescs for .spill files 📎	Kuntal Ghosh	05:30
Re: Identifying user-created objects	Amit Langote	05:32
Re: Internal key management system 📎	Masahiko Sawada	06:15
Re: Postgres 32 bits client compilation fail. Win32 bits client is supported?	Michael Paquier	06:38
RE: Complete data erasure	[email protected]	06:57
Re: WAL usage calculation patch	Craig Ringer	07:20
Re: In PG12, query with float calculations is slower than PG11	Amit Langote	07:33
pg_basebackup -F plain -R overwrites postgresql.auto.conf 📎	Fujii Masao	07:58
Print physical file path when checksum check fails 📎	Hubert Zhang	08:04
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions	Amit Kapila	08:22
Re: pg_basebackup -F plain -R overwrites postgresql.auto.conf	Sergei Kornilov	08:23
Re: pg_basebackup -F plain -R overwrites postgresql.auto.conf	Fujii Masao	08:41
RE: Delaying/avoiding BTreeTupleGetNAtts() call within _bt_compare()	Floris Van Nee	09:05
RE: [PoC] Non-volatile WAL buffer 📎	Takashi Menjo	09:29
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions	Dilip Kumar	09:39
[PATCH] Comments related to "Take fewer snapshots" and "Revert patch for taking fewer snapshots" 📎	Michail Nikolaev	09:42
Re: ERROR: subtransaction logged without previous top-level txn record	Amit Kapila	11:03
Re: Just for fun: Postgres 20?	Wolfgang Wilhelm	11:16
Re: [HACKERS] advanced partition matching algorithm for partition-wise join 📎	Etsuro Fujita	11:46
Re: Postgres 32 bits client compilation fail. Win32 bits client is supported?	Ranier Vilela	12:13
Re: pg_basebackup -F plain -R overwrites postgresql.auto.conf	Magnus Hagander	12:35
Re: ERROR: subtransaction logged without previous top-level txn record 📎	Arseny Sher	13:04
Re: Is custom MemoryContext prohibited?	Kohei KaiGai	13:18
Re: Is custom MemoryContext prohibited?	Craig Ringer	13:47
Re: WIP/PoC for parallel backup	Jeevan Chalke	13:48
Re: Postgres 32 bits client compilation fail. Win32 bits client is supported?	Craig Ringer	13:53
Re: logical copy_replication_slot issues	Arseny Sher	14:01
Is it memory leak or not?	Dmitry Igrishin	14:33
Re: pg_basebackup -F plain -R overwrites postgresql.auto.conf	Alvaro Herrera	15:28
Re: pg_basebackup -F plain -R overwrites postgresql.auto.conf	Alvaro Herrera	15:28
Re: pgsql: walreceiver uses a temporary replication slot by default	Peter Eisentraut	15:37
Re: pgsql: walreceiver uses a temporary replication slot by default	Peter Eisentraut	15:46
Re: Is it memory leak or not?	Tom Lane	15:59
Re: Is it memory leak or not?	Dmitry Igrishin	16:18
Re: [PATCH] Erase the distinctClause if the result is unique by definition	Ashutosh Bapat	16:22
2020-02-13 Press Release Draft 📎	Jonathan S. Katz	16:46
Re: Global temporary tables 📎	Konstantin Knizhnik	16:48
Re: 2020-02-13 Press Release Draft	Erik Rijkers	16:55
Re: [HACKERS] Moving relation extension locks out of heavyweight lock manager	Mahendra Singh Thalor	16:58
Re: 2020-02-13 Press Release Draft	Sehrope Sarkuni	17:03
Re: 2020-02-13 Press Release Draft	Jonathan S. Katz	17:07
Re: 2020-02-13 Press Release Draft	Jonathan S. Katz	17:07
Re: Yet another vectorized engine	Konstantin Knizhnik	17:20
Re: 2020-02-13 Press Release Draft	Alvaro Herrera	17:23

Browse Archives

Prev | Next