public inbox for [email protected]  
help / color / mirror / Atom feed
Messages from [email protected]

Re: Describing the natural architecture for an internet-facing Postgres based app: feedback sought
  2026-05-01 20:27 UTC  Merlin Moncure <[email protected]>

Re: Are SQL-language function lock ordering deadlocks solved in PostgreSQL 18?
  2025-10-07 20:51 UTC  Merlin Moncure <[email protected]>

Re: Downgrade pgsql 17 to pgsql 12 question
  2025-09-30 15:13 UTC  Merlin Moncure <[email protected]>

Re: Downgrade pgsql 17 to pgsql 12 question
  2025-09-28 23:40 UTC  Merlin Moncure <[email protected]>

Re: Silent data corruption in PostgreSQL 17 - how to detect it proactively?
  2025-09-16 16:41 UTC  Merlin Moncure <[email protected]>

Re: MVCC and all that...
  2025-09-11 16:52 UTC  Merlin Moncure <[email protected]>

Re: MVCC and all that...
  2025-09-10 18:54 UTC  Merlin Moncure <[email protected]>

Re: MVCC and all that...
  2025-09-09 22:55 UTC  Merlin Moncure <[email protected]>

Re: MVCC and all that...
  2025-09-09 17:10 UTC  Merlin Moncure <[email protected]>

Re: PostgreSQL include directive in plpgsql language PL/pgSQL
  2025-09-08 16:31 UTC  Merlin Moncure <[email protected]>

Re: PostgreSQL include directive in plpgsql language PL/pgSQL
  2025-09-05 16:21 UTC  Merlin Moncure <[email protected]>

Re: Domains vs data types
  2025-08-21 17:03 UTC  Merlin Moncure <[email protected]>

Re: Libpq.dll
  2025-08-06 19:28 UTC  Merlin Moncure <[email protected]>

Re: Is there any limit on the number of rows to import using copy command
  2025-07-23 17:49 UTC  Merlin Moncure <[email protected]>

Re: Performance of JSON type in postgres
  2025-07-15 17:32 UTC  Merlin Moncure <[email protected]>

Re: I have a suspicious query
  2025-07-11 22:59 UTC  Merlin Moncure <[email protected]>

Re: Aggregate versions of hashing functions (md5, sha1, etc...)
  2025-07-11 22:57 UTC  Merlin Moncure <[email protected]>

Re: Aggregate versions of hashing functions (md5, sha1, etc...)
  2025-07-11 20:30 UTC  Merlin Moncure <[email protected]>

Re: Aggregate versions of hashing functions (md5, sha1, etc...)
  2025-07-10 19:02 UTC  Merlin Moncure <[email protected]>

Re: Extension disappearing act
  2025-06-20 14:07 UTC  Merlin Moncure <[email protected]>

Re: Is anyone up for hosting the online PG game "Schemaverse"?
  2025-05-09 12:52 UTC  Merlin Moncure <[email protected]>

Re: Is anyone up for hosting the online PG game "Schemaverse"?
  2025-05-05 23:15 UTC  Merlin Moncure <[email protected]>

Re: Interesting case of IMMUTABLE significantly hurting performance
  2025-04-11 23:31 UTC  Merlin Moncure <[email protected]>

Re: Interesting case of IMMUTABLE significantly hurting performance
  2025-04-11 03:18 UTC  Merlin Moncure <[email protected]>

Re: pgvector as standard PostgreSQL feature?
  2025-04-06 20:59 UTC  Merlin Moncure <[email protected]>

Re: How to return seto records from seof record function?
  2025-02-26 23:31 UTC  Merlin Moncure <[email protected]>

Re: (When) can a single SQL statement return multiple result sets?
  2024-04-15 22:16 UTC  Merlin Moncure <[email protected]>

Re: (When) can a single SQL statement return multiple result sets?
  2024-04-10 22:47 UTC  Merlin Moncure <[email protected]>

Re: Timing out A Blocker Based on Time or Count of Waiters
  2024-03-26 01:52 UTC  Merlin Moncure <[email protected]>

Re: PostgreSQL as advanced job queuing system
  2024-03-25 13:44 UTC  Merlin Moncure <[email protected]>

Re: PostgreSQL as advanced job queuing system
  2024-03-23 02:12 UTC  Merlin Moncure <[email protected]>

