pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedQuery 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