pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
GIN INdex is not used with && operator for a text array index
  2023-12-06 14:32 UTC  balasubramanian c r <crbs.siebel@gmail.com>
` Re: GIN INdex is not used with && operator for a text array index
  2023-12-06 14:58 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [2+ messages in thread]

vacuumdb seems not to like option -j when run from crontab
  2023-12-04 16:07 UTC  Ron Johnson <ronljohnsonjr@gmail.com>
` Re: vacuumdb seems not to like option -j when run from crontab
  2023-12-04 16:13 UTC  Alan Hodgson <ahodgson@lists.simkin.ca>
` Re: vacuumdb seems not to like option -j when run from crontab
  2023-12-04 16:19 UTC  kaido vaikla <kaido.vaikla@gmail.com>
` Re: vacuumdb seems not to like option -j when run from crontab
  2023-12-04 16:22 UTC  Ron Johnson <ronljohnsonjr@gmail.com>
` Re: vacuumdb seems not to like option -j when run from crontab
  2023-12-05 17:56 UTC  Joshua Drake <jd@commandprompt.com>
  [5+ messages in thread]

Help understand why DELETE is so slow
  2023-12-01 17:47 UTC  Ping Yao <ping@optigo.net>
` Re: Help understand why DELETE is so slow
  2023-12-01 17:50 UTC  Christophe Pettus <xof@thebuild.com>
` Re: Help understand why DELETE is so slow
  2023-12-04 21:40 UTC  Merlin Moncure <mmoncure@gmail.com>
` Re: Help understand why DELETE is so slow
  2023-12-04 21:42 UTC  Ping Yao <ping@optigo.net>
` Re: Help understand why DELETE is so slow
  2023-12-04 21:51 UTC  Merlin Moncure <mmoncure@gmail.com>
` Re: Help understand why DELETE is so slow
  2023-12-05 00:43 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [6+ messages in thread]

libpq crashing on macOS during connection startup
  2023-11-30 14:45 UTC  John DeSoi <john@desoi.dev>
` Re: libpq crashing on macOS during connection startup
  2023-11-30 14:59 UTC  Joe Conway <mail@joeconway.com>
` Re: libpq crashing on macOS during connection startup
  2023-11-30 15:12 UTC  John DeSoi <john@desoi.dev>
` Re: libpq crashing on macOS during connection startup
  2023-11-30 15:36 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
` Re: libpq crashing on macOS during connection startup
  2023-11-30 15:49 UTC  John DeSoi <john@desoi.dev>
` Re: libpq crashing on macOS during connection startup
  2023-11-30 16:21 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
` Re: libpq crashing on macOS during connection startup
  2023-11-30 16:58 UTC  John DeSoi <john@desoi.dev>
` Re: libpq crashing on macOS during connection startup
  2023-11-30 20:07 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: libpq crashing on macOS during connection startup
  2023-12-01 01:26 UTC  John DeSoi <john@desoi.dev>
` Re: libpq crashing on macOS during connection startup
  2023-12-01 01:53 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: libpq crashing on macOS during connection startup
  2023-12-01 14:13 UTC  John DeSoi <john@desoi.dev>
` Re: libpq crashing on macOS during connection startup
  2023-12-01 17:02 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: libpq crashing on macOS during connection startup
  2023-12-01 17:24 UTC  John DeSoi <john@desoi.dev>
` Re: libpq crashing on macOS during connection startup
  2023-12-04 15:40 UTC  John DeSoi <john@desoi.dev>
  [14+ messages in thread]

vacuum visibility relevance
  2023-12-04 02:08 UTC  senor <frio_cervesa@hotmail.com>
` Re: vacuum visibility relevance
  2023-12-04 02:15 UTC  Ron Johnson <ronljohnsonjr@gmail.com>
` Re: vacuum visibility relevance
  2023-12-04 02:56 UTC  Laurenz Albe <laurenz.albe@cybertec.at>
` Re: vacuum visibility relevance
  2023-12-04 02:57 UTC  David Rowley <dgrowleyml@gmail.com>
  [4+ messages in thread]

Understanding partial index selection
  2023-11-28 22:23 UTC  Owen Nelson <onelson@gmail.com>
` Re: Understanding partial index selection
  2023-11-28 23:07 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Understanding partial index selection
  2023-11-28 23:08 UTC  David Rowley <dgrowleyml@gmail.com>
` Re: Understanding partial index selection
  2023-11-29 01:12 UTC  Owen Nelson <onelson@gmail.com>
` Re: Understanding partial index selection
  2023-11-29 01:44 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Understanding partial index selection
  2023-11-29 02:13 UTC  Owen Nelson <onelson@gmail.com>
` Re: Understanding partial index selection
  2023-11-29 05:23 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
` Re: Understanding partial index selection
  2023-12-01 19:08 UTC  Owen Nelson <onelson@gmail.com>
  [8+ messages in thread]

Query related to pg_dump write to a pipe on a windows client and with compressed format
  2023-12-01 02:57 UTC  Meera Nair <mnair@commvault.com>
` Re: Query related to pg_dump write to a pipe on a windows client and with compressed format
  2023-12-01 15:04 UTC  Ron Johnson <ronljohnsonjr@gmail.com>
` Re: Query related to pg_dump write to a pipe on a windows client and with compressed format
  2023-12-01 16:30 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
` Re: Query related to pg_dump write to a pipe on a windows client and with compressed format
  2023-12-01 18:19 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [4+ messages in thread]

Two started cluster on the same data directory and port
  2023-11-30 13:37 UTC  Loles <lolesft@gmail.com>
` Re: Two started cluster on the same data directory and port
  2023-11-30 15:23 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
` Re: Two started cluster on the same data directory and port
  2023-11-30 15:32 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
` Re: Two started cluster on the same data directory and port
  2023-11-30 16:37 UTC  Loles <lolesft@gmail.com>
` Re: Two started cluster on the same data directory and port
  2023-11-30 16:41 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
` Re: Two started cluster on the same data directory and port
  2023-11-30 16:43 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
` Re: Two started cluster on the same data directory and port
  2023-11-30 16:46 UTC  Loles <lolesft@gmail.com>
` Re: Two started cluster on the same data directory and port
  2023-11-30 17:01 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
` Re: Two started cluster on the same data directory and port
  2023-11-30 17:27 UTC  Loles <lolesft@gmail.com>
` Re: Two started cluster on the same data directory and port
  2023-11-30 18:35 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
` Re: Two started cluster on the same data directory and port
  2023-11-30 20:29 UTC  Loles <lolesft@gmail.com>
` Re: Two started cluster on the same data directory and port
  2023-11-30 20:35 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
` Re: Two started cluster on the same data directory and port
  2023-11-30 22:10 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
` Re: Two started cluster on the same data directory and port
  2023-12-01 04:43 UTC  Matthias Apitz <guru@unixarea.de>
` Re: Two started cluster on the same data directory and port
  2023-12-01 05:19 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
` Re: Two started cluster on the same data directory and port
  2023-12-01 09:17 UTC  Loles <lolesft@gmail.com>
` Re: Two started cluster on the same data directory and port
  2023-12-01 16:17 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
  [17+ messages in thread]

Feature request for INITCAP() function
  2023-12-01 02:08 UTC  Jeff Gerbracht <jeffgerbracht@gmail.com>
` Re: Feature request for INITCAP() function
  2023-12-01 07:22 UTC  Laurenz Albe <laurenz.albe@cybertec.at>
` Re: Feature request for INITCAP() function
  2023-12-01 11:52 UTC  Daniel Verite <daniel@manitou-mail.org>
  [3+ messages in thread]

PAF with Pacemaker
  2023-11-30 19:07 UTC  Vijaykumar Patil <vijaykumar.patil@maersk.com>
` Re: PAF with Pacemaker
  2023-12-01 08:07 UTC  Jehan-Guillaume de Rorthais <jgdr@dalibo.com>
  [2+ messages in thread]

replication strange behavior
  2023-11-30 20:41 UTC  Atul Kumar <akumar14871@gmail.com>
` Re: replication strange behavior
  2023-11-30 22:03 UTC  Ron Johnson <ronljohnsonjr@gmail.com>
` Re: replication strange behavior
  2023-11-30 23:42 UTC  Atul Kumar <akumar14871@gmail.com>
  [3+ messages in thread]

Fixing or Mitigating this ERROR: invalid page in block 35217 of relation base/16421/3192429
  2023-11-29 04:12 UTC  Abdul Qoyyuum <aqoyyuum@cardaccess.com.bn>
` Re: Fixing or Mitigating this ERROR: invalid page in block 35217 of relation base/16421/3192429
  2023-11-29 09:52 UTC  Stephen Frost <sfrost@snowman.net>
` Re: Fixing or Mitigating this ERROR: invalid page in block 35217 of relation base/16421/3192429
  2023-11-29 11:37 UTC  Chris Travers <chris.travers@gmail.com>
` Re: Fixing or Mitigating this ERROR: invalid page in block 35217 of relation base/16421/3192429
  2023-11-30 01:50 UTC  Abdul Qoyyuum <aqoyyuum@cardaccess.com.bn>
` Re: Fixing or Mitigating this ERROR: invalid page in block 35217 of relation base/16421/3192429
  2023-11-30 02:03 UTC  Abdul Qoyyuum <aqoyyuum@cardaccess.com.bn>