Re: Clarification regarding managing advisory locks in postgresql
  2024-02-08 19:34 UTC  Merlin Moncure <[email protected]>

Re: Moving to Postgresql database
  2024-01-18 02:29 UTC  Merlin Moncure <[email protected]>

Re: Help needed for the resolution of memory leak
  2024-01-18 01:05 UTC  Merlin Moncure <[email protected]>

Re: Help needed for the resolution of memory leak
  2024-01-16 22:41 UTC  Merlin Moncure <[email protected]>

Re: Help needed for the resolution of memory leak
  2024-01-15 20:00 UTC  Merlin Moncure <[email protected]>

Re: Can Postgres beat Oracle for regexp_count?
  2022-02-04 04:32 UTC  Merlin Moncure <[email protected]>

Re: pg_try_advisory_lock is waiting?
  2022-01-31 20:36 UTC  Merlin Moncure <[email protected]>

Re: Counting the number of repeated phrases in a column
  2022-01-27 23:10 UTC  Merlin Moncure <[email protected]>

Re: Counting the number of repeated phrases in a column
  2022-01-27 17:35 UTC  Merlin Moncure <[email protected]>

Re: Counting the number of repeated phrases in a column
  2022-01-27 17:03 UTC  Merlin Moncure <[email protected]>

Re: Counting the number of repeated phrases in a column
  2022-01-26 23:23 UTC  Merlin Moncure <[email protected]>

Re: Can we use sql language to create a function in Postgres?
  2022-01-05 17:42 UTC  Merlin Moncure <[email protected]>

Re: Primary keys and composite unique keys(basic question)
  2021-04-06 02:53 UTC  Merlin Moncure <[email protected]>

Re: Primary keys and composite unique keys(basic question)
  2021-04-06 02:17 UTC  Merlin Moncure <[email protected]>

Re: Primary keys and composite unique keys(basic question)
  2021-04-06 02:10 UTC  Merlin Moncure <[email protected]>

Re: Primary keys and composite unique keys(basic question)
  2021-04-02 02:28 UTC  Merlin Moncure <[email protected]>

Re: Binary encoding of timetz type
  2021-03-23 01:11 UTC  Merlin Moncure <[email protected]>

Re: Postgres Analog of Oracle APPEND hint
  2021-03-05 20:15 UTC  Merlin Moncure <[email protected]>

Re: a JOIN to a VIEW seems slow
  2017-09-22 13:53 UTC  Merlin Moncure <[email protected]>

Re: a JOIN to a VIEW seems slow
  2017-09-21 19:29 UTC  Merlin Moncure <[email protected]>

Re: a JOIN to a VIEW seems slow
  2017-09-21 13:54 UTC  Merlin Moncure <[email protected]>

Re: a JOIN to a VIEW seems slow
  2017-09-18 22:44 UTC  Merlin Moncure <[email protected]>

Re: looking for a globally unique row ID
  2017-09-14 22:02 UTC  Merlin Moncure <[email protected]>

Re: looking for a globally unique row ID
  2017-09-14 13:54 UTC  Merlin Moncure <[email protected]>

Re: B-tree index on a VARCHAR(4000) column
  2017-09-10 15:42 UTC  Merlin Moncure <[email protected]>

Re: B-tree index on a VARCHAR(4000) column
  2017-09-08 12:50 UTC  Merlin Moncure <[email protected]>

Re: Issue with json_agg() and ordering
  2017-09-01 18:10 UTC  Merlin Moncure <[email protected]>

Re: Would you add a --dry-run to pg_restore?
  2017-08-03 12:58 UTC  Merlin Moncure <[email protected]>

Re: Shared Constants in PLPGSQL
  2017-08-01 18:54 UTC  Merlin Moncure <[email protected]>

Re: Shared Constants in PLPGSQL
  2017-08-01 13:10 UTC  Merlin Moncure <[email protected]>

Re: Shared Constants in PLPGSQL
  2017-08-01 13:04 UTC  Merlin Moncure <[email protected]>

Re: Imperative Query Languages
  2017-07-11 12:36 UTC  Merlin Moncure <[email protected]>

Re: Imperative Query Languages
  2017-07-05 14:02 UTC  Merlin Moncure <[email protected]>

