Horton

Jeff Janes

jeff.janes@gmail.com

Email: jeff.janes@gmail.com
Name: Jeff Janes
Messages: 2611
First message: 2009-07-29
Last message: 2025-12-08

Recent messages

DateSubject
2025-12-08T00:53:40Z Re: Seeking guidance on extremely slow pg_restore despite strong I/O performance
2025-10-26T16:47:36Z Should HashSetOp go away
2025-10-19T19:04:58Z Re: Issues with blocksize smaller than 8KB
2025-02-24T02:08:47Z Re: Unfortunate Nested Loop + Missing Autovacuum
2025-01-19T02:32:02Z Re: BUG #18779: Segmentation fault while trying to connect via psql
2025-01-07T19:30:33Z Re: Aggressive vacuum
2024-10-09T17:29:53Z incorrect wal removal due to max_slot_wal_keep_size
2024-04-29T15:26:07Z Re: Unable to connect to server
2024-04-06T23:25:08Z Re: BUG #18423: suboptimal query plan is used when ordering by an indexed field with limit
2024-01-04T02:43:15Z Re: Slow GroupAggregate and Sort
2024-01-04T01:43:21Z Re: Parallel hints in PostgreSQL with consistent perfromance
2024-01-02T19:15:52Z Re: Questions about "Output" in EXPLAIN ANALYZE VERBOSE
2023-12-29T04:55:04Z Re: Parallel hints in PostgreSQL with consistent perfromance
2023-12-28T18:06:18Z Re: Slow GroupAggregate and Sort
2023-12-27T14:41:36Z Re: Parallel hints in PostgreSQL with consistent perfromance
2023-12-04T03:15:27Z Re: Strange "actual time" in simple CTE
2023-12-04T02:46:48Z connection timeout hint
2023-11-29T02:40:27Z Re: BUG #18216: Unaccent function is unable to remove accents (diacritic signs) from Japanese character 'ド'
2023-11-10T01:44:21Z Bug with GIN index over JSONB data: "ERROR: buffer 10112 is not owned by resource owner"
2023-11-05T19:11:46Z Re: [EXTERNAL] Re: Performance down with JDBC 42
2023-10-23T14:05:01Z Re: GIN JSONB path index is not always used
2023-10-19T00:42:21Z Re: Variable substitution in jsonb functions fails for jsonpath operator like_regex
2023-10-17T17:05:42Z Re: GIN JSONB path index is not always used
2023-09-30T18:04:56Z Re: BUG #18141: sorry, too many clients error occurring very frequently
2023-09-24T20:17:45Z Re: Dirty reads on index scan,
2023-09-01T03:18:12Z Re: Index bloat and REINDEX/VACUUM optimization for partial index
2023-09-01T03:01:06Z Re: Index bloat and REINDEX/VACUUM optimization for partial index
2023-08-31T17:12:45Z Re: BUG #18078: createdb not working
2023-08-31T16:52:31Z Re: Queries containing ORDER BY and LIMIT started to work slowly
2023-08-29T20:11:39Z Re: Queries containing ORDER BY and LIMIT started to work slowly
2023-08-29T19:43:05Z Re: Index bloat and REINDEX/VACUUM optimization for partial index
2023-08-29T18:42:27Z Re: Queries containing ORDER BY and LIMIT started to work slowly
2023-08-28T15:55:52Z Re: Use FD_CLOEXEC on ListenSockets (was Re: Refactoring backend fork+exec code)
2023-08-16T14:03:49Z Re: slow delete
2023-08-04T15:07:19Z Re: Plan weirdness. A sort produces more rows than the node beneath it
2023-07-28T21:02:15Z Re: BUG #18042: Query planner favor index corresponding to a order by with a limit even when there is a where
2023-07-28T13:26:30Z Re: Question about double table scans for a table
2023-06-27T12:47:44Z Re: Helping planner to chose sequential scan when it improves performance
2023-06-25T19:34:38Z Re: Helping planner to chose sequential scan when it improves performance
2023-06-02T19:17:13Z Re: thousands of CachedPlan entry per backend
2023-05-17T23:43:47Z Re: Need Support to Upgrade from 13.6 to 15.3
2023-03-26T15:12:48Z awkward cancellation of parallel queries on standby.
2023-03-24T19:45:36Z Bug with ICU for merge join
2023-03-11T22:13:59Z Re: Planner choosing nested loop in place of Hashjoin
2023-02-21T19:08:59Z Re: Query run in 27s with 15.2 vs 37ms with 14.6
2023-02-20T19:25:39Z Re: Query run in 27s with 15.2 vs 37ms with 14.6
2023-02-15T18:36:48Z Re: Connection forcibly closed remote server error.
2023-02-13T21:49:15Z Re: Performance of UPDATE operation
2023-01-22T17:49:51Z Re: LIKE CLAUSE on VIEWS
2022-12-11T15:29:52Z Re: BUG #17711: Login failed