pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedGuide to PG's capabilities for inlining, predicate hoisting, flattening, etc?
2011-11-02 14:22 UTC Jay Levitt <jay.levitt@gmail.com>
` Re: Guide to PG's capabilities for inlining, predicate hoisting, flattening, etc?
2011-11-02 14:38 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Guide to PG's capabilities for inlining, predicate hoisting, flattening, etc?
2011-11-02 15:13 UTC Robert Haas <robertmhaas@gmail.com>
` Re: Guide to PG's capabilities for inlining, predicate hoisting, flattening, etc?
2011-11-02 16:41 UTC Justin Pitts <justinpitts@gmail.com>
` Re: Guide to PG's capabilities for inlining, predicate hoisting, flattening, etc?
2011-11-02 17:13 UTC Andres Freund <andres@anarazel.de>
` Re: Guide to PG's capabilities for inlining, predicate hoisting, flattening, etc?
2011-11-02 17:22 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: Guide to PG's capabilities for inlining, predicate hoisting, flattening, etc?
2011-11-02 19:39 UTC Craig James <craig_james@emolecules.com>
` Re: Guide to PG's capabilities for inlining, predicate hoisting, flattening, etc?
2011-11-02 20:22 UTC Igor Neyman <ineyman@perceptron.com>
` Re: Guide to PG's capabilities for inlining, predicate hoisting, flattening, etc?
2011-11-03 00:17 UTC Gavin Flower <GavinFlower@archidevsys.co.nz>
` Re: Guide to PG's capabilities for inlining, predicate hoisting, flattening, etc?
2011-11-03 09:07 UTC Craig Ringer <ringerc@ringerc.id.au>
` Re: Guide to PG's capabilities for inlining, predicate hoisting, flattening, etc?
2011-11-03 13:16 UTC Igor Neyman <ineyman@perceptron.com>
[11+ messages in thread]
two table join just not fast enough.
2011-11-02 20:12 UTC Brian Fehrle <brianf@consistentstate.com>
` Re: two table join just not fast enough.
2011-11-02 23:53 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: two table join just not fast enough.
2011-11-03 00:33 UTC Brian Fehrle <brianf@consistentstate.com>
` Re: two table join just not fast enough.
2011-11-03 01:47 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
[4+ messages in thread]
procedure takes much more time than its query statement
2011-11-01 14:01 UTC Sabin Coanda <s.coanda@deuromedia.com>
` Re: procedure takes much more time than its query statement
2011-11-02 01:21 UTC Dave Crooke <dcrooke@gmail.com>
` Re: procedure takes much more time than its query statement
2011-11-02 02:21 UTC Craig Ringer <ringerc@ringerc.id.au>
` Re: procedure takes much more time than its query statement
2011-11-02 08:15 UTC Sabin Coanda <s.coanda@deuromedia.ro>
[4+ messages in thread]
does update of column with no relation imply a relation check of other column?
2011-10-19 15:51 UTC Anibal David Acosta <aa@devshock.com>
` Re: does update of column with no relation imply a relation check of other column?
2011-10-19 16:42 UTC Greg Jaskiewicz <gryzman@gmail.com>
` Re: does update of column with no relation imply a relation check of other column?
2011-10-31 18:19 UTC Robert Haas <robertmhaas@gmail.com>
` Re: does update of column with no relation imply a relation check of other column?
2011-10-31 19:55 UTC Tom Lane <tgl@sss.pgh.pa.us>
[4+ messages in thread]
Composite keys
2011-10-11 15:16 UTC Carlo Stonebanks <stonec.register@sympatico.ca>
` Re: Composite keys
2011-10-12 00:52 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: Composite keys
2011-10-12 01:28 UTC Dave Crooke <dcrooke@gmail.com>
` Re: Composite keys
2011-10-12 04:39 UTC Carlo Stonebanks <stonec.register@sympatico.ca>
` Re: Composite keys
2011-10-12 10:26 UTC Greg Smith <greg@2ndQuadrant.com>
` Re: Composite keys
2011-10-31 17:08 UTC Robert Haas <robertmhaas@gmail.com>
` Re: Composite keys
2011-10-31 17:52 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: Composite keys
2011-10-31 18:24 UTC Robert Haas <robertmhaas@gmail.com>
` Re: Composite keys
2011-10-31 18:34 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: Composite keys
2011-10-31 18:42 UTC Robert Haas <robertmhaas@gmail.com>
` Re: Composite keys
2011-10-31 18:59 UTC Tom Lane <tgl@sss.pgh.pa.us>
[11+ messages in thread]
Anti join miscalculates row number?
2011-10-26 10:23 UTC Jens Reufsteck <jens.reufsteck@staufenbiel.de>
` Re: Anti join miscalculates row number?
2011-10-26 14:45 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Anti join miscalculates row number?
2011-10-27 07:03 UTC Julius Tuskenis <julius@nsoft.lt>
` Re: Anti join miscalculates row number?
2011-10-31 16:44 UTC Jens Reufsteck <jens.reufsteck@staufenbiel.de>
[4+ messages in thread]
application of KNN code to US zipcode searches?
2011-02-17 14:40 UTC Mark Stosberg <mark@summersault.com>
` Re: application of KNN code to US zipcode searches?
2011-02-17 14:49 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: application of KNN code to US zipcode searches?
2011-02-17 15:20 UTC Mark Stosberg <mark@summersault.com>
` Re: application of KNN code to US zipcode searches?
2011-02-17 15:24 UTC Stephen Frost <sfrost@snowman.net>
` Re: application of KNN code to US zipcode searches?
2011-02-17 15:55 UTC Mark Stosberg <mark@summersault.com>
` Re: application of KNN code to US zipcode searches?
2011-02-17 16:41 UTC Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
` Re: application of KNN code to US zipcode searches?
2011-02-17 16:41 UTC Mark Stosberg <mark@summersault.com>
` Re: application of KNN code to US zipcode searches?
2011-02-17 19:13 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: application of KNN code to US zipcode searches?
2011-02-17 19:17 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: application of KNN code to US zipcode searches?
2011-02-17 20:17 UTC Oleg Bartunov <oleg@sai.msu.su>
` Re: application of KNN code to US zipcode searches?
2011-02-17 20:38 UTC Mark Stosberg <mark@summersault.com>
` Re: application of KNN code to US zipcode searches?
2011-02-17 23:26 UTC bricklen <bricklen@gmail.com>
` Re: application of KNN code to US zipcode searches?
2011-10-29 14:45 UTC Mark Stosberg <mark@summersault.com>
[13+ messages in thread]
Bad plan by Planner (Already resolved?)
2011-10-17 06:28 UTC Robins Tharakan <robins.tharakan@comodo.com>
` Re: Bad plan by Planner (Already resolved?)
2011-10-17 16:02 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Bad plan by Planner (Already resolved?)
2011-10-18 05:57 UTC Robins Tharakan <robins.tharakan@comodo.com>
` Re: Bad plan by Planner (Already resolved?)
2011-10-18 06:18 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
` Re: Bad plan by Planner (Already resolved?)
2011-10-18 12:46 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Bad plan by Planner (Already resolved?)
2011-10-25 10:53 UTC Robins Tharakan <robins.tharakan@comodo.com>
` Re: Bad plan by Planner (Already resolved?)
2011-10-26 19:57 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Bad plan by Planner (Already resolved?)
2011-10-29 14:42 UTC Robins Tharakan <robins.tharakan@comodo.com>
[8+ messages in thread]
backups blocking everything
2011-10-27 16:47 UTC Samuel Gendler <sgendler@ideasculptor.com>
` Re: backups blocking everything
2011-10-27 17:39 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: backups blocking everything
2011-10-27 20:45 UTC Nicholson, Brad (Toronto, ON, CA) <bnicholson@hp.com>
` Re: backups blocking everything
2011-10-27 21:15 UTC Samuel Gendler <sgendler@ideasculptor.com>
` Re: backups blocking everything
2011-10-27 23:29 UTC Samuel Gendler <sgendler@ideasculptor.com>
` Re: backups blocking everything
2011-10-28 21:20 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: backups blocking everything
2011-10-28 23:51 UTC Samuel Gendler <sgendler@ideasculptor.com>
[7+ messages in thread]
should i expected performance degradation over time
2011-09-10 16:55 UTC Anibal David Acosta <aa@devshock.com>
` Re: should i expected performance degradation over time
2011-09-10 17:20 UTC Andy Colson <andy@squeakycode.net>
` Re: should i expected performance degradation over time
2011-09-10 18:30 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: should i expected performance degradation over time
2011-10-11 18:20 UTC Anibal David Acosta <aa@devshock.com>
` Re: should i expected performance degradation over time
2011-10-28 19:03 UTC Robert Haas <robertmhaas@gmail.com>
[5+ messages in thread]
Choosing between Intel 320, Intel 510 or OCZ Vertex 3 SSD for db server
2011-10-24 14:09 UTC Amitabh Kant <amitabhkant@gmail.com>
` Re: Choosing between Intel 320, Intel 510 or OCZ Vertex 3 SSD for db server
2011-10-24 16:53 UTC David Boreham <david_list@boreham.org>
` Re: Choosing between Intel 320, Intel 510 or OCZ Vertex 3 SSD for db server
2011-10-24 21:31 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Choosing between Intel 320, Intel 510 or OCZ Vertex 3 SSD for db server
2011-10-24 22:47 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: Choosing between Intel 320, Intel 510 or OCZ Vertex 3 SSD for db server
2011-10-24 23:18 UTC David Boreham <david_list@boreham.org>
` Re: Choosing between Intel 320, Intel 510 or OCZ Vertex 3 SSD for db server
2011-10-25 02:37 UTC David Boreham <david_list@boreham.org>
` Re: Choosing between Intel 320, Intel 510 or OCZ Vertex 3 SSD for db server
2011-10-25 07:48 UTC Thilo Raufeisen <traufeisen@gmail.com>
` Re: Choosing between Intel 320, Intel 510 or OCZ Vertex 3 SSD for db server
2011-10-25 14:55 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: Choosing between Intel 320, Intel 510 or OCZ Vertex 3 SSD for db server
2011-10-25 15:00 UTC David Boreham <david_list@boreham.org>
` Re: Choosing between Intel 320, Intel 510 or OCZ Vertex 3 SSD for db server
2011-10-28 06:40 UTC Amitabh Kant <amitabhkant@gmail.com>
` Re: Choosing between Intel 320, Intel 510 or OCZ Vertex 3 SSD for db server
2011-10-28 13:22 UTC David Boreham <david_list@boreham.org>
[11+ messages in thread]
Usage of pg_stat_database
2011-10-24 14:04 UTC Amitabh Kant <amitabhkant@gmail.com>
` Re: Usage of pg_stat_database
2011-10-28 05:54 UTC Jeff Davis <pgsql@j-davis.com>
` Re: Usage of pg_stat_database
2011-10-28 06:37 UTC Amitabh Kant <amitabhkant@gmail.com>
[3+ messages in thread]
Performance problem with a table with 38928077 record
2011-10-07 10:04 UTC Giovanni Mancuso <gmancuso@babel.it>
` Re: Performance problem with a table with 38928077 record
2011-10-07 10:24 UTC Guillaume Cottenceau <gc@mnc.ch>
` Re: Performance problem with a table with 38928077 record
2011-10-07 10:29 UTC Gregg Jaskiewicz <gryzman@gmail.com>
` Re: Performance problem with a table with 38928077 record
2011-10-07 12:59 UTC Cédric Villemain <cedric.villemain.debian@gmail.com>
` Re: Performance problem with a table with 38928077 record
2011-10-07 15:12 UTC Giovanni Mancuso <gmancuso@babel.it>
` Re: Performance problem with a table with 38928077 record
2011-10-08 15:04 UTC Giovanni Mancuso <gmancuso@babel.it>
` Re: Performance problem with a table with 38928077 record
2011-10-27 19:13 UTC Robert Haas <robertmhaas@gmail.com>
` Re: Performance problem with a table with 38928077 record
2011-10-27 20:31 UTC Shaun Thomas <sthomas@peak6.com>
` Re: Performance problem with a table with 38928077 record
2011-10-27 22:19 UTC Tom Lane <tgl@sss.pgh.pa.us>
[9+ messages in thread]
Shortcutting too-large offsets?
2011-09-30 00:39 UTC Josh Berkus <josh@agliodbs.com>
` Re: Shortcutting too-large offsets?
2011-09-30 14:36 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Shortcutting too-large offsets?
2011-09-30 15:08 UTC pasman pasmański <pasman.p@gmail.com>
` Re: Shortcutting too-large offsets?
2011-09-30 18:44 UTC Josh Berkus <josh@agliodbs.com>
` Re: Shortcutting too-large offsets?
2011-09-30 18:56 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Shortcutting too-large offsets?
2011-10-27 18:46 UTC Robert Haas <robertmhaas@gmail.com>
[6+ messages in thread]
slow cursor
2006-04-17 14:34 UTC Sriram Dandapani <sdandapani@counterpane.com>
` Re: slow cursor
2006-04-18 04:55 UTC Luckys <plpgsql@gmail.com>
` Slow cursor
2011-10-26 12:43 UTC Cezariusz Marek <cezariusz.marek@comarch.pl>
` Re: Slow cursor
2011-10-26 12:49 UTC Gregg Jaskiewicz <gryzman@gmail.com>
` Re: Slow cursor
2011-10-26 12:56 UTC Cezariusz Marek <cezariusz.marek@comarch.pl>
` Re: Slow cursor
2011-10-26 13:10 UTC Andres Freund <andres@anarazel.de>
[6+ messages in thread]
CTE vs Subquery
2011-10-25 16:22 UTC Linos <info@linos.es>
` Re: CTE vs Subquery
2011-10-25 16:43 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: CTE vs Subquery
2011-10-25 16:47 UTC Linos <info@linos.es>
` Re: CTE vs Subquery
2011-10-25 17:11 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: CTE vs Subquery
2011-10-26 09:00 UTC Linos <info@linos.es>
` Re: CTE vs Subquery
2011-10-26 12:23 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: CTE vs Subquery
2011-10-26 12:55 UTC Linos <info@linos.es>
[7+ messages in thread]
how to use explain analyze
2011-10-25 14:12 UTC alan <alan.miller3@gmail.com>
` Re: how to use explain analyze
2011-10-26 07:48 UTC Julius Tuskenis <julius@nsoft.lt>
[2+ messages in thread]
sub
2011-10-25 13:07 UTC Cezariusz Marek <cezariusz.marek@comarch.pl>
Re: : PG9.0 - Checkpoint tuning and pg_stat_bgwriter
2011-10-04 10:50 UTC Venkat Balaji <venkat.balaji@verse.in>
` Re: : PG9.0 - Checkpoint tuning and pg_stat_bgwriter
2011-10-04 11:08 UTC Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
` Re: : PG9.0 - Checkpoint tuning and pg_stat_bgwriter
2011-10-04 11:23 UTC Venkat Balaji <venkat.balaji@verse.in>
` Re: : PG9.0 - Checkpoint tuning and pg_stat_bgwriter
2011-10-04 14:15 UTC pasman pasmański <pasman.p@gmail.com>
` Re: : PG9.0 - Checkpoint tuning and pg_stat_bgwriter
2011-10-04 22:32 UTC Greg Smith <greg@2ndQuadrant.com>
` Re: : PG9.0 - Checkpoint tuning and pg_stat_bgwriter
2011-10-04 22:47 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: : PG9.0 - Checkpoint tuning and pg_stat_bgwriter
2011-10-05 02:50 UTC Venkat Balaji <venkat.balaji@verse.in>
` Re: : PG9.0 - Checkpoint tuning and pg_stat_bgwriter
2011-10-05 05:32 UTC Greg Smith <greg@2ndQuadrant.com>
` Re: : PG9.0 - Checkpoint tuning and pg_stat_bgwriter
2011-10-24 12:16 UTC Venkat Balaji <venkat.balaji@verse.in>
` Re: : PG9.0 - Checkpoint tuning and pg_stat_bgwriter
2011-10-25 02:17 UTC Robert Haas <robertmhaas@gmail.com>
` Re: : PG9.0 - Checkpoint tuning and pg_stat_bgwriter
2011-10-25 05:00 UTC Venkat Balaji <venkat.balaji@verse.in>
[11+ messages in thread]
Tsearch2 - bad performance with concatenated ts-vectors
2011-08-02 06:22 UTC Jan Wielgus <jan_w@tlen.pl>
` Re: Tsearch2 - bad performance with concatenated ts-vectors
2011-08-02 23:01 UTC Gavin Flower <GavinFlower@archidevsys.co.nz>
` Re: Tsearch2 - bad performance with concatenated ts-vectors
2011-08-04 21:16 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Tsearch2 - bad performance with concatenated ts-vectors
2011-10-24 19:31 UTC Robert Haas <robertmhaas@gmail.com>
[4+ messages in thread]
delete/recreate indexes
2011-10-19 15:03 UTC alan <alan.miller3@gmail.com>
` Re: delete/recreate indexes
2011-10-20 02:51 UTC Jeff Davis <pgsql@j-davis.com>
` Re: delete/recreate indexes
2011-10-20 13:24 UTC Bort, Paul <pbort@tmwsystems.com>
` Re: delete/recreate indexes
2011-10-24 14:08 UTC alan <alan.miller3@gmail.com>
[4+ messages in thread]
hstore query: Any better idea than adding more memory?
2011-10-22 23:33 UTC Stefan Keller <sfkeller@gmail.com>
` Re: hstore query: Any better idea than adding more memory?
2011-10-23 23:25 UTC Stephen Frost <sfrost@snowman.net>
` Re: hstore query: Any better idea than adding more memory?
2011-10-24 00:19 UTC Stefan Keller <sfkeller@gmail.com>
` Re: hstore query: Any better idea than adding more memory?
2011-10-24 00:41 UTC Stephen Frost <sfrost@snowman.net>
[4+ messages in thread]
explain workload
2011-10-22 01:11 UTC Radhya sahal <rad_cs_2006@yahoo.com>
` Re: explain workload
2011-10-23 10:38 UTC Robins Tharakan <robins.tharakan@comodo.com>
` Re: explain workload
2011-10-23 15:44 UTC Tom Lane <tgl@sss.pgh.pa.us>
[3+ messages in thread]
8.4.4, 9.0, and 9.1 Planner Differences
2011-10-21 23:39 UTC Anthony Presley <anthony@resolution.com>
` Re: 8.4.4, 9.0, and 9.1 Planner Differences
2011-10-22 15:58 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: 8.4.4, 9.0, and 9.1 Planner Differences
2011-10-22 23:12 UTC Anthony Presley <anthony@resolution.com>
` Re: 8.4.4, 9.0, and 9.1 Planner Differences
2011-10-23 02:31 UTC Tom Lane <tgl@sss.pgh.pa.us>
[4+ messages in thread]
How many Cluster database on a single server
2011-10-19 09:46 UTC d.davolio@mastertraining.it <d.davolio@mastertraining.it>
` Re: How many Cluster database on a single server
2011-10-19 13:54 UTC Craig James <craig_james@emolecules.com>
` Re: How many Cluster database on a single server
2011-10-19 15:02 UTC d.davolio@mastertraining.it <d.davolio@mastertraining.it>
` Re: How many Cluster database on a single server
2011-10-19 15:13 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: How many Cluster database on a single server
2011-10-19 15:44 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: How many Cluster database on a single server
2011-10-20 03:34 UTC Craig Ringer <ringerc@ringerc.id.au>
` Re: How many Cluster database on a single server
2011-10-21 06:57 UTC d.davolio@mastertraining.it <d.davolio@mastertraining.it>
[7+ 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