pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
EXPLAIN PLAN for DELETE CASCADE or DELETE not using pkey index despite EXPLAINing that it would?
  2019-03-21 19:31 UTC  Gunther <raj@gusw.net>
` Re: EXPLAIN PLAN for DELETE CASCADE or DELETE not using pkey index despite EXPLAINing that it would?
  2019-03-21 21:16 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: EXPLAIN PLAN for DELETE CASCADE or DELETE not using pkey index despite EXPLAINing that it would?
  2019-03-22 20:01 UTC  Gunther <raj@gusw.net>
` Re: EXPLAIN PLAN for DELETE CASCADE or DELETE not using pkey index despite EXPLAINing that it would?
  2019-03-22 20:07 UTC  Justin Pryzby <pryzby@telsasoft.com>
  [4+ messages in thread]

Poor man's partitioned index .... not being used?
  2019-03-21 02:45 UTC  Gunther <raj@gusw.net>
` Re: Poor man's partitioned index .... not being used?
  2019-03-21 03:34 UTC  David Rowley <david.rowley@2ndquadrant.com>
` Re: Poor man's partitioned index .... not being used?
  2019-03-21 03:46 UTC  Andrew Gierth <andrew@tao11.riddles.org.uk>
` Re: Poor man's partitioned index .... not being used?
  2019-03-21 18:57 UTC  Gunther <raj@gusw.net>
` Re: Poor man's partitioned index .... not being used?
  2019-03-22 12:56 UTC  David Rowley <david.rowley@2ndquadrant.com>
  [5+ messages in thread]

AW: Performance issue with order by clause on
  2019-03-20 21:49 UTC  Stephan Schmidt <schmidt@dltmail.de>

Performance issue with order by clause on
  2019-03-20 11:05 UTC  Maracska Ádám <csuszmusz@gmail.com>
` Re: Performance issue with order by clause on
  2019-03-20 17:34 UTC  Corey Huinker <corey.huinker@gmail.com>
  [2+ messages in thread]

Distributing data over "spindles" even on AWS EBS, (followup to the work queue saga)
  2019-03-13 18:44 UTC  Gunther <raj@gusw.net>
` Re: Distributing data over "spindles" even on AWS EBS, (followup to the work queue saga)
  2019-03-14 14:53 UTC  Gunther <raj@gusw.net>
` Re: Distributing data over "spindles" even on AWS EBS, (followup to the work queue saga)
  2019-03-14 15:11 UTC  Jeremy Schneider <schnjere@amazon.com>
` Re: Distributing data over "spindles" even on AWS EBS, (followup to the work queue saga)
  2019-03-14 15:54 UTC  Justin Pryzby <pryzby@telsasoft.com>
` Re: Distributing data over "spindles" even on AWS EBS, (followup to the work queue saga)
  2019-03-17 18:42 UTC  Gunther <raj@gusw.net>
` Re: Distributing data over "spindles" even on AWS EBS, (followup to the work queue saga)
  2019-03-19 15:18 UTC  Sam Gendler <sgendler@ideasculptor.com>
  [6+ messages in thread]

Facing issue in using special characters
  2019-03-15 05:19 UTC  M Tarkeshwar Rao <m.tarkeshwar.rao@ericsson.com>
` Re: Facing issue in using special characters
  2019-03-15 06:33 UTC  David G. Johnston <david.g.johnston@gmail.com>
` Re: Facing issue in using special characters
  2019-03-15 15:59 UTC  Gunther <raj@gusw.net>
` Re: Facing issue in using special characters
  2019-03-15 19:26 UTC  Chapman Flack <chap@anastigmatix.net>
` Re: Facing issue in using special characters
  2019-03-17 15:01 UTC  Warner, Gary, Jr <gar@uab.edu>
` Re: Facing issue in using special characters
  2019-03-18 21:19 UTC  Peter J. Holzer <hjp-pgsql@hjp.at>
  [6+ messages in thread]

MDRaid or LSI MegaRAID?
  2019-03-16 18:58 UTC  Rory Campbell-Lange <rory@campbell-lange.net>

jsonb_set performance degradation / multiple jsonb_set on multiple documents
  2019-03-15 16:02 UTC  Alexandru Lazarev <alexandru.lazarev@gmail.com>
` Re: jsonb_set performance degradation / multiple jsonb_set on multiple documents
  2019-03-15 16:35 UTC  Michel Pelletier <pelletier.michel@gmail.com>
  [2+ messages in thread]

impact of auto explain on overall performance
  2019-03-14 07:29 UTC  Stephan Schmidt <schmidt@dltmail.de>
` Re: impact of auto explain on overall performance
  2019-03-14 08:23 UTC  Justin Pryzby <pryzby@telsasoft.com>
` Re: impact of auto explain on overall performance
  2019-03-14 09:08 UTC  Adrien NAYRAT <adrien.nayrat@anayrat.info>
` Re: impact of auto explain on overall performance
  2019-03-14 17:50 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: impact of auto explain on overall performance
  2019-03-14 19:58 UTC  Jeremy Schneider <schneider@ardentperf.com>
  [5+ messages in thread]

ERROR: found xmin from before relfrozenxid
  2019-01-23 15:25 UTC  Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: ERROR: found xmin from before relfrozenxid
  2019-01-23 19:42 UTC  Jerry Sievers <gsievers19@comcast.net>
` Re: ERROR: found xmin from before relfrozenxid
  2019-01-24 06:32 UTC  Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: ERROR: found xmin from before relfrozenxid
  2019-01-24 14:14 UTC  Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: ERROR: found xmin from before relfrozenxid
  2019-01-25 08:18 UTC  Adrien NAYRAT <adrien.nayrat@anayrat.info>
` Re: ERROR: found xmin from before relfrozenxid
  2019-01-25 17:20 UTC  Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: ERROR: found xmin from before relfrozenxid
  2019-01-26 10:48 UTC  Adrien NAYRAT <adrien.nayrat@anayrat.info>
` Re: ERROR: found xmin from before relfrozenxid
  2019-01-26 10:56 UTC  Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: ERROR: found xmin from before relfrozenxid
  2019-01-26 10:59 UTC  Adrien NAYRAT <adrien.nayrat@anayrat.info>
` Re: ERROR: found xmin from before relfrozenxid
  2019-01-30 07:51 UTC  Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: ERROR: found xmin from before relfrozenxid
  2019-01-30 09:13 UTC  Alvaro Herrera <alvherre@2ndquadrant.com>
` Re: ERROR: found xmin from before relfrozenxid
  2019-01-30 10:35 UTC  Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: ERROR: found xmin from before relfrozenxid
  2019-02-04 16:42 UTC  Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: ERROR: found xmin from before relfrozenxid
  2019-03-12 07:58 UTC  Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: ERROR: found xmin from before relfrozenxid
  2019-03-13 12:24 UTC  Adrien NAYRAT <adrien.nayrat@anayrat.info>
` Re: ERROR: found xmin from before relfrozenxid
  2019-03-13 12:29 UTC  Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: ERROR: found xmin from before relfrozenxid
  2019-03-13 12:48 UTC  Alexandre Arruda <adaldeia@gmail.com>
` Re: ERROR: found xmin from before relfrozenxid
  2019-03-13 12:59 UTC  Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: ERROR: found xmin from before relfrozenxid
  2019-03-13 15:30 UTC  Adrien NAYRAT <adrien.nayrat@anayrat.info>
  [19+ messages in thread]

Planner not choosing GIN index
  2019-03-13 01:44 UTC  Corey Huinker <corey.huinker@gmail.com>
` Re: Planner not choosing GIN index
  2019-03-13 09:10 UTC  Flo Rance <trourance@gmail.com>
` Re: Planner not choosing GIN index
  2019-03-13 13:55 UTC  Corey Huinker <corey.huinker@gmail.com>
` Re: Planner not choosing GIN index
  2019-03-13 14:20 UTC  Flo Rance <trourance@gmail.com>
  [4+ messages in thread]

shared buffers
  2005-08-29 16:23 UTC  Carlos Henrique Reimer <carlosreimer@yahoo.com.br>
` Re: shared buffers
  2005-08-30 01:27 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: shared buffers
  2005-08-30 01:54 UTC  Carlos Henrique Reimer <carlosreimer@yahoo.com.br>
` Re: shared buffers
  2005-08-30 02:08 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: shared buffers
  2005-08-30 02:16 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: shared buffers
  2005-08-30 07:05 UTC  William Yu <wyu@talisys.com>
` Re: shared buffers
  2005-09-05 02:56 UTC  Martin Nickel <martin@portant.com>
` Re: shared buffers
  2005-09-11 12:35 UTC  John A Meinel <john@arbash-meinel.com>
` shared_buffers
  2010-02-22 15:04 UTC  George Sexton <georges@mhsoftware.com>
` Re: shared_buffers
  2010-02-22 15:23 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Shared_buffers
  2019-03-11 08:12 UTC  Daulat Ram <Daulat.Ram@exponential.com>
` Re: Shared_buffers
  2019-03-12 08:29 UTC  Laurenz Albe <laurenz.albe@cybertec.at>
` Re: Shared_buffers
  2019-03-12 19:23 UTC  Michael Lewis <mlewis@entrata.com>
` Re: Shared_buffers
  2019-03-12 20:03 UTC  MichaelDBA <MichaelDBA@sqlexec.com>
