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

Oct. 24, 2017

Thread	Author	Time
Re: Proposal: Local indexes for partitioned table	Amit Langote	00:27
Re: [sqlsmith] Failed assertion in adjust_appendrel_attrs_mutator	Amit Langote	00:37
Re: BLK_DONE state in XLogReadBufferForRedoExtended	Amit Kapila	03:49
Remove secondary checkpoint 📎	Simon Riggs	06:20
Re: [POC] hash partitioning 📎	amul sul	07:13
Re: WIP: long transactions on hot standby feedback replica / proof of concept 📎	Ivan Kartyshov	07:56
Re: Parallel Hash take II 📎	Thomas Munro	09:10
Re: SIGSEGV in BRIN autosummarize 📎	Alvaro Herrera	10:39
Current int & float overflow checking is slow.	Andres Freund	10:39
Transform for pl/perl 📎	anthony	11:01
Re: [POC] hash partitioning 📎	amul sul	11:21
Re: [POC] hash partitioning	Andres Freund	11:30
Re: [POC] hash partitioning	amul sul	11:35
Re: WIP: long transactions on hot standby feedback replica / proof of concept	Alexander Korotkov	12:23
Re: Current int & float overflow checking is slow.	Greg Stark	12:26
Re: Transform for pl/perl	Anthony Bykov	12:27
Re: Remove secondary checkpoint	Tom Lane	13:50
Help needed regarding DSA based in-memory index!	Gaddam Sai Ram	13:54
Re: Remove secondary checkpoint	Andres Freund	13:55
Re: Current int & float overflow checking is slow.	Tom Lane	14:09
CurTransactionContext freed before transaction COMMIT ???	Gaddam Sai Ram	14:12
Re: performance drop after upgrade (9.6 > 10)	johannes graën	14:15
Re: Current int & float overflow checking is slow.	Andres Freund	14:17
Re: CurTransactionContext freed before transaction COMMIT ???	Tom Lane	14:26
Re: Current int & float overflow checking is slow.	Tom Lane	14:36
Re: Remove secondary checkpoint	Simon Riggs	14:46
Re: CurTransactionContext freed before transaction COMMIT ???	Gaddam Sai Ram	14:55
Re: performance drop after upgrade (9.6 > 10)	Justin Pryzby	15:18
Re: performance drop after upgrade (9.6 > 10)	Johannes Graën	15:57
Re: performance drop after upgrade (9.6 > 10)	Alvaro Herrera	16:17
Deadlock in ALTER SUBSCRIPTION REFRESH PUBLICATION	Konstantin Knizhnik	17:13
unique index violation after pg_upgrade to PG10	Justin Pryzby	18:14
Re: Current int & float overflow checking is slow.	Robert Haas	18:27
Re: unique index violation after pg_upgrade to PG10	Kenneth Marshall	18:27
Re: unique index violation after pg_upgrade to PG10	Justin Pryzby	18:30
Re: unique index violation after pg_upgrade to PG10	Kenneth Marshall	18:48
Re: Current int & float overflow checking is slow.	Tom Lane	19:28
Re: unique index violation after pg_upgrade to PG10	Peter Geoghegan	19:31
Re: unique index violation after pg_upgrade to PG10	Justin Pryzby	20:11
Re: Domains and arrays and composites, oh my 📎	Tom Lane	20:19
Re: Transactions involving multiple postgres foreign servers 📎	Masahiko Sawada	21:45
Re: unique index violation after pg_upgrade to PG10	Peter Geoghegan	21:57
Re: pgsql: Fix traversal of half-frozen update chains	Peter Geoghegan	22:05
Re: Remove secondary checkpoint	Michael Paquier	22:17
Re: unique index violation after pg_upgrade to PG10	Justin Pryzby	22:27
Re: unique index violation after pg_upgrade to PG10	Justin Pryzby	22:28
Re: per-sesson errors after interrupting CLUSTER pg_attrdef	Michael Paquier	23:56

Oct. 25, 2017

Thread	Author	Time
Implementing pg_receivewal --no-sync 📎	Michael Paquier	00:37
Re: Remove secondary checkpoint	Tsunakawa, Takayuki	00:58
Re: Remove secondary checkpoint	Michael Paquier	01:33
Re: Remove secondary checkpoint	Tsunakawa, Takayuki	01:48
Re: Remove secondary checkpoint	Tsunakawa, Takayuki	02:24
Re: Remove secondary checkpoint	Michael Paquier	04:36
Re: unique index violation after pg_upgrade to PG10	Justin Pryzby	05:20
Re: Current int & float overflow checking is slow.	Robert Haas	05:33
Re: unique index violation after pg_upgrade to PG10	Peter Geoghegan	05:39
Re: Current int & float overflow checking is slow.	Andres Freund	05:53
Re: Parallel Hash take II 📎	Thomas Munro	06:03
Re: Implementing pg_receivewal --no-sync	Kuntal Ghosh	06:05
Re: Pluggable storage	Robert Haas	06:07
Re: UPDATE of partition key 📎	Amit Khandekar	06:10
Re: path toward faster partition pruning 📎	Amit Langote	06:47
Re: path toward faster partition pruning 📎	Amit Langote	07:37
Re: pgbench more operators & functions	Pavel Stehule	08:57
Re: path toward faster partition pruning	Beena Emerson	09:18
Re: pgbench - allow to store select results into variables	Pavel Stehule	09:55
Jsonb transform for pl/python 📎	Anthony Bykov	11:51
Re: Pluggable storage	Amit Kapila	11:59
pgsql: Process variadic arguments consistently in json functions	Andrew Dunstan	12:24
Re: CurTransactionContext freed before transaction COMMIT ???	Amit Kapila	13:12
Re: CurTransactionContext freed before transaction COMMIT ???	Gaddam Sai Ram	14:34
Re: BUG #14849: jsonb_build_object doesn't like VARIADIC calls very much	Michael Paquier	15:32
Re: CurTransactionContext freed before transaction COMMIT ???	Michael Paquier	15:41
WIP: BRIN multi-range indexes 📎	Tomas Vondra	16:22
Re: WIP: BRIN multi-range indexes 📎	Tomas Vondra	16:51
Timeline ID in backup_label file	Michael Paquier	18:50
Re: Implementing pg_receivewal --no-sync 📎	Michael Paquier	20:03
Removing [Merge]Append nodes which contain a single subpath	David Rowley	21:59

Oct. 26, 2017

Thread	Author	Time
Re: [BUGS] BUG #14849: jsonb_build_object doesn't like VARIADIC calls very much	Marko Tiikkaja	01:04
Re: Continuous integration on Windows?	Thomas Munro	01:44
Re: Timeline ID in backup_label file	Craig Ringer	02:10
Re: proposal: Support Unicode host variable in ECPG 📎	Jing Wang	03:29
Re: [COMMITTERS] pgsql: Process variadic arguments consistently in json functions	Michael Paquier	04:12
Re: path toward faster partition pruning	Beena Emerson	04:40
Re: More stats about skipped vacuums	Kyotaro HORIGUCHI	06:06
proposal: schema variables	Pavel Stehule	07:21
Re: Add support for tuple routing to foreign partitions 📎	Etsuro Fujita	07:40
Try to fix endless loop in ecpg with informix mode 📎	高增琦	08:03
Re: show "aggressive" or not in autovacuum logs 📎	Kyotaro HORIGUCHI	08:18
Re: [bug fix] ECPG: fails to recognize embedded parameters	Michael Meskes	08:44
Re: Re: Is anything preventing us from allowing write to foreign tables from standby?	Ashutosh Bapat	09:14
Subscriber resets additional columns to NULL on UPDATE 📎	Petr Jelinek	09:20
Re: [BUGS] Bug in Physical Replication Slots (at least 9.5)? 📎	Kyotaro HORIGUCHI	10:05
Re: Removing [Merge]Append nodes which contain a single subpath	Ashutosh Bapat	10:12
Index only scan for cube and seg 📎	Andrey Borodin	10:22
Re: Removing [Merge]Append nodes which contain a single subpath	Robert Haas	10:30
Re: Moving relation extension locks out of heavyweight lock manager 📎	Masahiko Sawada	10:36
Re: show "aggressive" or not in autovacuum logs	Robert Haas	10:42
Re: Removing [Merge]Append nodes which contain a single subpath	Antonin Houska	10:42
Re: Refactor handling of database attributes between pg_dump and pg_dumpall	Robert Haas	11:01
Re: How to determine that a TransactionId is really aborted?	Robert Haas	11:14
Re: Removing [Merge]Append nodes which contain a single subpath	David Rowley	11:17
Re: path toward faster partition pruning 📎	Amit Langote	11:17
Re: Parallel tuplesort (for parallel B-Tree index creation) 📎	Rushabh Lathia	11:22
Re: Parallel Hash take II	Rushabh Lathia	11:24
Re: path toward faster partition pruning	Robert Haas	11:34
Re: legitimacy of using PG_TRY , PG_CATCH , PG_END_TRY in C function	Robert Haas	11:35
Re: Removing [Merge]Append nodes which contain a single subpath	David Rowley	11:37
Re: make async slave to wait for lsn to be replayed	Robert Haas	11:38
Re: Transform for pl/perl	Robert Haas	11:42
Re: PATCH: pgbench - option to build using ppoll() for larger connection counts	Robert Haas	11:45
Re: [COMMITTERS] pgsql: Process variadic arguments consistently in json functions	Andrew Dunstan	12:18
Re: Transactions involving multiple postgres foreign servers	Ashutosh Bapat	12:36
Re: Removing [Merge]Append nodes which contain a single subpath	Ashutosh Bapat	12:44
Re: Timeline ID in backup_label file	David Steele	12:50
Re: PATCH: pgbench - option to build using ppoll() for larger connection counts	Rady, Doug	13:21
Adding table_constraint description in ALTER TABLE synopsis 📎	Lætitia Avrot	13:23
Re: Remove secondary checkpoint	Alvaro Herrera	13:43
Re: How to determine that a TransactionId is really aborted?	Alvaro Herrera	13:50
Re: Transactions involving multiple postgres foreign servers	Masahiko Sawada	14:11
Re: make async slave to wait for lsn to be replayed	Ants Aasma	14:29
Re: CurTransactionContext freed before transaction COMMIT ???	Amit Kapila	14:43
Re: Moving relation extension locks out of heavyweight lock manager	Robert Haas	15:03
Re: make async slave to wait for lsn to be replayed	Robert Haas	15:09
Re: Removing [Merge]Append nodes which contain a single subpath	Tom Lane	15:47
Re: [COMMITTERS] pgsql: Process variadic arguments consistently in json functions	Michael Paquier	16:23
Re: taking stdbool.h into use 📎	Peter Eisentraut	16:25
Re: taking stdbool.h into use	Alvaro Herrera	17:51
Re: Flexible configuration for full-text search	Emre Hasegeli	18:01
Re: Timeline ID in backup_label file 📎	Michael Paquier	18:03
Re: [BUGS] Bug in Physical Replication Slots (at least 9.5)?	Michael Paquier	18:13
Re: logical decoding of two-phase transactions 📎	Sokolov Yura	19:01
Re: Removing [Merge]Append nodes which contain a single subpath	David Rowley	19:19
Re: [GENERAL] Postgres 10 manual breaks links with anchors 📎	Peter Eisentraut	19:22
Re: performance drop after upgrade (9.6 > 10)	Justin Pryzby	19:45
Re: Removing [Merge]Append nodes which contain a single subpath	Tom Lane	20:06
Re: [GENERAL] Postgres 10 manual breaks links with anchors	Tom Lane	20:10
proposal: custom autovacuum entries	Jordan Deitch	20:18
Re: proposal: custom autovacuum entries	Tom Lane	20:47
Re: taking stdbool.h into use	Michael Paquier	20:53
Re: proposal: custom autovacuum entries	Michael Paquier	20:56
Re: proposal: schema variables	Nico Williams	22:07
bgwriter_lru_maxpages range in postgresql.conf	Jeff Janes	22:40
Re: taking stdbool.h into use	Alvaro Herrera	22:48
Re: taking stdbool.h into use	Michael Paquier	23:10
Re: [bug fix] ECPG: fails to recognize embedded parameters	Tsunakawa, Takayuki	23:46

Oct. 27, 2017

