pgsql-hackers since 2021-03-12 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

March 12, 2021

Thread Author Time
Re: automatic analyze: readahead - add "IO read time" log message 📎 Stephen Frost 00:11
Re: shared-memory based stats collector 📎 Kyotaro Horiguchi 00:23
Re: automatic analyze: readahead - add "IO read time" log message Tomas Vondra 00:29
Re: Hybrid Hash/Nested Loop joins and caching results from subplans David Rowley 00:31
Re: Hybrid Hash/Nested Loop joins and caching results from subplans David Rowley 00:38
Re: automatic analyze: readahead - add "IO read time" log message Stephen Frost 00:41
Re: [PATCH] Covering SPGiST index Tom Lane 00:42
Re: compression libraries and CF bot Thomas Munro 00:44
Re: Is Recovery actually paused? Dilip Kumar 00:51
Re: shared-memory based stats collector Fujii Masao 01:03
Re: New IndexAM API controlling index vacuum strategies Peter Geoghegan 01:05
Re: shared-memory based stats collector Kyotaro Horiguchi 01:07
Re: shared-memory based stats collector Kyotaro Horiguchi 01:16
Re: shared-memory based stats collector Kyotaro Horiguchi 01:38
Re: Hybrid Hash/Nested Loop joins and caching results from subplans 📎 David Rowley 01:49
Re: Procedures versus the "fastpath" API Noah Misch 01:52
Re: Hybrid Hash/Nested Loop joins and caching results from subplans Tom Lane 01:59
HotStandbyActive() issue in postgres 📎 Hao Wu 02:14
Re: Allow batched insert during cross-partition updates Amit Langote 02:45
Re: Hybrid Hash/Nested Loop joins and caching results from subplans David Rowley 03:01
Re: [HACKERS] Custom compression methods Dilip Kumar 03:08
Re: shared-memory based stats collector Andres Freund 03:22
Re: [HACKERS] Custom compression methods Justin Pryzby 03:24
Re: Key management with tests 📎 Bruce Momjian 03:31
Re: [HACKERS] Custom compression methods Justin Pryzby 03:33
Re: Huge memory consumption on partitioned table with FKs Tatsuro Yamada 03:35
Re: About to add WAL write/fsync statistics to pg_stat_wal view Fujii Masao 03:39
RE: Parallel INSERT (INTO ... SELECT ...) [email protected] 04:03
Re: [HACKERS] Custom compression methods Dilip Kumar 04:07
Re: [HACKERS] Custom compression methods Dilip Kumar 04:08
Re: [Patch] Optimize dropping of relation buffers using dlist Amit Kapila 04:20
Re: [HACKERS] Custom compression methods Dilip Kumar 04:22
Re: [Patch] Optimize dropping of relation buffers using dlist Thomas Munro 04:27
RE: [Patch] Optimize dropping of relation buffers using dlist [email protected] 04:30
Re: Performance degradation of REFRESH MATERIALIZED VIEW Masahiko Sawada 04:32
Re: shared-memory based stats collector 📎 Kyotaro Horiguchi 04:49
Re: pg_amcheck contrib application 📎 Mark Dilger 05:00
Re: [HACKERS] logical decoding of two-phase transactions vignesh C 05:07
Re: [HACKERS] Custom compression methods 📎 Justin Pryzby 05:15
Re: About to add WAL write/fsync statistics to pg_stat_wal view Fujii Masao 05:25
RE: [Patch] Optimize dropping of relation buffers using dlist 📎 [email protected] 05:26
Re: shared-memory based stats collector Kyotaro Horiguchi 05:32
RE: [POC] Fast COPY FROM command for the table with foreign partitions 📎 [email protected] 05:54
Re: [HACKERS] Custom compression methods Dilip Kumar 05:54
Re: [PATCH] Hooks at XactCommand level Julien Rouhaud 05:55
Re: [Patch] Optimize dropping of relation buffers using dlist Kyotaro Horiguchi 06:10
Re: shared-memory based stats collector Fujii Masao 06:13
Re: [HACKERS] Custom compression methods Justin Pryzby 06:25
Re: [HACKERS] Custom compression methods Dilip Kumar 06:30
RE: [Patch] Optimize dropping of relation buffers using dlist 📎 [email protected] 06:36
RE: [Patch] Optimize dropping of relation buffers using dlist [email protected] 06:55
Re: PostmasterIsAlive() in recovery (non-USE_POST_MASTER_DEATH_SIGNAL builds) Thomas Munro 06:55
Re: Parallel INSERT (INTO ... SELECT ...) Amit Langote 07:05
Re: Parallel INSERT (INTO ... SELECT ...) 📎 Greg Nancarrow 07:23
RE: Enhance traceability of wal_level changes for backup management [email protected] 07:25
Re: Different compression methods for FPI 📎 Justin Pryzby 07:45
Re: OpenSSL 3.0.0 compatibility Peter Eisentraut 07:51
Re: Enhance traceability of wal_level changes for backup management Peter Eisentraut 08:03
RE: Parallel INSERT (INTO ... SELECT ...) [email protected] 08:03
Re: [PATCH] Disable bgworkers during servers start in pg_upgrade Julien Rouhaud 08:23
Re: shared-memory based stats collector 📎 Kyotaro Horiguchi 08:24
Re: [HACKERS] logical decoding of two-phase transactions 📎 Peter Smith 08:39
Re: [HACKERS] Custom compression methods Dilip Kumar 08:42
Re: HotStandbyActive() issue in postgres Fujii Masao 08:58
Re: [HACKERS] logical decoding of two-phase transactions Peter Smith 08:59
Re: Removing unneeded self joins Hywel Carver 09:05
Re: documentation fix for SET ROLE Laurenz Albe 09:16
Re: Self-join optimisation Hywel Carver 09:20
RE: Parallel INSERT (INTO ... SELECT ...) 📎 [email protected] 09:31
Re: [HACKERS] logical decoding of two-phase transactions vignesh C 09:38
Re: [HACKERS] Custom compression methods Dilip Kumar 09:39
Re: pgbench - add pseudo-random permutation function Fabien COELHO 09:43
Re: [HACKERS] Custom compression methods Justin Pryzby 10:36
unrecognized configuration parameter "plpgsql.check_asserts" Walker 10:53
Re: Allow batched insert during cross-partition updates 📎 gkokolatos 10:59
Re: unrecognized configuration parameter "plpgsql.check_asserts" Pavel Stehule 11:11
Re: [Patch] Optimize dropping of relation buffers using dlist Amit Kapila 11:34
Re: Parallel INSERT (INTO ... SELECT ...) Amit Kapila 11:36
回复： unrecognized configuration parameter "plpgsql.check_asserts" Walker 12:12
Re: unrecognized configuration parameter "plpgsql.check_asserts" Pavel Stehule 12:25
Re: 回复： unrecognized configuration parameter "plpgsql.check_asserts" Julien Rouhaud 12:27
Re: Do we support upgrade of logical replication? Amit Kapila 12:35
Re: 回复： unrecognized configuration parameter "plpgsql.check_asserts" Walker 12:38
Re: MultiXact\SLRU buffers configuration 📎 Andrey Borodin 12:44
Re: non-HOT update not looking at FSM for large tuple update Matthias van de Meent 12:45
Re: posgres 12 bug (partitioned table) 📎 Amit Langote 12:47
Re: [POC] verifying UTF-8 using SIMD instructions Amit Khandekar 13:14
Re: pg_amcheck contrib application 📎 Robert Haas 13:33
Re: shared-memory based stats collector 📎 Fujii Masao 14:33
Re: documentation fix for SET ROLE 📎 Laurenz Albe 14:35
Re: documentation fix for SET ROLE David G. Johnston 14:45
Re: [POC] verifying UTF-8 using SIMD instructions John Naylor 15:36
Re: pg_amcheck contrib application 📎 Mark Dilger 16:41
Re: pg_amcheck contrib application Robert Haas 18:10
Re: Confusing behavior of psql's \e 📎 Tom Lane 18:12
Re: documentation fix for SET ROLE Bossart, Nathan 18:16
Re: pg_amcheck contrib application Peter Geoghegan 18:32
Re: pg_amcheck contrib application Peter Geoghegan 18:35
Re: pg_amcheck contrib application er 19:05
Re: documentation fix for SET ROLE Joe Conway 19:13
Re: pg_amcheck contrib application Robert Haas 19:24
Re: pg_amcheck contrib application Robert Haas 19:31
Re: [patch] [doc] Minor variable related cleanup and rewording of plpgsql docs 📎 Tom Lane 20:08
Re: [patch] [doc] Minor variable related cleanup and rewording of plpgsql docs Pavel Stehule 20:17
Re: [patch] [doc] Minor variable related cleanup and rewording of plpgsql docs Tom Lane 20:36
Re: [patch] [doc] Minor variable related cleanup and rewording of plpgsql docs Pavel Stehule 20:48
Re: pgbench - add pseudo-random permutation function Thomas Munro 21:06
Re: pgbench - add pseudo-random permutation function Alvaro Herrera 21:12
Re: [patch] [doc] Minor variable related cleanup and rewording of plpgsql docs David G. Johnston 21:30
Re: [HACKERS] GSoC 2017: Foreign Key Arrays 📎 Mark Rofail 21:32
Re: [patch] [doc] Minor variable related cleanup and rewording of plpgsql docs 📎 Tom Lane 21:40
Re: documentation fix for SET ROLE Bossart, Nathan 21:41
Re: pg_amcheck contrib application Robert Haas 21:43
Re: pg_amcheck contrib application Peter Geoghegan 22:08
Re: Background writer and checkpointer in crash recovery 📎 Thomas Munro 22:16
Re: VACUUM (DISABLE_PAGE_SKIPPING on) Tomas Vondra 22:16
Re: pg_amcheck contrib application 📎 Mark Dilger 22:24
Re: zstd compression for pg_dump Tomas Vondra 22:31
Re: pg_amcheck contrib application Robert Haas 22:55
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Justin Pryzby 23:11
Re: pg_amcheck contrib application 📎 Mark Dilger 23:24
Re: pg_amcheck contrib application Mark Dilger 23:32
Re: GROUP BY DISTINCT Tomas Vondra 23:33

