pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Re: win32 performance - fsync question
  2005-02-18 15:11 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>

Re: Degradation of postgres 7.4.5 on FreeBSD/CygWin
  2005-02-18 14:08 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Degradation of postgres 7.4.5 on FreeBSD/CygWin
  2005-02-18 14:32 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Degradation of postgres 7.4.5 on FreeBSD/CygWin
  2005-02-18 14:40 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
` Degradation of postgres 7.4.5 on FreeBSD/CygWin
  2005-02-18 14:54 UTC  Rodrigo Moreno <rodrigo.miguel@terra.com.br>
  [4+ messages in thread]

PG proper configuation for a php forum
  2005-02-17 13:29 UTC  JM <jerome@gmanmi.tv>

How to interpret this explain analyse?
  2005-02-11 09:18 UTC  Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
` Re: How to interpret this explain analyse?
  2005-02-11 10:20 UTC  Richard Huxton <dev@archonet.com>
` Re: How to interpret this explain analyse?
  2005-02-11 16:18 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: How to interpret this explain analyse?
  2005-02-11 19:25 UTC  Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
` Re: How to interpret this explain analyse?
  2005-02-11 19:40 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: How to interpret this explain analyse?
  2005-02-11 23:12 UTC  Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
` Re: How to interpret this explain analyse?
  2005-02-15 00:10 UTC  Kevin Brown <kevin@sysexperts.com>
` Re: How to interpret this explain analyse?
  2005-02-15 07:17 UTC  Greg Stark <gsstark@mit.edu>
` Re: How to interpret this explain analyse?
  2005-02-15 15:11 UTC  Bricklen Anderson <BAnderson@PresiNET.com>
` Re: How to interpret this explain analyse?
  2005-02-16 21:09 UTC  Kevin Brown <kevin@sysexperts.com>
  [10+ messages in thread]

disagreeing query planners
  2005-02-15 19:15 UTC  lcham02 <lukechambers7@gmail.com>

VACCUM FULL ANALYZE PROBLEM
  2005-02-15 01:34 UTC  Michael Ryan S. Puncia <mpuncia@census.gov.ph>
` Re: VACCUM FULL ANALYZE PROBLEM
  2005-02-15 01:52 UTC  Iain <iain@mst.co.jp>
` Re: VACCUM FULL ANALYZE PROBLEM
  2005-02-15 02:10 UTC  Michael Ryan S. Puncia <mpuncia@census.gov.ph>
` Re: VACCUM FULL ANALYZE PROBLEM
  2005-02-15 02:21 UTC  Rod Taylor <pg@rbt.ca>
` Re: VACCUM FULL ANALYZE PROBLEM
  2005-02-15 02:31 UTC  Iain <iain@mst.co.jp>
` Re: VACCUM FULL ANALYZE PROBLEM
  2005-02-15 05:30 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: VACCUM FULL ANALYZE PROBLEM
  2005-02-15 05:58 UTC  Iain <iain@mst.co.jp>
` Re: VACCUM FULL ANALYZE PROBLEM
  2005-02-15 08:51 UTC  PFC <lists@boutiquenumerique.com>
  [8+ messages in thread]

String matching
  2005-02-14 19:57 UTC  Ivan Voras <ivoras@fer.hr>
` Re: String matching
  2005-02-14 20:08 UTC  PFC <lists@boutiquenumerique.com>
` Re: String matching
  2005-02-14 20:31 UTC  Ivan Voras <ivoras@fer.hr>
` Re: String matching
  2005-02-14 20:42 UTC  Stephan Szabo <sszabo@megazone.bigpanda.com>
` Re: String matching
  2005-02-14 20:45 UTC  Ivan Voras <ivoras@fer.hr>
` Re: String matching
  2005-02-14 22:12 UTC  Stephan Szabo <sszabo@megazone.bigpanda.com>
` Re: String matching
  2005-02-14 22:29 UTC  Ivan Voras <ivoras@fer.hr>
` Re: String matching
  2005-02-14 22:31 UTC  Stephan Szabo <sszabo@megazone.bigpanda.com>
  [8+ messages in thread]

estimated rows vs. actual rows
  2005-02-13 21:27 UTC  Jaime Casanova <systemguards@gmail.com>
` Re: estimated rows vs. actual rows
  2005-02-13 21:41 UTC  Josh Berkus <josh@agliodbs.com>
` Re: estimated rows vs. actual rows
  2005-02-14 03:18 UTC  Jaime Casanova <systemguards@gmail.com>
` Re: estimated rows vs. actual rows
  2005-02-14 03:38 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: estimated rows vs. actual rows
  2005-02-14 03:45 UTC  Mark Kirkwood <markir@coretech.co.nz>
` Re: estimated rows vs. actual rows
  2005-02-14 12:41 UTC  Christopher Browne <cbbrowne@acm.org>
  [6+ messages in thread]

Benchmark
  2003-08-15 06:33 UTC  mixo <mixo@coza.net.za>
` Re: Benchmark
  2003-08-15 09:32 UTC  Tomka Gergely <tomka@zeus.gau.hu>
` Re: Benchmark
  2003-08-15 13:12 UTC  Richard Huxton <dev@archonet.com>
` Re: Benchmark
  2003-08-15 16:21 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Benchmark
  2003-08-15 18:24 UTC  Jeff <threshar@torgo.978.org>
` Re: Benchmark
  2003-08-15 18:47 UTC  Balazs Wellisch <balazs@neusolutions.com>
` Re: Benchmark
  2003-08-17 03:48 UTC  David Emery <dave@skiddlydee.com>
` Benchmark
  2005-02-10 05:49 UTC  Jaime Casanova <systemguards@yahoo.com>
` Re: Benchmark
  2005-02-10 13:21 UTC  Jeff <threshar@torgo.978.org>
` Re: Benchmark
  2005-02-11 05:22 UTC  Mitch Pirtle <mitch.pirtle@gmail.com>
` Re: Benchmark
  2005-02-11 06:38 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Benchmark
  2005-02-11 07:04 UTC  Mitch Pirtle <mitch.pirtle@gmail.com>
` Re: Benchmark
  2005-02-11 07:22 UTC  Jaime Casanova <systemguards@gmail.com>
` Re: Benchmark
  2005-02-11 13:08 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: Benchmark
  2005-02-11 13:16 UTC  Richard Huxton <dev@archonet.com>
` Re: Benchmark
  2005-02-11 13:20 UTC  Jeff <threshar@torgo.978.org>
` Re: Benchmark
  2005-02-11 15:04 UTC  Greg Stark <gsstark@mit.edu>
` Re: Benchmark
  2005-02-11 18:09 UTC  Mike Benoit <ipso@snappymail.ca>
` Re: Benchmark
  2005-02-11 18:32 UTC  PFC <lists@boutiquenumerique.com>
` Re: Benchmark
  2005-02-11 18:41 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Benchmark
  2005-02-11 20:41 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: Benchmark
  2005-02-13 01:34 UTC  Christopher Browne <cbbrowne@acm.org>
` Re: Benchmark
  2005-02-13 09:21 UTC  Ron Mayer <rm_pg@cheapcomplexdevices.com>
` Re: Benchmark
  2005-02-13 16:34 UTC  Greg Stark <gsstark@mit.edu>
` Re: Benchmark
  2005-02-13 19:24 UTC  Patrick Meylemans <Patrick.Meylemans@wtcm.be>
` Re: Benchmark
  2005-02-14 10:46 UTC  Harald Fuchs <hf0722x@protecting.net>
  [26+ messages in thread]

Autocommit
  2005-02-14 08:01 UTC  Hasnul Fadhly bin Hasan <hasnulfadhly.h@mimos.my>
` Re: Autocommit
  2005-02-14 08:47 UTC  Michael Fuhr <mike@fuhr.org>
` Re: Autocommit
  2005-02-14 08:58 UTC  Hasnul Fadhly bin Hasan <hasnulfadhly.h@mimos.my>
` Re: Autocommit
  2005-02-14 09:34 UTC  Michael Fuhr <mike@fuhr.org>
  [4+ messages in thread]

Re: Benchmark (slightly off topic but oh well)
  2005-02-11 18:22 UTC  PFC <lists@boutiquenumerique.com>

Large time difference between explain analyze and normal run
  2005-02-10 18:34 UTC  Chris Kratz <chris.kratz@vistashare.com>
` Re: Large time difference between explain analyze and normal run
  2005-02-10 18:58 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Large time difference between explain analyze and normal run
  2005-02-10 19:05 UTC  Chris Kratz <chris.kratz@vistashare.com>
` Re: Large time difference between explain analyze and normal run
  2005-02-10 20:09 UTC  Darcy Buskermolen <darcy@wavefire.com>
` Re: Large time difference between explain analyze and normal run
  2005-02-10 20:25 UTC  Chris Kratz <chris.kratz@vistashare.com>
  [5+ messages in thread]

How can I make use of both CPUs in a dual processor machine
  2005-02-09 14:26 UTC  Alex <alex@meerkatsoft.com>
` Re: How can I make use of both CPUs in a dual processor
  2005-02-09 14:49 UTC  John A Meinel <john@arbash-meinel.com>
` Re: How can I make use of both CPUs in a dual processor
  2005-02-09 15:00 UTC  Alex <alex@meerkatsoft.com>
` Re: How can I make use of both CPUs in a dual processor
  2005-02-09 15:14 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: How can I make use of both CPUs in a dual processor
  2005-02-09 15:16 UTC  John A Meinel <john@arbash-meinel.com>
` Re: How can I make use of both CPUs in a dual processor
  2005-02-10 01:50 UTC  Iain <iain@mst.co.jp>
` Re: How can I make use of both CPUs in a dual processor
  2005-02-10 13:18 UTC  Alex <alex@meerkatsoft.com>
  [7+ messages in thread]

GiST indexes and concurrency (tsearch2)
  2005-02-03 04:55 UTC  Marinos J. Yannikos <mjy@geizhals.at>
` Re: GiST indexes and concurrency (tsearch2)
  2005-02-03 05:26 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: GiST indexes and concurrency (tsearch2)
  2005-02-03 09:28 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: GiST indexes and concurrency (tsearch2)
  2005-02-03 09:57 UTC  Oleg Bartunov <oleg@sai.msu.su>
` Re: GiST indexes and concurrency (tsearch2)
  2005-02-03 11:04 UTC  Marinos J. Yannikos <mjy@geizhals.at>
` Re: GiST indexes and concurrency (tsearch2)
  2005-02-03 12:11 UTC  PFC <lists@boutiquenumerique.com>
` Re: GiST indexes and concurrency (tsearch2)
  2005-02-03 12:16 UTC  Oleg Bartunov <oleg@sai.msu.su>
` Re: GiST indexes and concurrency (tsearch2)
  2005-02-03 13:15 UTC  Marinos J. Yannikos <mjy@geizhals.at>
` Re: GiST indexes and concurrency (tsearch2)
  2005-02-03 16:27 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: GiST indexes and concurrency (tsearch2)
  2005-02-03 19:06 UTC  Marinos J. Yannikos <mjy@geizhals.at>
` Re: GiST indexes and concurrency (tsearch2)
  2005-02-03 19:50 UTC  Oleg Bartunov <oleg@sai.msu.su>
` Re: GiST indexes and concurrency (tsearch2)
  2005-02-05 13:01 UTC  Marinos Yannikos <mjy@geizhals.at>
` Re: GiST indexes and concurrency (tsearch2)
  2005-02-05 19:01 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: GiST indexes and concurrency (tsearch2)
  2005-02-05 19:42 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: GiST indexes and concurrency (tsearch2)
  2005-02-09 19:25 UTC  Marinos J. Yannikos <mjy@geizhals.at>
` Re: GiST indexes and concurrency (tsearch2)
  2005-02-10 00:55 UTC  Marinos J. Yannikos <mjy@geizhals.at>
