pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
join and query planner
  2005-07-06 21:54 UTC  Dario Pudlo <dariop@unitech.com.ar>
` join and query planner
  2005-07-06 22:04 UTC  Dario <dario_d_s@unitech.com.ar>
` Re: join and query planner
  2005-07-06 22:34 UTC  Stephan Szabo <sszabo@megazone.bigpanda.com>
` Re: join and query planner
  2005-07-11 23:39 UTC  John A Meinel <john@arbash-meinel.com>
` Re: join and query planner
  2005-07-12 14:35 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: join and query planner
  2005-07-18 17:57 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: join and query planner
  2005-07-18 19:24 UTC  Dario <dario_d_s@unitech.com.ar>
` Re: join and query planner
  2005-07-18 20:47 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: join and query planner
  2005-07-19 21:41 UTC  Dario <dario_d_s@unitech.com.ar>
  [9+ messages in thread]

context-switching issue on Xeon
  2005-07-19 18:23 UTC  Sailer, Denis (YBUSA-CDR) <Denis.Sailer@Yellowbook.com>
` Re: context-switching issue on Xeon
  2005-07-19 18:38 UTC  David Hodgkinson <daveh@hodgkinson.org>
` Re: context-switching issue on Xeon
  2005-07-19 18:40 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [3+ messages in thread]

slow joining very large table to smaller ones
  2005-07-14 08:05 UTC  Dan Harris <fbsd@drivefaster.net>
` Re: slow joining very large table to smaller ones
  2005-07-14 15:42 UTC  John A Meinel <john@arbash-meinel.com>
` Re: slow joining very large table to smaller ones
  2005-07-14 22:29 UTC  Dan Harris <fbsd@drivefaster.net>
` Re: slow joining very large table to smaller ones
  2005-07-14 22:46 UTC  John A Meinel <john@arbash-meinel.com>
` Re: slow joining very large table to smaller ones
  2005-07-14 22:47 UTC  Michael Stone <mstone+postgres@mathom.us>
` Re: slow joining very large table to smaller ones
  2005-07-14 23:08 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: slow joining very large table to smaller ones
  2005-07-14 23:12 UTC  John A Meinel <john@arbash-meinel.com>
` Re: slow joining very large table to smaller ones
  2005-07-14 23:30 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: slow joining very large table to smaller ones
  2005-07-14 23:39 UTC  John A Meinel <john@arbash-meinel.com>
` Re: slow joining very large table to smaller ones
  2005-07-15 00:12 UTC  Dan Harris <fbsd@drivefaster.net>
` Re: slow joining very large table to smaller ones
  2005-07-15 03:49 UTC  Dan Harris <fbsd@drivefaster.net>
` Re: slow joining very large table to smaller ones
  2005-07-15 04:12 UTC  John A Meinel <john@arbash-meinel.com>
` Re: slow joining very large table to smaller ones
  2005-07-15 15:09 UTC  Dan Harris <fbsd@drivefaster.net>
` Re: slow joining very large table to smaller ones
  2005-07-15 15:21 UTC  Dan Harris <fbsd@drivefaster.net>
` Re: slow joining very large table to smaller ones
  2005-07-15 16:44 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: slow joining very large table to smaller ones
  2005-07-15 17:39 UTC  PFC <lists@boutiquenumerique.com>
` Re: slow joining very large table to smaller ones
  2005-07-16 00:06 UTC  John A Meinel <john@arbash-meinel.com>
` Re: slow joining very large table to smaller ones
  2005-07-18 07:51 UTC  Dawid Kuroczko <qnex42@gmail.com>
  [18+ messages in thread]

Questions about temporary tables and performance
  2005-07-16 21:42 UTC  Steven Rosenstein <srosenst@us.ibm.com>
` Re: Questions about temporary tables and performance
  2005-07-17 04:44 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [2+ messages in thread]

Really bad diskio
  2005-07-15 20:39 UTC  Ron Wills <ron@rwsoft.ca>