Thread	Author	Time
Re: Remove secondary checkpoint	Tsunakawa, Takayuki	00:26
FieldSelect/FieldStore dependencies, take 2 📎	Tom Lane	00:29
Re: taking stdbool.h into use	Tom Lane	00:41
Re: path toward faster partition pruning	Amit Langote	01:17
[bug fix] postgres.exe crashes with access violation on Windows while starting up 📎	Tsunakawa, Takayuki	02:10
Re: [bug fix] postgres.exe crashes with access violation on Windows while starting up 📎	Tsunakawa, Takayuki	02:51
Re: path toward faster partition pruning	Robert Haas	04:57
Re: Pluggable storage	Robert Haas	05:06
Re: proposal: schema variables	Pavel Stehule	05:08
Re: [PATCH] Lockable views	Robert Haas	05:11
Re: WIP: BRIN bloom indexes	Robert Haas	05:20
Re: proposal: schema variables	Tatsuo Ishii	05:30
Re: Implementing pg_receivewal --no-sync	Robert Haas	05:46
Re: proposal: schema variables	Tsunakawa, Takayuki	05:47
Burst in WAL size when UUID is used as PK while full_page_writes are enabled	sanyam jain	05:56
Re: path toward faster partition pruning	Amit Langote	06:12
Re: proposal: schema variables	Pavel Stehule	06:16
Re: CurTransactionContext freed before transaction COMMIT ???	Gaddam Sai Ram	06:23
Re: Implementing pg_receivewal --no-sync	Michael Paquier	07:03
Typos in src/backend/optimizer/README 📎	Etsuro Fujita	07:34
Re: WIP: BRIN bloom indexes	Simon Riggs	07:34
Re: Re: Is anything preventing us from allowing write to foreign tables from standby?	Robert Haas	07:44
Reading timeline from pg_control on replication slave	Andrey Borodin	08:04
Re: path toward faster partition pruning	Rajkumar Raghuwanshi	08:05
inconsistency in process names - bgworker: logical replication launcher	Pavel Stehule	08:06
MERGE SQL Statement for PG11 📎	Simon Riggs	08:55
Re: path toward faster partition pruning 📎	Amit Langote	09:11
Re: Burst in WAL size when UUID is used as PK while full_page_writes are enabled	Tomas Vondra	09:12
Re: WIP: BRIN bloom indexes	Tomas Vondra	09:25
Re: MERGE SQL Statement for PG11	Szymon Lipiński	09:33
Re: path toward faster partition pruning	Rajkumar Raghuwanshi	10:29
Re: Parallel safety for extern params	Amit Kapila	10:37
Re: Add support for tuple routing to foreign partitions 📎	Etsuro Fujita	11:00
Re: Partition-wise aggregation/grouping 📎	Jeevan Chalke	11:01
Re: inconsistency in process names - bgworker: logical replication launcher	Peter Eisentraut	11:03
Re: inconsistency in process names - bgworker: logical replication launcher	Pavel Stehule	11:05
Re: [GENERAL] Postgres 10 manual breaks links with anchors	Peter Eisentraut	11:31
Re: Burst in WAL size when UUID is used as PK while full_page_writes are enabled	Amit Kapila	11:54
Re: Burst in WAL size when UUID is used as PK while full_page_writes are enabled	Alvaro Herrera	12:06
Re: Burst in WAL size when UUID is used as PK while full_page_writes are enabled	Thomas Kellerer	12:16
Linking libpq statically to libssl	Daniele Varrazzo	12:24
Re: MERGE SQL Statement for PG11	Alvaro Herrera	12:45
Re: parallel.c oblivion of worker-startup failures	Amit Kapila	12:54
Re: WIP: BRIN bloom indexes	Alvaro Herrera	12:55
Re: Re: protocol version negotiation (Re: Libpq PGRES_COPY_BOTH - version compatibility) 📎	Robert Haas	12:55
Re: WIP: BRIN bloom indexes	Robert Haas	13:10
Re: Burst in WAL size when UUID is used as PK while full_page_writes are enabled	Amit Kapila	13:19
Re: Re: Burst in WAL size when UUID is used as PK while full_page_writes are enabled	Amit Kapila	13:21
Re: MERGE SQL Statement for PG11	Robert Haas	13:24
Re: [GENERAL] Postgres 10 manual breaks links with anchors	Tom Lane	13:29
Re: Linking libpq statically to libssl	Tom Lane	13:37
Re: proposal: schema variables	Gilles Darold	13:38
Re: proposal: schema variables	Pavel Stehule	14:09
Re: Linking libpq statically to libssl	Daniele Varrazzo	14:25

Browse Archives

Prev | Next