pgsql-hackers since 2019-10-17 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. 17, 2019

Thread	Author	Time
Re: maintenance_work_mem used by Vacuum	Greg Stark	00:37
Re: v12.0: segfault in reindex CONCURRENTLY	Michael Paquier	00:49
Re: v12.0: segfault in reindex CONCURRENTLY	Michael Paquier	01:04
Re: Cache lookup errors with functions manipulation object addresses	Michael Paquier	01:29
Re: Cache lookup errors with functions manipulation object addresses 📎	Michael Paquier	01:37
Remaining calls of heap_close/heap_open in the tree 📎	Michael Paquier	01:47
RE: New SQL counter statistics view (pg_stat_sql) 📎	Smith, Peter	02:22
Re: ICU for global collation 📎	Thomas Munro	02:52
Re: Questions/Observations related to Gist vacuum 📎	Amit Kapila	03:31
Re: configure fails for perl check on CentOS8	Kyotaro Horiguchi	03:39
Re: Questions/Observations related to Gist vacuum	Amit Kapila	03:45
Re: Proposal: Make use of C99 designated initialisers for nulls/values arrays	vignesh C	04:21
Re: Questions/Observations related to Gist vacuum	Dilip Kumar	04:21
Re: maintenance_work_mem used by Vacuum	Amit Kapila	05:10
Re: SegFault on 9.6.14	Thomas Munro	05:20
Re: WIP/PoC for parallel backup 📎	Asif Rehman	05:21
Re: [HACKERS] Block level parallel vacuum	Masahiko Sawada	05:25
Re: recovery_min_apply_delay in archive recovery causes assertion failure in latch	Michael Paquier	05:35
Re: Proposal: Make use of C99 designated initialisers for nulls/values arrays	Thomas Munro	05:37
Re: [HACKERS] Block level parallel vacuum	Mahendra Singh	06:17
Re: [HACKERS] Block level parallel vacuum	Masahiko Sawada	06:28
Re: [HACKERS] Block level parallel vacuum	Amit Kapila	06:51
Re: Questions/Observations related to Gist vacuum	Heikki Linnakangas	06:57
Re: Clean up MinGW def file generation	Michael Paquier	07:18
Re: Proposal: Make use of C99 designated initialisers for nulls/values arrays	Michael Paquier	07:30
Re: Remove obsolete information schema tables	Michael Paquier	07:44
Re: Remaining calls of heap_close/heap_open in the tree	Andres Freund	08:04
Re: parallel restore sometimes fails for FKs to partitioned tables	Alvaro Herrera	08:14
Re: Remaining calls of heap_close/heap_open in the tree	Tom Lane	08:15
Re: Questions/Observations related to Gist vacuum	Dilip Kumar	08:16
Re: Remaining calls of heap_close/heap_open in the tree	Michael Paquier	08:25
Re: [HACKERS] Block level parallel vacuum	Amit Kapila	08:30
Re: v12.0: segfault in reindex CONCURRENTLY	Alvaro Herrera	08:33
Re: pgbench - extend initialization phase control	btendouan	08:35
Re: Zedstore - compressed in-core columnar storage	Heikki Linnakangas	08:41
Re: [HACKERS] Block level parallel vacuum	Masahiko Sawada	08:41
Re: v12.0: segfault in reindex CONCURRENTLY	Michael Paquier	08:50
Re: Change atoi to strtol in same place	Kyotaro Horiguchi	08:52
Re: maintenance_work_mem used by Vacuum	Amit Kapila	09:13
Re: Questions/Observations related to Gist vacuum	Amit Kapila	09:28
Re: maintenance_work_mem used by Vacuum	Tom Lane	09:40
Re: [HACKERS] Block level parallel vacuum	Dilip Kumar	09:55
Re: v12.0: segfault in reindex CONCURRENTLY	Alvaro Herrera	09:56
Re: Remaining calls of heap_close/heap_open in the tree	Alvaro Herrera	09:58
Memory leak reported by address sanitizer in ECPGconnect/CRYPTO_zalloc	Madars Vitolins	10:12
Re: [Proposal] Global temporary tables	曾文旌 (义从)	10:18
Re: v12 and pg_restore -f-	Tom Lane	10:24
Re: [HACKERS] Block level parallel vacuum	Amit Kapila	10:30
Re: Remaining calls of heap_close/heap_open in the tree	Andres Freund	11:02
Re: pgbench - extend initialization phase control 📎	Fabien COELHO	11:09
Re: Ordering of header file inclusion	Amit Kapila	11:14
Can you please tell us how set this prefetch attribute in following lines.	M Tarkeshwar Rao	11:16
Re: Proposal: Make use of C99 designated initialisers for nulls/values arrays	Kyotaro Horiguchi	11:28
Re: Remaining calls of heap_close/heap_open in the tree	Dagfinn Ilmari Mannsåker	11:34
Re: "pg_ctl: the PID file ... is empty" at end of make check	Tom Lane	12:20
Re: maintenance_work_mem used by Vacuum	Masahiko Sawada	12:34
Re: Questions/Observations related to Gist vacuum	Dilip Kumar	13:02
Re: [PATCH] Race condition in logical walsender causes long postgresql shutdown delay	Alvaro Herrera	13:13
Re: v12 and pg_restore -f-	Justin Pryzby	15:30
Re: Compressed pluggable storage experiments	Alvaro Herrera	15:47
Re: Can you please tell us how set this prefetch attribute in following lines.	Reid Thompson	16:18
Re: Can you please tell us how set this prefetch attribute in following lines.	Laurenz Albe	17:05
UPSERT on view does not find constraint by name	Jeremy Finzel	17:49
Non working timeout detection in logical worker 📎	Julien Rouhaud	18:00
libpq: Fix wrong connection status on invalid "connect_timeout" 📎	Lars Kanis	18:04
Re: libpq: Fix wrong connection status on invalid "connect_timeout"	Lars Kanis	20:10
Re: ICU for global collation	Thomas Munro	21:43
Re: v12 and pg_restore -f-	Stephen Frost	22:02