` Re: Really bad diskio
  2005-07-15 20:45 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: Really bad diskio
  2005-07-15 21:00 UTC  Jeffrey W. Baker <jwbaker@acm.org>
` Re: Really bad diskio
  2005-07-15 21:04 UTC  Ron Wills <ron@rwsoft.ca>
` Re: Really bad diskio
  2005-07-15 21:07 UTC  Dan Harris <fbsd@drivefaster.net>
` Re: Really bad diskio
  2005-07-15 21:10 UTC  Alvaro Herrera <alvherre@alvh.no-ip.org>
` Re: Really bad diskio
  2005-07-15 21:17 UTC  Jeffrey W. Baker <jwbaker@acm.org>
` Re: Really bad diskio
  2005-07-15 21:29 UTC  Ron Wills <ron@rwsoft.ca>
` Re: Really bad diskio
  2005-07-15 21:48 UTC  Ron Wills <ron@rwsoft.ca>
` Re: Really bad diskio
  2005-07-15 21:53 UTC  Jeffrey W. Baker <jwbaker@acm.org>
` Re: Really bad diskio
  2005-07-15 22:11 UTC  Ron Wills <ron@rwsoft.ca>
` Re: Really bad diskio
  2005-07-16 21:14 UTC  Ron Wills <ron@rwsoft.ca>
  [12+ messages in thread]

more filesystem benchmarks
  2005-07-16 08:12 UTC  Jeffrey W. Baker <jwbaker@acm.org>
` Re: more filesystem benchmarks
  2005-07-16 11:01 UTC  Michael Stone <mstone+postgres@mathom.us>
  [2+ messages in thread]

performance problems ... 100 cpu utilization
  2005-07-13 19:13 UTC  Dennis <dennis@works4me.com>
` Re: performance problems ... 100 cpu utilization
  2005-07-14 03:11 UTC  Qingqing Zhou <zhouqq@cs.toronto.edu>
` Re: performance problems ... 100 cpu utilization
  2005-07-14 03:28 UTC  Dennis <dennis@works4me.com>
` Re: performance problems ... 100 cpu utilization
  2005-07-14 05:07 UTC  David Mitchell <david.mitchell@telogis.com>
` Re: performance problems ... 100 cpu utilization
  2005-07-14 06:54 UTC  Dennis <dennis@works4me.com>
` Re: performance problems ... 100 cpu utilization
  2005-07-15 00:43 UTC  David Mitchell <david.mitchell@telogis.com>
` Re: performance problems ... 100 cpu utilization
  2005-07-15 16:03 UTC  Dennis <dennis@works4me.com>
  [7+ messages in thread]

What's a lot of connections?
  2005-07-15 07:00 UTC  Karim Nassar <karim.nassar@acm.org>
` Re: What's a lot of connections?
  2005-07-15 07:14 UTC  Jeffrey W. Baker <jwbaker@acm.org>
` Re: What's a lot of connections?
  2005-07-15 14:16 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [3+ messages in thread]

PostgresSQL vs. Firebird
  2005-07-14 07:19 UTC  Relaxin <me@yourhouse.com>
` Re: PostgresSQL vs. Firebird
  2005-07-15 09:17 UTC  Chris Mair <list@1006.org>
  [2+ messages in thread]

Profiler for PostgreSQL
  2005-07-14 05:58 UTC  Agha Asif Raza <aghaasif@gmail.com>
` Re: Profiler for PostgreSQL
  2005-07-14 06:27 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
` Re: Profiler for PostgreSQL
  2005-07-14 06:29 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: Profiler for PostgreSQL
  2005-07-14 20:47 UTC  Simon Riggs <simon@2ndquadrant.com>
` Re: Profiler for PostgreSQL
  2005-07-15 08:19 UTC  Andreas Pflug <pgadmin@pse-consulting.de>
  [5+ messages in thread]

Quad Opteron stuck in the mud
  2005-07-13 18:54 UTC  Dan Harris <fbsd@drivefaster.net>
` Re: Quad Opteron stuck in the mud
  2005-07-13 19:09 UTC  Dan Harris <fbsd@drivefaster.net>