` Re: Fixing or Mitigating this ERROR: invalid page in block 35217 of relation base/16421/3192429
  2023-11-30 04:13 UTC  Chris Travers <chris.travers@gmail.com>
` Re: Fixing or Mitigating this ERROR: invalid page in block 35217 of relation base/16421/3192429
  2023-11-30 17:48 UTC  Stephen Frost <sfrost@snowman.net>
  [7+ messages in thread]

Re:Could not read from file "pg_subtrans/00F5" at offset 122880: Success.
  2023-11-27 11:50 UTC  Sri Mrudula Attili <sri@ebi.ac.uk>
` Re: Could not read from file "pg_subtrans/00F5" at offset 122880: Success.
  2023-11-27 16:12 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
` Re: Could not read from file "pg_subtrans/00F5" at offset 122880: Success.
  2023-11-27 18:58 UTC  Laurenz Albe <laurenz.albe@cybertec.at>
` Re: Could not read from file "pg_subtrans/00F5" at offset 122880: Success.
  2023-11-28 08:54 UTC  Kyotaro Horiguchi <horikyota.ntt@gmail.com>
` Re: Could not read from file "pg_subtrans/00F5" at offset 122880: Success.
  2023-11-28 14:57 UTC  Sri Mrudula Attili <sri@ebi.ac.uk>
` Re: Could not read from file "pg_subtrans/00F5" at offset 122880: Success.
  2023-11-29 17:20 UTC  Sri Mrudula Attili <sri@ebi.ac.uk>
` Re: Could not read from file "pg_subtrans/00F5" at offset 122880: Success.
  2023-11-29 17:29 UTC  Alvaro Herrera <alvherre@alvh.no-ip.org>
` Re: Could not read from file "pg_subtrans/00F5" at offset 122880: Success.
  2023-11-29 20:24 UTC  Ron Johnson <ronljohnsonjr@gmail.com>
` Re: Could not read from file "pg_subtrans/00F5" at offset 122880: Success.
  2023-11-30 00:39 UTC  Kyotaro Horiguchi <horikyota.ntt@gmail.com>
  [9+ messages in thread]

Removing oids with pg_repack
  2023-11-21 18:41 UTC  CG <cgg007@yahoo.com>
` Re: Removing oids with pg_repack
  2023-11-22 06:19 UTC  Achilleas Mantzios <a.mantzios@cloud.gatewaynet.com>
` Re: Removing oids with pg_repack
  2023-11-22 13:14 UTC  CG <cgg007@yahoo.com>
` Re: Removing oids with pg_repack
  2023-11-22 14:53 UTC  Ron Johnson <ronljohnsonjr@gmail.com>
` Re: Removing oids with pg_repack
  2023-11-22 14:59 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Removing oids with pg_repack
  2023-11-22 17:38 UTC  Achilleas Mantzios <a.mantzios@cloud.gatewaynet.com>
` Re: Removing oids with pg_repack
  2023-11-27 14:51 UTC  CG <cgg007@yahoo.com>
` Re: Removing oids with pg_repack
  2023-11-29 21:54 UTC  Achilleas Mantzios <a.mantzios@cloud.gatewaynet.com>
  [8+ messages in thread]

Installing extension temporal_tables for PG13
  2023-11-27 23:37 UTC  H <agents@meddatainc.com>
` Re: Installing extension temporal_tables for PG13
  2023-11-27 23:58 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
` Re: Installing extension temporal_tables for PG13
  2023-11-28 00:18 UTC  H <agents@meddatainc.com>
` Re: Installing extension temporal_tables for PG13
  2023-11-28 00:24 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
` Re: Installing extension temporal_tables for PG13
  2023-11-28 00:26 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
` Re: Installing extension temporal_tables for PG13
  2023-11-28 01:17 UTC  H <agents@meddatainc.com>
` Re: Installing extension temporal_tables for PG13
  2023-11-28 01:38 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
` Re: Installing extension temporal_tables for PG13
  2023-11-28 01:41 UTC  H <agents@meddatainc.com>
` Re: Installing extension temporal_tables for PG13
  2023-11-28 01:48 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
` Re: Installing extension temporal_tables for PG13
  2023-11-28 02:18 UTC  H <agents@meddatainc.com>
` Re: Installing extension temporal_tables for PG13
  2023-11-28 05:38 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
` Re: Installing extension temporal_tables for PG13
  2023-11-29 21:15 UTC  H <agents@meddatainc.com>
  [12+ messages in thread]

Query runtime differences-  trying to understand why.
  2023-11-29 20:25 UTC  Dirschel, Steve <steve.dirschel@thomsonreuters.com>
` Re: Query runtime differences- trying to understand why.
  2023-11-29 21:09 UTC  Andreas Kretschmer <andreas@a-kretschmer.de>
