pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Special bloom index of INT, BIGINT, BIT, VARBIT for bitwise operation
  2018-07-11 06:02 UTC  Takao Magoori <mago@magomago.jp>
` Re: Special bloom index of INT, BIGINT, BIT, VARBIT for bitwise operation
  2018-07-17 14:57 UTC  Tomas Vondra <tomas.vondra@2ndquadrant.com>
  [2+ messages in thread]

HDD vs SSD without explanation
  2018-01-14 20:44 UTC  Neto pr <netopr9@gmail.com>
` Re: HDD vs SSD without explanation
  2018-01-14 21:40 UTC  Justin Pryzby <pryzby@telsasoft.com>
` Re: HDD vs SSD without explanation
  2018-01-14 23:59 UTC  Neto pr <netopr9@gmail.com>
` Re: HDD vs SSD without explanation
  2018-01-15 02:25 UTC  Neto pr <netopr9@gmail.com>
` Re: HDD vs SSD without explanation
  2018-01-15 02:36 UTC  Neto pr <netopr9@gmail.com>
` Re: HDD vs SSD without explanation
  2018-01-15 03:09 UTC  Justin Pryzby <pryzby@telsasoft.com>
` Re: HDD vs SSD without explanation
  2018-01-15 11:04 UTC  Neto pr <netopr9@gmail.com>
` Re: HDD vs SSD without explanation
  2018-01-15 12:35 UTC  Neto pr <netopr9@gmail.com>
` Re: HDD vs SSD without explanation
  2018-01-15 18:32 UTC  Georg H. <georg-h@silentrunner.de>
` Re: HDD vs SSD without explanation
  2018-01-15 19:46 UTC  Brian Busch <bdbuschg@gmail.com>
` Re: HDD vs SSD without explanation
  2018-01-15 19:55 UTC  Fernando Hevia <fhevia@gmail.com>
` Re: HDD vs SSD without explanation
  2018-01-15 23:10 UTC  Neto pr <netopr9@gmail.com>
` Re: HDD vs SSD without explanation
  2018-01-15 23:25 UTC  Neto pr <netopr9@gmail.com>
` Re: HDD vs SSD without explanation
  2018-01-16 00:18 UTC  Fernando Hevia <fhevia@gmail.com>
` Re: HDD vs SSD without explanation
  2018-01-16 01:19 UTC  Neto pr <netopr9@gmail.com>
` Re: HDD vs SSD without explanation
  2018-01-16 01:58 UTC  Justin Pryzby <pryzby@telsasoft.com>
` Re: HDD vs SSD without explanation
  2018-01-16 02:25 UTC  Neto pr <netopr9@gmail.com>
` Re: HDD vs SSD without explanation
  2018-01-16 04:04 UTC  Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
` Re: HDD vs SSD without explanation
  2018-01-16 10:14 UTC  Neto pr <netopr9@gmail.com>
` Re: HDD vs SSD without explanation
  2018-01-16 15:08 UTC  Nicolas Charles <nicolas.charles@normation.com>
` Re: HDD vs SSD without explanation
  2018-01-16 21:24 UTC  Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
` Re: HDD vs SSD without explanation
  2018-07-17 12:47 UTC  Neto pr <netopr9@gmail.com>
  [22+ messages in thread]

High concurrency but simple updating causes deadlock
  2018-07-11 14:16 UTC  枫 <liufeng_leo@qq.com>
` Re: High concurrency but simple updating causes deadlock
  2018-07-12 10:55 UTC  Roman Konoval <rkonoval@gmail.com>
  [2+ messages in thread]

Suggestion to optimize performance of the PLSQL procedure.
  2018-07-12 03:18 UTC  Dinesh Chandra 12108 <Dinesh.Chandra@cyient.com>

add default parallel query to v10 release notes? (Re: [PERFORM] performance drop after upgrade (9.6 > 10))
  2018-05-25 01:00 UTC  Justin Pryzby <pryzby@telsasoft.com>
` Re: add default parallel query to v10 release notes? (Re: [PERFORM] performance drop after upgrade (9.6 > 10))
  2018-06-20 15:13 UTC  Bruce Momjian <bruce@momjian.us>