Re: storing large files in database - performance
  2017-05-19 20:59 UTC  Merlin Moncure <[email protected]>

Re: union all taking years - PG 9.6
  2017-05-18 14:52 UTC  Merlin Moncure <[email protected]>

Re: storing large files in database - performance
  2017-05-18 13:48 UTC  Merlin Moncure <[email protected]>

Re: storing large files in database - performance
  2017-05-17 14:21 UTC  Merlin Moncure <[email protected]>

Re: Insert performance and disk usage in JSON vs JSONB
  2017-05-15 20:52 UTC  Merlin Moncure <[email protected]>

Re: Row value expression much faster than equivalent OR clauses
  2017-01-05 19:14 UTC  Merlin Moncure <[email protected]>

Re: Performance PLV8 vs PLPGSQL
  2017-01-04 22:55 UTC  Merlin Moncure <[email protected]>

Re: storing C binary array in bytea via libpq
  2016-12-09 15:31 UTC  Merlin Moncure <[email protected]>

Re: When to use COMMENT vs --
  2016-12-09 15:23 UTC  Merlin Moncure <[email protected]>

Re: About the MONEY type
  2016-11-30 20:27 UTC  Merlin Moncure <[email protected]>

Re: Index is not used for "IN (non-correlated subquery)"
  2016-11-30 17:08 UTC  Merlin Moncure <[email protected]>

Re: Index is not used for "IN (non-correlated subquery)"
  2016-11-30 16:45 UTC  Merlin Moncure <[email protected]>

Re: About the MONEY type
  2016-11-30 16:41 UTC  Merlin Moncure <[email protected]>

Re: Fastest memmove in C
  2016-07-07 16:23 UTC  Merlin Moncure <[email protected]>

Re: PSQL does not remove obvious useless joins
  2016-07-01 19:41 UTC  Merlin Moncure <[email protected]>

Re: Stored procedure version control
  2016-06-30 14:16 UTC  Merlin Moncure <[email protected]>

Re: ***SPAM*** Re: random huge delay when recreate a VIEW or FUNCTION
  2016-06-17 13:48 UTC  Merlin Moncure <[email protected]>

Re: random huge delay when recreate a VIEW or FUNCTION
  2016-06-17 13:31 UTC  Merlin Moncure <[email protected]>

Re: psql remote shell command
  2016-06-03 15:34 UTC  Merlin Moncure <[email protected]>

Re: RowDescription via the SQL?
  2016-06-02 22:55 UTC  Merlin Moncure <[email protected]>

Re: Monitoring and insight into NOTIFY queue
  2016-02-19 15:08 UTC  Merlin Moncure <[email protected]>

Re: BDR with postgres 9.5
  2016-01-21 20:24 UTC  Merlin Moncure <[email protected]>

Re: Dynamic collation support
  2016-01-19 21:46 UTC  Merlin Moncure <[email protected]>

Re: Dynamic collation support
  2016-01-19 19:04 UTC  Merlin Moncure <[email protected]>

Re: Dynamic collation support
  2016-01-19 15:57 UTC  Merlin Moncure <[email protected]>

Re: Dynamic collation support
  2016-01-19 15:42 UTC  Merlin Moncure <[email protected]>

Dynamic collation support
  2016-01-19 15:07 UTC  Merlin Moncure <[email protected]>

Re: ??: postgres cpu 100% need help
  2015-11-30 14:46 UTC  Merlin Moncure <[email protected]>

Re: ??: postgres cpu 100% need help
  2015-11-23 22:59 UTC  Merlin Moncure <[email protected]>

Re: ??: postgres cpu 100% need help
  2015-11-10 15:55 UTC  Merlin Moncure <[email protected]>

Re: ??: postgres cpu 100% need help
  2015-11-10 14:26 UTC  Merlin Moncure <[email protected]>

Re: How to search a string inside a json structure
  2015-11-03 16:43 UTC  Merlin Moncure <[email protected]>

Re: Approach to extract top records from table based upon aggregate
  2015-11-03 16:32 UTC  Merlin Moncure <[email protected]>

 Re: [GENERAL] Re: [GENERAL] 回复: postgres cpu 100% need help
  2015-10-27 21:05 UTC  Merlin Moncure <[email protected]>

 Re: [GENERAL] Re: [GENERAL] 回复: postgres cpu 100% need help
  2015-10-27 21:04 UTC  Merlin Moncure <[email protected]>

Re: ??: postgres cpu 100% need help
  2015-10-27 18:35 UTC  Merlin Moncure <[email protected]>

Re: My first PL/pgSQL function
  2015-10-21 15:44 UTC  Merlin Moncure <[email protected]>

Re: RAID and SSD configuration question
  2015-10-20 19:09 UTC  Merlin Moncure <[email protected]>

Re: My first PL/pgSQL function
  2015-10-20 16:43 UTC  Merlin Moncure <[email protected]>

Re: RAID and SSD configuration question
  2015-10-20 16:26 UTC  Merlin Moncure <[email protected]>

Re: RAID and SSD configuration question
  2015-10-20 13:30 UTC  Merlin Moncure <[email protected]>

Re: Understanding "seq scans"
  2015-10-14 16:31 UTC  Merlin Moncure <[email protected]>

Re: Understanding "seq scans"
  2015-10-13 00:47 UTC  Merlin Moncure <[email protected]>

Re: crosstab
  2012-09-04 20:56 UTC  Merlin Moncure <[email protected]>

Re: Databas has no Object Identifier Types & Functions
  2012-09-04 14:58 UTC  Merlin Moncure <[email protected]>

Re: String comparision in PostgreSQL
  2012-08-30 15:09 UTC  Merlin Moncure <[email protected]>

Re: Would my postgresql 8.4.12 profit from doubling RAM?
  2012-08-30 13:52 UTC  Merlin Moncure <[email protected]>

Re: Refreshing functional index
  2012-08-29 21:06 UTC  Merlin Moncure <[email protected]>

Re: Views versus user-defined functions: formatting, comments, performance, etc.
  2012-08-29 19:22 UTC  Merlin Moncure <[email protected]>

Re: C locale versus en_US.UTF8. (Was: String comparision in PostgreSQL)
  2012-08-29 18:45 UTC  Merlin Moncure <[email protected]>

Re: String comparision in PostgreSQL
  2012-08-29 16:45 UTC  Merlin Moncure <[email protected]>

Re: String comparision in PostgreSQL
  2012-08-29 15:08 UTC  Merlin Moncure <[email protected]>

Re: PQfformat question and retrieving bytea data in C
  2012-08-29 13:20 UTC  Merlin Moncure <[email protected]>

Re: Views versus user-defined functions: formatting, comments, performance, etc.
  2012-08-29 13:15 UTC  Merlin Moncure <[email protected]>

Re: "Need some information about postgresql products and community"
  2012-08-28 14:47 UTC  Merlin Moncure <[email protected]>

Re: Overlapping time ranges constraints in 8.4
  2012-08-28 13:44 UTC  Merlin Moncure <[email protected]>

Re: Postgres DBA in Berlin, Germany
  2012-08-28 12:58 UTC  Merlin Moncure <[email protected]>

Re: Documentation of Implicit Function Call /w Composite Types
  2012-08-27 21:59 UTC  Merlin Moncure <[email protected]>

Re: Some thoughts on table inheritance (which is uniquely awesome on PostgreSQL)
  2012-08-23 19:36 UTC  Merlin Moncure <[email protected]>

Re: How hard would a "path" operator be to implement in PostgreSQL
  2012-08-23 19:20 UTC  Merlin Moncure <[email protected]>

Re: Amazon High I/O instances
  2012-08-23 15:37 UTC  Merlin Moncure <[email protected]>

Re: Performance implications of numeric?
  2012-08-23 15:17 UTC  Merlin Moncure <[email protected]>

Re: At what point does a big table start becoming too big?
  2012-08-23 13:46 UTC  Merlin Moncure <[email protected]>

Re: Database Bloat
  2012-08-22 18:16 UTC  Merlin Moncure <[email protected]>

Re: Amazon High I/O instances
  2012-08-21 14:36 UTC  Merlin Moncure <[email protected]>

Re: Database Bloat
  2012-08-20 22:16 UTC  Merlin Moncure <[email protected]>

Re: function depend on view
  2012-08-20 15:12 UTC  Merlin Moncure <[email protected]>

Re: function depend on view
  2012-08-20 14:57 UTC  Merlin Moncure <[email protected]>

Re: Views versus user-defined functions: formatting, comments, performance, etc.
  2012-08-20 14:06 UTC  Merlin Moncure <[email protected]>

Re: Views versus user-defined functions: formatting, comments, performance, etc.
  2012-08-17 22:49 UTC  Merlin Moncure <[email protected]>

Re: Alternatives to very large tables with many performance-killing indicies?
  2012-08-16 21:00 UTC  Merlin Moncure <[email protected]>

Re: Visualize database schema
  2012-08-14 19:49 UTC  Merlin Moncure <[email protected]>

Re: json support for composites in upcoming 9.2
  2012-08-13 15:58 UTC  Merlin Moncure <[email protected]>

Re: JSON in 9.2: limitations
  2012-08-09 13:58 UTC  Merlin Moncure <[email protected]>

Re: JSON in 9.2: limitations
  2012-08-07 19:45 UTC  Merlin Moncure <[email protected]>

Re: JSON in 9.2: limitations
  2012-08-07 16:31 UTC  Merlin Moncure <[email protected]>

Re: Threads With Libpq
  2012-08-01 14:03 UTC  Merlin Moncure <[email protected]>

Re: Smaller data types use same disk space
  2012-07-26 16:42 UTC  Merlin Moncure <[email protected]>

Re: Smaller data types use same disk space
  2012-07-26 16:12 UTC  Merlin Moncure <[email protected]>

Re: Smaller data types use same disk space
  2012-07-25 22:49 UTC  Merlin Moncure <[email protected]>

Re: Advice Wanted on Selecting Multi-row Data Requests in 10-Row Blocks
  2008-06-30 16:24 UTC  Merlin Moncure <[email protected]>

Re: pg_locks "at-a-glance" view
  2008-06-19 13:41 UTC  Merlin Moncure <[email protected]>

Re: Annoying messages when copy sql code to psql terminal
  2008-06-06 12:12 UTC  Merlin Moncure <[email protected]>

Re: Annoying messages when copy sql code to psql terminal
  2008-06-06 02:28 UTC  Merlin Moncure <[email protected]>

Re: Money data type - Deprecated?
  2008-05-27 13:29 UTC  Merlin Moncure <[email protected]>

Re: Stored procedures when and how: was: Sun acquires MySQL
  2008-01-22 08:26 UTC  Merlin Moncure <[email protected]>

Re: US Military / Government Approval
  2008-01-21 20:56 UTC  Merlin Moncure <[email protected]>

Re: Sun acquires MySQL
  2008-01-21 13:45 UTC  Merlin Moncure <[email protected]>

Re: Replication Using Triggers
  2008-01-21 03:18 UTC  Merlin Moncure <[email protected]>

Re: Accessing composite type columns from C
  2008-01-17 23:33 UTC  Merlin Moncure <[email protected]>

Re: Locking & concurrency - best practices
  2008-01-15 13:51 UTC  Merlin Moncure <[email protected]>

Re: Locking & concurrency - best practices
  2008-01-15 04:08 UTC  Merlin Moncure <[email protected]>

Re: Locking & concurrency - best practices
  2008-01-15 04:06 UTC  Merlin Moncure <[email protected]>

Re: Can I create a TYPE (or DOMAIN) with arguments?
  2008-01-10 15:29 UTC  Merlin Moncure <[email protected]>

Re: Connect to SQL Server via ODBC from Postgresql
  2008-01-10 14:54 UTC  Merlin Moncure <[email protected]>

Re: PITR and warm standby setup questions
  2007-11-13 05:38 UTC  Merlin Moncure <[email protected]>

Re: PITR and warm standby setup questions
  2007-11-13 00:30 UTC  Merlin Moncure <[email protected]>

Re: What makes a Postgres DBA?
  2007-11-05 01:04 UTC  Merlin Moncure <[email protected]>

Re: young guy wanting (Postgres DBA) ammo
  2007-11-03 15:20 UTC  Merlin Moncure <[email protected]>

Re: array_to_set functions
  2007-08-05 14:48 UTC  Merlin Moncure <[email protected]>

Re: Linux distro
  2007-08-05 13:18 UTC  Merlin Moncure <[email protected]>

Re: Linux distro
  2007-08-02 13:07 UTC  Merlin Moncure <[email protected]>

