pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedSpecial 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