public inbox for pgsql-general@postgresql.orghelp / color / mirror / Atom feed
Messages from robjsargent@gmail.com Re: Double prepare 2026-05-16 14:07 UTC Rob Sargent <robjsargent@gmail.com> Re: Choosing default collation/ctype 2026-05-04 04:16 UTC Rob Sargent <robjsargent@gmail.com> Signatures and code of conduct 2026-04-09 14:47 UTC Rob Sargent <robjsargent@gmail.com> Re: help debugging an issue with selectivity 2026-03-18 00:38 UTC Rob Sargent <robjsargent@gmail.com> Re: How to properly use TRIM()? 2026-03-07 19:19 UTC Rob Sargent <robjsargent@gmail.com> Re: How did VACUUM ANALYZE reclaim large TOAST bloat at disk level in PostgreSQL 16? 2026-01-15 18:55 UTC Rob Sargent <robjsargent@gmail.com> Re: Schema design: user account deletion vs. keeping family tree data 2025-11-26 23:26 UTC Rob Sargent <robjsargent@gmail.com> Re: Schema design: user account deletion vs. keeping family tree data 2025-11-24 15:43 UTC Rob Sargent <robjsargent@gmail.com> Re: phadmin4 app not starting after most recent upgrade 2025-10-27 21:35 UTC Rob Sargent <robjsargent@gmail.com> Re: Convert date and time colums to datetime 2025-10-23 23:23 UTC Rob Sargent <robjsargent@gmail.com> Re: Arrays vs separate tables 2025-10-20 14:48 UTC Rob Sargent <robjsargent@gmail.com> Re: Convert date and time colums to datetime 2025-10-20 13:26 UTC Rob Sargent <robjsargent@gmail.com> Re: Convert date and time colums to datetime 2025-10-20 12:53 UTC Rob Sargent <robjsargent@gmail.com> Re: Convert date and time colums to datetime 2025-10-20 12:43 UTC Rob Sargent <robjsargent@gmail.com> Re: Convert date and time colums to datetime 2025-10-20 02:32 UTC Rob Sargent <robjsargent@gmail.com> Re: Convert date and time colums to datetime 2025-10-19 19:40 UTC Rob Sargent <robjsargent@gmail.com> Re: Option on `postgres` CLI to shutdown when there are no more active connections? 2025-10-13 02:00 UTC Rob Sargent <robjsargent@gmail.com> Re: High latency and profiling 2025-10-09 20:54 UTC Rob Sargent <robjsargent@gmail.com> Re: pg_hint_tables 2025-09-30 20:24 UTC Rob Sargent <robjsargent@gmail.com> Re: Index (primary key) corrupt? 2025-09-20 20:16 UTC Rob Sargent <robjsargent@gmail.com> Re: Index (primary key) corrupt? 2025-09-20 16:26 UTC Rob Sargent <robjsargent@gmail.com> Re: MVCC and all that... 2025-09-09 16:40 UTC Rob Sargent <robjsargent@gmail.com> Re: How to configure client-side TLS ciphers for streaming replication? 2025-08-26 13:55 UTC Rob Sargent <robjsargent@gmail.com> Re: Streaming replica hangs periodically for ~ 1 second - how to diagnose/debug 2025-08-20 17:24 UTC Rob Sargent <robjsargent@gmail.com> Re: pg_rewind problem: cannot find WAL 2025-05-08 14:04 UTC Rob Sargent <robjsargent@gmail.com> Re: Query optimization 2025-03-14 02:49 UTC Rob Sargent <robjsargent@gmail.com> Re: Query optimization 2025-03-14 02:34 UTC Rob Sargent <robjsargent@gmail.com> Re: Quesion about querying distributed databases 2025-03-06 03:43 UTC Rob Sargent <robjsargent@gmail.com> Re: Keep specialized query pairs, or use single more general but more complex one 2025-02-24 14:51 UTC Rob Sargent <robjsargent@gmail.com> Re: psql command line editing 2025-02-13 19:14 UTC Rob Sargent <robjsargent@gmail.com> Re: psql command line editing 2025-02-12 21:17 UTC Rob Sargent <robjsargent@gmail.com> Re: How to perform a long running dry run transaction without blocking 2025-02-06 18:53 UTC Rob Sargent <robjsargent@gmail.com> Re: Lookup tables 2025-02-04 17:05 UTC Rob Sargent <robjsargent@gmail.com> Re: Lookup tables 2025-02-04 16:57 UTC Rob Sargent <robjsargent@gmail.com> Re: Need help in logical replication 2025-01-13 15:38 UTC Rob Sargent <robjsargent@gmail.com> Re: Insert records in the tavke only if they are not exist 2024-12-08 00:23 UTC Rob Sargent <robjsargent@gmail.com> Re: uninstalling postgresql 13 on ubuntu 22.04? 2024-11-28 01:13 UTC Rob Sargent <robjsargent@gmail.com> Re: JDBC using REFERENCES 2024-11-25 02:21 UTC Rob Sargent <robjsargent@gmail.com> Re: postgresql-17.0-1 Application - silent installation Issue 2024-11-14 15:20 UTC Rob Sargent <robjsargent@gmail.com> Re: Index Partition Size Double of its Table Partition? 2024-10-31 16:13 UTC Rob Sargent <robjsargent@gmail.com> Re: load fom csv 2024-09-18 13:29 UTC Rob Sargent <robjsargent@gmail.com> Re: load fom csv 2024-09-17 19:45 UTC Rob Sargent <robjsargent@gmail.com> Re: Manual query vs trigger during data load 2024-09-13 17:22 UTC Rob Sargent <robjsargent@gmail.com> Re: Ghost data from failed FDW transactions? 2024-08-28 22:16 UTC Rob Sargent <robjsargent@gmail.com> Re: can stored procedures with computational sql queries improve API performance? 2024-07-10 13:13 UTC Rob Sargent <robjsargent@gmail.com> Re: Transaction issue 2024-06-20 14:41 UTC Rob Sargent <robjsargent@gmail.com> Re: Transaction issue 2024-06-19 22:14 UTC Rob Sargent <robjsargent@gmail.com> Re: Manual Failover 2024-06-19 15:26 UTC Rob Sargent <robjsargent@gmail.com> Re: UPDATE with multiple WHERE conditions 2024-06-12 22:05 UTC Rob Sargent <robjsargent@gmail.com> Re: Purpose of pg_dump tar archive format? 2024-06-04 19:37 UTC Rob Sargent <robjsargent@gmail.com> Re: Purpose of pg_dump tar archive format? 2024-06-04 18:55 UTC Rob Sargent <robjsargent@gmail.com> Re: How to reference a DB with a period in its name ? 2024-03-29 22:52 UTC Rob Sargent <robjsargent@gmail.com> Re: After 10 -> 15 upgrade getting "cannot commit while a portal is pinned" on one python function 2024-03-27 23:35 UTC Rob Sargent <robjsargent@gmail.com> Re: Dropping a temporary view? 2024-03-20 17:00 UTC Rob Sargent <robjsargent@gmail.com> Re: Insert with Jsonb column hangs 2024-03-10 00:18 UTC Rob Sargent <robjsargent@gmail.com> Re: Unable to get PostgreSQL 15 with Kerberos (GSS) working 2024-02-29 14:56 UTC Rob Sargent <robjsargent@gmail.com> Re: Need Assistance: Command to display procedures does not work 2024-02-28 16:55 UTC Rob Sargent <robjsargent@gmail.com> Re: "reverse" (?) UPSERT -- how to ? 2024-02-17 16:33 UTC Rob Sargent <robjsargent@gmail.com> Re: Mimic ALIAS in Postgresql? 2024-01-22 23:38 UTC Rob Sargent <robjsargent@gmail.com> Re: Tips on troubleshooting slow DELETE (suspect cascades) 2024-01-18 16:53 UTC Rob Sargent <robjsargent@gmail.com> Re: Mimic ALIAS in Postgresql? 2024-01-17 00:41 UTC Rob Sargent <robjsargent@gmail.com> Re: Mimic ALIAS in Postgresql? 2024-01-17 00:39 UTC Rob Sargent <robjsargent@gmail.com> Re: Mimic ALIAS in Postgresql? 2024-01-16 22:57 UTC Rob Sargent <robjsargent@gmail.com> Re: Mimic ALIAS in Postgresql? 2024-01-16 22:31 UTC Rob Sargent <robjsargent@gmail.com> Re: Postgres Database Service Interruption 2024-01-16 17:03 UTC Rob Sargent <robjsargent@gmail.com> Re: postgres sql assistance 2024-01-16 14:34 UTC Rob Sargent <robjsargent@gmail.com> Re: Counting the number of repeated phrases in a column 2022-01-27 17:09 UTC Rob Sargent <robjsargent@gmail.com> Re: PostgreSQL Management and monitoring tool 2022-01-27 04:01 UTC Rob Sargent <robjsargent@gmail.com> Re: Counting the number of repeated phrases in a column 2022-01-26 21:40 UTC Rob Sargent <robjsargent@gmail.com> Re: Robust ways for checking allowed values in a column 2022-01-25 16:40 UTC Rob Sargent <robjsargent@gmail.com> Re: Undetected Deadlock 2022-01-25 05:06 UTC Rob Sargent <robjsargent@gmail.com> Re: psql does not provide proper response 2022-01-20 17:56 UTC Rob Sargent <robjsargent@gmail.com> Re: java.lang.ClassNotFoundException: batchprint.Batch 2022-01-07 18:27 UTC Rob Sargent <robjsargent@gmail.com> Re: Trouble DROP'ing a ROLE, despite REVOKE'ing its privileges 2022-01-05 18:10 UTC Rob Sargent <robjsargent@gmail.com> Re: Create and access a dictionary type 2022-01-05 16:59 UTC Rob Sargent <robjsargent@gmail.com> Re: Primary keys and composite unique keys(basic question) 2021-04-07 18:16 UTC Rob Sargent <robjsargent@gmail.com> Re: Primary keys and composite unique keys(basic question) 2021-04-07 16:35 UTC Rob Sargent <robjsargent@gmail.com> Re: Primary keys and composite unique keys(basic question) 2021-04-06 02:37 UTC Rob Sargent <robjsargent@gmail.com> Re: Primary keys and composite unique keys(basic question) 2021-04-02 03:26 UTC Rob Sargent <robjsargent@gmail.com> Re: Is replacing transactions with CTE a good idea? 2021-04-01 15:04 UTC Rob Sargent <robjsargent@gmail.com> Re: accessing cross-schema materialized views 2021-03-31 22:36 UTC Rob Sargent <robjsargent@gmail.com> Re: PostgreSQL Views Where Clause Character Columns getting Typecasted to Text and Indexes not getting Used 2021-03-26 04:55 UTC Rob Sargent <robjsargent@gmail.com> Re: Compare with default value? 2021-03-13 20:58 UTC Rob Sargent <robjsargent@gmail.com> Re: unexpected character used as group separator by to_char 2021-03-09 23:09 UTC Rob Sargent <robjsargent@gmail.com> Re: unexpected character used as group separator by to_char 2021-03-09 21:32 UTC Rob Sargent <robjsargent@gmail.com> self-made certs not quite right 2021-03-02 23:12 UTC Rob Sargent <robjsargent@gmail.com> Re: Postgres Analog of Oracle APPEND hint 2021-02-25 16:40 UTC Rob Sargent <robjsargent@gmail.com> Re: Inserting millions of record in a partitioned Table 2017-09-20 20:54 UTC Rob Sargent <robjsargent@gmail.com> Re: looking for a globally unique row ID 2017-09-18 00:34 UTC Gmail <robjsargent@gmail.com> Re: looking for a globally unique row ID 2017-09-17 01:30 UTC Gmail <robjsargent@gmail.com> Re: looking for a globally unique row ID 2017-09-16 15:19 UTC Gmail <robjsargent@gmail.com> Re: looking for a globally unique row ID 2017-09-15 18:49 UTC Rob Sargent <robjsargent@gmail.com> Re: looking for a globally unique row ID 2017-09-15 15:30 UTC Rob Sargent <robjsargent@gmail.com> Re: looking for a globally unique row ID 2017-09-14 21:15 UTC Rob Sargent <robjsargent@gmail.com> Re: looking for a globally unique row ID 2017-09-14 17:30 UTC Rob Sargent <robjsargent@gmail.com> Re: pglogical bidirectional replication of sequences 2017-09-01 15:57 UTC Rob Sargent <robjsargent@gmail.com> Re: PostgreSQL with PowerBuilder, and Identity keys (serials) 2017-08-05 21:29 UTC Rob Sargent <robjsargent@gmail.com> Re: Text search dictionary vs. the C locale 2017-07-02 17:19 UTC Gmail <robjsargent@gmail.com> Re: Text search dictionary vs. the C locale 2017-07-02 17:11 UTC Gmail <robjsargent@gmail.com> Re: dump to pg 2017-05-31 15:33 UTC Rob Sargent <robjsargent@gmail.com> Re: all serial type was changed to 1 2017-05-01 23:23 UTC Rob Sargent <robjsargent@gmail.com> Re: COPY: row is too big 2017-01-05 18:59 UTC Rob Sargent <robjsargent@gmail.com> Re: COPY: row is too big 2017-01-05 16:31 UTC Rob Sargent <robjsargent@gmail.com> Re: COPY: row is too big 2017-01-02 20:57 UTC Rob Sargent <robjsargent@gmail.com> Re: Performance PLV8 vs PLPGSQL 2016-12-29 23:51 UTC Rob Sargent <robjsargent@gmail.com> Re: About the MONEY type 2016-12-19 01:17 UTC Rob Sargent <robjsargent@gmail.com> Re: huge table occupation after updates 2016-12-10 17:10 UTC Rob Sargent <robjsargent@gmail.com> Re: huge table occupation after updates 2016-12-10 15:36 UTC Rob Sargent <robjsargent@gmail.com> Re: huge table occupation after updates 2016-12-10 15:04 UTC Rob Sargent <robjsargent@gmail.com> Re: high transaction rate 2016-12-07 23:54 UTC Rob Sargent <robjsargent@gmail.com> Re: high transaction rate 2016-12-07 22:23 UTC Rob Sargent <robjsargent@gmail.com> Re: FreeBSD 10 => 11: Dump and reload your PostgreSQL database unless you like it broken 2016-12-07 21:20 UTC Rob Sargent <robjsargent@gmail.com> Re: high transaction rate 2016-12-07 16:47 UTC Rob Sargent <robjsargent@gmail.com> Re: INSERT ON CONFLICT of "wide" table: target lists can have at most 1664 entries 2016-12-04 16:52 UTC Gmail <robjsargent@gmail.com> Re: Postrgres-XL and Postgres-BDR 2016-12-04 00:59 UTC Gmail <robjsargent@gmail.com> Re: pg_dump fundenental question 2016-07-05 17:03 UTC Rob Sargent <robjsargent@gmail.com> Re: Stored procedure version control 2016-07-02 00:22 UTC Rob Sargent <robjsargent@gmail.com> Re: How to pass jsonb and inet arguments to a stored function with JDBC? 2016-06-14 14:19 UTC Rob Sargent <robjsargent@gmail.com> Re: Automate copy - Postgres 9.2 2016-06-09 03:05 UTC Rob Sargent <robjsargent@gmail.com> 119+ results
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox