pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedslow 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]
disused indexes and performance?
2011-10-19 15:24 UTC Elisa <elisa.derickson@shoutlet.com>
` Re: disused indexes and performance?
2011-10-20 02:01 UTC Scott Marlowe <scott.marlowe@gmail.com>
[2+ messages in thread]
Rapidly finding maximal rows
2011-10-10 21:59 UTC James Cranch <jdc41@cam.ac.uk>
` Rapidly finding maximal rows
2011-10-11 10:16 UTC James Cranch <jdc41@cam.ac.uk>
` Re: Rapidly finding maximal rows
2011-10-11 23:22 UTC bricklen <bricklen@gmail.com>
` Re: Rapidly finding maximal rows
2011-10-12 01:05 UTC Dave Crooke <dcrooke@gmail.com>
` Re: Rapidly finding maximal rows
2011-10-12 11:40 UTC James Cranch <jdc41@cam.ac.uk>
` Re: Rapidly finding maximal rows
2011-10-12 11:41 UTC James Cranch <jdc41@cam.ac.uk>
` Re: Rapidly finding maximal rows
2011-10-14 04:25 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Rapidly finding maximal rows
2011-10-19 14:54 UTC Merlin Moncure <mmoncure@gmail.com>
[8+ messages in thread]
Inner Join - Explicit vs Implicit Join Performance
2011-10-19 10:39 UTC Gnanakumar <gnanam@zoniac.com>
` Re: Inner Join - Explicit vs Implicit Join Performance
2011-10-19 11:14 UTC Pavel Stehule <pavel.stehule@gmail.com>
[2+ messages in thread]
Optimize the database performance
2011-10-17 09:48 UTC Micka <mickamusset@gmail.com>
` Re: Optimize the database performance
2011-10-17 10:39 UTC MirrorX <mirrorx@gmail.com>
` Re: Optimize the database performance
2011-10-17 18:35 UTC Andy Colson <andy@squeakycode.net>
` Re: Optimize the database performance
2011-10-17 20:31 UTC Cédric Villemain <cedric.villemain.debian@gmail.com>
[4+ messages in thread]
Tablespace files deleted automatically.
2011-10-13 12:52 UTC Vishnu S. <vishnu.s@nestgroup.net>
` Re: Tablespace files deleted automatically.
2011-10-14 18:19 UTC Josh Berkus <josh@agliodbs.com>
` Re: Tablespace files deleted automatically.
2011-10-17 12:04 UTC Robert Klemme <shortcutter@googlemail.com>
[3+ messages in thread]
Slow query when using ORDER BY *and* LIMIT
2011-07-06 00:18 UTC Jonathan <jonathan@kc8onw.net>
` Re: Slow query when using ORDER BY *and* LIMIT
2011-07-08 22:23 UTC Jonathan <jonathan@kc8onw.net>
` Re: Slow query when using ORDER BY *and* LIMIT
2011-07-09 03:39 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Slow query when using ORDER BY *and* LIMIT
2011-07-09 03:49 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Slow query when using ORDER BY *and* LIMIT
2011-10-13 19:34 UTC davidsarmstrong <dsatemp-1@yahoo.com>
` Re: Slow query when using ORDER BY *and* LIMIT
2011-10-15 21:09 UTC Michael Viscuso <michael.viscuso@getcarbonblack.com>
[6+ messages in thread]
Join over two tables of 50K records takes 2 hours
2011-10-12 08:55 UTC Svetlin Manavski <svetlin.manavski@gmail.com>
` Re: Join over two tables of 50K records takes 2 hours
2011-10-14 04:37 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Join over two tables of 50K records takes 2 hours
2011-10-14 04:38 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Join over two tables of 50K records takes 2 hours
2011-10-14 08:35 UTC Svetlin Manavski <svetlin.manavski@gmail.com>
` Re: Join over two tables of 50K records takes 2 hours
2011-10-14 09:41 UTC Scott Marlowe <scott.marlowe@gmail.com>
[5+ messages in thread]
postgresql query runtime
2011-10-11 19:08 UTC Radhya sahal <rad_cs_2006@yahoo.com>
` Re: postgresql query runtime
2011-10-11 19:11 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: postgresql query runtime
2011-10-11 19:13 UTC Szymon Guz <mabewlun@gmail.com>
` Re: postgresql query runtime
2011-10-11 19:14 UTC Szymon Guz <mabewlun@gmail.com>
` Re: postgresql query runtime
2011-10-11 19:15 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: postgresql query runtime
2011-10-11 21:29 UTC Radhya sahal <rad_cs_2006@yahoo.com>
` Re: postgresql query runtime
2011-10-11 21:43 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
[7+ messages in thread]
Re: Adding more memory = hugh cpu load [solved]
2011-10-11 18:02 UTC alexandre - aldeia digital <adaldeia@gmail.com>
` Re: Adding more memory = hugh cpu load [solved]
2011-10-11 18:05 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: Adding more memory = hugh cpu load [solved]
2011-10-11 20:02 UTC alexandre - aldeia digital <adaldeia@gmail.com>
` Re: Adding more memory = hugh cpu load [solved]
2011-10-11 20:08 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: Adding more memory = hugh cpu load [solved]
2011-10-11 20:33 UTC Arjen van der Meijden <acmmailing@tweakers.net>
` Re: Adding more memory = hugh cpu load [solved]
2011-10-11 20:46 UTC Claudio Freire <klaussfreire@gmail.com>
[6+ messages in thread]
Query tuning help
2005-05-08 23:20 UTC Dan Harris <fbsd@drivefaster.net>
` Re: Query tuning help
2005-05-09 00:48 UTC Josh Berkus <josh@agliodbs.com>
` Re: Query tuning help
2005-05-09 00:51 UTC Russell Smith <mr-russ@pws.com.au>
` Re: Query tuning help
2005-05-09 00:58 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Query tuning help
2005-05-09 01:49 UTC Dan Harris <fbsd@drivefaster.net>
` Re: Query tuning help
2005-05-09 02:06 UTC Josh Berkus <josh@agliodbs.com>
` Re: Query tuning help
2005-05-09 02:28 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Query tuning help
2005-05-09 02:31 UTC Dan Harris <fbsd@drivefaster.net>
` Re: Query tuning help
2005-05-09 02:32 UTC Russell Smith <mr-russ@pws.com.au>
` Re: Query tuning help
2005-05-09 02:49 UTC Dan Harris <fbsd@drivefaster.net>
` Re: Query tuning help
2005-05-09 04:17 UTC Klint Gore <kg@kgb.une.edu.au>
` Re: Query tuning help
2005-05-09 11:39 UTC Harald Fuchs <use_reply_to@protecting.net>
` Re: Query tuning help
2005-05-09 17:31 UTC Mischa Sandberg <mischa.sandberg@telus.net>
` Re: Query tuning help
2005-05-11 12:47 UTC Ulrich Wisser <ulrich.wisser@relevanttraffic.se>
` query tuning help
2010-06-14 10:41 UTC AI Rumman <rummandba@gmail.com>
` Re: query tuning help
2010-06-14 13:50 UTC Andy Colson <andy@squeakycode.net>
` Query tuning help
2011-10-11 17:52 UTC CS DBA <cs_dba@consistentstate.com>
` Re: Query tuning help
2011-10-11 18:02 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Query tuning help
2011-10-11 18:03 UTC Szymon Guz <mabewlun@gmail.com>
` Re: Query tuning help
2011-10-11 18:14 UTC CS DBA <cs_dba@consistentstate.com>
` Re: Query tuning help
2011-10-11 18:31 UTC CS DBA <cs_dba@consistentstate.com>
` Re: Query tuning help
2011-10-11 18:59 UTC Pavel Stehule <pavel.stehule@gmail.com>
[22+ messages in thread]
Adding more memory = hugh cpu load
2011-10-10 13:26 UTC alexandre - aldeia digital <adaldeia@gmail.com>
` Re: Adding more memory = hugh cpu load
2011-10-10 13:51 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Adding more memory = hugh cpu load
2011-10-10 14:04 UTC Shaun Thomas <sthomas@peak6.com>
` Re: Adding more memory = hugh cpu load
2011-10-10 15:14 UTC Leonardo Francalanci <m_lists@yahoo.it>
` Re: Adding more memory = hugh cpu load
2011-10-10 15:39 UTC Shaun Thomas <sthomas@peak6.com>
` Re: Adding more memory = hugh cpu load
2011-10-10 16:07 UTC Greg Smith <greg@2ndQuadrant.com>
` Re: Adding more memory = hugh cpu load
2011-10-10 16:14 UTC Leonardo Francalanci <m_lists@yahoo.it>
` Re: Adding more memory = hugh cpu load
2011-10-10 17:31 UTC alexandre - aldeia digital <adaldeia@gmail.com>
` Re: Adding more memory = hugh cpu load
2011-10-10 17:46 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Adding more memory = hugh cpu load
2011-10-10 18:54 UTC alexandre - aldeia digital <adaldeia@gmail.com>
` Re: Adding more memory = hugh cpu load
2011-10-10 19:39 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Adding more memory = hugh cpu load
2011-10-10 20:25 UTC Shaun Thomas <sthomas@peak6.com>
` Re: Adding more memory = hugh cpu load
2011-10-10 20:34 UTC alexandre - aldeia digital <adaldeia@gmail.com>
` Re: Adding more memory = hugh cpu load
2011-10-10 20:52 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Adding more memory = hugh cpu load
2011-10-10 22:02 UTC Samuel Gendler <sgendler@ideasculptor.com>
` Re: Adding more memory = hugh cpu load
2011-10-11 02:19 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: Adding more memory = hugh cpu load
2011-10-11 06:42 UTC Greg Smith <greg@2ndQuadrant.com>
` Re: Adding more memory = hugh cpu load
2011-10-11 06:50 UTC Greg Smith <greg@2ndQuadrant.com>
` Re: Adding more memory = hugh cpu load
2011-10-11 08:57 UTC Leonardo Francalanci <m_lists@yahoo.it>
` Re: Adding more memory = hugh cpu load
2011-10-11 10:20 UTC Ivan Voras <ivoras@freebsd.org>
` Re: Adding more memory = hugh cpu load
2011-10-11 11:54 UTC alexandre - aldeia digital <adaldeia@gmail.com>
` Re: Adding more memory = hugh cpu load
2011-10-11 12:14 UTC alexandre - aldeia digital <adaldeia@gmail.com>
` Re: Adding more memory = hugh cpu load
2011-10-11 12:50 UTC Luca Tettamanti <kronos.it@gmail.com>
` Re: Adding more memory = hugh cpu load
2011-10-11 15:32 UTC Greg Smith <greg@2ndQuadrant.com>
[24+ messages in thread]
: Performance Improvement Strategy
2011-09-20 16:22 UTC Venkat Balaji <venkat.balaji@verse.in>
` Re: : Performance Improvement Strategy
2011-09-20 17:51 UTC Marcin Mirosław <marcin@mejor.pl>
` Re: : Performance Improvement Strategy
2011-09-20 18:09 UTC Josh Berkus <josh@agliodbs.com>
` Re: : Performance Improvement Strategy
2011-09-20 22:05 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
` Re: : Performance Improvement Strategy
2011-09-20 22:10 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
` Re: : Performance Improvement Strategy
2011-09-21 05:38 UTC Venkat Balaji <venkat.balaji@verse.in>
` Re: : Performance Improvement Strategy
2011-09-21 05:59 UTC Venkat Balaji <venkat.balaji@verse.in>
` Re: : Performance Improvement Strategy
2011-09-21 13:03 UTC Shaun Thomas <sthomas@peak6.com>
` Re: : Performance Improvement Strategy
2011-09-21 13:57 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: : Performance Improvement Strategy
2011-09-21 16:13 UTC Venkat Balaji <venkat.balaji@verse.in>
` Re: : Performance Improvement Strategy
2011-09-21 17:57 UTC Greg Smith <greg@2ndQuadrant.com>
` Re: : Performance Improvement Strategy
2011-09-21 18:18 UTC Venkat Balaji <venkat.balaji@verse.in>
` Re: : Performance Improvement Strategy
2011-09-21 18:41 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: : Performance Improvement Strategy
2011-09-27 12:29 UTC Venkat Balaji <venkat.balaji@verse.in>
` Re: : Performance Improvement Strategy
2011-09-27 12:31 UTC Venkat Balaji <venkat.balaji@verse.in>
` Re: : Performance Improvement Strategy
2011-10-03 10:59 UTC Venkat Balaji <venkat.balaji@verse.in>
` Re: : Performance Improvement Strategy
2011-10-03 16:15 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: : Performance Improvement Strategy
2011-10-03 16:54 UTC Venkat Balaji <venkat.balaji@verse.in>
` Re: : Performance Improvement Strategy
2011-10-05 09:08 UTC Venkat Balaji <venkat.balaji@verse.in>
` Re: : Performance Improvement Strategy
2011-10-05 09:30 UTC Raghavendra <raghavendra.rao@enterprisedb.com>
` Re: : Performance Improvement Strategy
2011-10-05 09:39 UTC Guillaume Cottenceau <gc@mnc.ch>
` Re: : Performance Improvement Strategy
2011-10-05 16:13 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: : Performance Improvement Strategy
2011-10-05 17:09 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: : Performance Improvement Strategy
2011-10-05 18:15 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: : Performance Improvement Strategy
2011-10-06 09:31 UTC Raghavendra <raghavendra.rao@enterprisedb.com>
` Re: : Performance Improvement Strategy
2011-10-06 19:20 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: : Performance Improvement Strategy
2011-10-10 08:04 UTC Leonardo Francalanci <m_lists@yahoo.it>
[27+ messages in thread]
PostgreSQL-9.0 Monitoring System to improve performance
2011-09-27 16:35 UTC Venkat Balaji <venkat.balaji@verse.in>
` Re: PostgreSQL-9.0 Monitoring System to improve performance
2011-09-28 07:05 UTC Greg Smith <greg@2ndquadrant.com>
` Re: PostgreSQL-9.0 Monitoring System to improve performance
2011-09-28 12:14 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: PostgreSQL-9.0 Monitoring System to improve performance
2011-09-30 10:30 UTC Venkat Balaji <venkat.balaji@verse.in>
` Re: PostgreSQL-9.0 Monitoring System to improve performance
2011-09-30 10:32 UTC Venkat Balaji <venkat.balaji@verse.in>
` Re: PostgreSQL-9.0 Monitoring System to improve performance
2011-09-30 11:53 UTC Gregg Jaskiewicz <gryzman@gmail.com>
` Re: PostgreSQL-9.0 Monitoring System to improve performance
2011-09-30 21:29 UTC Bobby Dewitt <Bdewitt@appriss.com>
` Re: PostgreSQL-9.0 Monitoring System to improve performance
2011-10-07 22:01 UTC Fernando Hevia <fhevia@gmail.com>
` Re: PostgreSQL-9.0 Monitoring System to improve performance
2011-10-07 22:13 UTC Ben Ciceron <ben@triggit.com>
[9+ messages in thread]
pg9 replication over WAN ?
2011-10-05 21:53 UTC Ben Ciceron <ben@triggit.com>
` Re: pg9 replication over WAN ?
2011-10-07 03:22 UTC mark <dvlhntr@gmail.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