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

Oct. 18, 2017

Thread Author Time
Re: Re: Is anything preventing us from allowing write to foreign tables from standby? Craig Ringer 00:14
alter table doc fix 📎 Amit Langote 00:43
Re: [COMMITTERS] pgsql: Implement table partitioning. Amit Langote 01:00
Re: Re: Is anything preventing us from allowing write to foreign tables from standby? Michael Paquier 01:49
A handful of typos in allpaths.c 📎 David Rowley 02:45
Re: Partition-wise aggregation/grouping Dilip Kumar 04:23
Re: [POC] Faster processing at Gather node Andres Freund 05:33
Re: pgbench: Skipping the creating primary keys after initialization 📎 Masahiko Sawada 07:16
Re: parallelize queries containing initplans 📎 tushar 08:36
Re: [COMMITTERS] pgsql: Implement table partitioning. Alvaro Herrera 08:53
Re: Re: Is anything preventing us from allowing write to foreign tables from standby? Wolfgang Wilhelm 10:20
Re: v10 telease note for pg_basebackup refers to old --xlog-method argument Alvaro Herrera 11:25
Re: alter table doc fix Alvaro Herrera 11:37
Re: 64-bit queryId? Julien Rouhaud 13:20
Re: [COMMITTERS] pgsql: Implement table partitioning. Alvaro Herrera 15:27
Re: BUG #14849: jsonb_build_object doesn't like VARIADIC calls very much Andrew Dunstan 15:46
Re: BUG #14849: jsonb_build_object doesn't like VARIADIC calls very much Dmitry Dolgov 15:47
Re: [COMMITTERS] pgsql: Implement table partitioning. Robert Haas 16:35
Re: [COMMITTERS] pgsql: Implement table partitioning. Tom Lane 16:39
Re: SIGSEGV in BRIN autosummarize Justin Pryzby 16:48
Re: SIGSEGV in BRIN autosummarize Alvaro Herrera 16:54
Re: [COMMITTERS] pgsql: Implement table partitioning. Robert Haas 16:58
Re: SIGSEGV in BRIN autosummarize Justin Pryzby 17:06
Re: Supporting Windows SChannel as OpenSSL replacement Robert Haas 17:17
Re: [COMMITTERS] pgsql: Implement table partitioning. Alvaro Herrera 17:18
Re: SIGSEGV in BRIN autosummarize Alvaro Herrera 17:22
Re: SIGSEGV in BRIN autosummarize Justin Pryzby 17:40
Re: BUG #14849: jsonb_build_object doesn't like VARIADIC calls very much Andrew Dunstan 17:54
Re: Supporting Windows SChannel as OpenSSL replacement Tom Lane 18:50
Re: SIGSEGV in BRIN autosummarize Tom Lane 18:58
Re: [COMMITTERS] pgsql: Implement table partitioning. Robert Haas 19:07
Re: Supporting Windows SChannel as OpenSSL replacement Robert Haas 19:09
Re: 64-bit queryId? Robert Haas 19:12
Re: heap/SLRU verification, relfrozenxid cut-off, and freeze-the-dead bug (Was: amcheck (B-Tree integrity checking tool)) Peter Geoghegan 19:45
Re: [POC] Faster processing at Gather node Robert Haas 19:46
Re: [GENERAL] huge RAM use in multi-command ALTER of table heirarchy Justin Pryzby 19:54
Interest in a SECURITY DEFINER function current_user stack access mechanism? Nico Williams 20:01
Re: Interest in a SECURITY DEFINER function current_user stack access mechanism? Pavel Stehule 20:15
Re: Interest in a SECURITY DEFINER function current_user stack access mechanism? Nico Williams 20:15
Re: Interest in a SECURITY DEFINER function current_user stack access mechanism? Nico Williams 20:26
Re: [POC] Faster processing at Gather node Andres Freund 20:30
Re: Interest in a SECURITY DEFINER function current_user stack access mechanism? David G. Johnston 20:43
Re: [COMMITTERS] pgsql: Fix traversal of half-frozen update chains Robert Haas 20:54
Re: Interest in a SECURITY DEFINER function current_user stack access mechanism? Nico Williams 21:08
Re: Interest in a SECURITY DEFINER function current_user stack access mechanism? David G. Johnston 21:13
Re: Interest in a SECURITY DEFINER function current_user stack access mechanism? Nico Williams 21:30
Re: Interest in a SECURITY DEFINER function current_user stack access mechanism? David G. Johnston 21:45
Re: [COMMITTERS] pgsql: Fix traversal of half-frozen update chains Peter Geoghegan 21:52
Re: Interest in a SECURITY DEFINER function current_user stack access mechanism? Nico Williams 22:00
Re: 64-bit queryId? Michael Paquier 23:08
Re: Fix performance degradation of contended LWLock on NUMA Andres Freund 23:28
Re: Re: protocol version negotiation (Re: Libpq PGRES_COPY_BOTH - version compatibility) 📎 Badrul Chowdhury 23:35

