Horton

James Pang

jamespang886@gmail.com

Email: jamespang886@gmail.com
Name: James Pang
Messages: 58
First message: 2022-12-06
Last message: 2026-04-19

Recent messages

DateSubject
2026-04-19T07:22:51Z Re: table bloat very fast and free space can not be reused
2026-04-19T01:28:31Z table bloat very fast and free space can not be reused
2026-02-28T09:46:30Z hot standby failed in read pg_commit_ts
2026-02-28T08:26:05Z Re: Primary and standby setting cross-checks
2025-08-20T09:03:05Z Re: max_locks_per_transaction v18
2025-08-18T06:23:30Z Re: max_locks_per_transaction v18
2025-08-18T03:12:57Z max_locks_per_transaction v18
2025-06-26T08:58:27Z Re: many sessions waiting DataFileRead and extend
2025-06-26T07:22:49Z Re: many sessions waiting DataFileRead and extend
2025-06-26T06:47:56Z Re: many sessions waiting DataFileRead and extend
2025-06-26T03:48:45Z Re: many sessions waiting DataFileRead and extend
2025-06-26T02:32:50Z Re: many sessions waiting DataFileRead and extend
2025-06-25T09:10:55Z Re: many sessions waiting DataFileRead and extend
2025-06-25T03:15:08Z many sessions waiting DataFileRead and extend
2025-06-24T14:22:38Z many deletes and inserts on pg_class, total rows is 14200 rows in "pg_class", any idea why so many inserts/deletes on "pg_class" it's self?
2025-06-23T12:28:21Z Re: pgv18: simple table scan take more time than pgv14
2025-06-20T01:46:06Z pgv18: simple table scan take more time than pgv14
2025-05-15T13:43:17Z Re: a lot of session wait on lock relation
2025-05-15T13:32:38Z Re: a lot of session wait on lock relation
2025-05-15T08:27:31Z a lot of session wait on lock relation
2025-04-14T05:30:07Z session waiting IO while background writer writing data
2025-04-11T14:36:57Z many sessions wait on LWlock WALWrite suddenly
2025-04-03T12:38:49Z Re: partition table optimizer join cost misestimation
2025-04-03T00:46:28Z Re: partition table optimizer join cost misestimation
2025-04-02T10:18:57Z partition table optimizer join cost misestimation
2024-12-22T03:38:37Z Re: huge shared_blocks_hit one select but manually run very fast
2024-12-21T11:50:40Z huge shared_blocks_hit one select but manually run very fast
2024-11-21T12:13:10Z could not send data to client: Connection reset by peer
2024-10-25T07:59:26Z Re: proposal: schema variables
2024-10-25T07:58:39Z Re: proposal: schema variables
2024-10-25T06:36:26Z lwlock:LockManager wait_events
2024-09-11T07:00:38Z Re: many backends hang on MultiXactOffsetSLRU
2024-09-10T08:34:46Z Re: many backends hang on MultiXactOffsetSLRU
2024-09-10T07:33:18Z many backends hang on MultiXactOffsetSLRU
2024-07-31T06:48:43Z Re: logical replication out of memory
2024-07-31T02:30:19Z Re: logical replication out of memory
2024-07-31T02:17:41Z logical replication out of memory
2024-07-08T02:21:58Z Re: Hash Right join and seq scan
2024-07-05T14:43:06Z Re: Hash Right join and seq scan
2024-07-05T00:50:18Z Re: Hash Right join and seq scan
2024-07-03T06:53:35Z Re: Hash Right join and seq scan
2024-07-03T06:51:54Z Re: Hash Right join and seq scan
2024-07-03T04:57:08Z Hash Right join and seq scan
2024-07-01T10:58:37Z Re: a lot of shared buffers hit when planning for a simple query with primary access path
2024-07-01T09:45:29Z a lot of shared buffers hit when planning for a simple query with primary access path
2024-04-09T07:54:45Z Re: LWlock:LockManager waits
2024-04-09T03:07:49Z LWlock:LockManager waits
2024-03-15T02:03:47Z Re: FW: huge SubtransSLRU and SubtransBuffer wait_event
2024-03-01T06:56:38Z Re: FW: huge SubtransSLRU and SubtransBuffer wait_event
2024-02-29T14:27:42Z generic plan generate poor performance