` Re: add default parallel query to v10 release notes? (Re: [PERFORM] performance drop after upgrade (9.6 > 10))
  2018-06-22 09:23 UTC  Amit Kapila <amit.kapila16@gmail.com>
` Re: add default parallel query to v10 release notes? (Re: [PERFORM] performance drop after upgrade (9.6 > 10))
  2018-07-09 15:19 UTC  Bruce Momjian <bruce@momjian.us>
  [4+ messages in thread]

where can I download the binaries of plpython extension
  2018-07-08 13:06 UTC  Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: where can I download the binaries of plpython extension
  2018-07-08 13:20 UTC  Justin Pryzby <pryzby@telsasoft.com>
` Re: where can I download the binaries of plpython extension
  2018-07-08 13:24 UTC  Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: where can I download the binaries of plpython extension
  2018-07-08 13:33 UTC  Justin Pryzby <pryzby@telsasoft.com>
` Re: where can I download the binaries of plpython extension
  2018-07-08 13:38 UTC  Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: where can I download the binaries of plpython extension
  2018-07-08 13:43 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: where can I download the binaries of plpython extension
  2018-07-08 13:43 UTC  Justin Pryzby <pryzby@telsasoft.com>
` Re: where can I download the binaries of plpython extension
  2018-07-08 13:46 UTC  Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: where can I download the binaries of plpython extension
  2018-07-08 14:18 UTC  Justin Pryzby <pryzby@telsasoft.com>
` Re: where can I download the binaries of plpython extension
  2018-07-08 14:36 UTC  Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: where can I download the binaries of plpython extension
  2018-07-08 17:25 UTC  Justin Pryzby <pryzby@telsasoft.com>
` Re: where can I download the binaries of plpython extension
  2018-07-09 06:18 UTC  Mariel Cherkassky <mariel.cherkassky@gmail.com>
  [12+ messages in thread]

Problems with installing pgwatch2 without docker
  2018-07-08 14:22 UTC  Mariel Cherkassky <MarielC@bezeqint.co.il>
` Re: Problems with installing pgwatch2 without docker
  2018-07-08 16:35 UTC  Andrew Dunstan <andrew.dunstan@2ndquadrant.com>
  [2+ messages in thread]

Trigger overhead/performance and alternatives?
  2018-07-01 09:31 UTC  AJG <ayden@gera.co.nz>
` Re: Trigger overhead/performance and alternatives?
  2018-07-07 07:47 UTC  Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
  [2+ messages in thread]

tcp_keepalives
  2018-07-04 13:19 UTC  José Mello Júnior <jose.mello.junior@gmail.com>
` Re: tcp_keepalives
  2018-07-05 03:56 UTC  Justin Pryzby <pryzby@telsasoft.com>
  [2+ messages in thread]

Bug in PostgreSQL
  2018-06-27 15:30 UTC  Rambabu V <ram.wissen@gmail.com>
` Re: Bug in PostgreSQL
  2018-06-27 15:50 UTC  Steve Crawford <scrawford@pinpointresearch.com>
` Re: Bug in PostgreSQL
  2018-06-27 15:53 UTC  Joseph Curtin <jbcurtincode@gmail.com>
` Re: Bug in PostgreSQL
  2018-06-28 06:55 UTC  Laurenz Albe <laurenz.albe@cybertec.at>
` Re: Bug in PostgreSQL
  2018-06-28 16:13 UTC  Andres Freund <andres@anarazel.de>
  [5+ messages in thread]

Queue table that quickly grows causes query planner to choose poor plan
  2018-06-27 03:45 UTC  David Wheeler <dwheeler@dgitsystems.com>
` Re: Queue table that quickly grows causes query planner to choose poor plan
  2018-06-27 18:05 UTC  Justin Pryzby <pryzby@telsasoft.com>
` Re: Queue table that quickly grows causes query planner to choose poor plan
  2018-06-27 18:27 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Queue table that quickly grows causes query planner to choose poor plan
  2018-06-28 00:00 UTC  David Wheeler <dwheeler@dgitsystems.com>
  [4+ messages in thread]

Slow join
  2018-06-25 15:55 UTC  Roman Kushnir <roman.kushnir@ad2games.com>
` Re: Slow join
  2018-06-25 16:45 UTC  Justin Pryzby <pryzby@telsasoft.com>
` Re: Slow join
  2018-06-25 19:39 UTC  Roman Kushnir <roman.kushnir@ad2games.com>
` Re: Slow join
  2018-06-27 08:19 UTC  Laurenz Albe <laurenz.albe@cybertec.at>
` Re: Slow join
  2018-06-27 09:02 UTC  Roman Kushnir <roman.kushnir@ad2games.com>
  [5+ messages in thread]

"set primary keys..." is missing when using hight values for transactions / scaling factor with pgbench
  2018-06-26 12:21 UTC  Elvir Kurić <elvirkuric@gmail.com>
` Re: "set primary keys..." is missing when using hight values for transactions / scaling factor with pgbench
  2018-06-26 12:41 UTC  David Rowley <david.rowley@2ndquadrant.com>
` Re: "set primary keys..." is missing when using hight values for transactions / scaling factor with pgbench
  2018-06-26 12:51 UTC  Elvir Kurić <elvirkuric@gmail.com>
  [3+ messages in thread]

Slow query when pg_trgm is in inner lopp
  2018-06-20 13:21 UTC  Sasa Vilic <sasavilic@gmail.com>
` Re: Slow query when pg_trgm is in inner lopp
  2018-06-20 13:29 UTC  Matthew Hall <mhall@mhcomputing.net>
` Re: Slow query when pg_trgm is in inner lopp
  2018-06-20 14:13 UTC  Sasa Vilic <sasavilic@gmail.com>
` Re: Slow query when pg_trgm is in inner lopp
  2018-06-20 14:53 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: Slow query when pg_trgm is in inner lopp
  2018-06-20 15:38 UTC  Sasa Vilic <sasavilic@gmail.com>
  [5+ messages in thread]

[PERFORM] Dissuade the use of exclusion constraint index
  2018-04-06 16:30 UTC  Adam Brusselback <adambrusselback@gmail.com>
` Re: [PERFORM] Dissuade the use of exclusion constraint index
  2018-04-11 05:59 UTC  Adam Brusselback <adambrusselback@gmail.com>
` Re: [PERFORM] Dissuade the use of exclusion constraint index
  2018-04-11 09:41 UTC  Dave Cramer <pg@fastcrypt.com>
` Re: [PERFORM] Dissuade the use of exclusion constraint index
  2018-04-11 14:47 UTC  Adam Brusselback <adambrusselback@gmail.com>
` Re: [PERFORM] Dissuade the use of exclusion constraint index
  2018-06-13 15:59 UTC  Adam Brusselback <adambrusselback@gmail.com>
` Re: [PERFORM] Dissuade the use of exclusion constraint index
  2018-06-19 19:50 UTC  Adam Brusselback <adambrusselback@gmail.com>
  [6+ messages in thread]

Small query plan change, big performance difference
  2018-06-14 18:02 UTC  Michael Sacket <msacket@gammastream.com>
` Re: Small query plan change, big performance difference
  2018-06-14 18:24 UTC  Adam Brusselback <adambrusselback@gmail.com>
` Re: Small query plan change, big performance difference
  2018-06-14 18:49 UTC  Michael Sacket <msacket@gammastream.com>
  [3+ messages in thread]

pg_upgrade 10.2
  2018-06-12 20:34 UTC  Murthy Nunna <mnunna@fnal.gov>
` Re: pg_upgrade 10.2
  2018-06-12 20:47 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
` RE: pg_upgrade 10.2
  2018-06-12 20:58 UTC  Murthy Nunna <mnunna@fnal.gov>
` Re: pg_upgrade 10.2
  2018-06-12 21:13 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
` RE: pg_upgrade 10.2
  2018-06-12 21:18 UTC  Murthy Nunna <mnunna@fnal.gov>
` Re: pg_upgrade 10.2
  2018-06-12 21:34 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
` RE: pg_upgrade 10.2
  2018-06-12 21:49 UTC  Murthy Nunna <mnunna@fnal.gov>
` Re: pg_upgrade 10.2
  2018-06-12 23:24 UTC  Jerry Sievers <gsievers19@comcast.net>
` RE: pg_upgrade 10.2
  2018-06-12 23:41 UTC  Murthy Nunna <mnunna@fnal.gov>
` Re: pg_upgrade 10.2
  2018-06-12 23:50 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
` Re: pg_upgrade 10.2
  2018-06-12 23:56 UTC  Jerry Sievers <gsievers19@comcast.net>
` Re: pg_upgrade 10.2
  2018-06-12 23:59 UTC  Jerry Sievers <gsievers19@comcast.net>
  [12+ messages in thread]

Client Server performance & UDS
  2017-05-26 14:02 UTC  Kevin.Hughes@uk.fujitsu.com <Kevin.Hughes@uk.fujitsu.com>
` Re: Client Server performance & UDS
  2017-05-27 12:26 UTC  Rick Otten <rottenwindfish@gmail.com>
` Re: Client Server performance & UDS
  2017-05-30 07:34 UTC  Kevin.Hughes@uk.fujitsu.com <Kevin.Hughes@uk.fujitsu.com>
` Re: Client Server performance & UDS
  2017-05-30 10:17 UTC  Rick Otten <rottenwindfish@gmail.com>
` Re: Client Server performance & UDS
  2017-05-30 20:20 UTC  Karl Czajkowski <karlcz@isi.edu>
` Re: Client Server performance & UDS
  2017-06-09 13:20 UTC  Kevin.Hughes@uk.fujitsu.com <Kevin.Hughes@uk.fujitsu.com>
` Re: Client Server performance & UDS
  2018-06-07 09:40 UTC  e-blokos <infos@e-blokos.com>
  [7+ messages in thread]

Simple Query Elapsed Time ~ 3 hrs Using Bitmap Index/Heap Scan
  2018-06-05 14:17 UTC  Fred Habash <fmhabash@gmail.com>
` Re: Simple Query Elapsed Time ~ 3 hrs Using Bitmap Index/Heap Scan
  2018-06-05 14:26 UTC  Sergei Kornilov <sk@zsrv.org>
` Re: Simple Query Elapsed Time ~ 3 hrs Using Bitmap Index/Heap Scan
  2018-06-05 14:42 UTC  Matthew Hall <mhall@mhcomputing.net>
` Re: Simple Query Elapsed Time ~ 3 hrs Using Bitmap Index/Heap Scan
  2018-06-05 14:42 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` RE: Simple Query Elapsed Time ~ 3 hrs Using Bitmap Index/Heap Scan
  2018-06-05 17:18 UTC  Fd Habash <fmhabash@gmail.com>
  [5+ messages in thread]

Sort is generating rows
  2018-05-31 11:22 UTC  Nicolas Seinlet <nicolas@seinlet.com>
` Re: Sort is generating rows
  2018-05-31 13:10 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: Sort is generating rows
  2018-05-31 13:16 UTC  Nicolas Seinlet <nicolas@seinlet.com>
  [3+ messages in thread]