` Re: Shared_buffers
  2019-03-12 20:11 UTC  Justin Pryzby <pryzby@telsasoft.com>
` Re: Shared_buffers
  2019-03-12 20:11 UTC  MichaelDBA <MichaelDBA@sqlexec.com>
  [16+ messages in thread]

Performance regression related to parallel execution
  2019-03-11 19:19 UTC  Jinho Jung <jinhojun@usc.edu>

Wired execution in my benchmark using postgresql 9.6
  2019-03-11 14:14 UTC  tayeb merabti <tayeb.merabti@gmail.com>

Hot to model data in DB (PostgreSQL) for SNMP-like multiple configurations
  2019-03-08 14:39 UTC  Alexandru Lazarev <alexandru.lazarev@gmail.com>
` Re: Hot to model data in DB (PostgreSQL) for SNMP-like multiple configurations
  2019-03-08 15:15 UTC  Alban Hertroys <haramrae@gmail.com>
` Re: Hot to model data in DB (PostgreSQL) for SNMP-like multiple configurations
  2019-03-08 16:40 UTC  Alexandru Lazarev <alexandru.lazarev@gmail.com>
` Re: Hot to model data in DB (PostgreSQL) for SNMP-like multiple configurations
  2019-03-09 20:08 UTC  Rene Romero Benavides <rene.romero.b@gmail.com>
  [4+ messages in thread]

IS NOT DISTINCT FROM statement
  2019-03-08 11:30 UTC  =?iso-8859-2?Q?Artur_Zaj=B1c?= <azajac@ang.com.pl>
` Re: IS NOT DISTINCT FROM statement
  2019-03-08 11:45 UTC  Laurenz Albe <laurenz.albe@cybertec.at>
` Re: IS NOT DISTINCT FROM statement
  2019-03-08 12:13 UTC  David Rowley <david.rowley@2ndquadrant.com>
` RE: IS NOT DISTINCT FROM statement
  2019-03-08 12:25 UTC  Artur Zając <azajac@ang.com.pl>
` Re: IS NOT DISTINCT FROM statement
  2019-03-08 13:12 UTC  David Rowley <david.rowley@2ndquadrant.com>
` Re: IS NOT DISTINCT FROM statement
  2019-03-08 14:53 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [6+ messages in thread]

rusage (Re: Good afternoon.)
  2019-03-06 22:48 UTC  Justin Pryzby <pryzby@telsasoft.com>
` Re: rusage (Re: Good afternoon.)
  2019-03-06 22:59 UTC  Julien Rouhaud <rjuju123@gmail.com>
  [2+ messages in thread]

Performance regressions found using sqlfuzz
  2019-02-11 22:29 UTC  Jung, Jinho <jinho.jung@gatech.edu>
` Re: Performance regressions found using sqlfuzz
  2019-02-12 12:00 UTC  Christoph Berg <myon@debian.org>
` Re: Performance regressions found using sqlfuzz
  2019-02-12 18:03 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: Performance regressions found using sqlfuzz
  2019-02-14 17:27 UTC  Jung, Jinho <jinho.jung@gatech.edu>
` Re: Performance regressions found using sqlfuzz
  2019-02-15 16:20 UTC  Andrew Gierth <andrew@tao11.riddles.org.uk>
` Re: Performance regressions found using sqlfuzz
  2019-02-15 16:44 UTC  Andres Freund <andres@anarazel.de>
` Re: Performance regressions found using sqlfuzz
  2019-02-16 22:37 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Performance regressions found using sqlfuzz
  2019-02-18 21:08 UTC  Jung, Jinho <jinho.jung@gatech.edu>
` Re: Performance regressions found using sqlfuzz
  2019-02-28 16:43 UTC  Jung, Jinho <jinho.jung@gatech.edu>
` Performance regressions found using sqlfuzz
  2019-03-06 21:41 UTC  Jinho Jung <jinhojun@usc.edu>
  [10+ messages in thread]

JIT performance question
  2019-03-06 17:16 UTC  Tobias Gierke <tobias.gierke@code-sourcery.de>
` Re: JIT performance question
  2019-03-06 17:42 UTC  Andres Freund <andres@anarazel.de>
` Re: JIT performance question
  2019-03-06 18:21 UTC  Tobias Gierke <tobias.gierke@code-sourcery.de>
` Re: JIT performance question
  2019-03-06 18:32 UTC  Andres Freund <andres@anarazel.de>
  [4+ messages in thread]

autovacuum just stop vacuuming specific table for 7 hours
  2019-03-06 16:47 UTC  Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: autovacuum just stop vacuuming specific table for 7 hours
  2019-03-06 17:05 UTC  Justin Pryzby <pryzby@telsasoft.com>
` Re: autovacuum just stop vacuuming specific table for 7 hours
  2019-03-06 17:16 UTC  Mariel Cherkassky <mariel.cherkassky@gmail.com>
  [3+ messages in thread]