Oct. 19, 2017

Thread Author Time
Re: Fix performance degradation of contended LWLock on NUMA Andres Freund 00:03
Re: BUG #14849: jsonb_build_object doesn't like VARIADIC calls very much 📎 Michael Paquier 02:07
I've just started working on Full Text Search with version 10 on Ubuntu 16 Ronald Jewell 02:53
Re: Supporting Windows SChannel as OpenSSL replacement Satyanarayana Narlapuram 05:15
Re: 64-bit queryId? 📎 Julien Rouhaud 06:11
Re: path toward faster partition pruning 📎 Amit Langote 06:46
Re: Parallel Append implementation 📎 Amit Khandekar 07:05
Re: show "aggressive" or not in autovacuum logs Masahiko Sawada 08:53
Fix a typo in libpq/auth.c 📎 Masahiko Sawada 10:05
Re: show "aggressive" or not in autovacuum logs Alvaro Herrera 11:03
Re: Fix performance degradation of contended LWLock on NUMA Sokolov Yura 11:36
Re: I've just started working on Full Text Search with version 10 on Ubuntu 16 Aleksandr Parfenov 11:45
Re: Fix a typo in libpq/auth.c Magnus Hagander 11:57
Re: A handful of typos in allpaths.c Magnus Hagander 12:00
Re: Fix performance degradation of contended LWLock on NUMA 📎 Sokolov Yura 12:10
Re: [PATCH] Tests for reloptions Alvaro Herrera 12:20
Re: [PATCH] Tests for reloptions Alvaro Herrera 12:27
Re: BUG #14849: jsonb_build_object doesn't like VARIADIC calls very much Andrew Dunstan 13:13
Cursor With_Hold Performance Workarounds/Optimization Leon Winter 13:20
Re: Cursor With_Hold Performance Workarounds/Optimization David Fetter 13:54
Re: Cursor With_Hold Performance Workarounds/Optimization Leon Winter 14:06
Re: Cursor With_Hold Performance Workarounds/Optimization David Fetter 14:15
Re: [COMMITTERS] pgsql: Fix traversal of half-frozen update chains Robert Haas 14:21
Flexible configuration for full-text search 📎 Aleksandr Parfenov 14:24
Re: Cursor With_Hold Performance Workarounds/Optimization Geoff Winkless 14:31
Re: Cursor With_Hold Performance Workarounds/Optimization Tom Lane 14:53
Re: BUG #14849: jsonb_build_object doesn't like VARIADIC calls very much 📎 Michael Paquier 15:25
Re: Supporting Windows SChannel as OpenSSL replacement Robert Haas 15:44
Re: [COMMITTERS] pgsql: Fix traversal of half-frozen update chains Peter Geoghegan 16:03
Re: Fix performance degradation of contended LWLock on NUMA Andres Freund 16:46
Re: Interest in a SECURITY DEFINER function current_user stack access mechanism? Nico Williams 18:27
Re: pgbench: Skipping the creating primary keys after initialization Fabien COELHO 18:31
Re: [PATCH] Add recovery_min_apply_delay_reconnect recovery option 📎 Eric Radman 18:46
What is the point of setrefs.c's is_converted_whole_row_reference? Tom Lane 18:56
Re: [PATCH] Add ALWAYS DEFERRED option for constraints 📎 Nico Williams 20:05
WIP: BRIN bloom indexes 📎 Tomas Vondra 20:15
Queuing all tables for analyze after recovery Tomasz Ostrowski 20:39
Queuing all tables for analyze after recovery Tomasz Ostrowski 20:42
Re: [COMMITTERS] pgsql: Fix traversal of half-frozen update chains Peter Geoghegan 20:44
Re: Domains and arrays and composites, oh my 📎 Tom Lane 20:46
Re: Queuing all tables for analyze after recovery Tom Lane 20:54
Re: Queuing all tables for analyze after recovery Vik Fearing 21:15
Re: Queuing all tables for analyze after recovery Tomasz Ostrowski 21:16
Re: Queuing all tables for analyze after recovery Tom Lane 21:26
Re: Queuing all tables for analyze after recovery Vik Fearing 21:30
CUBE seems a bit confused about ORDER BY Tomas Vondra 21:52
Re: CUBE seems a bit confused about ORDER BY Alexander Korotkov 22:01