` Re: Quad Opteron stuck in the mud
  2005-07-13 19:11 UTC  John A Meinel <john@arbash-meinel.com>
` Re: Quad Opteron stuck in the mud
  2005-07-13 19:16 UTC  Dan Harris <fbsd@drivefaster.net>
` Re: Quad Opteron stuck in the mud
  2005-07-13 20:17 UTC  Stephen Frost <sfrost@snowman.net>
` Re: Quad Opteron stuck in the mud
  2005-07-13 20:18 UTC  Alvaro Herrera <alvherre@alvh.no-ip.org>
` Re: Quad Opteron stuck in the mud
  2005-07-13 20:20 UTC  Dan Harris <fbsd@drivefaster.net>
` Re: Quad Opteron stuck in the mud
  2005-07-13 20:49 UTC  Vivek Khera <vivek@khera.org>
` Re: Quad Opteron stuck in the mud
  2005-07-13 22:51 UTC  Simon Riggs <simon@2ndquadrant.com>
` Re: Quad Opteron stuck in the mud
  2005-07-14 06:12 UTC  Greg Stark <gsstark@mit.edu>
` Re: Quad Opteron stuck in the mud
  2005-07-14 06:28 UTC  Dan Harris <fbsd@drivefaster.net>
` Re: Quad Opteron stuck in the mud
  2005-07-14 15:47 UTC  Alvaro Herrera <alvherre@alvh.no-ip.org>
` Re: Quad Opteron stuck in the mud
  2005-07-14 16:05 UTC  Dan Harris <fbsd@drivefaster.net>
` Re: Quad Opteron stuck in the mud
  2005-07-14 20:47 UTC  Greg Stark <gsstark@mit.edu>
  [14+ messages in thread]

JFS fastest filesystem for PostgreSQL?
  2005-07-14 00:20 UTC  Jeffrey W. Baker <jwbaker@acm.org>
` JFS fastest filesystem for PostgreSQL?
  2005-07-14 06:33 UTC  Jeffrey W. Baker <jwbaker@acm.org>
` Re: JFS fastest filesystem for PostgreSQL?
  2005-07-14 07:08 UTC  Dmitri Bichko <dbichko@aveopharma.com>
` Re: JFS fastest filesystem for PostgreSQL?
  2005-07-14 08:03 UTC  Dawid Kuroczko <qnex42@gmail.com>
` Re: JFS fastest filesystem for PostgreSQL?
  2005-07-14 09:56 UTC  mudfoot@rawbw.com
` Re: JFS fastest filesystem for PostgreSQL?
  2005-07-14 10:30 UTC  Michael Stone <mstone+postgres@mathom.us>
` Re: JFS fastest filesystem for PostgreSQL?
  2005-07-14 12:15 UTC  Grega Bremec <gregab@p0f.net>
` Re: JFS fastest filesystem for PostgreSQL?
  2005-07-14 13:20 UTC  Michael Stone <mstone+postgres@mathom.us>
` Re: JFS fastest filesystem for PostgreSQL?
  2005-07-14 13:27 UTC  Jeffrey W. Baker <jwbaker@acm.org>
` Re: JFS fastest filesystem for PostgreSQL?
  2005-07-14 18:29 UTC  Jim C. Nasby <decibel@decibel.org>
` Re: JFS fastest filesystem for PostgreSQL?
  2005-07-14 18:37 UTC  Joshua D. Drake <jd@commandprompt.com>
  [11+ messages in thread]

large table vs multiple smal tables
  2005-07-13 10:08 UTC  Nicolas Beaume <nicolas.beaume@univ-nantes.fr>
` Re: large table vs multiple smal tables
  2005-07-13 12:33 UTC  Kenneth Marshall <ktm@it.is.rice.edu>
` Re: large table vs multiple smal tables
  2005-07-14 18:26 UTC  Jim C. Nasby <decibel@decibel.org>
  [3+ messages in thread]

Indexing Function called on VACUUM and sorting ?
  2005-07-13 23:46 UTC  jobapply <jobapply@nextmail.ru>
` Indexing Function called on VACUUM and sorting ?
  2005-07-14 06:33 UTC  jobapply <jobapply@nextmail.ru>
  [2+ messages in thread]

Functional index is 5 times slower than the basic one
  2005-07-13 22:35 UTC  jobapply <jobapply@nextmail.ru>

cost-based vacuum
  2005-07-08 16:25 UTC  Ian Westmacott <ianw@intellivid.com>
` Re: cost-based vacuum
  2005-07-08 17:48 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: cost-based vacuum
  2005-07-11 11:31 UTC  Simon Riggs <simon@2ndquadrant.com>
` Re: cost-based vacuum
  2005-07-11 13:07 UTC  Ian Westmacott <ianw@intellivid.com>
` Re: cost-based vacuum
  2005-07-11 13:28 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: cost-based vacuum
  2005-07-11 14:51 UTC  Simon Riggs <simon@2ndquadrant.com>
` Re: cost-based vacuum
  2005-07-12 07:45 UTC  Simon Riggs <simon@2ndquadrant.com>
` Re: cost-based vacuum
  2005-07-12 17:50 UTC  Ian Westmacott <ianw@intellivid.com>
` Re: cost-based vacuum
  2005-07-13 15:55 UTC  Simon Riggs <simon@2ndquadrant.com>
` Re: cost-based vacuum
  2005-07-13 18:40 UTC  Ian Westmacott <ianw@intellivid.com>
` Re: cost-based vacuum
  2005-07-13 18:58 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: cost-based vacuum
  2005-07-13 20:39 UTC  Simon Riggs <simon@2ndquadrant.com>
` Re: cost-based vacuum
  2005-07-13 21:46 UTC  Ian Westmacott <ianw@intellivid.com>
  [13+ messages in thread]

General DB Tuning
  2005-07-12 06:22 UTC  Brent Henry <bh_pgperf@yahoo.com>
` Re: General DB Tuning
  2005-07-12 21:54 UTC  Tom Arthurs <tarthurs@jobflash.com>
` Re: General DB Tuning
  2005-07-12 23:32 UTC  Brent Henry <bh_pgperf@yahoo.com>
` Re: General DB Tuning
  2005-07-13 00:36 UTC  Tom Arthurs <tarthurs@jobflash.com>
` Re: General DB Tuning
  2005-07-13 01:05 UTC  Dennis <dennis@works4me.com>
` Re: General DB Tuning
  2005-07-13 01:17 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: General DB Tuning
  2005-07-13 01:30 UTC  Tom Arthurs <tarthurs@jobflash.com>
` Re: General DB Tuning
  2005-07-13 01:36 UTC  Brent Henry <bh_pgperf@yahoo.com>
` Re: General DB Tuning
  2005-07-13 01:52 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: General DB Tuning
  2005-07-13 01:53 UTC  Tom Arthurs <tarthurs@jobflash.com>
` Re: General DB Tuning
  2005-07-13 10:07 UTC  Mark Rae <mrae@purplebat.com>
` Re: General DB Tuning
  2005-07-13 16:10 UTC  Simon Riggs <simon@2ndquadrant.com>
  [12+ messages in thread]

size of cache
  2005-07-13 08:20 UTC  Jean-Max Reymond <jmreymond@gmail.com>
` Re: size of cache
  2005-07-13 16:07 UTC  Simon Riggs <simon@2ndquadrant.com>
  [2+ messages in thread]

(pas de sujet)
  2005-07-13 13:55 UTC  Nicolas Beaume <nicolas.beaume@univ-nantes.fr>

Projecting currentdb to more users
  2005-07-12 16:21 UTC  Yves Vindevogel <yves.vindevogel@implements.be>
` Re: Projecting currentdb to more users
  2005-07-12 18:00 UTC  Matthew Nuzum <mattnuzum@gmail.com>
` Re: [PERFORM] Projecting currentdb to more users
  2005-07-12 18:24 UTC  Mohan, Ross <RMohan@arbinet.com>
` Re: [PERFORM] Projecting currentdb to more users
  2005-07-12 18:41 UTC  Scott Marlowe <smarlowe@g2switchworks.com>
` Re: [PERFORM] Projecting currentdb to more users
  2005-07-12 20:06 UTC  Mark Rae <mrae@purplebat.com>
` Re: [PERFORM] Projecting currentdb to more users
  2005-07-12 20:11 UTC  Scott Marlowe <smarlowe@g2switchworks.com>
` Re: [PERFORM] Projecting currentdb to more users
  2005-07-12 20:32 UTC  Mark Rae <mrae@purplebat.com>
` Re: Projecting currentdb to more users
  2005-07-13 05:18 UTC  Jean-Max Reymond <jmreymond@gmail.com>
  [8+ messages in thread]

Sorting on longer key is faster ?
  2005-07-09 18:38 UTC  jobapply <jobapply@nextmail.ru>
` Re: Sorting on longer key is faster ?
  2005-07-11 23:42 UTC  John A Meinel <john@arbash-meinel.com>
` Re: Sorting on longer key is faster ?
  2005-07-11 23:47 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Sorting on longer key is faster ?
  2005-07-12 01:48 UTC  John A Meinel <john@arbash-meinel.com>
` Re: Sorting on longer key is faster ?
  2005-07-12 01:52 UTC  John A Meinel <john@arbash-meinel.com>
  [5+ messages in thread]

Question
  2005-07-11 12:59 UTC  Alejandro Lemus <alejandro_lemus2003@yahoo.com>
` Re: Question
  2005-07-11 13:29 UTC  Richard Huxton <dev@archonet.com>
` Re: Question
  2005-07-11 13:34 UTC  Magnus Hagander <mha@sollentuna.net>
` Re: Question
  2005-07-11 23:26 UTC  Gregory S. Williamson <gsw@globexplorer.com>
  [4+ messages in thread]

Data Warehousing Tuning
  2005-07-06 17:15 UTC  Paul Johnson <paul@oxton.com>
` Re: Data Warehousing Tuning
  2005-07-07 00:02 UTC  Frank Wosczyna <frankw@greenplum.com>
` Re: Data Warehousing Tuning
  2005-07-07 00:40 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Data Warehousing Tuning
  2005-07-10 22:07 UTC  Alexander Kirpa <postgres@bilteks.com>
  [4+ messages in thread]

Mount database on RAM disk?
  2005-07-08 01:32 UTC  Stuart Bishop <stuart@stuartbishop.net>
` Re: Mount database on RAM disk?
  2005-07-08 03:05 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: Mount database on RAM disk?
  2005-07-08 03:30 UTC  Chris Browne <cbbrowne@acm.org>
` Re: Mount database on RAM disk?
  2005-07-08 14:03 UTC  Rod Taylor <pg@rbt.ca>
` Re: Mount database on RAM disk?
  2005-07-08 17:22 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Mount database on RAM disk?
  2005-07-08 19:21 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: Mount database on RAM disk?
  2005-07-09 21:48 UTC  Alex Stapleton <alexs@advfn.com>
` Re: Mount database on RAM disk?
  2005-07-10 04:54 UTC  Christopher Browne <cbbrowne@acm.org>
  [8+ messages in thread]

How to revoke a password
  2005-07-08 23:56 UTC  Bailey, Larry <lbailey@firstam.com>
` Re: How to revoke a password
  2005-07-09 00:09 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: How to revoke a password
  2005-07-09 00:16 UTC  Bailey, Larry <lbailey@firstam.com>
` Re: How to revoke a password
  2005-07-09 00:17 UTC  Alvaro Herrera <alvherre@alvh.no-ip.org>
` Re: How to revoke a password
  2005-07-09 00:56 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: How to revoke a password
  2005-07-09 00:58 UTC  Michael Fuhr <mike@fuhr.org>
  [6+ 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