public inbox for [email protected]help / color / mirror / Atom feed
Messages from [email protected] Re: Parallel safety docs for CTEs 2025-03-12 17:11 UTC James Coleman <[email protected]> Idea: lock_timeout scoped by lock types 2025-01-29 19:54 UTC James Coleman <[email protected]> Re: Question about behavior of deletes with REPLICA IDENTITY NOTHING 2024-12-17 15:50 UTC James Coleman <[email protected]> Parallel safety docs for CTEs 2024-11-19 19:16 UTC James Coleman <[email protected]> Re: Seq scan instead of index scan querying single row from primary key on large table 2024-07-18 19:18 UTC James Coleman <[email protected]> Seq scan instead of index scan querying single row from primary key on large table 2024-07-18 18:10 UTC James Coleman <[email protected]> Re: Should we document how column DEFAULT expressions work? 2024-07-01 13:37 UTC James Coleman <[email protected]> Re: Should we document how column DEFAULT expressions work? 2024-06-25 23:05 UTC James Coleman <[email protected]> Should we document how column DEFAULT expressions work? 2024-06-25 20:51 UTC James Coleman <[email protected]> Re: Fix grammar oddities in comments 2024-06-10 12:28 UTC James Coleman <[email protected]> Fix grammar oddities in comments 2024-06-01 22:08 UTC James Coleman <[email protected]> Re: Add last_commit_lsn to pg_stat_database 2024-05-28 15:45 UTC James Coleman <[email protected]> Re: Add last_commit_lsn to pg_stat_database 2024-05-28 15:11 UTC James Coleman <[email protected]> Re: commitfest.postgresql.org is no longer fit for purpose 2024-05-28 14:51 UTC James Coleman <[email protected]> Re: commitfest.postgresql.org is no longer fit for purpose 2024-05-28 14:38 UTC James Coleman <[email protected]> Re: Teach predtest about IS [NOT] <boolean> proofs 2024-04-06 00:43 UTC James Coleman <[email protected]> Re: Teach predtest about IS [NOT] <boolean> proofs 2024-04-01 12:06 UTC James Coleman <[email protected]> Re: Teach predtest about IS [NOT] <boolean> proofs 2024-04-01 12:05 UTC James Coleman <[email protected]> Re: [DOCS] HOT - correct claim about indexes not referencing old line pointers 2024-03-23 21:43 UTC James Coleman <[email protected]> Re: [DOCS] HOT - correct claim about indexes not referencing old line pointers 2024-03-23 21:42 UTC James Coleman <[email protected]> Re: [DOCS] HOT - correct claim about indexes not referencing old line pointers 2024-03-15 01:06 UTC James Coleman <[email protected]> Re: RFC: Logging plan of the running query 2024-03-02 15:46 UTC James Coleman <[email protected]> Re: RFC: Logging plan of the running query 2024-02-24 13:56 UTC James Coleman <[email protected]> Re: RFC: Logging plan of the running query 2024-02-22 00:54 UTC James Coleman <[email protected]> Re: Question about behavior of deletes with REPLICA IDENTITY NOTHING 2024-02-08 13:54 UTC James Coleman <[email protected]> Re: Question about behavior of deletes with REPLICA IDENTITY NOTHING 2024-02-08 13:53 UTC James Coleman <[email protected]> Re: Question about behavior of deletes with REPLICA IDENTITY NOTHING 2024-02-08 00:12 UTC James Coleman <[email protected]> Re: Question about behavior of deletes with REPLICA IDENTITY NOTHING 2024-02-07 22:03 UTC James Coleman <[email protected]> Question about behavior of deletes with REPLICA IDENTITY NOTHING 2024-02-07 20:12 UTC James Coleman <[email protected]> Re: set_cheapest without checking pathlist 2024-02-02 02:06 UTC James Coleman <[email protected]> Re: Parallelize correlated subqueries that execute within each worker 2024-02-01 02:11 UTC James Coleman <[email protected]> set_cheapest without checking pathlist 2024-02-01 02:04 UTC James Coleman <[email protected]> Re: Parallelize correlated subqueries that execute within each worker 2024-01-31 13:53 UTC James Coleman <[email protected]> Re: Parallelize correlated subqueries that execute within each worker 2024-01-31 02:56 UTC James Coleman <[email protected]> Re: Parallelize correlated subqueries that execute within each worker 2024-01-31 02:51 UTC James Coleman <[email protected]> Re: Opportunistically pruning page before update 2024-01-30 02:39 UTC James Coleman <[email protected]> Re: Opportunistically pruning page before update 2024-01-27 01:33 UTC James Coleman <[email protected]> Re: Teach predtest about IS [NOT] <boolean> proofs 2024-01-25 01:08 UTC James Coleman <[email protected]> Re: Opportunistically pruning page before update 2024-01-23 01:47 UTC James Coleman <[email protected]> Re: Opportunistically pruning page before update 2024-01-23 01:21 UTC James Coleman <[email protected]> Re: Add last_commit_lsn to pg_stat_database 2024-01-23 00:29 UTC James Coleman <[email protected]> Re: PG12 change to DO UPDATE SET column references 2024-01-21 00:12 UTC James Coleman <[email protected]> Re: PG12 change to DO UPDATE SET column references 2024-01-20 21:45 UTC James Coleman <[email protected]> Re: PG12 change to DO UPDATE SET column references 2024-01-20 17:51 UTC James Coleman <[email protected]> Re: PG12 change to DO UPDATE SET column references 2024-01-20 14:10 UTC James Coleman <[email protected]> PG12 change to DO UPDATE SET column references 2024-01-19 17:00 UTC James Coleman <[email protected]> Re: Add last_commit_lsn to pg_stat_database 2024-01-18 02:12 UTC James Coleman <[email protected]> Re: Add last_commit_lsn to pg_stat_database 2024-01-18 02:11 UTC James Coleman <[email protected]> Re: Teach predtest about IS [NOT] <boolean> proofs 2024-01-18 00:34 UTC James Coleman <[email protected]> Re: Teach predtest about IS [NOT] <boolean> proofs 2023-12-22 15:00 UTC James Coleman <[email protected]> Re: Teach predtest about IS [NOT] <boolean> proofs 2023-12-14 00:35 UTC James Coleman <[email protected]> Teach predtest about IS [NOT] <boolean> proofs 2023-12-11 19:59 UTC James Coleman <[email protected]> Re: RFC: Logging plan of the running query 2023-10-18 16:34 UTC James Coleman <[email protected]> Re: RFC: Logging plan of the running query 2023-10-06 13:10 UTC James Coleman <[email protected]> Re: Opportunistically pruning page before update 2023-10-06 13:08 UTC James Coleman <[email protected]> Re: [DOCS] HOT - correct claim about indexes not referencing old line pointers 2023-10-05 01:12 UTC James Coleman <[email protected]> Re: Opportunistically pruning page before update 2023-10-04 21:01 UTC James Coleman <[email protected]> Re: [DOCS] HOT - correct claim about indexes not referencing old line pointers 2023-10-04 13:35 UTC James Coleman <[email protected]> Re: [DOCS] HOT - correct claim about indexes not referencing old line pointers 2023-10-03 19:35 UTC James Coleman <[email protected]> Re: RFC: Logging plan of the running query 2023-10-03 18:00 UTC James Coleman <[email protected]> Re: [DOCS] HOT - correct claim about indexes not referencing old line pointers 2023-09-30 01:27 UTC James Coleman <[email protected]> Re: [DOCS] HOT - correct claim about indexes not referencing old line pointers 2023-09-29 18:45 UTC James Coleman <[email protected]> Re: Fix incorrect comment reference 2023-09-29 18:38 UTC James Coleman <[email protected]> [DOCS] HOT - correct claim about indexes not referencing old line pointers 2023-09-29 17:39 UTC James Coleman <[email protected]> Re: Opportunistically pruning page before update 2023-09-26 12:30 UTC James Coleman <[email protected]> Re: RFC: Logging plan of the running query 2023-09-06 02:17 UTC James Coleman <[email protected]> Re: RFC: Logging plan of the running query 2023-08-28 13:47 UTC James Coleman <[email protected]> Re: RFC: Logging plan of the running query 2023-08-26 12:03 UTC James Coleman <[email protected]> Re: RFC: Logging plan of the running query 2023-08-25 11:43 UTC James Coleman <[email protected]> Re: pgindent (probably my missing something obvious) 2023-07-04 01:41 UTC James Coleman <[email protected]> Re: Parallelize correlated subqueries that execute within each worker 2023-07-04 01:26 UTC James Coleman <[email protected]> pgindent (probably my missing something obvious) 2023-07-04 01:12 UTC James Coleman <[email protected]> Re: Analyze on table creation? 2023-06-27 14:14 UTC James Coleman <[email protected]> Re: Analyze on table creation? 2023-06-26 20:16 UTC James Coleman <[email protected]> Re: Analyze on table creation? 2023-06-26 18:59 UTC James Coleman <[email protected]> Re: Analyze on table creation? 2023-06-26 17:48 UTC James Coleman <[email protected]> Analyze on table creation? 2023-06-26 17:40 UTC James Coleman <[email protected]> Re: Stampede of the JIT compilers 2023-06-25 19:21 UTC James Coleman <[email protected]> Re: Stampede of the JIT compilers 2023-06-25 02:27 UTC James Coleman <[email protected]> Re: Stampede of the JIT compilers 2023-06-25 02:24 UTC James Coleman <[email protected]> Re: Stampede of the JIT compilers 2023-06-24 17:12 UTC James Coleman <[email protected]> Stampede of the JIT compilers 2023-06-23 14:27 UTC James Coleman <[email protected]> Re: Memory leak in incremental sort re-scan 2023-06-21 18:54 UTC James Coleman <[email protected]> Re: Use of additional index columns in rows filtering 2023-06-21 16:17 UTC James Coleman <[email protected]> Opportunistically pruning page before update 2023-06-21 12:51 UTC James Coleman <[email protected]> Re: Use of additional index columns in rows filtering 2023-06-21 12:45 UTC James Coleman <[email protected]> Re: path->param_info only set for lateral? 2023-06-21 00:55 UTC James Coleman <[email protected]> path->param_info only set for lateral? 2023-06-19 02:36 UTC James Coleman <[email protected]> Re: RFC: Logging plan of the running query 2023-06-15 16:34 UTC James Coleman <[email protected]> Re: RFC: Logging plan of the running query 2023-06-14 16:48 UTC James Coleman <[email protected]> Re: RFC: Logging plan of the running query 2023-06-13 15:53 UTC James Coleman <[email protected]> Re: RFC: Logging plan of the running query 2023-06-12 15:52 UTC James Coleman <[email protected]> Re: Parallelize correlated subqueries that execute within each worker 2023-06-12 02:23 UTC James Coleman <[email protected]> Add last_commit_lsn to pg_stat_database 2023-06-10 02:26 UTC James Coleman <[email protected]> Re: RFC: Logging plan of the running query 2023-06-05 18:26 UTC James Coleman <[email protected]> Re: RFC: Logging plan of the running query 2023-06-02 17:51 UTC James Coleman <[email protected]> Re: An inefficient query caused by unnecessary PlaceHolderVar 2023-06-01 17:33 UTC James Coleman <[email protected]> Re: An inefficient query caused by unnecessary PlaceHolderVar 2023-05-30 17:26 UTC James Coleman <[email protected]> Re: pg_rewind: warn when checkpoint hasn't happened after promotion 2023-02-28 12:37 UTC James Coleman <[email protected]> Re: Parallelize correlated subqueries that execute within each worker 2023-02-08 13:38 UTC James Coleman <[email protected]> Re: Fix incorrect comment reference 2023-01-23 23:42 UTC James Coleman <[email protected]> Re: Fix incorrect comment reference 2023-01-23 21:07 UTC James Coleman <[email protected]> Re: Fix incorrect comment reference 2023-01-23 20:19 UTC James Coleman <[email protected]> Re: Parallelize correlated subqueries that execute within each worker 2023-01-23 14:00 UTC James Coleman <[email protected]> Fix incorrect comment reference 2023-01-23 13:31 UTC James Coleman <[email protected]> Re: Parallelize correlated subqueries that execute within each worker 2023-01-22 03:07 UTC James Coleman <[email protected]> Re: Parallelize correlated subqueries that execute within each worker 2023-01-19 02:34 UTC James Coleman <[email protected]> Re: Commit fest 2022-11 2022-11-14 13:23 UTC James Coleman <[email protected]> Re: cirrus-ci cross-build interactions? 2022-09-27 02:58 UTC James Coleman <[email protected]> Re: Parallelize correlated subqueries that execute within each worker 2022-09-27 02:56 UTC James Coleman <[email protected]> Re: cirrus-ci cross-build interactions? 2022-09-27 02:43 UTC James Coleman <[email protected]> cirrus-ci cross-build interactions? 2022-09-27 02:36 UTC James Coleman <[email protected]> Add hint about downloadable logs to CI README 2022-09-27 02:08 UTC James Coleman <[email protected]> Re: Allow foreign keys to reference a superset of unique columns 2022-09-26 17:11 UTC James Coleman <[email protected]> Re: Allow foreign keys to reference a superset of unique columns 2022-09-26 17:08 UTC James Coleman <[email protected]> Re: Consider parallel for lateral subqueries with limit 2022-09-26 15:17 UTC James Coleman <[email protected]> Re: Allow foreign keys to reference a superset of unique columns 2022-09-26 12:37 UTC James Coleman <[email protected]> Re: Allow foreign keys to reference a superset of unique columns 2022-09-26 02:00 UTC James Coleman <[email protected]> Re: Allow foreign keys to reference a superset of unique columns 2022-09-25 19:28 UTC James Coleman <[email protected]> Re: Allow foreign keys to reference a superset of unique columns 2022-09-25 01:34 UTC James Coleman <[email protected]> Re: Consider parallel for lateral subqueries with limit 2022-09-25 00:35 UTC James Coleman <[email protected]> Re: Consider parallel for lateral subqueries with limit 2022-09-22 21:19 UTC James Coleman <[email protected]> Re: Support pg_attribute_aligned and noreturn in MSVC 2022-09-21 12:21 UTC James Coleman <[email protected]> Re: Auto explain after query timeout 2022-09-20 21:08 UTC James Coleman <[email protected]> Re: Auto explain after query timeout 2022-09-20 18:34 UTC James Coleman <[email protected]> Auto explain after query timeout 2022-09-20 17:34 UTC James Coleman <[email protected]> Re: Support pg_attribute_aligned and noreturn in MSVC 2022-09-20 12:01 UTC James Coleman <[email protected]> Re: Support pg_attribute_aligned and noreturn in MSVC 2022-09-20 00:51 UTC James Coleman <[email protected]> Support pg_attribute_aligned and noreturn in MSVC 2022-09-19 22:21 UTC James Coleman <[email protected]> Re: Consider parallel for lateral subqueries with limit 2022-09-19 19:58 UTC James Coleman <[email protected]> Fix comment in convert_saop_to_hashed_saop 2022-09-14 16:07 UTC James Coleman <[email protected]> Re: Fix broken link to FreeBSD DocProj in docs 2022-09-13 11:36 UTC James Coleman <[email protected]> Fix broken link to FreeBSD DocProj in docs 2022-09-12 16:13 UTC James Coleman <[email protected]> Re: [Commitfest 2022-07] Patch Triage: Waiting on Author 2022-07-26 23:47 UTC James Coleman <[email protected]> Re: pg_rewind: warn when checkpoint hasn't happened after promotion 2022-07-05 18:46 UTC James Coleman <[email protected]> Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size 2022-06-17 12:33 UTC James Coleman <[email protected]> Re: pg_rewind: warn when checkpoint hasn't happened after promotion 2022-06-06 12:32 UTC James Coleman <[email protected]> Re: pg_rewind: warn when checkpoint hasn't happened after promotion 2022-06-06 12:10 UTC James Coleman <[email protected]> pg_rewind: warn when checkpoint hasn't happened after promotion 2022-06-04 12:59 UTC James Coleman <[email protected]> Re: Restructure ALTER TABLE notes to clarify table rewrites and verification scans 2022-04-01 14:10 UTC James Coleman <[email protected]> Re: Correct docs re: rewriting indexes when table rewrite is skipped 2022-04-01 13:01 UTC James Coleman <[email protected]> Re: Correct docs re: rewriting indexes when table rewrite is skipped 2022-03-31 20:19 UTC James Coleman <[email protected]> Re: Correct docs re: rewriting indexes when table rewrite is skipped 2022-03-31 14:51 UTC James Coleman <[email protected]> Re: Correct docs re: rewriting indexes when table rewrite is skipped 2022-03-31 14:13 UTC James Coleman <[email protected]> Re: Correct docs re: rewriting indexes when table rewrite is skipped 2022-03-31 13:17 UTC James Coleman <[email protected]> Re: Correct docs re: rewriting indexes when table rewrite is skipped 2022-03-30 20:33 UTC James Coleman <[email protected]> Re: Correct docs re: rewriting indexes when table rewrite is skipped 2022-03-30 14:04 UTC James Coleman <[email protected]> Restructure ALTER TABLE notes to clarify table rewrites and verification scans 2022-03-29 14:20 UTC James Coleman <[email protected]> Correct docs re: rewriting indexes when table rewrite is skipped 2022-03-29 14:03 UTC James Coleman <[email protected]> Re: Document atthasmissing default optimization avoids verification table scan 2022-03-29 13:53 UTC James Coleman <[email protected]> Re: Document atthasmissing default optimization avoids verification table scan 2022-03-28 13:54 UTC James Coleman <[email protected]> Re: Document atthasmissing default optimization avoids verification table scan 2022-03-27 18:17 UTC James Coleman <[email protected]> Re: Document atthasmissing default optimization avoids verification table scan 2022-03-27 17:00 UTC James Coleman <[email protected]> Re: Document atthasmissing default optimization avoids verification table scan 2022-03-26 22:29 UTC James Coleman <[email protected]> Re: Document atthasmissing default optimization avoids verification table scan 2022-03-26 22:25 UTC James Coleman <[email protected]> Re: Synchronizing slots from primary to standby 2022-02-23 19:16 UTC James Coleman <[email protected]> Re: Synchronizing slots from primary to standby 2022-02-18 21:46 UTC James Coleman <[email protected]> Re: Synchronizing slots from primary to standby 2022-02-18 15:25 UTC James Coleman <[email protected]> Re: Add last commit LSN to pg_last_committed_xact() 2022-01-29 19:51 UTC James Coleman <[email protected]> Re: Add last commit LSN to pg_last_committed_xact() 2022-01-28 23:43 UTC James Coleman <[email protected]> Re: Document atthasmissing default optimization avoids verification table scan 2022-01-25 13:48 UTC James Coleman <[email protected]> Re: Parallelize correlated subqueries that execute within each worker 2022-01-23 01:25 UTC James Coleman <[email protected]> Re: Document atthasmissing default optimization avoids verification table scan 2022-01-22 13:18 UTC James Coleman <[email protected]> Re: Document atthasmissing default optimization avoids verification table scan 2022-01-22 00:14 UTC James Coleman <[email protected]> Re: Document atthasmissing default optimization avoids verification table scan 2022-01-21 23:29 UTC James Coleman <[email protected]> Re: Document atthasmissing default optimization avoids verification table scan 2022-01-21 18:55 UTC James Coleman <[email protected]> Re: Document atthasmissing default optimization avoids verification table scan 2022-01-20 20:43 UTC James Coleman <[email protected]> Re: Document atthasmissing default optimization avoids verification table scan 2022-01-20 14:05 UTC James Coleman <[email protected]> Re: Add last commit LSN to pg_last_committed_xact() 2022-01-20 13:15 UTC James Coleman <[email protected]> Re: Add last commit LSN to pg_last_committed_xact() 2022-01-20 02:23 UTC James Coleman <[email protected]> Re: Document atthasmissing default optimization avoids verification table scan 2022-01-20 01:14 UTC James Coleman <[email protected]> Re: Add last commit LSN to pg_last_committed_xact() 2022-01-19 01:58 UTC James Coleman <[email protected]> Re: Add last commit LSN to pg_last_committed_xact() 2022-01-19 01:32 UTC James Coleman <[email protected]> Re: Add last commit LSN to pg_last_committed_xact() 2022-01-18 23:31 UTC James Coleman <[email protected]> Re: Add last commit LSN to pg_last_committed_xact() 2022-01-18 21:40 UTC James Coleman <[email protected]> Re: Add last commit LSN to pg_last_committed_xact() 2022-01-18 18:55 UTC James Coleman <[email protected]> Re: Add last commit LSN to pg_last_committed_xact() 2022-01-18 18:41 UTC James Coleman <[email protected]> Re: Add last commit LSN to pg_last_committed_xact() 2022-01-18 14:47 UTC James Coleman <[email protected]> Re: Add last commit LSN to pg_last_committed_xact() 2022-01-18 01:41 UTC James Coleman <[email protected]> Re: Add last commit LSN to pg_last_committed_xact() 2022-01-18 01:39 UTC James Coleman <[email protected]> Add last commit LSN to pg_last_committed_xact() 2022-01-15 00:42 UTC James Coleman <[email protected]> Re: Parallelize correlated subqueries that execute within each worker 2022-01-14 19:24 UTC James Coleman <[email protected]> Re: Parallelize correlated subqueries that execute within each worker 2022-01-14 19:15 UTC James Coleman <[email protected]> Re: Consider parallel for lateral subqueries with limit 2022-01-13 23:26 UTC James Coleman <[email protected]> Re: Consider parallel for lateral subqueries with limit 2022-01-05 02:59 UTC James Coleman <[email protected]> Re: Parallelize correlated subqueries that execute within each worker 2021-11-03 17:34 UTC James Coleman <[email protected]> Re: Consider parallel for lateral subqueries with limit 2021-11-03 13:49 UTC James Coleman <[email protected]> Re: Parallelize correlated subqueries that execute within each worker 2021-11-03 13:46 UTC James Coleman <[email protected]> Re: Document spaces in .pgpass need to be escaped 2021-09-30 17:37 UTC James Coleman <[email protected]> Document spaces in .pgpass need to be escaped 2021-09-28 14:17 UTC James Coleman <[email protected]> Document atthasmissing default optimization avoids verification table scan 2021-09-24 14:30 UTC James Coleman <[email protected]> Re: Parallelize correlated subqueries that execute within each worker 2021-09-08 12:47 UTC James Coleman <[email protected]> Re: Parallelize correlated subqueries that execute within each worker 2021-09-07 13:16 UTC James Coleman <[email protected]> Re: [PATCH] Use optimized single-datum tuplesort in ExecSort 2021-07-21 01:39 UTC James Coleman <[email protected]> Re: [PATCH] Use optimized single-datum tuplesort in ExecSort 2021-07-19 13:10 UTC James Coleman <[email protected]> Re: Consider parallel for lateral subqueries with limit 2021-07-16 19:16 UTC James Coleman <[email protected]> Re: Early Sort/Group resjunk column elimination. 2021-07-16 15:37 UTC James Coleman <[email protected]> Re: [PATCH] Use optimized single-datum tuplesort in ExecSort 2021-07-16 13:14 UTC James Coleman <[email protected]> Re: [PATCH] Use optimized single-datum tuplesort in ExecSort 2021-07-15 17:00 UTC James Coleman <[email protected]> Re: [PATCH] Use optimized single-datum tuplesort in ExecSort 2021-07-15 13:44 UTC James Coleman <[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