public inbox for [email protected]help / color / mirror / Atom feed
Messages from [email protected] Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits 2021-01-10 22:35 UTC Tomas Vondra <[email protected]> Re: Additional improvements to extended statistics 2020-11-12 14:18 UTC Tomas Vondra <[email protected]> Re: Fix brin_form_tuple to properly detoast data 2020-11-04 22:25 UTC Tomas Vondra <[email protected]> Re: automatic analyze: readahead - add "IO read time" log message 2020-11-04 16:46 UTC Tomas Vondra <[email protected]> Re: automatic analyze: readahead - add "IO read time" log message 2020-11-04 14:19 UTC Tomas Vondra <[email protected]> Re: PANIC: could not fsync file "pg_multixact/..." since commit dee663f7843 2020-11-04 13:50 UTC Tomas Vondra <[email protected]> Re: PANIC: could not fsync file "pg_multixact/..." since commit dee663f7843 2020-11-04 01:57 UTC Tomas Vondra <[email protected]> PANIC: could not fsync file "pg_multixact/..." since commit dee663f7843 2020-11-04 01:32 UTC Tomas Vondra <[email protected]> Fix brin_form_tuple to properly detoast data 2020-11-04 01:05 UTC Tomas Vondra <[email protected]> Re: Use of "long" in incremental sort code 2020-11-03 21:42 UTC Tomas Vondra <[email protected]> Re: enable_incremental_sort changes query behavior 2020-11-03 21:39 UTC Tomas Vondra <[email protected]> Re: Use of "long" in incremental sort code 2020-11-03 02:53 UTC Tomas Vondra <[email protected]> Re: enable_incremental_sort changes query behavior 2020-11-03 02:37 UTC Tomas Vondra <[email protected]> Re: WIP: BRIN multi-range indexes 2020-11-02 23:25 UTC Tomas Vondra <[email protected]> Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits 2020-11-02 14:44 UTC Tomas Vondra <[email protected]> Re: Parallel copy 2020-10-31 13:39 UTC Tomas Vondra <[email protected]> Re: Stats collector's idx_blks_hit value is highly misleading in practice 2020-10-31 01:46 UTC Tomas Vondra <[email protected]> Re: [PATCH] Add extra statistics to explain for Nested Loop 2020-10-31 01:20 UTC Tomas Vondra <[email protected]> Re: A couple questions about ordered-set aggregates 2020-10-30 23:49 UTC Tomas Vondra <[email protected]> Re: Should the function get_variable_numdistinct consider the case when stanullfrac is 1.0? 2020-10-30 23:40 UTC Tomas Vondra <[email protected]> Re: Extending range type operators to cope with elements 2020-10-30 22:08 UTC Tomas Vondra <[email protected]> Re: enable_incremental_sort changes query behavior 2020-10-30 21:03 UTC Tomas Vondra <[email protected]> Re: Parallel copy 2020-10-30 20:56 UTC Tomas Vondra <[email protected]> Re: Parallel copy 2020-10-30 20:37 UTC Tomas Vondra <[email protected]> Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits 2020-10-30 00:42 UTC Tomas Vondra <[email protected]> Re: enable_incremental_sort changes query behavior 2020-10-29 22:06 UTC Tomas Vondra <[email protected]> Re: MultiXact\SLRU buffers configuration 2020-10-29 13:49 UTC Tomas Vondra <[email protected]> Re: Track statistics for streaming of in-progress transactions 2020-10-28 23:46 UTC Tomas Vondra <[email protected]> Re: MultiXact\SLRU buffers configuration 2020-10-28 23:32 UTC Tomas Vondra <[email protected]> Re: MultiXact\SLRU buffers configuration 2020-10-28 23:21 UTC Tomas Vondra <[email protected]> Re: Add important info about ANALYZE after create Functional Index 2020-10-28 23:02 UTC Tomas Vondra <[email protected]> Re: Add important info about ANALYZE after create Functional Index 2020-10-28 19:35 UTC Tomas Vondra <[email protected]> Re: Add important info about ANALYZE after create Functional Index 2020-10-28 19:13 UTC Tomas Vondra <[email protected]> Re: Add important info about ANALYZE after create Functional Index 2020-10-28 19:12 UTC Tomas Vondra <[email protected]> Re: list of extended statistics on psql 2020-10-28 19:07 UTC Tomas Vondra <[email protected]> Re: list of extended statistics on psql 2020-10-28 19:06 UTC Tomas Vondra <[email protected]> Re: [HACKERS] Custom compression methods 2020-10-28 19:01 UTC Tomas Vondra <[email protected]> Re: Add important info about ANALYZE after create Functional Index 2020-10-28 18:55 UTC Tomas Vondra <[email protected]> Re: Add important info about ANALYZE after create Functional Index 2020-10-28 18:52 UTC Tomas Vondra <[email protected]> Re: cleanup temporary files after crash 2020-10-28 18:42 UTC Tomas Vondra <[email protected]> Re: parallel distinct union and aggregate support patch 2020-10-28 12:31 UTC Tomas Vondra <[email protected]> Re: Patch to fix FK-related selectivity estimates with constants 2020-10-28 01:43 UTC Tomas Vondra <[email protected]> Re: MultiXact\SLRU buffers configuration 2020-10-28 01:36 UTC Tomas Vondra <[email protected]> Re: Resetting spilled txn statistics in pg_stat_replication 2020-10-27 23:56 UTC Tomas Vondra <[email protected]> Re: Patch to fix FK-related selectivity estimates with constants 2020-10-27 23:18 UTC Tomas Vondra <[email protected]> Re: POC: GROUP BY optimization 2020-10-27 20:19 UTC Tomas Vondra <[email protected]> Re: Use of "long" in incremental sort code 2020-10-21 21:00 UTC Tomas Vondra <[email protected]> Re: [HACKERS] Custom compression methods 2020-10-21 20:41 UTC Tomas Vondra <[email protected]> Re: [HACKERS] Custom compression methods 2020-10-12 14:02 UTC Tomas Vondra <[email protected]> Re: WIP: WAL prefetch (another approach) 2020-10-10 11:29 UTC Tomas Vondra <[email protected]> Re: Possible NULL dereferencing null pointer (src/backend/executor/nodeIncrementalSort.c) 2020-10-09 22:12 UTC Tomas Vondra <[email protected]> Re: Possible NULL dereferencing null pointer (src/backend/executor/nodeIncrementalSort.c) 2020-10-09 22:04 UTC Tomas Vondra <[email protected]> Re: Possible NULL dereferencing null pointer (src/backend/executor/nodeIncrementalSort.c) 2020-10-09 17:05 UTC Tomas Vondra <[email protected]> Re: POC: postgres_fdw insert batching 2020-10-08 22:14 UTC Tomas Vondra <[email protected]> Re: [HACKERS] Custom compression methods 2020-10-08 21:54 UTC Tomas Vondra <[email protected]> Re: enable_incremental_sort changes query behavior 2020-10-07 22:34 UTC Tomas Vondra <[email protected]> Re: enable_incremental_sort changes query behavior 2020-10-07 22:22 UTC Tomas Vondra <[email protected]> Re: WIP: WAL prefetch (another approach) 2020-10-07 00:58 UTC Tomas Vondra <[email protected]> Re: [HACKERS] Custom compression methods 2020-10-06 16:51 UTC Tomas Vondra <[email protected]> Re: [HACKERS] Custom compression methods 2020-10-05 16:03 UTC Tomas Vondra <[email protected]> Re: [HACKERS] Custom compression methods 2020-10-05 12:23 UTC Tomas Vondra <[email protected]> Re: [HACKERS] Custom compression methods 2020-10-04 22:07 UTC Tomas Vondra <[email protected]> Re: enable_incremental_sort changes query behavior 2020-10-03 21:44 UTC Tomas Vondra <[email protected]> Re: Optimize memory allocation code 2020-10-03 20:57 UTC Tomas Vondra <[email protected]> Re: POC: contrib/unaccent as IMMUTABLE 2020-10-03 13:01 UTC Tomas Vondra <[email protected]> Re: a misbehavior of partition row movement (?) 2020-10-03 11:15 UTC Tomas Vondra <[email protected]> Re: Parallel copy 2020-10-03 00:49 UTC Tomas Vondra <[email protected]> Re: enable_incremental_sort changes query behavior 2020-10-02 22:28 UTC Tomas Vondra <[email protected]> Re: enable_incremental_sort changes query behavior 2020-10-02 20:56 UTC Tomas Vondra <[email protected]> Re: enable_incremental_sort changes query behavior 2020-10-02 18:25 UTC Tomas Vondra <[email protected]> Re: enable_incremental_sort changes query behavior 2020-10-02 14:32 UTC Tomas Vondra <[email protected]> Re: enable_incremental_sort changes query behavior 2020-10-01 22:08 UTC Tomas Vondra <[email protected]> Re: WIP: BRIN multi-range indexes 2020-10-01 18:41 UTC Tomas Vondra <[email protected]> Re: WIP: BRIN multi-range indexes 2020-09-29 02:12 UTC Tomas Vondra <[email protected]> Re: WIP: BRIN multi-range indexes 2020-09-24 23:50 UTC Tomas Vondra <[email protected]> Re: WIP: BRIN multi-range indexes 2020-09-21 19:56 UTC Tomas Vondra <[email protected]> Re: Planner, check if can use consider HASH for groupings (src/backend/optimizer/plan/planner.c) 2020-09-21 17:24 UTC Tomas Vondra <[email protected]> Re: Planner, check if can use consider HASH for groupings (src/backend/optimizer/plan/planner.c) 2020-09-21 16:36 UTC Tomas Vondra <[email protected]> Re: Planner, check if can use consider HASH for groupings (src/backend/optimizer/plan/planner.c) 2020-09-21 00:10 UTC Tomas Vondra <[email protected]> Re: WIP: BRIN multi-range indexes 2020-09-18 22:27 UTC Tomas Vondra <[email protected]> Re: Dynamic gathering the values for seq_page_cost/xxx_cost 2020-09-18 13:50 UTC Tomas Vondra <[email protected]> Re: Planner, check if can use consider HASH for groupings (src/backend/optimizer/plan/planner.c) 2020-09-18 13:37 UTC Tomas Vondra <[email protected]> Re: WIP: BRIN multi-range indexes 2020-09-18 11:40 UTC Tomas Vondra <[email protected]> Re: WIP: BRIN multi-range indexes 2020-09-18 11:38 UTC Tomas Vondra <[email protected]> Re: Planner, check if can use consider HASH for groupings (src/backend/optimizer/plan/planner.c) 2020-09-17 20:09 UTC Tomas Vondra <[email protected]> Re: WIP: BRIN multi-range indexes 2020-09-17 19:19 UTC Tomas Vondra <[email protected]> Re: WIP: BRIN multi-range indexes 2020-09-17 16:34 UTC Tomas Vondra <[email protected]> Re: Use incremental sort paths for window functions 2020-09-14 17:18 UTC Tomas Vondra <[email protected]> Re: WIP: BRIN multi-range indexes 2020-09-13 16:40 UTC Tomas Vondra <[email protected]> Re: WIP: BRIN multi-range indexes 2020-09-12 16:13 UTC Tomas Vondra <[email protected]> Re: WIP: BRIN multi-range indexes 2020-09-11 18:05 UTC Tomas Vondra <[email protected]> Re: WIP: BRIN multi-range indexes 2020-09-11 10:14 UTC Tomas Vondra <[email protected]> Re: WIP: BRIN multi-range indexes 2020-09-10 18:32 UTC Tomas Vondra <[email protected]> Re: WIP: BRIN multi-range indexes 2020-09-09 20:26 UTC Tomas Vondra <[email protected]> Re: WIP: BRIN multi-range indexes 2020-09-09 19:35 UTC Tomas Vondra <[email protected]> Re: WIP: BRIN multi-range indexes 2020-09-09 18:06 UTC Tomas Vondra <[email protected]> Re: Inconsistency in determining the timestamp of the db statfile. 2020-09-09 13:56 UTC Tomas Vondra <[email protected]> Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions 2020-09-09 08:43 UTC Tomas Vondra <[email protected]> Re: WIP: WAL prefetch (another approach) 2020-09-08 23:16 UTC Tomas Vondra <[email protected]> Re: Ideas about a better API for postgres_fdw remote estimates 2020-09-08 21:05 UTC Tomas Vondra <[email protected]> Re: Disk-based hash aggregate's cost model 2020-09-08 14:06 UTC Tomas Vondra <[email protected]> Re: Disk-based hash aggregate's cost model 2020-09-06 21:21 UTC Tomas Vondra <[email protected]> Re: WIP: BRIN multi-range indexes 2020-09-05 23:20 UTC Tomas Vondra <[email protected]> Re: Disk-based hash aggregate's cost model 2020-09-04 19:01 UTC Tomas Vondra <[email protected]> Re: Ideas about a better API for postgres_fdw remote estimates 2020-09-04 14:57 UTC Tomas Vondra <[email protected]> Re: Disk-based hash aggregate's cost model 2020-09-04 12:56 UTC Tomas Vondra <[email protected]> Re: Get memory contexts of an arbitrary backend process 2020-09-04 12:46 UTC Tomas Vondra <[email protected]> Re: Division in dynahash.c due to HASH_FFACTOR 2020-09-04 12:04 UTC Tomas Vondra <[email protected]> Re: Group by reordering optimization 2020-09-02 16:12 UTC Tomas Vondra <[email protected]> Re: v13: show extended stats target in \d 2020-09-01 21:22 UTC Tomas Vondra <[email protected]> Re: Disk-based hash aggregate's cost model 2020-09-01 21:19 UTC Tomas Vondra <[email protected]> Re: Group by reordering optimization 2020-09-01 21:08 UTC Tomas Vondra <[email protected]> Re: WIP: WAL prefetch (another approach) 2020-09-01 14:18 UTC Tomas Vondra <[email protected]> Re: WIP: WAL prefetch (another approach) 2020-09-01 13:14 UTC Tomas Vondra <[email protected]> Re: Disk-based hash aggregate's cost model 2020-09-01 09:19 UTC Tomas Vondra <[email protected]> Re: list of extended statistics on psql 2020-08-31 16:32 UTC Tomas Vondra <[email protected]> Re: list of extended statistics on psql 2020-08-31 15:30 UTC Tomas Vondra <[email protected]> Re: list of extended statistics on psql 2020-08-31 15:20 UTC Tomas Vondra <[email protected]> Re: list of extended statistics on psql 2020-08-30 16:48 UTC Tomas Vondra <[email protected]> Re: Disk-based hash aggregate's cost model 2020-08-30 15:03 UTC Tomas Vondra <[email protected]> Re: Disk-based hash aggregate's cost model 2020-08-30 00:26 UTC Tomas Vondra <[email protected]> Re: list of extended statistics on psql 2020-08-29 22:54 UTC Tomas Vondra <[email protected]> Re: [EXTERNAL] Re: WIP: WAL prefetch (another approach) 2020-08-29 22:14 UTC Tomas Vondra <[email protected]> Re: list of extended statistics on psql 2020-08-29 21:54 UTC Tomas Vondra <[email protected]> Re: list of extended statistics on psql 2020-08-29 21:47 UTC Tomas Vondra <[email protected]> Re: Fix a couple of misuages of bms_num_members() 2020-08-25 13:18 UTC Tomas Vondra <[email protected]> Re: WIP: BRIN multi-range indexes 2020-08-07 16:27 UTC Tomas Vondra <[email protected]> Re: [Patch] Optimize dropping of relation buffers using dlist 2020-08-07 12:20 UTC Tomas Vondra <[email protected]> Re: [Patch] Optimize dropping of relation buffers using dlist 2020-08-06 21:33 UTC Tomas Vondra <[email protected]> Re: WIP: WAL prefetch (another approach) 2020-08-06 10:47 UTC Tomas Vondra <[email protected]> Re: LSM tree for Postgres 2020-08-04 17:44 UTC Tomas Vondra <[email protected]> Re: Parallel copy 2020-08-04 16:21 UTC Tomas Vondra <[email protected]> Re: WIP: BRIN multi-range indexes 2020-08-04 15:17 UTC Tomas Vondra <[email protected]> Re: LSM tree for Postgres 2020-08-04 15:11 UTC Tomas Vondra <[email protected]> Re: WIP: WAL prefetch (another approach) 2020-08-03 15:46 UTC Tomas Vondra <[email protected]> Re: HyperLogLog.c and pg_leftmost_one_pos32() 2020-07-30 17:16 UTC Tomas Vondra <[email protected]> Re: Default setting for enable_hashagg_disk 2020-07-26 18:34 UTC Tomas Vondra <[email protected]> Re: Default setting for enable_hashagg_disk 2020-07-26 00:05 UTC Tomas Vondra <[email protected]> Re: Default setting for enable_hashagg_disk 2020-07-24 19:16 UTC Tomas Vondra <[email protected]> Re: Default setting for enable_hashagg_disk 2020-07-24 16:01 UTC Tomas Vondra <[email protected]> Re: Default setting for enable_hashagg_disk 2020-07-24 13:18 UTC Tomas Vondra <[email protected]> Re: Default setting for enable_hashagg_disk 2020-07-24 08:40 UTC Tomas Vondra <[email protected]> Re: Default setting for enable_hashagg_disk 2020-07-24 01:22 UTC Tomas Vondra <[email protected]> Re: Default setting for enable_hashagg_disk 2020-07-20 17:25 UTC Tomas Vondra <[email protected]> Re: Default setting for enable_hashagg_disk 2020-07-20 00:48 UTC Tomas Vondra <[email protected]> Re: WIP: BRIN multi-range indexes 2020-07-19 15:19 UTC Tomas Vondra <[email protected]> Re: WIP: BRIN multi-range indexes 2020-07-13 14:58 UTC Tomas Vondra <[email protected]> Re: Default setting for enable_hashagg_disk 2020-07-13 14:11 UTC Tomas Vondra <[email protected]> Re: WIP: BRIN multi-range indexes 2020-07-13 00:14 UTC Tomas Vondra <[email protected]> Re: Default setting for enable_hashagg_disk 2020-07-12 12:36 UTC Tomas Vondra <[email protected]> Re: Default setting for enable_hashagg_disk 2020-07-12 12:30 UTC Tomas Vondra <[email protected]> Re: Default setting for enable_hashagg_disk 2020-07-12 00:30 UTC Tomas Vondra <[email protected]> Re: POC: postgres_fdw insert batching 2020-07-12 00:11 UTC Tomas Vondra <[email protected]> Re: WIP: BRIN multi-range indexes 2020-07-11 23:30 UTC Tomas Vondra <[email protected]> Re: Default setting for enable_hashagg_disk 2020-07-11 23:23 UTC Tomas Vondra <[email protected]> Re: WIP: BRIN multi-range indexes 2020-07-11 11:24 UTC Tomas Vondra <[email protected]> Re: WIP: BRIN multi-range indexes 2020-07-10 12:09 UTC Tomas Vondra <[email protected]> Re: Additional improvements to extended statistics 2020-07-03 01:10 UTC Tomas Vondra <[email protected]> Re: WIP: BRIN multi-range indexes 2020-07-03 00:57 UTC Tomas Vondra <[email protected]> Re: why do we allow people to create a publication before setting wal_leve 2020-07-02 23:58 UTC Tomas Vondra <[email protected]> Re: POC: postgres_fdw insert batching 2020-06-30 16:53 UTC Tomas Vondra <[email protected]> Re: Default setting for enable_hashagg_disk 2020-06-29 21:33 UTC Tomas Vondra <[email protected]> Re: Default setting for enable_hashagg_disk 2020-06-29 21:22 UTC Tomas Vondra <[email protected]> Re: Default setting for enable_hashagg_disk 2020-06-29 15:06 UTC Tomas Vondra <[email protected]> POC: postgres_fdw insert batching 2020-06-28 15:10 UTC Tomas Vondra <[email protected]> Re: Default setting for enable_hashagg_disk 2020-06-27 10:41 UTC Tomas Vondra <[email protected]> Re: Default setting for enable_hashagg_disk 2020-06-26 23:58 UTC Tomas Vondra <[email protected]> Re: Default setting for enable_hashagg_disk 2020-06-26 17:45 UTC Tomas Vondra <[email protected]> Re: Default setting for enable_hashagg_disk 2020-06-26 14:44 UTC Tomas Vondra <[email protected]> Re: Avoiding hash join batch explosions with extreme skew and weird stats 2020-06-26 00:22 UTC Tomas Vondra <[email protected]> Re: Default setting for enable_hashagg_disk 2020-06-25 23:53 UTC Tomas Vondra <[email protected]> Re: Default setting for enable_hashagg_disk 2020-06-25 23:23 UTC Tomas Vondra <[email protected]> Re: Default setting for enable_hashagg_disk 2020-06-25 23:18 UTC Tomas Vondra <[email protected]> Re: Default setting for enable_hashagg_disk 2020-06-25 23:11 UTC Tomas Vondra <[email protected]> Re: hashagg slowdown due to spill changes 2020-06-25 09:10 UTC Tomas Vondra <[email protected]> Re: Default setting for enable_hashagg_disk 2020-06-24 21:02 UTC Tomas Vondra <[email protected]> Re: Default setting for enable_hashagg_disk 2020-06-24 18:32 UTC Tomas Vondra <[email protected]> Re: Avoiding hash join batch explosions with extreme skew and weird stats 2020-06-23 22:24 UTC Tomas Vondra <[email protected]> Re: [PATCH] Initial progress reporting for COPY command 2020-06-23 11:15 UTC Tomas Vondra <[email protected]> Re: Resetting spilled txn statistics in pg_stat_replication 2020-06-23 10:18 UTC Tomas Vondra <[email protected]> Re: POC: GROUP BY optimization 2020-06-22 22:25 UTC Tomas Vondra <[email protected]> Re: suggest to rename enable_incrementalsort 2020-06-22 14:31 UTC Tomas Vondra <[email protected]> Re: [PATCH] Initial progress reporting for COPY command 2020-06-22 14:19 UTC Tomas Vondra <[email protected]> Re: [PATCH] Initial progress reporting for COPY command 2020-06-22 12:14 UTC Tomas Vondra <[email protected]> Re: suggest to rename enable_incrementalsort 2020-06-21 11:21 UTC Tomas Vondra <[email protected]> Re: Improve planner cost estimations for alternative subplans 2020-06-20 23:30 UTC Tomas Vondra <[email protected]> Re: Resetting spilled txn statistics in pg_stat_replication 2020-06-20 21:57 UTC Tomas Vondra <[email protected]> Re: Resetting spilled txn statistics in pg_stat_replication 2020-06-20 21:48 UTC Tomas Vondra <[email protected]> Re: POC: GROUP BY optimization 2020-06-20 18:23 UTC Tomas Vondra <[email protected]> Re: compile cube extension with float4 precision storing 2020-06-19 17:30 UTC Tomas Vondra <[email protected]> Re: Failures with installcheck and low work_mem value in 13~ 2020-06-19 17:08 UTC Tomas Vondra <[email protected]> Re: Failures with installcheck and low work_mem value in 13~ 2020-06-19 17:05 UTC Tomas Vondra <[email protected]> Re: hash as an search key and hash collision 2020-06-19 16:34 UTC Tomas Vondra <[email protected]> Re: hashagg slowdown due to spill changes 2020-06-16 16:54 UTC Tomas Vondra <[email protected]> Re: hashagg slowdown due to spill changes 2020-06-15 13:34 UTC Tomas Vondra <[email protected]> Re: hashagg slowdown due to spill changes 2020-06-13 20:19 UTC Tomas Vondra <[email protected]> Re: hashagg slowdown due to spill changes 2020-06-12 23:06 UTC Tomas Vondra <[email protected]> Re: Bump default wal_level to logical 2020-06-08 13:38 UTC Tomas Vondra <[email protected]> Re: Trouble with hashagg spill I/O pattern and costing 2020-06-05 23:17 UTC Tomas Vondra <[email protected]> Re: WIP: WAL prefetch (another approach) 2020-06-05 22:34 UTC Tomas Vondra <[email protected]> 200+ results
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox