pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedHow to determine cause of performance problem?
2005-09-23 06:49 UTC Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
` Re: How to determine cause of performance problem?
2005-09-23 09:31 UTC Ulrich Wisser <ulrich.wisser@relevanttraffic.se>
` Re: How to determine cause of performance problem?
2005-09-23 09:55 UTC Michael Stone <mstone+postgres@mathom.us>
` Re: How to determine cause of performance problem?
2005-09-23 10:21 UTC Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
` Re: How to determine cause of performance problem?
2005-09-23 11:05 UTC Michael Stone <mstone+postgres@mathom.us>
` Re: How to determine cause of performance problem?
2005-09-23 11:19 UTC Arjen van der Meijden <acmmailing@tweakers.net>
` Re: How to determine cause of performance problem?
2005-09-23 11:30 UTC Dave Cramer <pg@fastcrypt.com>
` Re: How to determine cause of performance problem?
2005-09-23 13:35 UTC Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
` Re: How to determine cause of performance problem?
2005-09-23 13:49 UTC Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
` Re: How to determine cause of performance problem?
2005-09-23 14:06 UTC Arjen van der Meijden <acmmailing@tweakers.net>
` Re: How to determine cause of performance problem?
2005-09-23 14:33 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: How to determine cause of performance problem?
2005-09-23 14:47 UTC Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
` Re: How to determine cause of performance problem?
2005-09-23 14:50 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: How to determine cause of performance problem?
2005-09-23 15:31 UTC Michael Stone <mstone+postgres@mathom.us>
[14+ messages in thread]
Deadlock Issue with PostgreSQL
2005-09-21 01:44 UTC Anu Kucharlapati <anuk@rapidweb.com.au>
` Re: Deadlock Issue with PostgreSQL
2005-09-21 02:15 UTC Tom Lane <tgl@sss.pgh.pa.us>
` FW: Deadlock Issue with PostgreSQL
2005-09-23 00:21 UTC Anu Kucharlapati <anuk@rapidweb.com.au>
` Re: FW: Deadlock Issue with PostgreSQL
2005-09-23 02:49 UTC Josh Berkus <josh@agliodbs.com>
[4+ messages in thread]
Queries 15 times slower on 8.1 beta 2 than on 8.0
2005-09-22 21:20 UTC Jean-Pierre Pelletier <pelletier_32@sympatico.ca>
` Re: Queries 15 times slower on 8.1 beta 2 than on 8.0
2005-09-22 21:32 UTC Gavin M. Roy <gmr@ehpg.net>
` Re: Queries 15 times slower on 8.1 beta 2 than on 8.0
2005-09-22 21:38 UTC Jean-Pierre Pelletier <pelletier_32@sympatico.ca>
` Re: Queries 15 times slower on 8.1 beta 2 than on 8.0
2005-09-22 21:48 UTC John Arbash Meinel <john@arbash-meinel.com>
` Re: Queries 15 times slower on 8.1 beta 2 than on 8.0
2005-09-22 21:58 UTC Jean-Pierre Pelletier <pelletier_32@sympatico.ca>
` Re: Queries 15 times slower on 8.1 beta 2 than on 8.0
2005-09-22 22:03 UTC John Arbash Meinel <john@arbash-meinel.com>
` Re: Queries 15 times slower on 8.1 beta 2 than on 8.0
2005-09-22 22:19 UTC Josh Berkus <josh@agliodbs.com>
` Re: Queries 15 times slower on 8.1 beta 2 than on 8.0
2005-09-22 22:28 UTC Jean-Pierre Pelletier <pelletier_32@sympatico.ca>
` Re: Queries 15 times slower on 8.1 beta 2 than on 8.0
2005-09-22 22:37 UTC Tomeh, Husam <htomeh@firstam.com>
` Fw: Queries 15 times slower on 8.1 beta 2 than on 8.0
2005-09-22 22:43 UTC Jean-Pierre Pelletier <pelletier_32@sympatico.ca>
` Re: Queries 15 times slower on 8.1 beta 2 than on 8.0
2005-09-22 22:54 UTC Michael Fuhr <mike@fuhr.org>
` Re: Queries 15 times slower on 8.1 beta 2 than on 8.0
2005-09-22 23:07 UTC Jean-Pierre Pelletier <pelletier_32@sympatico.ca>
` Re: Queries 15 times slower on 8.1 beta 2 than on 8.0
2005-09-22 23:10 UTC Jean-Pierre Pelletier <pelletier_32@sympatico.ca>
` Re: Queries 15 times slower on 8.1 beta 2 than on 8.0
2005-09-22 23:12 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Queries 15 times slower on 8.1 beta 2 than on 8.0
2005-09-22 23:16 UTC Josh Berkus <josh@agliodbs.com>
` Re: Queries 15 times slower on 8.1 beta 2 than on 8.0
2005-09-22 23:17 UTC Michael Fuhr <mike@fuhr.org>
` Re: Queries 15 times slower on 8.1 beta 2 than on 8.0
2005-09-22 23:18 UTC Tomeh, Husam <htomeh@firstam.com>
` Re: Queries 15 times slower on 8.1 beta 2 than on 8.0
2005-09-22 23:26 UTC Jean-Pierre Pelletier <pelletier_32@sympatico.ca>
` Re: Queries 15 times slower on 8.1 beta 2 than on 8.0
2005-09-22 23:35 UTC Josh Berkus <josh@agliodbs.com>
` Re: Queries 15 times slower on 8.1 beta 2 than on 8.0
2005-09-22 23:50 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Queries 15 times slower on 8.1 beta 2 than on 8.0
2005-09-23 01:41 UTC Jean-Pierre Pelletier <pelletier_32@sympatico.ca>
[21+ messages in thread]
Nested Loop trouble : Execution time increases more 1000 time (long)
2005-09-17 15:47 UTC Antoine Bajolet <antoine.bajolet@free.fr>
` Re: Nested Loop trouble : Execution time increases more
2005-09-22 08:24 UTC Simon Riggs <simon@2ndquadrant.com>
` Re: Nested Loop trouble : Execution time increases more 1000 time (long)
2005-09-22 16:17 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Nested Loop trouble : Execution time increases more
2005-09-22 17:12 UTC Antoine Bajolet <antoine.bajolet@free.fr>
` Re: Nested Loop trouble : Execution time increases more
2005-09-22 17:52 UTC Antoine Bajolet <antoine.bajolet@free.fr>
[5+ messages in thread]
Performance considerations for very heavy INSERT traffic
2005-09-12 21:04 UTC Brandon Black <blblack@gmail.com>
` Re: Performance considerations for very heavy INSERT traffic
2005-09-12 21:24 UTC PFC <lists@boutiquenumerique.com>
` Re: Performance considerations for very heavy INSERT traffic
2005-09-12 21:45 UTC Alex Turner <armtuk@gmail.com>
` Re: Performance considerations for very heavy INSERT traffic
2005-09-12 22:02 UTC Brandon Black <blblack@gmail.com>
` Re: Performance considerations for very heavy INSERT traffic
2005-09-13 00:37 UTC Qingqing Zhou <zhouqq@cs.toronto.edu>
` Re: Performance considerations for very heavy INSERT traffic
2005-09-13 00:38 UTC Alan Stange <stange@rentec.com>
` Re: Performance considerations for very heavy INSERT traffic
2005-09-13 03:07 UTC Greg Stark <gsstark@mit.edu>
` Re: Performance considerations for very heavy INSERT traffic
2005-09-13 03:39 UTC Christopher Petrilli <petrilli@gmail.com>
` Re: Performance considerations for very heavy INSERT traffic
2005-09-13 03:44 UTC Brandon Black <blblack@gmail.com>
` Re: Performance considerations for very heavy INSERT traffic
2005-09-13 03:53 UTC Brandon Black <blblack@gmail.com>
` Re: Performance considerations for very heavy INSERT
2005-09-13 05:02 UTC Ron Peacetree <rjpeace@earthlink.net>
` Re: Performance considerations for very heavy INSERT traffic
2005-09-13 14:10 UTC Stephen Frost <sfrost@snowman.net>
` Re: Performance considerations for very heavy INSERT
2005-09-13 15:26 UTC evgeny gridasov <eugrid@fpm.kubsu.ru>
` Re: Performance considerations for very heavy INSERT traffic
2005-09-13 15:30 UTC Brandon Black <blblack@gmail.com>
` Re: Performance considerations for very heavy INSERT
2005-09-13 16:16 UTC Ian Westmacott <ianw@intellivid.com>
` Re: Performance considerations for very heavy INSERT
2005-09-13 17:22 UTC Alvaro Herrera <alvherre@alvh.no-ip.org>
` Re: Performance considerations for very heavy INSERT traffic
2005-09-21 15:57 UTC Vivek Khera <vivek@khera.org>
` Re: Performance considerations for very heavy INSERT traffic
2005-09-21 16:01 UTC Vivek Khera <vivek@khera.org>
[18+ messages in thread]
CHECK vs REFERENCES
2005-09-10 03:23 UTC Marc G. Fournier <scrappy@postgresql.org>
` Re: CHECK vs REFERENCES
2005-09-10 03:49 UTC Michael Fuhr <mike@fuhr.org>
` Re: CHECK vs REFERENCES
2005-09-10 04:03 UTC Marc G. Fournier <scrappy@postgresql.org>
` Re: CHECK vs REFERENCES
2005-09-10 13:06 UTC Michael Fuhr <mike@fuhr.org>
` Re: CHECK vs REFERENCES
2005-09-21 15:35 UTC Vivek Khera <vivek@khera.org>
[5+ messages in thread]
Planner statistics vs. count(*)
2005-09-20 18:12 UTC evgeny gridasov <eugrid@fpm.kubsu.ru>
` Re: Planner statistics vs. count(*)
2005-09-20 18:29 UTC Bricklen Anderson <BAnderson@PresiNET.com>
[2+ messages in thread]
RAID Stripe size
2005-09-16 11:51 UTC bm\mbn <miki@canaan.co.il>
` Re: RAID Stripe size
2005-09-20 04:24 UTC John A Meinel <john@arbash-meinel.com>
` Re: RAID Stripe size
2005-09-20 07:51 UTC Michael Ben-Nes <miki@canaan.co.il>
` Re: RAID Stripe size
2005-09-20 09:41 UTC Michael Stone <mstone+postgres@mathom.us>
` Re: RAID Stripe size
2005-09-20 10:53 UTC evgeny gridasov <eugrid@fpm.kubsu.ru>
` Re: RAID Stripe size
2005-09-20 14:01 UTC Jignesh K. Shah <J.K.Shah@Sun.COM>
` Re: RAID Stripe size
2005-09-20 15:13 UTC Alex Turner <armtuk@gmail.com>
` Re: RAID Stripe size
2005-09-20 15:21 UTC Welty, Richard <richard.welty@bankofamerica.com>
` Re: RAID Stripe size
2005-09-20 15:33 UTC Alex Turner <armtuk@gmail.com>
` Re: RAID Stripe size
2005-09-20 16:02 UTC evgeny gridasov <eugrid@fpm.kubsu.ru>
[10+ messages in thread]
Need for speed 2
2005-08-25 07:10 UTC Ulrich Wisser <ulrich.wisser@relevanttraffic.se>
` Re: Need for speed 2
2005-08-25 13:47 UTC Frank Wiles <frank@wiles.org>
` Re: Need for speed 2
2005-08-25 15:16 UTC Ron <rjpeace@earthlink.net>
` Re: Need for speed 2
2005-08-25 17:30 UTC Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: Need for speed 2
2005-08-25 19:00 UTC Kelly Burkhart <kelly@tradebotsystems.com>
` Re: Need for speed 2
2005-09-20 15:35 UTC Alex Turner <armtuk@gmail.com>
[6+ messages in thread]
Index Selection: ORDER BY vs. PRIMARY KEY
2005-09-19 23:00 UTC Thomas F. O'Connell <tfo@sitening.com>
` Re: Index Selection: ORDER BY vs. PRIMARY KEY
2005-09-20 03:05 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Index Selection: ORDER BY vs. PRIMARY KEY
2005-09-20 05:36 UTC Thomas F. O'Connell <tfo@sitening.com>
[3+ messages in thread]
How many tables is too many tables?
2005-09-13 20:23 UTC cydatamatt@gmail.com <cydatamatt@gmail.com>
` Re: How many tables is too many tables?
2005-09-15 01:49 UTC Qingqing Zhou <zhouqq@cs.toronto.edu>
` Re: How many tables is too many tables?
2005-09-20 03:21 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: How many tables is too many tables?
2005-09-20 04:22 UTC John A Meinel <john@arbash-meinel.com>
[4+ messages in thread]
How can this be?
2005-09-17 01:34 UTC Martin Nickel <martin@portant.com>
` Re: How can this be?
2005-09-19 23:02 UTC Steve Atkins <steve@blighty.com>
` Re: How can this be?
2005-09-19 23:07 UTC Stephan Szabo <sszabo@megazone.bigpanda.com>
[3+ messages in thread]
Re: [ODBC] ODBC Driver on Windows 64 bit
2005-09-15 14:01 UTC Merlin Moncure <merlin.moncure@rcsonline.com>
About method of PostgreSQL's Optimizer
2005-09-13 22:50 UTC Pryscila B Guttoski <pryscila.lista@gmail.com>
` Re: About method of PostgreSQL's Optimizer
2005-09-13 23:16 UTC Neil Conway <neilc@samurai.com>
` Re: About method of PostgreSQL's Optimizer
2005-09-13 23:23 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: About method of PostgreSQL's Optimizer
2005-09-13 23:31 UTC Cristian Prieto <cristian@clickdiario.com>
` Re: About method of PostgreSQL's Optimizer
2005-09-14 00:40 UTC Pryscila B Guttoski <pryscila.lista@gmail.com>
` About method of PostgreSQL's Optimizer
2005-09-14 00:41 UTC Pryscila B Guttoski <pryscila.lista@gmail.com>
` Re: About method of PostgreSQL's Optimizer
2005-09-14 01:34 UTC Neil Conway <neilc@samurai.com>
` Re: About method of PostgreSQL's Optimizer
2005-09-14 02:26 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: About method of PostgreSQL's Optimizer
2005-09-14 03:08 UTC Jonah H. Harris <jonah.harris@gmail.com>
` Re: About method of PostgreSQL's Optimizer
2005-09-14 03:20 UTC Pryscila B Guttoski <pryscila.lista@gmail.com>
` Re: About method of PostgreSQL's Optimizer
2005-09-14 15:44 UTC Josh Berkus <josh@agliodbs.com>
` Re: About method of PostgreSQL's Optimizer
2005-09-14 15:52 UTC Pryscila B Guttoski <pryscila.lista@gmail.com>
` Re: About method of PostgreSQL's Optimizer
2005-09-14 16:36 UTC Jonah H. Harris <jonah.harris@gmail.com>
` Re: About method of PostgreSQL's Optimizer
2005-09-14 17:54 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: About method of PostgreSQL's Optimizer
2005-09-15 04:39 UTC Jonah H. Harris <jonah.harris@gmail.com>
` Re: About method of PostgreSQL's Optimizer
2005-09-15 05:08 UTC Jonah H. Harris <jonah.harris@gmail.com>
[16+ messages in thread]
Battery Backed Cache for RAID
2005-09-14 18:25 UTC Peter Darley <pdarley@kinesis-cem.com>
` Re: Battery Backed Cache for RAID
2005-09-14 18:28 UTC Jeffrey W. Baker <jwbaker@acm.org>
` Re: Battery Backed Cache for RAID
2005-09-14 20:03 UTC Alvaro Herrera <alvherre@alvh.no-ip.org>
` Re: Battery Backed Cache for RAID
2005-09-14 20:17 UTC Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: Battery Backed Cache for RAID
2005-09-14 20:40 UTC John A Meinel <john@arbash-meinel.com>
` Re: Battery Backed Cache for RAID
2005-09-14 20:46 UTC Welty, Richard <richard.welty@bankofamerica.com>
` Re: Battery Backed Cache for RAID
2005-09-14 20:47 UTC Arjen van der Meijden <acmmailing@tweakers.net>
` Re: Battery Backed Cache for RAID
2005-09-14 21:58 UTC mudfoot@rawbw.com
[8+ messages in thread]
Low performance on Windows problem
2005-09-13 11:05 UTC Dalibor Sramek <dali@insula.cz>
` Re: Low performance on Windows problem
2005-09-13 11:58 UTC Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: Low performance on Windows problem
2005-09-13 13:49 UTC Dalibor Sramek <dali@insula.cz>
` Re: Low performance on Windows problem
2005-09-13 14:20 UTC Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: Low performance on Windows problem
2005-09-13 14:34 UTC Dalibor Sramek <dali@insula.cz>
` Re: Low performance on Windows problem
2005-09-13 15:01 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Low performance on Windows problem
2005-09-13 15:05 UTC Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: Low performance on Windows problem
2005-09-13 15:32 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Low performance on Windows problem
2005-09-13 19:21 UTC Dalibor Sramek <dali@insula.cz>
` Re: Low performance on Windows problem
2005-09-14 13:02 UTC Dalibor Sramek <dali@insula.cz>
` Re: Low performance on Windows problem
2005-09-14 14:23 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Low performance on Windows problem
2005-09-14 17:10 UTC Merlin Moncure <merlin.moncure@rcsonline.com>
[12+ messages in thread]
Help with performance on current status column
2005-09-13 21:08 UTC Chris Kratz <chris.kratz@vistashare.com>
` Re: Help with performance on current status column
2005-09-14 09:13 UTC Richard Huxton <dev@archonet.com>
` Re: Help with performance on current status column
2005-09-14 13:35 UTC Chris Kratz <chris.kratz@vistashare.com>
[3+ messages in thread]
Any other idea for better performance?
2005-09-13 23:34 UTC Cristian Prieto <cristian@clickdiario.com>
Opencms6 ans Postgres8
2005-09-13 11:17 UTC Bouchard Sylvie <Sylvie.Bouchard@cpln.ch>
Prepared statement not using index
2005-09-01 23:09 UTC Guido Neitzer <guido.neitzer@pharmaline.de>
` Re: Prepared statement not using index
2005-09-12 04:58 UTC John A Meinel <john@arbash-meinel.com>
` Re: Prepared statement not using index
2005-09-12 12:38 UTC Dave Cramer <pg@fastcrypt.com>
` Re: Prepared statement not using index
2005-09-12 13:22 UTC Guido Neitzer <guido.neitzer@pharmaline.de>
` Re: Prepared statement not using index
2005-09-12 13:26 UTC Greg Sabino Mullane <greg@turnstep.com>
` Re: Prepared statement not using index
2005-09-12 15:28 UTC Dave Cramer <pg@fastcrypt.com>
` Re: Prepared statement not using index
2005-09-12 15:30 UTC Dave Cramer <pg@fastcrypt.com>
[7+ messages in thread]
LEFT JOIN optimization
2005-09-11 17:12 UTC Ksenia Marasanova <ksenia.marasanova@gmail.com>
` Re: LEFT JOIN optimization
2005-09-11 21:00 UTC Stephen Frost <sfrost@snowman.net>
` Re: LEFT JOIN optimization
2005-09-11 21:47 UTC Ksenia Marasanova <ksenia.marasanova@gmail.com>
` Re: LEFT JOIN optimization
2005-09-12 00:34 UTC Stephen Frost <sfrost@snowman.net>
` Re: LEFT JOIN optimization
2005-09-12 10:41 UTC Manfred Koizar <mkoi-pg@aon.at>
[5+ messages in thread]
Advise about how to delete entries
2005-09-02 11:43 UTC Arnau <arnaulist@andromeiberica.com>
` Re: Advise about how to delete entries
2005-09-02 13:36 UTC Michael Fuhr <mike@fuhr.org>
` Re: Advise about how to delete entries
2005-09-02 16:47 UTC PFC <lists@boutiquenumerique.com>
` Re: Advise about how to delete entries
2005-09-05 09:26 UTC Arnau <arnaulist@andromeiberica.com>
` Re: Advise about how to delete entries
2005-09-06 11:05 UTC Kevin <kev@drule.org>
` Re: Advise about how to delete entries
2005-09-12 05:06 UTC John A Meinel <john@arbash-meinel.com>
[6+ messages in thread]
Index not used with prepared statement
2005-09-11 08:29 UTC Guido Neitzer <guido.neitzer@pharmaline.de>
` Re: Index not used with prepared statement
2005-09-11 09:03 UTC Andreas Seltenreich <andreas+pg@gate450.dyndns.org>
` Re: Index not used with prepared statement
2005-09-11 10:35 UTC Guido Neitzer <guido.neitzer@pharmaline.de>
[3+ messages in thread]
performance discrepancy indexing one column versus two columns
2005-09-11 07:43 UTC Mark Dilger <pgsql@markdilger.com>
` Re: performance discrepancy indexing one column versus
2005-09-11 08:05 UTC Gavin Sherry <swm@alcove.com.au>
[2+ messages in thread]
please comment on cpu 32 bit or 64 bit
2005-09-09 05:54 UTC wisan watcharinporn <maccran@hotmail.com>
` Re: please comment on cpu 32 bit or 64 bit
2005-09-09 06:58 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: please comment on cpu 32 bit or 64 bit
2005-09-10 05:21 UTC Chris Browne <cbbrowne@acm.org>
[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