Oct. 18, 2019

Thread	Author	Time
Re: Remaining calls of heap_close/heap_open in the tree	Michael Paquier	01:03
Re: v12.0: segfault in reindex CONCURRENTLY	Michael Paquier	01:23
RE: extension patch of CREATE OR REPLACE TRIGGER 📎	[email protected]	01:23
Re: "pg_ctl: the PID file ... is empty" at end of make check	Thomas Munro	01:26
Re: maintenance_work_mem used by Vacuum	Amit Kapila	02:41
Re: maintenance_work_mem used by Vacuum	Amit Kapila	02:43
Re: Proposal: Make use of C99 designated initialisers for nulls/values arrays	Amit Kapila	02:51
Re: libpq: Fix wrong connection status on invalid "connect_timeout" 📎	Michael Paquier	03:06
Re: [HACKERS] Block level parallel vacuum	Dilip Kumar	03:15
Re: maintenance_work_mem used by Vacuum	Masahiko Sawada	03:27
Can you please tell us how set this prefetch attribute in following lines.	M Tarkeshwar Rao	03:43
RE: Can you please tell us how set this prefetch attribute in following lines.	M Tarkeshwar Rao	03:47
Can you please tell us how set this prefetch attribute in following lines.	M Tarkeshwar Rao	03:47
Re: Questions/Observations related to Gist vacuum	Dilip Kumar	04:04
Re: Questions/Observations related to Gist vacuum	Dilip Kumar	04:11
Re: SegFault on 9.6.14	Amit Kapila	04:38
Re: Questions/Observations related to Gist vacuum	Amit Kapila	05:18
Re: Questions/Observations related to Gist vacuum	Amit Kapila	05:25
Re: Non working timeout detection in logical worker	Michael Paquier	05:32
Re: Non working timeout detection in logical worker	Julien Rouhaud	05:47
Re: [HACKERS] Block level parallel vacuum	Amit Kapila	05:55
Re: [HACKERS] Block level parallel vacuum	Dilip Kumar	06:48
Obsolete comment in partbounds.c 📎	Etsuro Fujita	07:25
Re: generating catcache control data	John Naylor	07:51
Re: UPSERT on view does not find constraint by name	Tom Lane	08:42
Re: [Patch] Base backups and random or zero pageheaders 📎	Michael Banck	09:05
Re: Partitioning versus autovacuum	Greg Stark	09:21
Re: Obsolete comment in partbounds.c 📎	Alvaro Herrera	09:56
Re: [PATCH] Race condition in logical walsender causes long postgresql shutdown delay	Craig Ringer	10:14
Re: Compressed pluggable storage experiments	Andres Freund	10:25
Re: v12.0: segfault in reindex CONCURRENTLY	Alvaro Herrera	10:30
Re: WIP/PoC for parallel backup	Jeevan Chalke	11:11
Re: Questions/Observations related to Gist vacuum 📎	Dilip Kumar	11:21
Add Change Badges to documentation 📎	Corey Huinker	11:54
Re: libpq: Fix wrong connection status on invalid "connect_timeout" 📎	Lars Kanis	12:01
Re: libpq: Fix wrong connection status on invalid "connect_timeout" 📎	Lars Kanis	12:01
Re: libpq: Fix wrong connection status on invalid "connect_timeout" 📎	Lars Kanis	12:01
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions	Amit Kapila	12:01
Re: Clean up MinGW def file generation	Alvaro Herrera	12:07
Re: Proposal: Make use of C99 designated initialisers for nulls/values arrays	Stephen Frost	12:18
Re: [Patch proposal] libpq portal support	Craig Ringer	12:21
Re: Non working timeout detection in logical worker	Jehan-Guillaume (ioguix) de Rorthais	12:47
RE: Copy data to DSA area 📎	[email protected]	12:53
Re: UPSERT on view does not find constraint by name	Jeremy Finzel	12:59
Re: Proposal: Make use of C99 designated initialisers for nulls/values arrays	Chapman Flack	12:59
Re: Clean up MinGW def file generation	Tom Lane	13:00
Re: Proposal: Make use of C99 designated initialisers for nulls/values arrays	Stephen Frost	13:03
Backport "WITH ... AS MATERIALIZED" syntax to <12? 📎	Colin Watson	13:21
Re: UPSERT on view does not find constraint by name	Tom Lane	13:22
Re: Add Change Badges to documentation	Tomas Vondra	13:44
Re: configure fails for perl check on CentOS8	Tom Lane	13:50
Re: Bug about drop index concurrently	Tomas Vondra	15:00
Missing constant propagation in planner on hash quals causes join slowdown 📎	Hans Buschmann	15:40
Re: Can you please tell us how set this prefetch attribute in following lines.	Justin Pryzby	16:15
Re: Columns correlation and adaptive query optimization 📎	Konstantin Knizhnik	16:53
jsonb_set() strictness considered harmful to data	Ariadne Conill	17:37
Re: v12.0: reindex CONCURRENTLY: lock ShareUpdateExclusiveLock on object 14185/39327/0 is already held	Justin Pryzby	18:26
Re: jsonb_set() strictness considered harmful to data	Mark Felder	19:10
Re: jsonb_set() strictness considered harmful to data	Christoph Moench-Tegeder	21:50
Re: jsonb_set() strictness considered harmful to data	David G. Johnston	22:00
Re: jsonb_set() strictness considered harmful to data	Ariadne Conill	22:05
Re: jsonb_set() strictness considered harmful to data	Ariadne Conill	22:11
Re: jsonb_set() strictness considered harmful to data	Christoph Moench-Tegeder	22:57
Re: jsonb_set() strictness considered harmful to data	Adrian Klaver	23:01
Re: jsonb_set() strictness considered harmful to data	Ariadne Conill	23:31
Re: jsonb_set() strictness considered harmful to data	Ariadne Conill	23:45
Re: jsonb_set() strictness considered harmful to data	Stephen Frost	23:51

