pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedjoin estimate of subqueries with range conditions and constraint exclusion
2017-05-24 21:17 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: join estimate of subqueries with range conditions and constraint exclusion
2017-05-30 10:52 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: join estimate of subqueries with range conditions and constraint exclusion
2017-06-03 19:23 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: Re: join estimate of subqueries with range conditions and constraint exclusion
2017-06-05 21:02 UTC Tom Lane <tgl@sss.pgh.pa.us>
[4+ messages in thread]
Monitoring tool for Postgres Database
2017-05-25 19:48 UTC Ravi Tammineni <rtammineni@partner.aligntech.com>
` Re: [ADMIN] Monitoring tool for Postgres Database
2017-05-25 20:00 UTC Scott Whitney <scott@journyx.com>
` Re: Monitoring tool for Postgres Database
2017-05-25 20:48 UTC Thomas Kellerer <spam_eater@gmx.net>
` Re: [PERFORM] Monitoring tool for Postgres Database
2017-05-25 23:05 UTC Gary Evans <garyevans.au@gmail.com>
` Re: [ADMIN] Monitoring tool for Postgres Database
2017-05-26 01:20 UTC Steven Chang <stevenchang1213@gmail.com>
` Re: Monitoring tool for Postgres Database
2017-05-26 02:15 UTC Scott Mead <scottm@openscg.com>
` Re: Monitoring tool for Postgres Database
2017-05-26 10:19 UTC Rick Otten <rottenwindfish@gmail.com>
` Re: [ADMIN] Monitoring tool for Postgres Database
2017-05-26 11:31 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: [ADMIN] Monitoring tool for Postgres Database
2017-05-26 14:14 UTC Tatsuo Ishii <ishii@sraoss.co.jp>
` Re: [ADMIN] Monitoring tool for Postgres Database
2017-05-26 14:28 UTC Ashish Tiwari <tashish786@gmail.com>
` Re: Monitoring tool for Postgres Database
2017-05-26 14:31 UTC gevans <gevans@enova.com>
` Re: [PERFORM] Monitoring tool for Postgres Database
2017-05-26 14:32 UTC Sunkara, Amrutha <amrutha@nytimes.com>
` Re: [PERFORM] Monitoring tool for Postgres Database
2017-05-27 04:58 UTC Dave Stibrany <dstibrany@gmail.com>
` Re: Monitoring tool for Postgres Database
2017-05-27 15:42 UTC phb07 <phb07@apra.asso.fr>
` Re: Monitoring tool for Postgres Database
2017-06-03 08:37 UTC Nikolay Samokhvalov <samokhvalov@gmail.com>
[15+ messages in thread]
Different plan between 9.6 and 9.4 when using "Group by"
2017-05-27 08:40 UTC =?gb2312?B?wbq6o7Cyo6hLaWxsdWEgTGV1bmejqQ==?= <LIANGHAIAN001@pingan.com.cn>
` Re: Different plan between 9.6 and 9.4 when using "Group by"
2017-05-29 18:21 UTC Jeff Janes <jeff.janes@gmail.com>
[2+ messages in thread]
More cores or higer frequency ?
2017-05-23 18:29 UTC Jarek <jarek@poczta.srv.pl>
` Re: More cores or higer frequency ?
2017-05-23 18:39 UTC Steve Crawford <scrawford@pinpointresearch.com>
` Re: More cores or higer frequency ?
2017-05-23 20:14 UTC Jarek <jarek@poczta.srv.pl>
` Re: More cores or higer frequency ?
2017-05-23 20:49 UTC Sven R. Kunze <srkunze@mail.de>
` Re: More cores or higer frequency ?
2017-05-23 21:36 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: More cores or higer frequency ?
2017-05-23 21:40 UTC Steve Crawford <scrawford@pinpointresearch.com>
` Re: More cores or higer frequency ?
2017-05-26 17:51 UTC ldh@laurent-hasson.com <ldh@laurent-hasson.com>
[7+ messages in thread]
Query is running very slow......
2017-05-24 17:04 UTC Dinesh Chandra 12108 <Dinesh.Chandra@cyient.com>
` Re: Query is running very slow......
2017-05-24 17:25 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
` FW: Re: Query is running very slow......
2017-05-25 12:26 UTC Dinesh Chandra 12108 <Dinesh.Chandra@cyient.com>
` Re: FW: Re: Query is running very slow......
2017-05-25 15:38 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: FW: Re: Query is running very slow......
2017-05-26 12:31 UTC Dinesh Chandra 12108 <Dinesh.Chandra@cyient.com>
` Re: FW: Re: Query is running very slow......
2017-05-26 13:10 UTC Andreas Kretschmer <andreas@a-kretschmer.de>
[6+ messages in thread]
Multicolumn B-Tree index - order by on 1st column and IN lookup for 2nd
2017-05-25 18:29 UTC Alexandru Lazarev <alexandru.lazarev@gmail.com>
Delete, foreign key, index usage
2017-04-04 12:07 UTC Johann Spies <johann.spies@gmail.com>
` Re: Delete, foreign key, index usage
2017-04-05 10:40 UTC Johann Spies <johann.spies@gmail.com>
` Re: Delete, foreign key, index usage
2017-04-05 11:15 UTC Rick Otten <rottenwindfish@gmail.com>
` Re: Delete, foreign key, index usage
2017-04-24 06:48 UTC Johann Spies <johann.spies@gmail.com>
` Re: Delete, foreign key, index usage
2017-04-24 13:17 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: Delete, foreign key, index usage
2017-04-25 06:28 UTC Johann Spies <johann.spies@gmail.com>
` Re: Delete, foreign key, index usage
2017-04-25 07:34 UTC David Rowley <david.rowley@2ndquadrant.com>
` Re: Delete, foreign key, index usage
2017-04-25 23:35 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: Delete, foreign key, index usage
2017-05-25 12:21 UTC Johann Spies <johann.spies@gmail.com>
[9+ messages in thread]
Query is very much slow
2017-05-25 05:13 UTC Daulat Ram <Daulat.Ram@cyient.com>
` Re: Query is very much slow
2017-05-25 07:49 UTC Andreas Kretschmer <andreas@a-kretschmer.de>
` Re: Query is very much slow
2017-05-25 08:10 UTC Andreas Kretschmer <andreas@a-kretschmer.de>
[3+ messages in thread]
select subquery versus join subquery
2017-05-22 19:57 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: select subquery versus join subquery
2017-05-23 11:03 UTC Gunnar "Nick" Bluth <gunnar.bluth.extern@elster.de>
` Re: select subquery versus join subquery
2017-05-23 16:59 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: select subquery versus join subquery
2017-05-24 06:41 UTC Gunnar "Nick" Bluth <gunnar.bluth.extern@elster.de>
[4+ messages in thread]
Log update query along with username who has executed the same.
2017-05-23 12:42 UTC Dinesh Chandra 12108 <Dinesh.Chandra@cyient.com>
` Re: Log update query along with username who has executed the same.
2017-05-23 12:49 UTC Rick Otten <rottenwindfish@gmail.com>
` Re: Log update query along with username who has executed the same.
2017-05-23 13:07 UTC Dinesh Chandra 12108 <Dinesh.Chandra@cyient.com>
[3+ messages in thread]
Can postgresql plan a query using multiple CPU cores?
2017-05-22 20:21 UTC Clemens Eisserer <linuxhippy@gmail.com>
` Re: Can postgresql plan a query using multiple CPU cores?
2017-05-22 20:52 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: Can postgresql plan a query using multiple CPU cores?
2017-05-22 22:37 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
` Re: Can postgresql plan a query using multiple CPU cores?
2017-05-23 04:41 UTC Pavel Stehule <pavel.stehule@gmail.com>
[4+ messages in thread]
Bulk persistence strategy
2017-05-21 06:25 UTC Riaan Stander <rstander@exa.co.za>
` Re: Bulk persistence strategy
2017-05-21 14:33 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Bulk persistence strategy
2017-05-21 19:29 UTC Riaan Stander <rstander@exa.co.za>
` Re: Bulk persistence strategy
2017-05-21 22:37 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Bulk persistence strategy
2017-05-22 02:14 UTC Riaan Stander <rstander@exa.co.za>
` Re: Bulk persistence strategy
2017-05-22 05:15 UTC Simon Riggs <simon@2ndquadrant.com>
` Re: Bulk persistence strategy
2017-05-22 08:06 UTC Riaan Stander <rstander@exa.co.za>
` Re: Bulk persistence strategy
2017-05-22 08:27 UTC Simon Riggs <simon@2ndquadrant.com>
` Re: Bulk persistence strategy
2017-05-22 09:36 UTC Riaan Stander <rstander@exa.co.za>
` Re: Bulk persistence strategy
2017-05-22 11:50 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Bulk persistence strategy
2017-05-22 15:37 UTC Merlin Moncure <mmoncure@gmail.com>
[11+ messages in thread]
pg_stat_statements with fetch
2017-05-19 23:04 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: pg_stat_statements with fetch
2017-05-21 13:53 UTC Rick Otten <rottenwindfish@gmail.com>
[2+ messages in thread]
Index not being used on composite type for particular query
2017-05-20 23:33 UTC Zac Goldstein <goldzz@gmail.com>
` Re: Index not being used on composite type for particular query
2017-05-21 00:00 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Index not being used on composite type for particular query
2017-05-21 02:51 UTC Zac Goldstein <goldzz@gmail.com>
[3+ messages in thread]
GIN index not used if created in the same transaction as query
2017-05-19 15:14 UTC Adam Brusselback <adambrusselback@gmail.com>
` Re: GIN index not used if created in the same transaction as query
2017-05-19 15:33 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: GIN index not used if created in the same transaction as query
2017-05-19 15:49 UTC Adam Brusselback <adambrusselback@gmail.com>
` Re: GIN index not used if created in the same transaction as query
2017-05-19 16:09 UTC Tom Lane <tgl@sss.pgh.pa.us>
[4+ messages in thread]
postgres_fdw and column casting shippability
2017-05-15 21:42 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: postgres_fdw and column casting shippability
2017-05-15 22:22 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: postgres_fdw and column casting shippability
2017-05-16 16:54 UTC Jeff Janes <jeff.janes@gmail.com>
[3+ messages in thread]
Speed differences between in executing the same query
2017-05-11 13:54 UTC plukovic <petar@sobot.biz>
` Re: Speed differences between in executing the same query
2017-05-11 14:06 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Speed differences between in executing the same query
2017-05-11 17:11 UTC plukovic <petar@sobot.biz>
[3+ messages in thread]
Speed differences between two servers
2017-05-08 17:49 UTC Vincent Veyron <vv.lists@wanadoo.fr>
` Re: Speed differences between two servers
2017-05-08 18:48 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Speed differences between two servers
2017-05-08 22:24 UTC Vincent Veyron <vv.lists@wanadoo.fr>
` Re: Speed differences between two servers
2017-05-08 23:06 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Speed differences between two servers
2017-05-08 23:35 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Speed differences between two servers
2017-05-09 12:02 UTC Vincent Veyron <vv.lists@wanadoo.fr>
` Re: Speed differences between two servers
2017-05-09 13:08 UTC Vincent Veyron <vv.lists@wanadoo.fr>
` Re: Speed differences between two servers
2017-05-09 16:24 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Speed differences between two servers
2017-05-10 08:27 UTC Vincent Veyron <vv.lists@wanadoo.fr>
[9+ messages in thread]
Postgres uses too much RAM
2017-05-08 20:23 UTC Hans Braxmeier <hans.braxmeier@outlook.com>
` Re: Postgres uses too much RAM
2017-05-08 23:12 UTC Merlin Moncure <mmoncure@gmail.com>
[2+ messages in thread]
Postgres performance issue
2017-05-04 14:10 UTC Junaid Malik <junaid.malik@confiz.com>
` Re: Postgres performance issue
2017-05-04 14:36 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Postgres performance issue
2017-05-04 14:57 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Postgres performance issue
2017-05-08 18:50 UTC Scott Marlowe <scott.marlowe@gmail.com>
[4+ messages in thread]
Inefficient max query when using group by
2017-05-04 10:52 UTC jesse.hietanen@vaisala.com
` Re: Inefficient max query when using group by
2017-05-04 13:21 UTC bricklen <bricklen@gmail.com>
` Re: Inefficient max query when using group by
2017-05-04 13:51 UTC David Rowley <david.rowley@2ndquadrant.com>
[3+ messages in thread]
Questionaire: Common WAL write rates on busy servers.
2017-04-25 04:17 UTC Andres Freund <andres@anarazel.de>
` Re: Questionaire: Common WAL write rates on busy servers.
2017-04-25 07:56 UTC Vladimir Borodin <root@simply.name>
` Re: [GENERAL] Questionaire: Common WAL write rates on busy servers.
2017-04-25 14:19 UTC bricklen <bricklen@gmail.com>
` Re: Questionaire: Common WAL write rates on busy servers.
2017-04-25 16:07 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: Questionaire: Common WAL write rates on busy servers.
2017-04-25 18:56 UTC Jerry Sievers <gsievers19@comcast.net>
` Re: [PERFORM] Questionaire: Common WAL write rates on busy servers.
2017-04-27 15:59 UTC Andres Freund <andres@anarazel.de>
` Re: [PERFORM] Questionaire: Common WAL write rates on busy servers.
2017-04-27 16:31 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: Questionaire: Common WAL write rates on busy servers.
2017-04-27 16:34 UTC Andres Freund <andres@anarazel.de>
` Re: Questionaire: Common WAL write rates on busy servers.
2017-04-27 17:29 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: Questionaire: Common WAL write rates on busy servers.
2017-04-27 17:35 UTC Andres Freund <andres@anarazel.de>
` Re: Questionaire: Common WAL write rates on busy servers.
2017-04-27 22:53 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: [PERFORM] Questionaire: Common WAL write rates on busy servers.
2017-04-27 23:18 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: [PERFORM] Questionaire: Common WAL write rates on busy servers.
2017-04-27 23:29 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: Questionaire: Common WAL write rates on busy servers.
2017-04-27 23:34 UTC Andres Freund <andres@anarazel.de>
` Re: Questionaire: Common WAL write rates on busy servers.
2017-04-29 00:41 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
[15+ messages in thread]
Performance issue in PostgreSQL server...
2017-03-03 10:29 UTC Dinesh Chandra 12108 <Dinesh.Chandra@cyient.com>
` Re: Performance issue in PostgreSQL server...
2017-03-03 12:23 UTC Nur Agus <nuragus.linux@gmail.com>
` Re: Performance issue in PostgreSQL server...
2017-03-03 12:44 UTC Dinesh Chandra 12108 <Dinesh.Chandra@cyient.com>
` Re: Performance issue in PostgreSQL server...
2017-03-03 15:19 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Performance issue in PostgreSQL server...
2017-03-06 04:23 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Performance issue in PostgreSQL server...
2017-03-06 05:24 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: Performance issue in PostgreSQL server...
2017-03-06 12:17 UTC Dinesh Chandra 12108 <Dinesh.Chandra@cyient.com>
` Re: Performance issue in PostgreSQL server...
2017-04-27 18:47 UTC Justin Pryzby <pryzby@telsasoft.com>
[8+ messages in thread]
Re:
2006-02-23 14:38 UTC Vivek Khera <vivek@khera.org>
` Re:
2006-02-23 20:29 UTC Jim C. Nasby <jnasby@pervasive.com>
` Re:
2006-02-25 03:42 UTC Bruce Momjian <pgman@candle.pha.pa.us>
` EXCLUDE CONSTRAINT with intarray
2017-04-27 10:38 UTC Alexey Vasiliev <leopard_ne@inbox.ru>
[4+ messages in thread]
(no subject)
2006-02-22 10:38 UTC Chethana, Rao (IE10) <Chethana.Rao@Honeywell.com>
` Re:
2006-02-22 10:47 UTC Richard Huxton <dev@archonet.com>
` Re:
2006-02-22 10:51 UTC Gourish Singbal <gourish@gmail.com>
` Re:
2006-02-22 16:32 UTC Vivek Khera <vivek@khera.org>
` Re: Slow query with 3 table joins
2017-04-26 03:19 UTC Alessandro Ferrucci <alessandroferrucci@gmail.com>
` Re: Slow query with 3 table joins
2017-04-26 04:12 UTC David Rowley <david.rowley@2ndquadrant.com>
` Re: Slow query with 3 table joins
2017-04-26 06:24 UTC Johan Fredriksson <eskil@kth.se>
` Re: Slow query with 3 table joins
2017-04-26 11:04 UTC Alessandro Ferrucci <alessandroferrucci@gmail.com>
` Re: Slow query with 3 table joins
2017-04-26 11:35 UTC Alessandro Ferrucci <alessandroferrucci@gmail.com>
` Re: Slow query with 3 table joins
2017-04-26 11:35 UTC Johan Fredriksson <eskil@kth.se>
` Re: Slow query with 3 table joins
2017-04-26 12:27 UTC Gerardo Herzig <gherzig@fmed.uba.ar>
` Re: Slow query with 3 table joins
2017-04-26 15:00 UTC Gerardo Herzig <gherzig@fmed.uba.ar>
` Re: Slow query with 3 table joins
2017-04-26 15:22 UTC Alessandro Ferrucci <alessandroferrucci@gmail.com>
` Re: Slow query with 3 table joins
2017-04-26 15:30 UTC Matthew Bellew <matthewb@labkey.com>
[14+ 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