Server upgrade advice [xpost]
  2019-03-05 22:03 UTC  Rory Campbell-Lange <rory@campbell-lange.net>
` Re: Server upgrade advice [xpost]
  2019-03-06 05:04 UTC  Ian Harding <harding.ian@gmail.com>
  [2+ messages in thread]

pgstattuple_approx for toasted table
  2019-03-03 15:59 UTC  Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: pgstattuple_approx for toasted table
  2019-03-04 05:21 UTC  Laurenz Albe <laurenz.albe@cybertec.at>
  [2+ messages in thread]

How to get the content of Bind variables
  2019-02-28 12:21 UTC  ROS Didier <didier.ros@edf.fr>
` Re: How to get the content of Bind variables
  2019-02-28 12:36 UTC  MichaelDBA <MichaelDBA@sqlexec.com>
` RE: How to get the content of Bind variables
  2019-02-28 12:47 UTC  ROS Didier <didier.ros@edf.fr>
` Re: How to get the content of Bind variables
  2019-02-28 16:01 UTC  Laurenz Albe <laurenz.albe@cybertec.at>
` RE: How to get the content of Bind variables
  2019-02-28 16:12 UTC  ROS Didier <didier.ros@edf.fr>
` Re: How to get the content of Bind variables
  2019-02-28 16:19 UTC  Justin Pryzby <pryzby@telsasoft.com>
` RE: How to get the content of Bind variables
  2019-03-01 07:54 UTC  ROS Didier <didier.ros@edf.fr>
` Re: How to get the content of Bind variables
  2019-03-01 08:31 UTC  Laurenz Albe <laurenz.albe@cybertec.at>
` Re: How to get the content of Bind variables
  2019-03-01 16:29 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` RE: How to get the content of Bind variables
  2019-03-01 18:47 UTC  ROS Didier <didier.ros@edf.fr>
` RE: How to get the content of Bind variables
  2019-03-01 20:41 UTC  legrand legrand <legrand_legrand@hotmail.com>
` RE: How to get the content of Bind variables
  2019-03-02 13:14 UTC  ROS Didier <didier.ros@edf.fr>
` RE: How to get the content of Bind variables
  2019-03-02 14:10 UTC  legrand legrand <legrand_legrand@hotmail.com>
` Re: How to get the content of Bind variables
  2019-03-02 15:56 UTC  Justin Pryzby <pryzby@telsasoft.com>
` Re: How to get the content of Bind variables
  2019-03-02 16:33 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: How to get the content of Bind variables
  2019-03-02 16:33 UTC  Sergei Kornilov <sk@zsrv.org>
` RE: How to get the content of Bind variables
  2019-03-02 19:14 UTC  ROS Didier <didier.ros@edf.fr>
` RE: How to get the content of Bind variables
  2019-03-02 19:19 UTC  ROS Didier <didier.ros@edf.fr>
  [18+ messages in thread]

What is pg_stat_user_tables Showing NULL for last_autoanalyze & last_autovacuum
  2019-02-27 14:47 UTC  Fd Habash <fmhabash@gmail.com>
` Re: What is pg_stat_user_tables Showing NULL for last_autoanalyze & last_autovacuum
  2019-02-27 16:15 UTC  Justin Pryzby <pryzby@telsasoft.com>
` Re: What is pg_stat_user_tables Showing NULL for last_autoanalyze & last_autovacuum
  2019-02-28 08:44 UTC  Laurenz Albe <laurenz.albe@cybertec.at>
` RE: What is pg_stat_user_tables Showing NULL for last_autoanalyze &last_autovacuum
  2019-02-28 13:34 UTC  Fd Habash <fmhabash@gmail.com>
  [4+ messages in thread]

Query slow for new participants
  2019-02-25 10:41 UTC  Kim <support@mekong.be>
` Re: Query slow for new participants
  2019-02-25 16:16 UTC  Justin Pryzby <pryzby@telsasoft.com>
` Re: Query slow for new participants
  2019-02-25 19:23 UTC  support@mekong.be <support@mekong.be>
` Re: Query slow for new participants
  2019-02-25 23:22 UTC  support@mekong.be <support@mekong.be>
` Re: Query slow for new participants
  2019-02-25 23:59 UTC  Justin Pryzby <pryzby@telsasoft.com>
` Re: Query slow for new participants
  2019-02-26 00:30 UTC  MichaelDBA <MichaelDBA@sqlexec.com>
` Re: Query slow for new participants
  2019-02-26 19:08 UTC  Michael Lewis <mlewis@entrata.com>
` Re: Query slow for new participants
  2019-02-26 21:39 UTC  support@mekong.be <support@mekong.be>
` Re: Query slow for new participants
  2019-02-27 07:58 UTC  Laurenz Albe <laurenz.albe@cybertec.at>
  [9+ 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