Possible optimisation: push down SORT and LIMIT nodes
  2018-05-30 15:46 UTC  Christopher Wilson <chris.wilson@cantabcapital.com>
` Re: Possible optimisation: push down SORT and LIMIT nodes
  2018-05-30 19:02 UTC  Justin Pryzby <pryzby@telsasoft.com>
` Re: Possible optimisation: push down SORT and LIMIT nodes
  2018-05-30 19:09 UTC  Justin Pryzby <pryzby@telsasoft.com>
  [3+ messages in thread]

propose web form for submission of performance problems
  2018-05-24 23:57 UTC  Justin Pryzby <pryzby@telsasoft.com>
` Re: propose web form for submission of performance problems
  2018-05-25 01:27 UTC  Craig James <cjames@emolecules.com>
` Re: propose web form for submission of performance problems
  2018-05-25 01:52 UTC  Justin Pryzby <pryzby@telsasoft.com>
` Re: propose web form for submission of performance problems
  2018-05-25 05:45 UTC  Thomas Kellerer <spam_eater@gmx.net>
  [4+ messages in thread]

Help me in reducing the CPU cost for the high cost query below, as it is hitting production seriously!!
  2018-05-21 06:15 UTC  pavan95 <pavan.postgresdba@gmail.com>
` Re: Help me in reducing the CPU cost for the high cost query below, as it is hitting production seriously!!
  2018-05-21 08:03 UTC  mlunnon <mlunnon@rwa-net.co.uk>
` Re: Help me in reducing the CPU cost for the high cost query below, as it is hitting production seriously!!
  2018-05-21 11:13 UTC  pavan95 <pavan.postgresdba@gmail.com>
` Re: Help me in reducing the CPU cost for the high cost query below, as it is hitting production seriously!!
  2018-05-21 11:28 UTC  Abbas <abbas@rechat.com>
` Re: Help me in reducing the CPU cost for the high cost query below, as it is hitting production seriously!!
  2018-05-21 13:39 UTC  pavan95 <pavan.postgresdba@gmail.com>
` Re: Help me in reducing the CPU cost for the high cost query below, as it is hitting production seriously!!
  2018-05-21 14:03 UTC  David G. Johnston <david.g.johnston@gmail.com>
` Re: Help me in reducing the CPU cost for the high cost query below, as it is hitting production seriously!!
  2018-05-21 14:12 UTC  Abbas <abbas@rechat.com>
` Re: Help me in reducing the CPU cost for the high cost query below, as it is hitting production seriously!!
  2018-05-21 14:34 UTC  pavan95 <pavan.postgresdba@gmail.com>
` Re: Help me in reducing the CPU cost for the high cost query below, as it is hitting production seriously!!
  2018-05-21 14:43 UTC  pavan95 <pavan.postgresdba@gmail.com>
` Re: Help me in reducing the CPU cost for the high cost query below, as it is hitting production seriously!!
  2018-05-21 15:06 UTC  David G. Johnston <david.g.johnston@gmail.com>
` Re: Help me in reducing the CPU cost for the high cost query below, as it is hitting production seriously!!
  2018-05-21 15:48 UTC  mlunnon <mlunnon@rwa-net.co.uk>
` Re: Help me in reducing the CPU cost for the high cost query below, as it is hitting production seriously!!
  2018-05-22 10:32 UTC  pavan95 <pavan.postgresdba@gmail.com>
` Re: Help me in reducing the CPU cost for the high cost query below, as it is hitting production seriously!!
  2018-05-22 10:32 UTC  pavan95 <pavan.postgresdba@gmail.com>
` Re: Help me in reducing the CPU cost for the high cost query below, as it is hitting production seriously!!
  2018-05-22 10:39 UTC  Justin Pryzby <pryzby@telsasoft.com>
