pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
cpu_tuple_cost
  2005-03-11 14:25 UTC  Daniel Schuchardt <daniel_schuchardt@web.de>
` Re: cpu_tuple_cost
  2005-03-11 14:27 UTC  Daniel Schuchardt <daniel_schuchardt@web.de>
` Re: cpu_tuple_cost
  2005-03-14 06:29 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: cpu_tuple_cost
  2005-03-15 02:05 UTC  Greg Sabino Mullane <greg@turnstep.com>
` Re: cpu_tuple_cost
  2005-03-15 02:17 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
` Re: cpu_tuple_cost
  2005-03-15 02:23 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: cpu_tuple_cost
  2005-03-15 05:30 UTC  Gregory Stark <gsstark@mit.edu>
` Re: cpu_tuple_cost
  2005-03-15 06:10 UTC  Josh Berkus <josh@agliodbs.com>
` Re: cpu_tuple_cost
  2005-03-15 23:41 UTC  David Brown <time@bigpond.net.au>
` Re: cpu_tuple_cost
  2005-03-16 07:23 UTC  Greg Stark <gsstark@mit.edu>
` Re: cpu_tuple_cost
  2005-03-16 09:42 UTC  Magnus Hagander <mha@sollentuna.net>
` Re: cpu_tuple_cost
  2005-03-16 15:42 UTC  Greg Stark <gsstark@mit.edu>
` Re: cpu_tuple_cost
  2005-03-16 18:03 UTC  Josh Berkus <josh@agliodbs.com>
` Re: cpu_tuple_cost
  2005-03-16 19:45 UTC  Greg Stark <gsstark@mit.edu>
` Re: cpu_tuple_cost
  2005-03-16 20:42 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: cpu_tuple_cost
  2005-03-17 08:20 UTC  Manfred Koizar <mkoi-pg@aon.at>
` Re: cpu_tuple_cost
  2005-03-17 09:37 UTC  Daniel Schuchardt <daniel_schuchardt@web.de>
` Re: cpu_tuple_cost
  2005-03-17 17:54 UTC  Josh Berkus <josh@agliodbs.com>
` Re: cpu_tuple_cost
  2005-03-17 17:57 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: cpu_tuple_cost
  2005-03-17 18:26 UTC  Michael Fuhr <mike@fuhr.org>
  [20+ messages in thread]

TOP 10 SQL commands and more
  2005-03-17 13:17 UTC  Ales Vojacek <alesv@fbl.cz>
` Re: TOP 10 SQL commands and more
  2005-03-17 17:46 UTC  Josh Berkus <josh@agliodbs.com>
  [2+ messages in thread]

RES: Help to find out problem with joined tables
  2005-03-17 17:10 UTC  Rodrigo Moreno <rodrigo.miguel@terra.com.br>

Building a DB with performance in mind
  2005-03-17 15:56 UTC  Alexander Ranaldi <alexranaldi@gmail.com>
` Re: Building a DB with performance in mind
  2005-03-17 16:09 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Building a DB with performance in mind
  2005-03-17 16:16 UTC  John Arbash Meinel <john@arbash-meinel.com>
  [3+ messages in thread]

2 rows expected on a primary key
  2005-03-17 12:02 UTC  Gaetano Mendola <mendola@bigfoot.com>

index scan on =, but not < ?
  2005-03-08 18:35 UTC  Rick Schumeyer <rschumeyer@ieee.org>
` Re: index scan on =, but not < ?
  2005-03-08 18:52 UTC  Thomas F.O'Connell <tfo@sitening.com>
` Re: index scan on =, but not < ?
  2005-03-08 19:01 UTC  John Arbash Meinel <john@arbash-meinel.com>
` Re: index scan on =, but not < ?
  2005-03-08 19:02 UTC  Rick Schumeyer <rschumeyer@ieee.org>
` Re: index scan on =, but not < ?
  2005-03-08 19:04 UTC  Dennis Bjorklund <db@zigo.dhs.org>
` Re: index scan on =, but not < ?
  2005-03-09 04:38 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: index scan on =, but not < ?
  2005-03-09 04:55 UTC  Jim C. Nasby <decibel@decibel.org>
` Re: index scan on =, but not < ?
  2005-03-09 05:20 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: index scan on =, but not < ?
  2005-03-09 17:22 UTC  Jim C. Nasby <decibel@decibel.org>
` Re: index scan on =, but not < ?
  2005-03-10 00:06 UTC  David Brown <time@bigpond.net.au>
` Re: index scan on =, but not < ?
  2005-03-10 00:24 UTC  David Brown <time@bigpond.net.au>
` Re: index scan on =, but not < ?
  2005-03-17 08:12 UTC  Manfred Koizar <mkoi-pg@aon.at>
  [12+ messages in thread]

Join method influences scan method?
  2005-03-17 06:16 UTC  mark.lubratt@indeq.com
` Re: Join method influences scan method?
  2005-03-17 06:41 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [2+ messages in thread]

Help to find out problem with joined tables
  2005-03-16 20:10 UTC  Rodrigo Moreno <rodrigo.miguel@terra.com.br>
` Re: Help to find out problem with joined tables
  2005-03-17 04:42 UTC  Michael Fuhr <mike@fuhr.org>
  [2+ messages in thread]

Speeding up select distinct
  2005-03-16 17:58 UTC  Laurent Martelli <laurent@aopsys.com>
` Re: Speeding up select distinct
  2005-03-16 18:07 UTC  PFC <lists@boutiquenumerique.com>
` Re: Speeding up select distinct
  2005-03-16 18:10 UTC  Rod Taylor <pg@rbt.ca>
` Re: Speeding up select distinct
  2005-03-16 18:19 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: Speeding up select distinct
  2005-03-16 18:29 UTC  Laurent Martelli <laurent@aopsys.com>
` Re: Speeding up select distinct
  2005-03-16 18:31 UTC  Laurent Martelli <laurent@aopsys.com>
` Re: Speeding up select distinct
  2005-03-16 18:38 UTC  Laurent Martelli <laurent@aopsys.com>
` Re: Speeding up select distinct
  2005-03-16 18:41 UTC  Rod Taylor <pg@rbt.ca>
` Re: Speeding up select distinct
  2005-03-16 18:56 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: Speeding up select distinct
  2005-03-17 02:29 UTC  Greg Stark <gsstark@mit.edu>
  [10+ messages in thread]

Performance problem on delete from for 10k rows. May takes 20 minutes through JDBC interface
  2005-03-15 21:24 UTC  David Gagnon <dgagnon@siunik.com>
` Re: Performance problem on delete from for 10k rows. May takes 20 minutes through JDBC interface
  2005-03-15 23:38 UTC  Michael Fuhr <mike@fuhr.org>
` Re: Performance problem on delete from for 10k rows.
  2005-03-15 23:50 UTC  Rod Taylor <pg@rbt.ca>
` Re: Performance problem on delete from for 10k rows.  May
  2005-03-16 13:18 UTC  David Gagnon <dgagnon@siunik.com>
` Re: Performance problem on delete from for 10k rows.  May
  2005-03-16 14:06 UTC  Dave Cramer <pg@fastcrypt.com>
` Re: Performance problem on delete from for 10k rows.  May
  2005-03-16 14:26 UTC  David Gagnon <dgagnon@siunik.com>
` Re: Performance problem on delete from for 10k rows.  May
  2005-03-16 14:35 UTC  Alvaro Herrera <alvherre@dcc.uchile.cl>
` Re: Performance problem on delete from for 10k rows.  May
  2005-03-16 14:56 UTC  Dave Cramer <pg@fastcrypt.com>
` Re: Performance problem on delete from for 10k rows.  May
  2005-03-16 15:13 UTC  David Gagnon <dgagnon@siunik.com>
` Re: Performance problem on delete from for 10k rows.  May
  2005-03-16 16:28 UTC  Stephan Szabo <sszabo@megazone.bigpanda.com>
` Re: Performance problem on delete from for 10k rows.  May
  2005-03-16 17:02 UTC  David Gagnon <dgagnon@siunik.com>
` Re: Performance problem on delete from for 10k rows.  May
  2005-03-16 20:35 UTC  Stephan Szabo <sszabo@megazone.bigpanda.com>
  [12+ messages in thread]

Postgres on RAID5
  2005-03-11 19:48 UTC  Arshavir Grigorian <ag@m-cam.com>
` Postgres on RAID5
  2005-03-11 21:13 UTC  Arshavir Grigorian <ag@m-cam.com>
` Re: Postgres on RAID5
  2005-03-11 22:07 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Postgres on RAID5
  2005-03-11 22:29 UTC  Arshavir Grigorian <ag@m-cam.com>
` Re: Postgres on RAID5
  2005-03-11 22:36 UTC  Alvaro Herrera <alvherre@dcc.uchile.cl>
` Re: Postgres on RAID5
  2005-03-11 22:37 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Postgres on RAID5
  2005-03-12 00:22 UTC  Arshavir Grigorian <ag@m-cam.com>
` Re: Postgres on RAID5
  2005-03-12 01:32 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Postgres on RAID5
  2005-03-12 02:20 UTC  PFC <lists@boutiquenumerique.com>
` Re: Postgres on RAID5
  2005-03-12 02:21 UTC  Alexander Kirpa <postgres@bilteks.com>
` Re: Postgres on RAID5
  2005-03-12 03:50 UTC  Alex Turner <armtuk@gmail.com>
` Re: Postgres on RAID5
  2005-03-12 04:05 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: Postgres on RAID5
  2005-03-14 04:36 UTC  Greg Stark <gsstark@mit.edu>
` Re: Postgres on RAID5
  2005-03-14 18:54 UTC  Arshavir Grigorian <ag@m-cam.com>
` Re: Postgres on RAID5
  2005-03-14 19:53 UTC  Alex Turner <armtuk@gmail.com>
` Re: Postgres on RAID5
  2005-03-14 20:17 UTC  Greg Stark <gsstark@mit.edu>
` Re: Postgres on RAID5
  2005-03-14 20:35 UTC  Jim Buttafuoco <jim@contactbda.com>
` Re: Postgres on RAID5
  2005-03-14 20:54 UTC  Arshavir Grigorian <ag@m-cam.com>
` Re: Postgres on RAID5
  2005-03-14 21:03 UTC  Arshavir Grigorian <ag@m-cam.com>
` Re: Postgres on RAID5
  2005-03-14 21:18 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: Postgres on RAID5
  2005-03-14 21:31 UTC  Alex Turner <armtuk@gmail.com>
` Re: Postgres on RAID5
  2005-03-14 21:42 UTC  Alex Turner <armtuk@gmail.com>
` Re: Postgres on RAID5
  2005-03-14 22:47 UTC  Michael Tokarev <mjt@tls.msk.ru>
` Re: Postgres on RAID5
  2005-03-14 23:49 UTC  Guy <bugzilla@watkins-home.com>
` Re: Postgres on RAID5
  2005-03-16 16:47 UTC  David Dougall <davidd@et.byu.edu>
` Re: Postgres on RAID5
  2005-03-16 16:55 UTC  Michael Tokarev <mjt@tls.msk.ru>
  [26+ messages in thread]

Which one is faster: one way reading ="single pass reading"
  2005-03-16 11:15 UTC  Rosny <sehatrosny@hotmail.com>

Slow loads when indexes added.
  2005-03-15 15:23 UTC  Stef <svb@ucs.co.za>
` Re: Slow loads when indexes added.
  2005-03-16 07:59 UTC  Stef <svb@ucs.co.za>
  [2+ messages in thread]

interesting benchmarks PG/Firebird Linux/Windows fsync/nofsync
  2005-03-15 13:44 UTC  Chris Mair <list@1006.org>
` Re: interesting benchmarks PG/Firebird Linux/Windows fsync/nofsync
  2005-03-15 13:52 UTC  Magnus Hagander <mha@sollentuna.net>
` Re: interesting benchmarks PG/Firebird Linux/Windows fsync/nofsync
  2005-03-15 13:55 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
` Re: interesting benchmarks PG/Firebird Linux/Windows fsync/nofsync
  2005-03-16 01:44 UTC  Qingqing Zhou <zhouqq@cs.toronto.edu>
  [4+ messages in thread]

Re: Changing the random_page_cost default (was: cpu_tuple_cost)
  2005-03-15 12:35 UTC  Greg Sabino Mullane <greg@turnstep.com>