Re: Linux distro
  2007-08-02 03:05 UTC  Merlin Moncure <[email protected]>

Re: Linux distro
  2007-08-02 02:58 UTC  Merlin Moncure <[email protected]>

Re: array_to_set functions
  2007-08-01 01:44 UTC  Merlin Moncure <[email protected]>

Re: Need quick help with standalone mode
  2007-07-31 18:28 UTC  Merlin Moncure <[email protected]>

Re: PG Admin
  2007-07-31 16:09 UTC  Merlin Moncure <[email protected]>

Re: The leanest, meanest Windows installer possible
  2007-07-29 17:49 UTC  Merlin Moncure <[email protected]>

Re: How do I create a database if I can't connect to it?
  2007-07-27 15:56 UTC  Merlin Moncure <[email protected]>

Re: upgrade to 8.2.? or implement Slony, which first?
  2007-07-27 13:59 UTC  Merlin Moncure <[email protected]>

Re: Tunning PostgreSQL performance for views on Windows
  2007-07-27 13:38 UTC  Merlin Moncure <[email protected]>

Re: Primary Key Performance with INTEGER vs. VARCHAR
  2007-07-25 01:35 UTC  Merlin Moncure <[email protected]>

Re: Can't SELECT from (INSERT ... RETURNING)
  2007-07-19 00:20 UTC  Merlin Moncure <[email protected]>

Re: How to get fast ~ operator using C locale
  2007-07-05 12:50 UTC  Merlin Moncure <[email protected]>

Re: What O/S or hardware feature would be useful for databases?
  2007-07-03 18:03 UTC  Merlin Moncure <[email protected]>

Re: What O/S or hardware feature would be useful for databases?
  2007-06-18 13:05 UTC  Merlin Moncure <[email protected]>

Re: General Ledger db design
  2007-03-01 16:09 UTC  Merlin Moncure <[email protected]>

Re: [HACKERS] urgent: upgraded to 8.2, getting kernel panics
  2007-03-01 13:32 UTC  Merlin Moncure <[email protected]>

Re: [HACKERS] urgent: upgraded to 8.2, getting kernel panics
  2007-02-26 13:24 UTC  Merlin Moncure <[email protected]>

urgent: upgraded to 8.2, getting kernel panics
  2007-02-23 22:14 UTC  Merlin Moncure <[email protected]>

Re: postgresql vs mysql
  2007-02-21 17:47 UTC  Merlin Moncure <[email protected]>

Re: boolean operator on interval producing strange results
  2007-02-20 16:15 UTC  Merlin Moncure <[email protected]>

Re: boolean operator on interval producing strange results
  2007-02-20 14:30 UTC  Merlin Moncure <[email protected]>

boolean operator on interval producing strange results
  2007-02-19 21:39 UTC  Merlin Moncure <[email protected]>

Re: Stored Procedure examples
  2007-02-15 18:32 UTC  Merlin Moncure <[email protected]>

Re: Postgres SQL Syntax
  2007-02-09 18:19 UTC  Merlin Moncure <[email protected]>

Re: How to allow users to log on only from my application not from pgadmin
  2007-02-02 02:22 UTC  Merlin Moncure <[email protected]>

Re: Any Plans for cross database queries on the same server?
  2007-01-31 13:55 UTC  Merlin Moncure <[email protected]>

Re: could not write to log -> PANIC -> System down
  2006-12-14 21:00 UTC  Merlin Moncure <[email protected]>

Re: PG Admin
  2006-12-13 14:04 UTC  Merlin Moncure <[email protected]>

Re: Male/female
  2006-12-08 20:23 UTC  Merlin Moncure <[email protected]>

Re: The relative stability of different procedural languages
  2006-12-07 22:07 UTC  Merlin Moncure <[email protected]>

Re: porducing documentation from postgres
  2006-12-01 18:21 UTC  Merlin Moncure <[email protected]>

Re: Speed of postgres compared to ms sql, is this
  2006-11-13 20:56 UTC  Merlin Moncure <[email protected]>

Re: Dependency graph of all tuples relied upon in a query answer
  2006-09-05 18:01 UTC  Merlin Moncure <[email protected]>

Re: Dependency graph of all tuples relied upon in a query answer
  2006-09-01 13:30 UTC  Merlin Moncure <[email protected]>


200+ results

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox