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

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
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

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