` Re: Changing the random_page_cost default (was: cpu_tuple_cost)
  2005-03-15 13:31 UTC  Jeff Hoffmann <jeff@propertykey.com>
` Re: Changing the random_page_cost default (was: cpu_tuple_cost)
  2005-03-15 15:22 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Changing the random_page_cost default (was:
  2005-03-15 22:44 UTC  Mark Kirkwood <markir@paradise.net.nz>
` Re: Changing the random_page_cost default (was: cpu_tuple_cost)
  2005-03-16 01:03 UTC  Greg Sabino Mullane <greg@turnstep.com>
  [5+ messages in thread]

Avoiding tuple construction/deconstruction during joining
  2005-03-14 17:24 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Avoiding tuple construction/deconstruction during joining
  2005-03-14 19:11 UTC  Miroslav Šulc <miroslav.sulc@startnet.cz>
` Re: Avoiding tuple construction/deconstruction during joining
  2005-03-14 19:22 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Avoiding tuple construction/deconstruction during joining
  2005-03-14 19:31 UTC  Miroslav Šulc <miroslav.sulc@startnet.cz>
` Re: [PERFORM] Avoiding tuple construction/deconstruction during joining
  2005-03-15 17:17 UTC  PFC <lists@boutiquenumerique.com>
` Re: [PERFORM] Avoiding tuple construction/deconstruction during joining
  2005-03-15 19:53 UTC  PFC <lists@boutiquenumerique.com>
  [6+ messages in thread]

Effect of Stripe Size  (was Postgres on RAID5)
  2005-03-15 16:17 UTC  Ruth Ivimey-Cook <Ruth.Ivimey-Cook@ivimey.org>

How to read query plan
  2005-03-13 15:32 UTC  Miroslav Šulc <miroslav.sulc@startnet.cz>
` Re: How to read query plan
  2005-03-13 16:24 UTC  John Arbash Meinel <john@arbash-meinel.com>
` Re: How to read query plan
  2005-03-13 16:51 UTC  Ragnar Hafstað <gnari@simnet.is>
` Re: How to read query plan
  2005-03-13 17:10 UTC  Miroslav Šulc <miroslav.sulc@startnet.cz>
` Re: How to read query plan
  2005-03-13 17:23 UTC  Miroslav Šulc <miroslav.sulc@startnet.cz>
` Re: How to read query plan
  2005-03-13 17:30 UTC  John Arbash Meinel <john@arbash-meinel.com>
` Re: How to read query plan
  2005-03-13 17:50 UTC  John Arbash Meinel <john@arbash-meinel.com>
` Re: How to read query plan
  2005-03-13 18:10 UTC  Miroslav Šulc <miroslav.sulc@startnet.cz>
` Re: How to read query plan
  2005-03-13 19:07 UTC  Miroslav Šulc <miroslav.sulc@startnet.cz>
` Re: How to read query plan
  2005-03-13 19:15 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: How to read query plan
  2005-03-13 19:26 UTC  John Arbash Meinel <john@arbash-meinel.com>
` Re: How to read query plan
  2005-03-13 19:43 UTC  Miroslav Šulc <miroslav.sulc@startnet.cz>
` Re: How to read query plan
  2005-03-13 19:51 UTC  Miroslav Šulc <miroslav.sulc@startnet.cz>
` Re: How to read query plan
  2005-03-13 19:54 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: How to read query plan
  2005-03-13 20:03 UTC  Miroslav Šulc <miroslav.sulc@startnet.cz>
` Re: How to read query plan
  2005-03-13 20:26 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] How to read query plan
  2005-03-14 00:08 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] How to read query plan
  2005-03-14 05:00 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] How to read query plan
  2005-03-14 08:43 UTC  Miroslav Šulc <miroslav.sulc@startnet.cz>
` Re: [PERFORM] How to read query plan
  2005-03-14 08:44 UTC  Miroslav Šulc <miroslav.sulc@startnet.cz>
` Re: How to read query plan
  2005-03-14 08:58 UTC  Miroslav Šulc <miroslav.sulc@startnet.cz>
` Re: How to read query plan
  2005-03-14 09:02 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: How to read query plan
  2005-03-14 09:08 UTC  PFC <lists@boutiquenumerique.com>
` Re: How to read query plan
  2005-03-14 09:09 UTC  Miroslav Šulc <miroslav.sulc@startnet.cz>
` Re: How to read query plan
  2005-03-14 09:17 UTC  Miroslav Šulc <miroslav.sulc@startnet.cz>
` Re: How to read query plan
  2005-03-14 14:05 UTC  Harald Fuchs <use_reply_to@protecting.net>
` Re: [PERFORM] How to read query plan
  2005-03-14 15:03 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] How to read query plan
  2005-03-14 15:04 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] How to read query plan
  2005-03-14 15:21 UTC  Miroslav Šulc <miroslav.sulc@startnet.cz>
` Re: How to read query plan
  2005-03-14 15:27 UTC  Miroslav Šulc <miroslav.sulc@startnet.cz>
` Re: [PERFORM] How to read query plan
  2005-03-14 15:54 UTC  John Arbash Meinel <john@arbash-meinel.com>
` Re: How to read query plan
  2005-03-14 15:58 UTC  Greg Stark <gsstark@mit.edu>
` Re: How to read query plan
  2005-03-14 16:23 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: How to read query plan
  2005-03-14 16:33 UTC  Miroslav Šulc <miroslav.sulc@startnet.cz>