Oct. 19, 2019

Thread	Author	Time
Re: jsonb_set() strictness considered harmful to data	Stephen Frost	00:01
Re: jsonb_set() strictness considered harmful to data	Adrian Klaver	00:04
Missing error_context_stack = NULL in AutoVacWorkerMain()	Ashwin Agrawal	00:55
Re: jsonb_set() strictness considered harmful to data	Ariadne Conill	02:14
Re: v12.0: segfault in reindex CONCURRENTLY	Michael Paquier	02:14
Re: jsonb_set() strictness considered harmful to data	Ariadne Conill	02:18
Re: Remaining calls of heap_close/heap_open in the tree	Michael Paquier	02:26
Re: recovery_min_apply_delay in archive recovery causes assertion failure in latch	Michael Paquier	02:28
Re: Backport "WITH ... AS MATERIALIZED" syntax to <12?	Michael Paquier	02:34
Re: v12.0: reindex CONCURRENTLY: lock ShareUpdateExclusiveLock on object 14185/39327/0 is already held	Michael Paquier	02:41
pgsql: For all ppc compilers, implement compare_exchange and fetch_add	Noah Misch	03:27
Re: Backport "WITH ... AS MATERIALIZED" syntax to <12?	Andrew Gierth	04:01
Re: jsonb_set() strictness considered harmful to data	Pavel Stehule	04:17
Fix of fake unlogged LSN initialization 📎	[email protected]	05:03
Re: jsonb_set() strictness considered harmful to data	David G. Johnston	05:41
Re: jsonb_set() strictness considered harmful to data	Pavel Stehule	05:52
Re: jsonb_set() strictness considered harmful to data	Ariadne Conill	06:52
Re: Obsolete comment in partbounds.c	Etsuro Fujita	08:56
Re: Backport "WITH ... AS MATERIALIZED" syntax to <12?	Colin Watson	09:22
Re: Backport "WITH ... AS MATERIALIZED" syntax to <12?	Andres Freund	09:56
Re: Proposal: Make use of C99 designated initialisers for nulls/values arrays	Andres Freund	10:26
Re: dropdb --force	Amit Kapila	10:36
Re: Backport "WITH ... AS MATERIALIZED" syntax to <12?	Tomas Vondra	10:48
Re: Backport "WITH ... AS MATERIALIZED" syntax to <12?	Tomas Vondra	10:52
Re: jsonb_set() strictness considered harmful to data	Tomas Vondra	11:08
Re: Compressed pluggable storage experiments	Tomas Vondra	12:23
Remove obsolete options for createuser 📎	Alexander Lakhin	12:34
Re: jsonb_set() strictness considered harmful to data	Dmitry Dolgov	13:32
Re: jsonb_set() strictness considered harmful to data	Christoph Moench-Tegeder	13:59
Re: Backport "WITH ... AS MATERIALIZED" syntax to <12?	Andrew Dunstan	14:52
Log statement sample - take two 📎	Adrien Nayrat	15:02
Re: Backport "WITH ... AS MATERIALIZED" syntax to <12?	Isaac Morland	15:10
Re: jsonb_set() strictness considered harmful to data	Stephen Frost	15:21
Re: jsonb_set() strictness considered harmful to data	Andrew Dunstan	15:26
Re: Backport "WITH ... AS MATERIALIZED" syntax to <12?	Andrew Dunstan	15:30
Re: SQL/JSON: JSON_TABLE	Pavel Stehule	15:31
Re: Proposal: Make use of C99 designated initialisers for nulls/values arrays	Stephen Frost	15:43
Re: configure fails for perl check on CentOS8	Andrew Dunstan	15:55
Re: jsonb_set() strictness considered harmful to data	Tomas Vondra	16:18
Re: jsonb_set() strictness considered harmful to data	Tomas Vondra	16:31
Re: jsonb_set() strictness considered harmful to data	Andrew Dunstan	16:32
Re: jsonb_set() strictness considered harmful to data	David G. Johnston	16:32
Re: pgsql: Implement jsonpath .datetime() method 📎	Alexander Korotkov	16:44
Re: jsonb_set() strictness considered harmful to data	Andrew Dunstan	16:47
Re: Fix most -Wundef warnings	Peter Eisentraut	16:50
Re: Fix most -Wundef warnings	Peter Eisentraut	16:51
Re: Add a GUC variable that control logical replication	Peter Eisentraut	17:10
Re: Backport "WITH ... AS MATERIALIZED" syntax to <12?	Stephen Frost	17:36
Re: jsonb_set() strictness considered harmful to data	Adrian Klaver	18:28
Re: Backport "WITH ... AS MATERIALIZED" syntax to <12?	Isaac Morland	18:35
Re: jsonb_set() strictness considered harmful to data	Tomas Vondra	19:27
Re: pause recovery if pitr target not reached	Peter Eisentraut	19:45
Re: jsonb_set() strictness considered harmful to data	Ariadne Conill	19:49
Re: Ordering of header file inclusion	Peter Eisentraut	19:50
Re: Backport "WITH ... AS MATERIALIZED" syntax to <12?	Tom Lane	19:55
Re: dropdb --force 📎	Pavel Stehule	20:36
Re: Backport "WITH ... AS MATERIALIZED" syntax to <12?	Nikolay Samokhvalov	20:46
Re: Backport "WITH ... AS MATERIALIZED" syntax to <12?	Nikolay Samokhvalov	21:04
Re: Ordering of header file inclusion	Andres Freund	21:14
Re: Add a GUC variable that control logical replication	Euler Taveira	22:23

Oct. 20, 2019

Thread	Author	Time
Re: Ordering of header file inclusion	Tom Lane	04:53
Re: Remove obsolete information schema tables 📎	Peter Eisentraut	08:01
Re: Clean up MinGW def file generation	Peter Eisentraut	08:26
jsonb_set() strictness considered harmful to data	Floris Van Nee	08:39
Re: jsonb_set() strictness considered harmful to data	Steve Atkins	09:13

Browse Archives

Prev | Next