pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Query is not using index when it should
  2004-12-10 11:40 UTC  Tomas Skäre <tomas@nocrew.org>
` Re: Query is not using index when it should
  2004-12-11 02:28 UTC  Stephan Szabo <sszabo@megazone.bigpanda.com>
` Re: Query is not using index when it should
  2004-12-11 14:17 UTC  Tomas Skäre <tomas@nocrew.org>
` Re: [GENERAL] Query is not using index when it should
  2004-12-11 14:32 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: [GENERAL] Query is not using index when it should
  2004-12-11 16:25 UTC  Michael Fuhr <mike@fuhr.org>
` Re: [GENERAL] Query is not using index when it should
  2004-12-12 08:32 UTC  Tomas Skäre <tomas@nocrew.org>
` Re: Query is not using index when it should
  2004-12-13 02:48 UTC  Josh Berkus <josh@agliodbs.com>
  [7+ messages in thread]

Very different index usage on similar tables
  2004-12-11 17:01 UTC  Alvaro Nunes Melo <al_nunes@atua.com.br>

Slow INSERT
  2004-06-29 12:30 UTC  Michal Táborský <michal@taborsky.cz>
` Re: Slow INSERT
  2004-06-29 14:30 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Slow INSERT
  2004-06-29 15:09 UTC  Michal Taborsky <michal@taborsky.cz>
` Re: Slow INSERT
  2004-06-29 15:22 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Slow INSERT
  2004-06-29 15:47 UTC  Michal Taborsky <michal@taborsky.cz>
` Re: Slow INSERT
  2004-06-29 16:02 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Slow insert
  2004-12-08 02:42 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: Slow insert
  2004-12-11 01:45 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
  [8+ messages in thread]

8.0 vs. 7.4 benchmarks
  2004-12-06 09:28 UTC  Postgres Learner <postgres.learner@gmail.com>
` Fwd: 8.0 vs. 7.4 benchmarks
  2004-12-07 09:17 UTC  Postgres Learner <postgres.learner@gmail.com>
` Re: Fwd: 8.0 vs. 7.4 benchmarks
  2004-12-07 14:52 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: Fwd: 8.0 vs. 7.4 benchmarks
  2004-12-07 16:43 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: Fwd: 8.0 vs. 7.4 benchmarks
  2004-12-07 17:43 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: Fwd: 8.0 vs. 7.4 benchmarks
  2004-12-07 18:35 UTC  Joshua D. Drake <jd@commandprompt.com>
  [6+ messages in thread]

scaling beyond 4 processors
  2004-12-06 22:18 UTC  vogler@cipsoft.com
` Re: scaling beyond 4 processors
  2004-12-07 02:52 UTC  Jeff <threshar@torgo.978.org>
` Re: scaling beyond 4 processors
  2004-12-07 04:16 UTC  Christopher Browne <cbbrowne@acm.org>
` Re: scaling beyond 4 processors
  2004-12-07 04:17 UTC  Christopher Browne <cbbrowne@acm.org>
` Re: scaling beyond 4 processors
  2004-12-07 17:49 UTC  Josh Berkus <josh@agliodbs.com>
  [5+ messages in thread]

Config review
  2004-12-06 14:40 UTC  Bryan Vest <bvest@bright.net>
` Re: Config review
  2004-12-07 08:03 UTC  Greg Stark <gsstark@mit.edu>
` Re: Config review
  2004-12-07 15:07 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Config review
  2004-12-07 15:19 UTC  Andrew Sullivan <ajs@crankycanuck.ca>
  [4+ messages in thread]

TableSpace Design issues on Postgres 8.0 beta 5
  2004-12-06 13:52 UTC  Rosny <sehatrosny@hotmail.com>
` Re: TableSpace Design issues on Postgres 8.0 beta 5
  2004-12-06 20:28 UTC  Rosny <sehatrosny@hotmail.com>
` Re: TableSpace Design issues on Postgres 8.0 beta 5
  2004-12-07 04:44 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: TableSpace Design issues on Postgres 8.0 beta 5
  2004-12-07 07:58 UTC  Rosny <sehatrosny@hotmail.com>
  [4+ messages in thread]

Config Check
  2004-12-06 14:43 UTC  Bryan <bvest@rhondasworld.com>
` Re: Config Check
  2004-12-06 15:18 UTC  Pierre-Frédéric Caillaud <lists@boutiquenumerique.com>
` Re: Config Check
  2004-12-06 15:56 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Config Check
  2004-12-07 02:40 UTC  Hasnul Fadhly bin Hasan <hasnulfadhly.h@mimos.my>
` Re: Config Check
  2004-12-07 02:54 UTC  John A Meinel <john@arbash-meinel.com>
` Re: Config Check
  2004-12-07 05:03 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [6+ messages in thread]

Poor Query
  2004-12-06 15:28 UTC  Pallav Kalva <pkalva@deg.cc>
` Re: Poor Query
  2004-12-06 15:48 UTC  Pierre-Frédéric Caillaud <lists@boutiquenumerique.com>
` Re: Poor Query
  2004-12-06 15:52 UTC  Pallav Kalva <pkalva@deg.cc>
` Re: Poor Query
  2004-12-06 16:16 UTC  Pierre-Frédéric Caillaud <lists@boutiquenumerique.com>
` Re: Poor Query
  2004-12-06 16:37 UTC  Pallav Kalva <pkalva@deg.cc>
` Re: Poor Query
  2004-12-06 17:34 UTC  Pierre-Frédéric Caillaud <lists@boutiquenumerique.com>
` Re: Poor Query
  2004-12-06 18:00 UTC  Pallav Kalva <pkalva@deg.cc>
` Re: Poor Query
  2004-12-06 20:18 UTC  Pierre-Frédéric Caillaud <lists@boutiquenumerique.com>
` Re: Poor Query
  2004-12-06 20:44 UTC  Pallav Kalva <pkalva@deg.cc>
  [9+ messages in thread]

Improve BULK insertion
  2004-12-04 13:39 UTC  Grupos <grupos@carvalhaes.net>
` Re: Improve BULK insertion
  2004-12-04 14:47 UTC  Patrick Hatcher <PHatcher@macys.com>
` Re: Improve BULK insertion
  2004-12-04 14:48 UTC  Christopher Browne <cbbrowne@acm.org>
` Re: Improve BULK insertion
  2004-12-04 19:14 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Improve BULK insertion
  2004-12-05 19:52 UTC  Rodrigo Carvalhaes <grupos@carvalhaes.net>
` Re: Improve BULK insertion
  2004-12-05 22:48 UTC  Gregory S. Williamson <gsw@globexplorer.com>
` Re: Improve BULK insertion
  2004-12-05 23:19 UTC  Josh Berkus <josh@agliodbs.com>
  [7+ messages in thread]

lock problem
  2004-12-04 16:56 UTC  sarlav kumar <sarlavk@yahoo.com>
` Re: lock problem
  2004-12-04 17:34 UTC  Stephan Szabo <sszabo@megazone.bigpanda.com>
  [2+ messages in thread]

Overhead of dynamic query in trigger
  2004-12-04 03:46 UTC  Sven Willenberger <sven@dmv.com>

DB2 feature
  2004-12-03 20:38 UTC  Pailloncy Jean-Gérard <jg@rilk.com>
` Re: DB2 feature
  2004-12-03 21:02 UTC  Josh Berkus <josh@agliodbs.com>
` Re: DB2 feature
  2004-12-03 22:27 UTC  Christopher Browne <cbbrowne@acm.org>
` Re: DB2 feature
  2004-12-03 22:48 UTC  Pailloncy Jean-Gérard <jg@rilk.com>
  [4+ messages in thread]

Performance difference in similar queries
  2004-12-03 22:12 UTC  Kiran Mukhyala <mukhyala.kiran@gene.com>
` Performance difference in similar queries
  2004-12-03 22:31 UTC  Kiran Mukhyala <mukhyala.kiran@gene.com>
  [2+ messages in thread]

VACUUM ANALYZE downgrades performance
  2004-11-30 13:30 UTC  Dmitry Karasik <dmitry@karasik.eu.org>
` Re: VACUUM ANALYZE downgrades performance
  2004-11-30 15:33 UTC  Mike Rylander <mrylander@gmail.com>
` Re: VACUUM ANALYZE downgrades performance
  2004-11-30 15:42 UTC  Thomas Swan <tswan@idigx.com>
` Re: VACUUM ANALYZE downgrades performance
  2004-12-02 16:07 UTC  Dmitry Karasik <dmitry@karasik.eu.org>
` Re: VACUUM ANALYZE downgrades performance
  2004-12-02 16:25 UTC  Rod Taylor <pg@rbt.ca>
` Re: VACUUM ANALYZE downgrades performance
  2004-12-02 16:30 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: VACUUM ANALYZE downgrades performance
  2004-12-02 16:38 UTC  Shridhar Daithankar <ghodechhap@ghodechhap.net>
` Re: VACUUM ANALYZE downgrades performance
  2004-12-03 10:42 UTC  Dmitry Karasik <dmitry@karasik.eu.org>
  [8+ messages in thread]

Poor Performance on a table
  2004-12-02 19:11 UTC  Pallav Kalva <pkalva@deg.cc>
` Re: Poor Performance on a table
  2004-12-02 19:20 UTC  Frank Wiles <frank@wiles.org>
` Re: Poor Performance on a table
  2004-12-02 19:32 UTC  Pallav Kalva <pkalva@deg.cc>
` Re: Poor Performance on a table
  2004-12-02 19:36 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Poor Performance on a table
  2004-12-02 19:38 UTC  Frank Wiles <frank@wiles.org>
` Re: Poor Performance on a table
  2004-12-02 19:54 UTC  Pallav Kalva <pkalva@deg.cc>
` Re: Poor Performance on a table
  2004-12-02 20:10 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Poor Performance on a table
  2004-12-03 05:57 UTC  Josh Berkus <josh@agliodbs.com>
  [8+ messages in thread]

pg replication tools?
  2004-12-02 14:38 UTC  sarlav kumar <sarlavk@yahoo.com>
` Re: pg replication tools?
  2004-12-02 16:50 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: pg replication tools?
  2004-12-02 16:58 UTC  Darcy Buskermolen <darcy@wavefire.com>
` Re: pg replication tools?
  2004-12-03 02:39 UTC  Christopher Browne <cbbrowne@acm.org>
` Re: pg replication tools?
  2004-12-03 05:16 UTC  Vishal Kashyap @ [SaiHertz] <vishalonlist@gmail.com>
  [5+ messages in thread]

Normalization or Performance
  2004-12-02 17:05 UTC  Alvaro Nunes Melo <al_nunes@atua.com.br>
` Re: Normalization or Performance
  2004-12-02 18:34 UTC  Richard Huxton <dev@archonet.com>
` Re: Normalization or Performance
  2004-12-02 23:03 UTC  Jim C. Nasby <decibel@decibel.org>
` Re: Normalization or Performance
  2004-12-03 01:44 UTC  Iain <iain@mst.co.jp>
  [4+ messages in thread]

scalability issues on win32
  2004-11-22 22:07 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: scalability issues on win32
  2004-11-22 23:15 UTC  Pierre-Frédéric Caillaud <lists@boutiquenumerique.com>
` Re: scalability issues on win32
  2004-11-23 02:26 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
` Re: scalability issues on win32
  2004-11-23 10:19 UTC  Reini Urban <rurban@x-ray.at>
` Re: scalability issues on win32
  2004-11-23 10:35 UTC  Dave Page <dpage@vale-housing.co.uk>
` Re: scalability issues on win32
  2004-11-23 13:05 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: scalability issues on win32
  2004-11-23 15:06 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
` Re: scalability issues on win32
  2004-11-23 16:25 UTC  Magnus Hagander <mha@sollentuna.net>
` Re: [pgsql-hackers-win32] scalability issues on win32
  2004-11-23 17:06 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: scalability issues on win32
  2004-11-23 20:12 UTC  Dave Page <dpage@vale-housing.co.uk>
` Re: scalability issues on win32
  2004-11-24 04:38 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
