pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedSmall 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]
Sv: Re: Sv: Sv: Re: Latest advice on SSD?
2018-05-11 14:00 UTC Andreas Joseph Krogh <andreas@visena.com>
` Sv: Re: Sv: Sv: Re: Latest advice on SSD?
2018-05-11 14:17 UTC Andreas Joseph Krogh <andreas@visena.com>
[2+ messages in thread]
Sv: Sv: Re: Latest advice on SSD?
2018-05-11 11:23 UTC Andreas Joseph Krogh <andreas@visena.com>
` Re: Sv: Sv: Re: Latest advice on SSD?
2018-05-11 12:11 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
[2+ messages in thread]
Sv: Re: Latest advice on SSD?
2018-05-09 20:00 UTC Andreas Joseph Krogh <andreas@visena.com>
Time bucketing query performance
2018-05-07 23:33 UTC Julian Wilson <julianwlsn@gmail.com>
` Re: Time bucketing query performance
2018-05-08 01:08 UTC Justin Pryzby <pryzby@telsasoft.com>
[2+ messages in thread]
help in analysis of execution plans
2018-05-05 15:16 UTC Neto pr <netopr9@gmail.com>
` Re: help in analysis of execution plans
2018-05-05 18:07 UTC Neto pr <netopr9@gmail.com>
` Re: help in analysis of execution plans
2018-05-06 00:33 UTC David Rowley <david.rowley@2ndquadrant.com>
[3+ messages in thread]
Why doesn't the second query use the index for sorting?
2018-04-30 19:43 UTC Alf Lervåg <alf@lervag.net>
Performance issues while running select sql query
2018-04-29 04:35 UTC Kaushal Shriyan <kaushalshriyan@gmail.com>
` Re: Performance issues while running select sql query
2018-04-29 04:40 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: Performance issues while running select sql query
2018-04-29 05:03 UTC Kaushal Shriyan <kaushalshriyan@gmail.com>
` Re: Performance issues while running select sql query
2018-04-29 05:18 UTC Kaushal Shriyan <kaushalshriyan@gmail.com>
` Performance issues while running select sql query
2018-04-29 06:10 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: Performance issues while running select sql query
2018-04-29 14:18 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: Performance issues while running select sql query
2018-04-29 18:10 UTC Kaushal Shriyan <kaushalshriyan@gmail.com>
[7+ messages in thread]
pg_upgrade help
2018-04-18 07:30 UTC Akshay Ballarpure <akshay.ballarpure@tcs.com>
` Re: pg_upgrade help
2018-04-18 07:35 UTC Fabio Pardi <f.pardi@portavita.eu>
` Re: pg_upgrade help
2018-04-18 08:34 UTC Akshay Ballarpure <akshay.ballarpure@tcs.com>
` Re: pg_upgrade help
2018-04-18 08:39 UTC Sergei Kornilov <sk@zsrv.org>
` Re: pg_upgrade help
2018-04-18 09:05 UTC Fabio Pardi <f.pardi@portavita.eu>
` Re: pg_upgrade help
2018-04-18 12:02 UTC Akshay Ballarpure <akshay.ballarpure@tcs.com>
` Re: pg_upgrade help
2018-04-18 12:47 UTC Fabio Pardi <f.pardi@portavita.eu>
` Re: pg_upgrade help
2018-04-18 14:02 UTC Adrian Klaver <adrian.klaver@aklaver.com>
` Re: pg_upgrade help
2018-04-19 00:12 UTC Rajni Baliyan <saan654@gmail.com>
` Re: pg_upgrade help
2018-04-19 07:37 UTC Akshay Ballarpure <akshay.ballarpure@tcs.com>
` Re: pg_upgrade help
2018-04-19 10:14 UTC Fabio Pardi <f.pardi@portavita.eu>
` Re: pg_upgrade help
2018-04-19 12:56 UTC Akshay Ballarpure <akshay.ballarpure@tcs.com>
` Re: pg_upgrade help
2018-04-20 09:24 UTC Akshay Ballarpure <akshay.ballarpure@tcs.com>
` Re: pg_upgrade help
2018-04-20 09:48 UTC Fabio Pardi <f.pardi@portavita.eu>
[14+ messages in thread]
SeqScan vs. IndexScan
2018-04-18 22:14 UTC Vitaliy Garnashevich <vgarnashevich@gmail.com>
` Re: SeqScan vs. IndexScan
2018-04-18 22:33 UTC Tom Lane <tgl@sss.pgh.pa.us>
[2+ messages in thread]
Data migration from postgres 8.4 to 9.4
2018-04-16 07:03 UTC Akshay Ballarpure <akshay.ballarpure@tcs.com>
` Re: Data migration from postgres 8.4 to 9.4
2018-04-16 07:11 UTC Amitabh Kant <amitabhkant@gmail.com>
` Re: Data migration from postgres 8.4 to 9.4
2018-04-16 08:09 UTC Gunnar "Nick" Bluth <gunnar.bluth.extern@elster.de>
` RE: Data migration from postgres 8.4 to 9.4
2018-04-17 12:24 UTC Akshay Ballarpure <akshay.ballarpure@tcs.com>
` RE: Data migration from postgres 8.4 to 9.4
2018-04-18 08:06 UTC Ahmed, Nawaz <Nawaz@fast.au.fujitsu.com>
[5+ messages in thread]
Installing PostgreSQL 9.5 in centos 6 using YUM
2018-04-17 09:25 UTC Dinesh Chandra 12108 <Dinesh.Chandra@cyient.com>
` RE: Installing PostgreSQL 9.5 in centos 6 using YUM
2018-04-18 07:47 UTC Ahmed, Nawaz <Nawaz@fast.au.fujitsu.com>
[2+ messages in thread]
citext performance
2018-04-06 16:51 UTC Deepak Somaiya <deepsom@yahoo.com>
` Re: citext performance
2018-04-08 10:12 UTC Nandakumar M <m.nanda92@gmail.com>
` Re: citext performance
2018-04-08 20:14 UTC Deepak Somaiya <deepsom@yahoo.com>
` Citext Performance
2018-04-17 21:05 UTC Deepak Somaiya <deepsom@yahoo.com>
[4+ messages in thread]
Unexplainable execution time difference between two test functions...one using IF (SELECT COUNT(*) FROM...) and the other using IF EXISTS (SELECT 1 FROM...)
2018-04-16 20:42 UTC Hackety Man <hacketyman@gmail.com>
` Re: Unexplainable execution time difference between two test functions...one using IF (SELECT COUNT(*) FROM...) and the other using IF EXISTS (SELECT 1 FROM...)
2018-04-17 05:17 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Unexplainable execution time difference between two test functions...one using IF (SELECT COUNT(*) FROM...) and the other using IF EXISTS (SELECT 1 FROM...)
2018-04-17 10:49 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: Unexplainable execution time difference between two test functions...one using IF (SELECT COUNT(*) FROM...) and the other using IF EXISTS (SELECT 1 FROM...)
2018-04-17 10:52 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: Unexplainable execution time difference between two test functions...one using IF (SELECT COUNT(*) FROM...) and the other using IF EXISTS (SELECT 1 FROM...)
2018-04-17 14:01 UTC Hackety Man <hacketyman@gmail.com>
` Re: Unexplainable execution time difference between two test functions...one using IF (SELECT COUNT(*) FROM...) and the other using IF EXISTS (SELECT 1 FROM...)
2018-04-17 14:05 UTC Hackety Man <hacketyman@gmail.com>
` Re: Unexplainable execution time difference between two test functions...one using IF (SELECT COUNT(*) FROM...) and the other using IF EXISTS (SELECT 1 FROM...)
2018-04-17 14:23 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: Unexplainable execution time difference between two test functions...one using IF (SELECT COUNT(*) FROM...) and the other using IF EXISTS (SELECT 1 FROM...)
2018-04-17 15:43 UTC Hackety Man <hacketyman@gmail.com>
` Re: Unexplainable execution time difference between two test functions...one using IF (SELECT COUNT(*) FROM...) and the other using IF EXISTS (SELECT 1 FROM...)
2018-04-17 16:13 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Unexplainable execution time difference between two test functions...one using IF (SELECT COUNT(*) FROM...) and the other using IF EXISTS (SELECT 1 FROM...)
2018-04-17 16:41 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Unexplainable execution time difference between two test functions...one using IF (SELECT COUNT(*) FROM...) and the other using IF EXISTS (SELECT 1 FROM...)
2018-04-17 20:29 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: Unexplainable execution time difference between two test functions...one using IF (SELECT COUNT(*) FROM...) and the other using IF EXISTS (SELECT 1 FROM...)
2018-04-17 20:30 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
[12+ messages in thread]
Table order at FROM clause affects performance?
2018-04-12 14:35 UTC Eduard Català <eduard.catala@gmail.com>
` Re: Table order at FROM clause affects performance?
2018-04-12 15:30 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Table order at FROM clause affects performance?
2018-04-12 16:25 UTC Eduard Català <eduard.catala@gmail.com>
[3+ messages in thread]
FW:
2007-05-09 01:13 UTC Orhan Aglagul <oaglagul@cittio.com>
` Sv: Latest advice on SSD?
2018-04-10 07:21 UTC Andreas Joseph Krogh <andreas@visena.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