March 13, 2021

Thread Author Time
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Thomas Munro 00:34
Fwd: GROUP BY DISTINCT Pantelis Theodosiou 01:03
Re: pg_amcheck contrib application 📎 Mark Dilger 01:04
Re: pg_amcheck contrib application Robert Haas 01:16
Re: Different compression methods for FPI 📎 Justin Pryzby 01:28
Re: EXPLAIN/EXPLAIN ANALYZE REFRESH MATERIALIZED VIEW Japin Li 01:29
Re: pgbench: option delaying queries till connections establishment? Tom Lane 02:46
Re: A qsort template Thomas Munro 02:49
Re: Parallel INSERT (INTO ... SELECT ...) Amit Kapila 03:00
Re: pgbench: option delaying queries till connections establishment? Thomas Munro 03:00
Re: pgbench: option delaying queries till connections establishment? Tom Lane 03:08
Re: TRUNCATE on foreign table Kazutaka Onishi 03:35
Re: pgbench: option delaying queries till connections establishment? 📎 Thomas Munro 03:37
Re: pgbench: option delaying queries till connections establishment? Tom Lane 03:58
Re: pgbench: option delaying queries till connections establishment? Thomas Munro 04:23
Re: [HACKERS] PATCH: Batch/pipelining support for libpq 📎 Alvaro Herrera 04:28
Re: Parallel INSERT (INTO ... SELECT ...) Tom Lane 04:38
Re: pg_amcheck contrib application 📎 Mark Dilger 04:41
Re: pg_amcheck contrib application Tom Lane 04:53
Re: pg_amcheck contrib application Tom Lane 04:56
Re: pg_amcheck contrib application Tom Lane 05:08
Re: pg_amcheck contrib application Mark Dilger 05:09
Re: Parallel INSERT (INTO ... SELECT ...) Amit Kapila 05:17
Re: pg_amcheck contrib application Tom Lane 05:27
Re: pg_amcheck contrib application Tom Lane 05:30
Re: New IndexAM API controlling index vacuum strategies Masahiko Sawada 05:34
Re: proposal: schema variables 📎 Pavel Stehule 06:01
Re: pg_amcheck contrib application Tom Lane 06:07
Re: pg_amcheck contrib application Noah Misch 06:16
Re: pg_amcheck contrib application Mark Dilger 06:18
Re: shared-memory based stats collector Andres Freund 06:20
Re: pg_amcheck contrib application Tom Lane 06:22
Re: pg_amcheck contrib application Mark Dilger 06:28
Re: pg_amcheck contrib application Andres Freund 06:30
Re: pgbench: option delaying queries till connections establishment? Tom Lane 06:31
Re: pg_amcheck contrib application 📎 Mark Dilger 06:33
Re: pg_amcheck contrib application Tom Lane 06:36
Re: pg_amcheck contrib application Mark Dilger 06:55
Re: pg_amcheck contrib application Tom Lane 07:00
Re: pg_amcheck contrib application Noah Misch 07:19
Re: pg_amcheck contrib application Tom Lane 07:36
RE: [HACKERS] logical decoding of two-phase transactions [email protected] 08:00
Re: pgbench: option delaying queries till connections establishment? Fabien COELHO 08:08
Re: pgbench - add pseudo-random permutation function 📎 Fabien COELHO 08:49
Re: pl/pgsql feature request: shorthand for argument and local variable references Julien Rouhaud 08:53
Re: pgbench: option delaying queries till connections establishment? Thomas Munro 09:54
Re: TRUNCATE on foreign table 📎 Kazutaka Onishi 09:57
Re: [HACKERS] GSoC 2017: Foreign Key Arrays 📎 Mark Rofail 10:08
Re: [PATCH] Provide more information to filter_prepare Amit Kapila 10:13
Re: pgbench: option delaying queries till connections establishment? Fabien COELHO 11:09
Re: pl/pgsql feature request: shorthand for argument and local variable references 📎 Pavel Stehule 11:10
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail 11:42
Re: pl/pgsql feature request: shorthand for argument and local variable references Julien Rouhaud 11:49
Re: shared-memory based stats collector Magnus Hagander 11:53
Re: pg_amcheck contrib application Robert Haas 13:49
Re: pgbench - add pseudo-random permutation function Alvaro Herrera 14:44
Re: pg_amcheck contrib application Tom Lane 14:50
Re: pg_amcheck contrib application 📎 Mark Dilger 15:20
Re: pgbench - add pseudo-random permutation function 📎 Fabien COELHO 15:42
Re: Different compression methods for FPI Andrey Borodin 15:48
Re: pg_amcheck contrib application Robert Haas 15:59
Re: shared-memory based stats collector Andres Freund 18:05
amcheck hardening 📎 Mark Dilger 18:35
Re: pg_amcheck contrib application Noah Misch 18:46
Re: pg_amcheck contrib application Mark Dilger 18:51
Re: amcheck hardening Peter Geoghegan 19:06
Re: pg_amcheck contrib application Noah Misch 19:18
Re: amcheck hardening Mark Dilger 19:29
Re: PITR promote bug: Checkpointer writes to older timeline 📎 Soumyadeep Chakraborty 20:29
Re: Using COPY FREEZE in pgbench Fabien COELHO 21:16

March 14, 2021

Thread Author Time
Re: Using COPY FREEZE in pgbench Tatsuo Ishii 00:22
Re: Using COPY FREEZE in pgbench Tatsuo Ishii 00:28
Re: A qsort template 📎 Thomas Munro 02:35
RE: [HACKERS] logical decoding of two-phase transactions [email protected] 02:52
Re: New IndexAM API controlling index vacuum strategies Peter Geoghegan 03:23
Re: A qsort template Zhihong Yu 04:06
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view? 📎 Julien Rouhaud 08:06

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