pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedEfficiently merging and sorting collections of sorted rows
2017-06-23 22:58 UTC Clint Miller <clint.miller1@gmail.com>
` Re: Efficiently merging and sorting collections of sorted rows
2017-06-23 23:32 UTC Peter Geoghegan <pg@bowt.ie>
` Re: Efficiently merging and sorting collections of sorted rows
2017-06-23 23:33 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Efficiently merging and sorting collections of sorted rows
2017-06-28 13:13 UTC Merlin Moncure <mmoncure@gmail.com>
[4+ messages in thread]
Fwd: Stalled post to pgsql-performance
2017-06-27 13:15 UTC Chris Wilson <chris+postgresql@qwirx.com>
Fwd: Slow query from ~7M rows, joined to two tables of ~100 rows each
2017-06-23 20:09 UTC Chris Wilson <chris+postgresql@qwirx.com>
` Re: Fwd: Slow query from ~7M rows, joined to two tables of ~100 rows each
2017-06-24 02:01 UTC Karl Czajkowski <karlcz@isi.edu>
` Re: Fwd: Slow query from ~7M rows, joined to two tables of ~100 rows each
2017-06-26 15:43 UTC Chris Wilson <chris+postgresql@qwirx.com>
` Re: Fwd: Slow query from ~7M rows, joined to two tables of ~100 rows each
2017-06-26 17:01 UTC Karl Czajkowski <karlcz@isi.edu>
` Re: Fwd: Slow query from ~7M rows, joined to two tables of ~100 rows each
2017-06-26 20:32 UTC Karl Czajkowski <karlcz@isi.edu>
` Re: Fwd: Slow query from ~7M rows, joined to two tables of ~100 rows each
2017-06-26 21:22 UTC Jeff Janes <jeff.janes@gmail.com>
[6+ messages in thread]
Inappropriate inner table for nested loop join
2017-06-23 10:31 UTC Akihiko Odaki <akihiko.odaki.4i@stu.hosei.ac.jp>
` Re: Inappropriate inner table for nested loop join
2017-06-23 11:20 UTC Albe Laurenz <laurenz.albe@wien.gv.at>
` Re: Inappropriate inner table for nested loop join
2017-06-23 11:36 UTC Akihiko Odaki <akihiko.odaki.4i@stu.hosei.ac.jp>
` Re: Inappropriate inner table for nested loop join
2017-06-23 11:54 UTC Akihiko Odaki <akihiko.odaki.4i@stu.hosei.ac.jp>
` Re: Inappropriate inner table for nested loop join
2017-06-23 13:05 UTC Albe Laurenz <laurenz.albe@wien.gv.at>
` Re: Inappropriate inner table for nested loop join
2017-06-26 08:55 UTC Albe Laurenz <laurenz.albe@wien.gv.at>
[6+ messages in thread]
slow delete due to reference
2017-06-24 07:28 UTC Rikard Pavelic <rikard@ngs.hr>
` Re: slow delete due to reference
2017-06-24 16:14 UTC Tom Lane <tgl@sss.pgh.pa.us>
[2+ messages in thread]
Dataset is fetched from cache but still takes same time to fetch records as first run
2017-06-23 00:40 UTC Sumeet Shukla <sumeet.k.shukla@gmail.com>
` Re: Dataset is fetched from cache but still takes same time to fetch records as first run
2017-06-23 00:54 UTC Dave Stibrany <dstibrany@gmail.com>
` Re: Dataset is fetched from cache but still takes same time to fetch records as first run
2017-06-23 04:35 UTC Sumeet Shukla <sumeet.k.shukla@gmail.com>
` Re: Dataset is fetched from cache but still takes same time to fetch records as first run
2017-06-23 04:50 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Dataset is fetched from cache but still takes same time to fetch records as first run
2017-06-23 07:52 UTC Glyn Astill <glynastill@yahoo.co.uk>
` Re: Dataset is fetched from cache but still takes same time to fetch records as first run
2017-06-23 12:09 UTC Adam Brusselback <adambrusselback@gmail.com>
` Re: Dataset is fetched from cache but still takes same time to fetch records as first run
2017-06-23 16:55 UTC ldh@laurent-hasson.com <ldh@laurent-hasson.com>
[7+ messages in thread]
substring index what is better way to query
2017-06-20 11:51 UTC Tieson Molly <tvmaly@gmail.com>
` Re: substring index what is better way to query
2017-06-20 14:19 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: substring index what is better way to query
2017-06-20 14:40 UTC Tieson Molly <tvmaly@gmail.com>
` Re: substring index what is better way to query
2017-06-20 14:45 UTC Tom Lane <tgl@sss.pgh.pa.us>
[4+ messages in thread]
Using array instead of sub table (storage and speed)
2017-06-15 08:06 UTC Lutz Fischer <l.fischer@ed.ac.uk>
` Re: Using array instead of sub table (storage and speed)
2017-06-15 13:37 UTC Stephen Frost <sfrost@snowman.net>
` Re: Using array instead of sub table (storage and speed)
2017-06-16 10:37 UTC Lutz Fischer <l.fischer@ed.ac.uk>
` Re: Using array instead of sub table (storage and speed)
2017-06-16 12:05 UTC Stephen Frost <sfrost@snowman.net>
[4+ messages in thread]
Re: Re: join under-estimates with ineq conditions
2017-06-08 16:05 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: Re: join under-estimates with ineq conditions
2017-06-16 02:53 UTC Justin Pryzby <pryzby@telsasoft.com>
[2+ messages in thread]
Sudden drastic change in performance
2017-06-15 14:53 UTC ldh@laurent-hasson.com <ldh@laurent-hasson.com>
` Re: Sudden drastic change in performance
2017-06-15 15:09 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Sudden drastic change in performance
2017-06-15 15:14 UTC Andreas Kretschmer <andreas@a-kretschmer.de>
[3+ messages in thread]
Invalid WAL segment size. Allowed values are 1,2,4,8,16,32,64
2017-06-09 13:55 UTC Cocco Gianfranco <Gianfranco.Cocco@eng.it>
` Re: Invalid WAL segment size. Allowed values are 1,2,4,8,16,32,64
2017-06-09 22:43 UTC Michael Paquier <michael.paquier@gmail.com>
` Re: Invalid WAL segment size. Allowed values are 1,2,4,8,16,32,64
2017-06-12 17:27 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Invalid WAL segment size. Allowed values are 1,2,4,8,16,32,64
2017-06-12 21:25 UTC Michael Paquier <michael.paquier@gmail.com>
` Re: [BUGS] Invalid WAL segment size. Allowed values are 1,2,4,8,16,32,64
2017-06-13 09:34 UTC Michael Paquier <michael.paquier@gmail.com>
` Re: [BUGS] Invalid WAL segment size. Allowed values are 1,2,4,8,16,32,64
2017-06-13 20:38 UTC Michael Paquier <michael.paquier@gmail.com>
[6+ messages in thread]
R: Invalid WAL segment size. Allowed values are 1,2,4,8,16,32,64
2017-06-13 09:10 UTC Cocco Gianfranco <Gianfranco.Cocco@eng.it>
Rollback table data.
2017-06-07 11:33 UTC Dinesh Chandra 12108 <Dinesh.Chandra@cyient.com>
` Re: Rollback table data.
2017-06-07 12:42 UTC Moreno Andreo <moreno.andreo@evolu-s.it>
` Re: Rollback table data.
2017-06-07 12:48 UTC Andreas Kretschmer <andreas@a-kretschmer.de>
` Re: Rollback table data.
2017-06-07 13:23 UTC Anthony Sotolongo <asotolongo@gmail.com>
` Re: Rollback table data.
2017-06-08 00:15 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Rollback table data.
2017-06-10 07:04 UTC phb07 <phb07@apra.asso.fr>
[6+ messages in thread]
index of only not null, use function index?
2017-05-22 15:17 UTC Ariel <aspostgresql@dsgml.com>
` Re: index of only not null, use function index?
2017-06-08 14:47 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: index of only not null, use function index?
2017-06-08 14:58 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: index of only not null, use function index?
2017-06-08 16:05 UTC Jeremy Finzel <finzelj@gmail.com>
` Re: index of only not null, use function index?
2017-06-08 19:57 UTC Merlin Moncure <mmoncure@gmail.com>
[5+ messages in thread]
join 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 梁海安（Killua Leung） <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]
[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