` Re: Help me in reducing the CPU cost for the high cost query below, as it is hitting production seriously!!
  2018-05-22 10:51 UTC  pavan95 <pavan.postgresdba@gmail.com>
` Re: Help me in reducing the CPU cost for the high cost query below, as it is hitting production seriously!!
  2018-05-22 18:23 UTC  Justin Pryzby <pryzby@telsasoft.com>
` Re: Help me in reducing the CPU cost for the high cost query below, as it is hitting production seriously!!
  2018-05-22 18:25 UTC  Pavan Teja <pavan.postgresdba@gmail.com>
` Re: Help me in reducing the CPU cost for the high cost query below, as it is hitting production seriously!!
  2018-05-23 07:01 UTC  pavan95 <pavan.postgresdba@gmail.com>
` Re: Help me in reducing the CPU cost for the high cost query below, as it is hitting production seriously!!
  2018-05-23 11:12 UTC  mlunnon <mlunnon@rwa-net.co.uk>
` Re: Help me in reducing the CPU cost for the high cost query below, as it is hitting production seriously!!
  2018-05-23 13:39 UTC  pavan95 <pavan.postgresdba@gmail.com>
` Re: Help me in reducing the CPU cost for the high cost query below, as it is hitting production seriously!!
  2018-05-23 13:43 UTC  Justin Pryzby <pryzby@telsasoft.com>
` Re: Help me in reducing the CPU cost for the high cost query below, as it is hitting production seriously!!
  2018-05-23 14:03 UTC  pavan95 <pavan.postgresdba@gmail.com>
` Re: Help me in reducing the CPU cost for the high cost query below, as it is hitting production seriously!!
  2018-05-23 20:01 UTC  Justin Pryzby <pryzby@telsasoft.com>
` Re: Help me in reducing the CPU cost for the high cost query below, as it is hitting production seriously!!
  2018-05-24 05:20 UTC  pavan95 <pavan.postgresdba@gmail.com>
` Re: Help me in reducing the CPU cost for the high cost query below, as it is hitting production seriously!!
  2018-05-24 06:06 UTC  Justin Pryzby <pryzby@telsasoft.com>
  [25+ messages in thread]

Help with tuning slow query
  2018-05-18 20:32 UTC  Kotapati, Anil <Anil_Kotapati@comcast.com>
` Re: Help with tuning slow query
  2018-05-19 15:57 UTC  Justin Pryzby <pryzby@telsasoft.com>
  [2+ messages in thread]

Latest advice on SSD?
  2018-04-10 02:36 UTC  Craig James <cjames@emolecules.com>
` Re: Latest advice on SSD?
  2018-04-10 17:41 UTC  Craig James <cjames@emolecules.com>
` Re: Latest advice on SSD?
  2018-04-10 17:54 UTC  Benjamin Scherrey <scherrey@proteus-tech.com>
` Re: Latest advice on SSD?
  2018-04-10 19:00 UTC  Aaron <aaron.werman@gmail.com>
` Re: Latest advice on SSD?
  2018-04-10 19:11 UTC  Dmitry Shalashov <skaurus@gmail.com>
` Re: Latest advice on SSD?
  2018-04-10 19:58 UTC  Charles Sprickman <css@morefoo.com>
` Re: Latest advice on SSD?
  2018-04-10 20:15 UTC  Frits Jalvingh <jal@etc.to>
` Re: Latest advice on SSD?
  2018-04-10 22:56 UTC  Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
` Re: Latest advice on SSD?
  2018-04-11 01:39 UTC  Matthew Hall <mhall@mhcomputing.net>
` Re: Latest advice on SSD?
  2018-04-12 05:11 UTC  Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
` Re: Latest advice on SSD?
  2018-04-13 09:55 UTC  Ants Aasma <ants.aasma@eesti.ee>
` Re: Latest advice on SSD?
  2018-05-11 14:48 UTC  Evgeniy Shishkin <itparanoia@gmail.com>
` Re: Latest advice on SSD?
  2018-05-12 05:19 UTC  Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
  [13+ 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