Horton

Rick Otten

rottenwindfish@gmail.com

Email: rottenwindfish@gmail.com
Name: Rick Otten
Messages: 102
First message: 2015-06-22
Last message: 2026-04-20

Recent messages

DateSubject
2026-04-20T14:39:24Z Re: table bloat very fast and free space can not be reused
2026-04-06T14:12:18Z Linux 7.0 performance degradation
2024-12-09T14:25:45Z Re: PostgreSQL and a Catch-22 Issue related to dead rows
2023-08-29T21:06:54Z Re: Queries containing ORDER BY and LIMIT started to work slowly
2023-03-13T12:45:14Z Re: Huge Tables
2023-02-08T23:07:15Z max_wal_senders
2023-01-30T22:47:50Z Fwd: Database Stalls
2023-01-22T15:55:13Z Re: LIKE CLAUSE on VIEWS
2022-12-14T20:03:42Z creating hash indexes
2022-11-14T14:11:18Z Re: =ANY(ARRAY) vs =ANY(ARRAY(expr)) performance
2022-10-12T00:42:19Z Re: Identify root-cause for intermittent spikes
2022-08-12T20:17:02Z Re: to_jsonb performance on array aggregated correlated subqueries
2022-08-02T12:54:46Z Re: Postgresql 14 partitioning advice
2022-08-01T14:16:11Z Re: Postgresql 14 partitioning advice
2022-07-29T21:44:11Z Re: Postgresql 14 partitioning advice
2022-07-27T12:55:14Z Postgresql 14 partitioning advice
2022-07-17T20:39:15Z Re: data consolidation: logical replication design considerations
2021-11-15T14:17:14Z Re: postgresql13-llvm jit-13.5-1PGDG.rhel8.x86_64
2021-08-05T13:25:57Z Re: Logical Replication speed-up initial data
2021-05-07T12:50:08Z Re: Very slow Query compared to Oracle / SQL - Server
2021-05-04T12:12:38Z Re: 15x slower PreparedStatement vs raw query
2021-03-23T13:07:11Z Re: Odd (slow) plan choice with min/max
2021-03-01T14:53:49Z Re: Potential performance issues
2020-03-27T15:03:10Z Re: Best way to delete big amount of records from big table
2019-11-13T11:18:16Z Re: Slow "not in array" operation
2019-10-09T00:12:48Z Re: Would SSD improve Index Only Scan performance by a lot?
2019-09-11T17:57:25Z Re: select distinct runs slow on pg 10.6
2019-09-10T11:56:54Z Re: select distinct runs slow on pg 10.6
2019-08-01T18:27:53Z Re: PSQL performance - TPS
2019-07-29T12:35:20Z Re: High concurrency same row (inventory)
2019-07-22T12:06:09Z Re: benchmarking effective_io_concurrency
2019-06-26T12:38:46Z Re: Max_connections limit
2019-06-25T11:03:31Z Re: materialized view refresh of a foreign table
2019-06-23T14:21:40Z materialized view refresh of a foreign table
2019-04-08T12:24:39Z Re: Oracle to postgres migration
2018-12-20T13:46:04Z Re: Why Postgres doesn't use TID scan?
2018-12-09T15:42:40Z Re: Database size 1T but unclear why
2018-09-14T17:14:12Z Re: How Do You Associate a Query With its Invoking Procedure?
2018-03-21T12:12:31Z Re: badly scaling performance with appending to bytea
2018-02-23T15:23:03Z Re: effective_io_concurrency on EBS/gp2
2018-02-21T15:53:18Z blending fast and temp space volumes
2018-02-08T11:04:36Z Re: failing to use index on UNION of matviews (Re: postgresql 10.1 wrong plan in when using partitions bug)
2018-02-06T20:03:24Z Re: failing to use index on UNION of matviews (Re: postgresql 10.1 wrong plan in when using partitions bug)
2018-02-06T20:02:56Z Re: failing to use index on UNION of matviews (Re: postgresql 10.1 wrong plan in when using partitions bug)
2018-02-04T16:04:56Z Re: postgresql 10.1 wrong plan in when using partitions bug
2018-02-04T13:38:46Z Re: postgresql 10.1 wrong plan in when using partitions bug
2018-02-04T12:15:24Z Re: postgresql 10.1 wrong plan in when using partitions bug
2018-01-31T13:01:27Z Re: effective_io_concurrency on EBS/gp2
2018-01-29T21:35:53Z Re: dsa_allocate() faliure
2018-01-29T16:19:43Z dsa_allocate() faliure