` Re: GiST indexes and concurrency (tsearch2)
  2005-02-10 01:13 UTC  Neil Conway <neilc@samurai.com>
  [17+ messages in thread]

annotated PostgreSQL.conf now up
  2005-02-09 21:50 UTC  Josh Berkus <josh@agliodbs.com>
` Re: annotated PostgreSQL.conf now up
  2005-02-09 23:18 UTC  Jon Asher <jon@vagabond-software.com>
  [2+ messages in thread]

Solaris 9 tuning
  2005-02-07 22:25 UTC  Paul Johnson <paul@oxton.com>
` Re: Solaris 9 tuning
  2005-02-08 02:22 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Solaris 9 tuning
  2005-02-09 19:02 UTC  Paul Johnson <paul@oxton.com>
` Re: Solaris 9 tuning
  2005-02-09 19:23 UTC  Tom Arthurs <tom@jobflash.com>
` Re: Solaris 9 tuning
  2005-02-09 19:31 UTC  Tom Arthurs <tarthurs@jobflash.com>
` Re: Solaris 9 tuning
  2005-02-09 20:49 UTC  Paul Johnson <paul@oxton.com>
` Re: Solaris 9 tuning
  2005-02-09 22:08 UTC  Tom Arthurs <tarthurs@jobflash.com>
  [7+ messages in thread]

Tell postgres which index to use?
  2005-02-09 15:58 UTC  Silke Trissl <trissl@informatik.hu-berlin.de>
` Re: Tell postgres which index to use?
  2005-02-09 17:41 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Tell postgres which index to use?
  2005-02-09 17:58 UTC  Silke Trissl <trissl@informatik.hu-berlin.de>
` Re: Tell postgres which index to use?
  2005-02-09 18:36 UTC  John Arbash Meinel <john@arbash-meinel.com>
` Re: Tell postgres which index to use?
  2005-02-09 20:50 UTC  Greg Stark <gsstark@mit.edu>
  [5+ messages in thread]

Slow Restoration of a template1 Database (ALTER GROUP)
  2005-02-08 18:23 UTC  Ben Young <Ben.Young@etrials.com>
` Re: Slow Restoration of a template1 Database (ALTER GROUP)
  2005-02-08 18:57 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Slow Restoration of a template1 Database (ALTER GROUP)
  2005-02-08 19:59 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Slow Restoration of a template1 Database (ALTER GROUP)
  2005-02-08 20:08 UTC  Ben Young <Ben.Young@etrials.com>
` Re: Slow Restoration of a template1 Database (ALTER GROUP)
  2005-02-08 20:32 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [5+ messages in thread]

Retry: Is this possible / slow performance?
  2005-02-07 16:37 UTC  Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
` Re: Retry: Is this possible / slow performance?
  2005-02-07 17:03 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Retry: Is this possible / slow performance?
  2005-02-07 18:16 UTC  PFC <lists@boutiquenumerique.com>
` Re: Retry: Is this possible / slow performance?
  2005-02-07 19:27 UTC  Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
` Re: Retry: Is this possible / slow performance?
  2005-02-07 19:52 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
  [5+ messages in thread]

Are JOINs allowed with DELETE FROM
  2005-02-06 17:16 UTC  Steven Rosenstein <srosenst@us.ibm.com>
` Re: Are JOINs allowed with DELETE FROM
  2005-02-06 17:36 UTC  Gaetano Mendola <mendola@bigfoot.com>
` Re: Are JOINs allowed with DELETE FROM
  2005-02-06 17:50 UTC  Michael Fuhr <mike@fuhr.org>
` Re: Are JOINs allowed with DELETE FROM
  2005-02-06 17:58 UTC  John Arbash Meinel <john@arbash-meinel.com>
` Re: Are JOINs allowed with DELETE FROM
  2005-02-06 19:33 UTC  Steven Rosenstein <srosenst@us.ibm.com>
` Re: Are JOINs allowed with DELETE FROM
  2005-02-06 19:49 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Are JOINs allowed with DELETE FROM
  2005-02-06 21:57 UTC  Steven Rosenstein <srosenst@us.ibm.com>
