Horton

Philip Semanchuk

philip@americanefficient.com

Email: philip@americanefficient.com
Name: Philip Semanchuk
Messages: 77
First message: 2020-02-27
Last message: 2025-08-06

Recent messages

DateSubject
2025-08-06T13:16:50Z Re: Stored procedures or raw queries
2024-11-25T16:23:36Z Re: Inconsistent results for division and multiplication operations
2024-10-09T13:02:38Z Re: Disk is filling up with large files. How can I clean?
2024-09-30T15:16:20Z Re: Suggestion for memory parameters
2024-06-17T12:59:07Z Re: performance of sql and plpgsql functions
2024-01-30T20:08:40Z Re: Slow query in table where many rows were deleted. VACUUM FULL fixes it
2024-01-16T21:33:58Z Re: Parameter value in RDS
2023-11-09T13:54:36Z Re: Awkward Join between generate_series and long table
2023-11-03T14:06:59Z Re: Local postgres manual
2023-11-03T13:39:46Z Re: Local postgres manual
2023-07-11T16:07:26Z Entire index scanned, but only when in SQL function?
2023-03-14T13:12:11Z Re: Uppercase version of ß desired
2023-02-07T14:09:12Z Re: ALTER COLUMN to change GENERATED ALWAYS AS expression?
2023-02-06T17:04:48Z ALTER COLUMN to change GENERATED ALWAYS AS expression?
2023-01-18T16:09:38Z Re: IN clause behaving badly with missing comma and line break
2023-01-18T15:20:57Z Re: IN clause behaving badly with missing comma and line break
2022-11-10T23:33:36Z Re: IMMUTABLE function to cast enum to/from text?
2022-11-10T19:52:24Z IMMUTABLE function to cast enum to/from text?
2022-10-19T19:02:42Z Custom function ROWS hint ignored due to inlining?
2022-06-03T15:11:14Z Re: Max sane value for join_collapse_limit?
2022-04-28T17:11:28Z Could Postgres warn about incorrect volatility class?
2022-04-20T19:26:42Z Re: Are stored procedures/triggers common in your industry
2022-03-29T18:43:27Z Re: Why is my function inlined only when STABLE?
2022-03-29T18:05:44Z Why is my function inlined only when STABLE?
2022-03-28T17:35:03Z Re: Leading comments and client applications
2022-03-25T18:05:50Z Re: Leading comments and client applications
2022-03-25T15:32:24Z Leading comments and client applications
2021-10-29T18:44:15Z Re: psql syntax for array of strings in a variable?
2021-10-29T17:21:19Z psql syntax for array of strings in a variable?
2021-08-19T12:43:05Z Re: PGSQL bug - "Column ??? is an identity column defined as GENERATED ALWAYS.",
2021-08-18T12:46:26Z Re: Help with my MacOS PostgreSQL 12 installation
2021-07-29T13:33:16Z Re: Low cache hit ratio
2021-06-07T15:21:42Z Re: Database issues when adding GUI
2021-06-02T12:39:33Z Re: CREATE/REFRESH MATERIALIZED VIEW planner difference?
2021-06-01T18:26:00Z Re: CREATE/REFRESH MATERIALIZED VIEW planner difference?
2021-06-01T18:00:16Z CREATE/REFRESH MATERIALIZED VIEW planner difference?
2021-05-27T13:45:30Z Re: How different is AWS-RDS postgres?
2021-02-25T22:32:32Z Re: Postgres performance comparing GCP and AWS
2021-02-25T20:53:13Z Re: Postgres performance comparing GCP and AWS
2021-02-25T18:13:33Z Re: Postgres performance comparing GCP and AWS
2021-02-16T18:06:01Z Re: pg_stat_user_tables.n_mod_since_analyze persistence?
2021-02-15T16:57:55Z pg_stat_user_tables.n_mod_since_analyze persistence?
2021-02-10T14:22:58Z Re: How does Postgres decide if to use additional workers?
2021-01-19T13:40:03Z Re: How to check if a materialised view is being updated?
2021-01-07T17:05:29Z Re: how to make query
2021-01-07T13:58:56Z Re: how to make query
2020-12-31T13:52:43Z Re: plpgsql unit testing and code coverage
2020-12-22T14:57:19Z Re: Avoid excessive inlining?
2020-12-21T16:45:41Z Re: Avoid excessive inlining?
2020-11-19T16:43:18Z Re: maintenance_work_mem