` Re: [PERFORM] scalability issues on win32
  2004-12-02 19:21 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: [PERFORM] scalability issues on win32
  2004-12-02 19:28 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
` Re: [PERFORM] scalability issues on win32
  2004-12-02 19:42 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [14+ messages in thread]

Different location or different instance
  2004-12-02 17:16 UTC  Gabriele Bartolini <angusgb@tin.it>

Recommended Specs
  2004-12-02 00:20 UTC  Hasnul Fadhly bin Hasan <hasnulfadhly.h@mimos.my>
` Re: Recommended Specs
  2004-12-02 06:15 UTC  Josh Berkus <josh@agliodbs.com>
  [2+ messages in thread]

query with timestamp not using index
  2004-12-01 16:46 UTC  Brian Hirt <bhirt@mobygames.com>
` Re: query with timestamp not using index
  2004-12-01 17:38 UTC  Richard Huxton <dev@archonet.com>
` Re: query with timestamp not using index
  2004-12-01 20:06 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: query with timestamp not using index
  2004-12-01 22:09 UTC  Brian Hirt <bhirt@mobygames.com>
` Re: query with timestamp not using index
  2004-12-01 22:16 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [5+ messages in thread]

Using "LIMIT" is much faster even though, searching with PK.
  2004-12-01 04:10 UTC  장현성 <siche@siche.net>
` Re: Using "LIMIT" is much faster even though, searching with PK.
  2004-12-01 04:26 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Using "LIMIT" is much faster even though, searching
  2004-12-01 04:38 UTC  Hyun-Sung, Jang <siche@siche.net>
` Re: Using "LIMIT" is much faster even though, searching
  2004-12-01 05:03 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Using "LIMIT" is much faster even though, searching
  2004-12-01 06:03 UTC  Hyun-Sung, Jang <siche@siche.net>
` Re: Using "LIMIT" is much faster even though, searching
  2004-12-01 08:23 UTC  Andrew McMillan <andrew@catalyst.net.nz>
` Re: Using "LIMIT" is much faster even though, searching
  2004-12-01 20:25 UTC  Josh Berkus <josh@agliodbs.com>
  [7+ messages in thread]

Query Performance and IOWait
  2004-11-18 13:42 UTC  Andrew Janian <ajanian@scottrade.com>
` Re: Query Performance and IOWait
  2004-11-18 13:56 UTC  Richard_D_Levine@raytheon.com
` Re: Query Performance and IOWait
  2004-11-18 14:01 UTC  Andrew Janian <ajanian@scottrade.com>
` Re: Query Performance and IOWait
  2004-11-18 14:18 UTC  Woody Woodring <george.woodring@iglass.net>
` Re: Query Performance and IOWait
  2004-11-18 15:39 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Query Performance and IOWait
  2004-11-18 15:57 UTC  Andrew Janian <ajanian@scottrade.com>
` Re: Query Performance and IOWait
  2004-11-18 16:44 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: Query Performance and IOWait
  2004-11-18 17:14 UTC  Dave Cramer <pg@fastcrypt.com>
` Re: Query Performance and IOWait
  2004-11-18 18:33 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Query Performance and IOWait
  2004-11-18 19:04 UTC  Woody Woodring <george.woodring@iglass.net>
` Re: Query Performance and IOWait
  2004-11-19 21:13 UTC  Frank Wiles <frank@wiles.org>
` Re: Query Performance and IOWait
  2004-11-19 21:22 UTC  Andrew Janian <ajanian@scottrade.com>
` Re: Query Performance and IOWait
  2004-11-22 15:20 UTC  Anjan Dave <adave@vantage.com>
` Re: Query Performance and IOWait
  2004-12-01 13:29 UTC  George Woodring <george.woodring@iglass.net>
  [14+ messages in thread]

"Group By " index usage
  2004-11-24 17:36 UTC  sdfasdfas sdfasdfs <descuarinjado@yahoo.es>
` Re: "Group By " index usage
  2004-11-24 17:55 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: "Group By " index usage
  2004-11-30 16:04 UTC  Alban Medici (NetCentrex) <amedici@fr.netcentrex.net>
  [3+ 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