` Re: Are JOINs allowed with DELETE FROM
  2005-02-07 17:22 UTC  Gaetano Mendola <mendola@bigfoot.com>
  [8+ messages in thread]

Can the V7.3 EXPLAIN ANALYZE be trusted?
  2005-02-06 19:50 UTC  Steven Rosenstein <srosenst@us.ibm.com>
` Re: Can the V7.3 EXPLAIN ANALYZE be trusted?
  2005-02-06 22:09 UTC  Leeuw van der, Tim <tim.leeuwvander@nl.unisys.com>
` Re: Can the V7.3 EXPLAIN ANALYZE be trusted?
  2005-02-06 22:34 UTC  Greg Stark <gsstark@mit.edu>
` Re: Can the V7.3 EXPLAIN ANALYZE be trusted?
  2005-02-06 22:46 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Can the V7.3 EXPLAIN ANALYZE be trusted?
  2005-02-07 02:43 UTC  Steven Rosenstein <srosenst@us.ibm.com>
` Re: Can the V7.3 EXPLAIN ANALYZE be trusted?
  2005-02-07 14:39 UTC  Markus Schaber <schabios@logi-track.com>
  [6+ messages in thread]

Bad query optimizer misestimation because of TOAST tables
  2005-02-02 17:21 UTC  Markus Schaber <schabios@logi-track.com>
` Re: Bad query optimizer misestimation because of TOAST tables
  2005-02-02 17:44 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Bad query optimizer misestimation because of TOAST
  2005-02-02 18:25 UTC  Markus Schaber <schabios@logi-track.com>
` Re: Bad query optimizer misestimation because of TOAST
  2005-02-02 23:49 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Bad query optimizer misestimation because of TOAST
  2005-02-03 10:30 UTC  Markus Schaber <schabios@logi-track.com>
` Re: [postgis-users] Bad query optimizer misestimation because of
  2005-02-03 13:59 UTC  Markus Schaber <schabios@logi-track.com>
` Re: Bad query optimizer misestimation because of TOAST
  2005-02-07 14:07 UTC  Markus Schaber <schabios@logi-track.com>
  [7+ messages in thread]

Index not used with or condition
  2005-02-07 09:07 UTC  Antony Paul <antonypaul24@gmail.com>
` Re: Index not used with or condition
  2005-02-07 11:14 UTC  Antony Paul <antonypaul24@gmail.com>
` Re: Index not used with or condition
  2005-02-07 11:46 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Index not used with or condition
  2005-02-07 11:53 UTC  Jan Poslusny <pajout@gingerall.cz>
` Re: Index not used with or condition
  2005-02-07 11:57 UTC  Antony Paul <antonypaul24@gmail.com>
` Re: Index not used with or condition
  2005-02-07 11:58 UTC  Antony Paul <antonypaul24@gmail.com>
  [6+ messages in thread]

Is this possible / slow performance?
  2005-02-07 11:36 UTC  Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>

horizontal partition
  2005-02-02 00:16 UTC  Gaetano Mendola <mendola@bigfoot.com>
` Re: horizontal partition
  2005-02-02 20:09 UTC  Josh Berkus <josh@agliodbs.com>
` Re: horizontal partition
  2005-02-03 01:10 UTC  Gaetano Mendola <mendola@bigfoot.com>
` Re: horizontal partition
  2005-02-03 03:16 UTC  Josh Berkus <josh@agliodbs.com>
` Re: horizontal partition
  2005-02-03 03:31 UTC  Klint Gore <kg@kgb.une.edu.au>
` Re: horizontal partition
  2005-02-03 06:41 UTC  Josh Berkus <josh@agliodbs.com>
` Re: horizontal partition
  2005-02-03 06:55 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: horizontal partition
  2005-02-03 10:40 UTC  Gaetano Mendola <mendola@bigfoot.com>
` Re: horizontal partition
  2005-02-06 15:50 UTC  Gaetano Mendola <mendola@bigfoot.com>
  [9+ 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