Oct. 20, 2017

Thread Author Time
per-sesson errors after interrupting CLUSTER pg_attrdef Justin Pryzby 00:01
Re: Pluggable storage Amit Kapila 03:47
Re: Pluggable storage Amit Kapila 03:56
Re: Cursor With_Hold Performance Workarounds/Optimization Leon Winter 07:34
Re: Cursor With_Hold Performance Workarounds/Optimization Leon Winter 07:41
Re: Cursor With_Hold Performance Workarounds/Optimization Leon Winter 07:57
Re: asynchronous execution 📎 Kyotaro HORIGUCHI 08:37
Re: Fix performance degradation of contended LWLock on NUMA Sokolov Yura 08:54
Re: Cursor With_Hold Performance Workarounds/Optimization Leon Winter 09:11
Re: More stats about skipped vacuums Masahiko Sawada 10:15
Re: Flexible configuration for full-text search 📎 Aleksandr Parfenov 12:39
Re: PATCH: enabling parallel execution for cursors explicitly (experimental) Robert Haas 13:23
Re: 64-bit queryId? Robert Haas 13:44
Re: BUG #14849: jsonb_build_object doesn't like VARIADIC calls very much Andrew Dunstan 13:49
Re: 64-bit queryId? Julien Rouhaud 14:07
Re: What is the point of setrefs.c's is_converted_whole_row_reference? Robert Haas 14:19
Re: [POC] Faster processing at Gather node Robert Haas 14:27
Re: pgbench more operators & functions 📎 Fabien COELHO 16:36
Re: pgbench - allow to store select results into variables 📎 Fabien COELHO 16:37
Useless(?) asymmetry in parse_func.c Tom Lane 16:52
Re: A GUC to prevent leader processes from running subplans? Robert Haas 19:09

Oct. 21, 2017

Thread Author Time
Re: A design for amcheck heapam verification 📎 Peter Geoghegan 00:34
Re: BUG #14849: jsonb_build_object doesn't like VARIADIC calls very much 📎 Michael Paquier 03:40
Re: Refactor handling of database attributes between pg_dump and pg_dumpall 📎 Haribabu Kommi 05:30
Re: BUG #14849: jsonb_build_object doesn't like VARIADIC calls very much Tom Lane 15:43
Re: Refactor handling of database attributes between pg_dump and pg_dumpall Robert Haas 16:08
Re: Block level parallel vacuum WIP Robert Haas 16:09
Re: BUG #14849: jsonb_build_object doesn't like VARIADIC calls very much Michael Paquier 16:10
Re: BUG #14849: jsonb_build_object doesn't like VARIADIC calls very much Tom Lane 16:43
Re: Block level parallel vacuum WIP Thomas Munro 20:25
Re: BUG #14849: jsonb_build_object doesn't like VARIADIC calls very much Michael Paquier 23:33

Oct. 22, 2017

Thread Author Time
new field for structured exception - query Pavel Stehule 06:55
stalled post to mailing list - wrong filter? Pavel Stehule 07:02
Re: stalled post to mailing list - wrong filter? Magnus Hagander 07:08
Re: stalled post to mailing list - wrong filter? Pavel Stehule 07:56
Re: Allow GiST opcalsses without compress\decompres functions 📎 Andrey Borodin 11:48
Re: BUG #14849: jsonb_build_object doesn't like VARIADIC calls very much Andrew Dunstan 13:19
Re: [PATCH] Tests for reloptions Nikolay Shaplov 13:24
Re: BUG #14849: jsonb_build_object doesn't like VARIADIC calls very much Andrew Dunstan 16:11
Re: Allow GiST opcalsses without compress\decompres functions Tom Lane 16:21
Re: [BUGS] BUG #14849: jsonb_build_object doesn't like VARIADIC calls very much Andrew Dunstan 16:44
[sqlsmith] Failed assertion in adjust_appendrel_attrs_mutator Andreas Seltenreich 16:49
Re: [sqlsmith] Failed assertion in adjust_appendrel_attrs_mutator Tom Lane 17:07
Re: Discussion on missing optimizations Andreas Seltenreich 17:20
Re: Useless(?) asymmetry in parse_func.c 📎 Tom Lane 18:20
How to determine that a TransactionId is really aborted? Eric Ridge 19:23
Re: How to determine that a TransactionId is really aborted? Peter Geoghegan 19:50
Re: How to determine that a TransactionId is really aborted? Eric Ridge 20:00
Re: [BUGS] BUG #14849: jsonb_build_object doesn't like VARIADIC calls very much Michael Paquier 20:35
Re: BUG #14849: jsonb_build_object doesn't like VARIADIC calls very much 📎 Andrew Dunstan 20:50
Re: How to determine that a TransactionId is really aborted? Jaime Casanova 20:50
Re: BUG #14849: jsonb_build_object doesn't like VARIADIC calls very much Tom Lane 21:11
Re: How to determine that a TransactionId is really aborted? Eric Ridge 21:19
Re: How to determine that a TransactionId is really aborted? Peter Geoghegan 21:24
Re: How to determine that a TransactionId is really aborted? Eric Ridge 21:44
Re: [BUGS] BUG #14849: jsonb_build_object doesn't like VARIADIC calls very much Michael Paquier 22:03

Oct. 23, 2017

Thread Author Time
legitimacy of using PG_TRY , PG_CATCH , PG_END_TRY in C function John Lumby 00:30
Re: Block level parallel vacuum WIP Amit Langote 01:43
Re: alter table doc fix Amit Langote 02:52
Re: legitimacy of using PG_TRY , PG_CATCH , PG_END_TRY in C function Tom Lane 03:04
Re: Refactor handling of database attributes between pg_dump and pg_dumpall Haribabu Kommi 05:36
Re: path toward faster partition pruning Rajkumar Raghuwanshi 06:58
Re: How to determine that a TransactionId is really aborted? Craig Ringer 07:07
Re: path toward faster partition pruning 📎 Amit Langote 07:42
[bug fix] ECPG: fails to recognize embedded parameters 📎 Tsunakawa, Takayuki 08:01
Re: Allow GiST opcalsses without compress\decompres functions Andrey Borodin 08:13
Re: legitimacy of using PG_TRY , PG_CATCH , PG_END_TRY in C function Craig Ringer 08:16
Re: legitimacy of using PG_TRY , PG_CATCH , PG_END_TRY in C function Craig Ringer 08:20
Re: legitimacy of using PG_TRY , PG_CATCH , PG_END_TRY in C function Andres Freund 08:22
Re: legitimacy of using PG_TRY , PG_CATCH , PG_END_TRY in C function Andres Freund 08:27
Re: [sqlsmith] Failed assertion in adjust_appendrel_attrs_mutator 📎 Amit Langote 09:07
Re: make async slave to wait for lsn to be replayed 📎 Ivan Kartyshov 09:29
Re: make async slave to wait for lsn to be replayed 📎 Ivan Kartyshov 09:42
Re: path toward faster partition pruning Rajkumar Raghuwanshi 09:54
Re: make async slave to wait for lsn to be replayed Alexander Korotkov 10:19
Re: make async slave to wait for lsn to be replayed 📎 Ivan Kartyshov 12:44
Re: [POC] Faster processing at Gather node Amit Kapila 12:46
Re: [POC] Faster processing at Gather node Amit Kapila 12:50
Re: BUG #14849: jsonb_build_object doesn't like VARIADIC calls very much 📎 Michael Paquier 13:50
Re: Proposal: Local indexes for partitioned table 📎 Alvaro Herrera 15:12
Re: UPDATE of partition key 📎 Amit Khandekar 15:15
Re: [sqlsmith] Failed assertion in adjust_appendrel_attrs_mutator 📎 Tom Lane 15:22
Re: Proposal: Local indexes for partitioned table Robert Haas 15:49
Re: Proposal: Local indexes for partitioned table Alvaro Herrera 16:15
Re: path toward faster partition pruning Beena Emerson 16:38
Re: SIGSEGV in BRIN autosummarize 📎 Alvaro Herrera 17:09
Re: PATCH: pgbench - option to build using ppoll() for larger connection counts 📎 Rady, Doug 18:44
Re: Block level parallel vacuum WIP Masahiko Sawada 20:54

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

Browse Archives

Prev | Next