` Re: How to read query plan
  2005-03-14 16:36 UTC  John Arbash Meinel <john@arbash-meinel.com>
` Re: How to read query plan
  2005-03-14 17:03 UTC  Kaloyan Iliev Iliev <news1@faith.digsys.bg>
` Re: How to read query plan
  2005-03-14 17:07 UTC  Miroslav Šulc <miroslav.sulc@startnet.cz>
  [37+ messages in thread]

Bad Performance[2]
  2005-03-14 16:47 UTC  Gaetano Mendola <mendola@bigfoot.com>

adding 'limit' leads to very slow query
  2005-03-07 23:39 UTC  Michael McFarland <sidlonDoesntLikeSpam@yahoo.com>
` Re: adding 'limit' leads to very slow query
  2005-03-08 04:46 UTC  John A Meinel <john@arbash-meinel.com>
` Re: adding 'limit' leads to very slow query
  2005-03-08 07:03 UTC  Stephan Szabo <sszabo@megazone.bigpanda.com>
` Re: adding 'limit' leads to very slow query
  2005-03-09 16:00 UTC  Michael McFarland <sidlonDoesntLikeSpam@yahoo.com>
` Re: adding 'limit' leads to very slow query
  2005-03-14 14:50 UTC  Stephan Szabo <sszabo@megazone.bigpanda.com>
  [5+ messages in thread]

Questions about 2 databases.
  2005-03-11 18:54 UTC  jelle <jellej@pacbell.net>
` Re: Questions about 2 databases.
  2005-03-11 20:33 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Questions about 2 databases.
  2005-03-11 20:51 UTC  Richard_D_Levine@raytheon.com
` Re: Questions about 2 databases.
  2005-03-11 21:43 UTC  jelle <jellej@pacbell.net>
` Re: Questions about 2 databases.
  2005-03-12 02:15 UTC  PFC <lists@boutiquenumerique.com>
` Re: Questions about 2 databases.
  2005-03-14 10:43 UTC  Mirko Zeibig <mirko-individual@zeibig.net>
  [6+ messages in thread]

Performance Tuning
  2005-02-09 20:01 UTC  Chris Kratz <chris.kratz@vistashare.com>
` Re: Performance Tuning
  2005-02-09 20:27 UTC  Rod Taylor <rbt@sitesell.com>
` Re: Performance Tuning
  2005-02-09 20:38 UTC  John Arbash Meinel <john@arbash-meinel.com>
` Re: Performance Tuning
  2005-02-09 20:59 UTC  Greg Stark <gsstark@mit.edu>
` Re: Performance Tuning
  2005-02-09 21:25 UTC  Chris Kratz <chris.kratz@vistashare.com>
` Re: Performance Tuning
  2005-02-09 22:08 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: Performance Tuning
  2005-02-09 22:15 UTC  Chris Kratz <chris.kratz@vistashare.com>
` Re: Performance Tuning
  2005-02-09 22:17 UTC  Chris Kratz <chris.kratz@vistashare.com>
` Re: Performance Tuning
  2005-02-09 22:30 UTC  Chris Kratz <chris.kratz@vistashare.com>
` Re: Performance Tuning
  2005-02-09 23:58 UTC  PFC <lists@boutiquenumerique.com>
` Re: Performance Tuning
  2005-02-10 01:27 UTC  Mike Rylander <mrylander@gmail.com>
` Re: Performance Tuning
  2005-02-10 03:09 UTC  Christopher Browne <cbbrowne@acm.org>
` Re: Performance Tuning
  2005-02-10 03:38 UTC  PFC <lists@boutiquenumerique.com>
` Performance tuning
  2005-03-11 15:40 UTC  Jacques Caron <jc@directinfos.com>
` Re: Performance tuning
  2005-03-14 09:41 UTC  Richard Huxton <dev@archonet.com>
  [15+ messages in thread]

Re: Postgres on RAID5 (possible sync blocking read type
  2005-03-14 07:44 UTC  David Greaves <david@dgreaves.com>

Index use and slow queries
  2005-03-13 05:40 UTC  Tom Pfeifer <tpfeifer@tela.com>
` Re: Index use and slow queries
  2005-03-13 06:07 UTC  Russell Smith <mr-russ@pws.com.au>
` Re: Index use and slow queries
  2005-03-13 06:26 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [3+ messages in thread]

What is the number of rows in explain?
  2005-03-11 13:45 UTC  Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
` Re: What is the number of rows in explain?
  2005-03-11 14:43 UTC  John A Meinel <john@arbash-meinel.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