` RE: [EXT] Re: Query runtime differences- trying to understand why.
  2023-11-29 21:14 UTC  Dirschel, Steve <steve.dirschel@thomsonreuters.com>
  [3+ messages in thread]

Get back the number of columns of a result-set prior to JSON aggregation
  2023-11-28 12:12 UTC  Dominique Devienne <ddevienne@gmail.com>
` Re: Get back the number of columns of a result-set prior to JSON aggregation
  2023-11-28 17:05 UTC  hector vass <hector.vass@gmail.com>
` Re: Get back the number of columns of a result-set prior to JSON aggregation
  2023-11-28 17:53 UTC  Erik Wienhold <ewie@ewie.name>
  [3+ messages in thread]

Off-label use for pg_repack
  2023-11-28 16:46 UTC  CG <cgg007@yahoo.com>
` Re: Off-label use for pg_repack
  2023-11-28 17:05 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
  [2+ messages in thread]

How to eliminate extra "NOT EXISTS"-query here?
  2023-11-25 13:26 UTC  Andreas Joseph Krogh <andreas@visena.com>
` Re: How to eliminate extra "NOT EXISTS"-query here?
  2023-11-25 16:08 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: How to eliminate extra "NOT EXISTS"-query here?
  2023-11-25 16:52 UTC  hector vass <hector.vass@gmail.com>
` Re: How to eliminate extra "NOT EXISTS"-query here?
  2023-11-25 17:18 UTC  Andreas Joseph Krogh <andreas@visena.com>
` Re: How to eliminate extra "NOT EXISTS"-query here?
  2023-11-27 09:29 UTC  Dominique Devienne <ddevienne@gmail.com>
` Re: How to eliminate extra "NOT EXISTS"-query here?
  2023-11-28 14:14 UTC  hector vass <hector.vass@gmail.com>
  [6+ messages in thread]

IPV6 issue
  2023-11-23 19:18 UTC  Atul Kumar <akumar14871@gmail.com>
` Re: IPV6 issue
  2023-11-23 19:35 UTC  Andreas Kretschmer <andreas@a-kretschmer.de>
` Re: IPV6 issue
  2023-11-23 20:43 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
` Re: IPV6 issue
  2023-11-27 20:11 UTC  Atul Kumar <akumar14871@gmail.com>
` Re: IPV6 issue
  2023-11-27 20:31 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
` Re: IPV6 issue
  2023-11-27 20:41 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: IPV6 issue
  2023-11-28 00:39 UTC  Atul Kumar <akumar14871@gmail.com>
` Re: IPV6 issue
  2023-11-28 00:42 UTC  Atul Kumar <akumar14871@gmail.com>
` Re: IPV6 issue
  2023-11-28 00:56 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
` Re: IPV6 issue
  2023-11-28 00:58 UTC  Atul Kumar <akumar14871@gmail.com>
` Re: IPV6 issue
  2023-11-28 01:14 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
  [11+ messages in thread]

malloc errors in psql with libpq 16.1 on Mac
  2023-11-27 23:52 UTC  Don Seiler <don@seiler.us>
` Re: malloc errors in psql with libpq 16.1 on Mac
  2023-11-28 00:02 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: malloc errors in psql with libpq 16.1 on Mac
  2023-11-28 00:27 UTC  Don Seiler <don@seiler.us>
` Re: malloc errors in psql with libpq 16.1 on Mac
  2023-11-28 00:31 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [4+ messages in thread]

Dynamically generate a nested json
  2023-11-27 22:32 UTC  Rushabh Shah <rushabh1007@gmail.com>

suppress notices from inside a stored a plpgqsl function
  2023-11-27 20:51 UTC  David Gauthier <dfgpostgres@gmail.com>
` Re: suppress notices from inside a stored a plpgqsl function
  2023-11-27 21:00 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
  [2+ messages in thread]

Ways to aggregate table info from variable number of schemas
  2023-11-27 18:16 UTC  Dominique Devienne <ddevienne@gmail.com>
` Re: Ways to aggregate table info from variable number of schemas
  2023-11-27 18:21 UTC  Christophe Pettus <xof@thebuild.com>
  [2+ messages in thread]

Parallel Index Scan Implementation
  2023-11-26 13:51 UTC  Brajendra Pratap Singh <singh.bpratap766@gmail.com>
` Re: Parallel Index Scan Implementation
  2023-11-27 15:27 UTC  Ron Johnson <ronljohnsonjr@gmail.com>
  [2+ messages in thread]


[next (older)]

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