pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Performance problem from migrating between versions!
  2005-01-17 15:37 UTC  Kaloyan Iliev Iliev <news1@faith.digsys.bg>
` Re: Performance problem from migrating between versions!
  2005-01-17 16:13 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Performance problem from migrating between versions!
  2005-01-17 18:02 UTC  Kaloyan Iliev Iliev <news1@faith.digsys.bg>
` Re: Performance problem from migrating between versions!
  2005-01-17 18:07 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Performance problem from migrating between versions!
  2005-01-17 18:15 UTC  Kaloyan Iliev Iliev <news1@faith.digsys.bg>
` Re: Performance problem from migrating between versions!
  2005-01-17 18:57 UTC  Kaloyan Iliev Iliev <news1@faith.digsys.bg>
` Re: Performance problem from migrating between versions!
  2005-01-17 19:23 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Performance problem from migrating between versions!
  2005-01-18 13:43 UTC  Kaloyan Iliev Iliev <news1@faith.digsys.bg>
  [8+ messages in thread]

Optimizing this count query
  2005-01-17 16:58 UTC  Andrei Bintintan <klodoma@ar-sd.net>
` Re: Optimizing this count query
  2005-01-17 17:55 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Optimizing this count query
  2005-01-18 07:48 UTC  Andrei Bintintan <klodoma@ar-sd.net>
  [3+ messages in thread]

Index on a function and SELECT DISTINCT
  2005-01-14 18:32 UTC  Adrian Holovaty <postgresql@holovaty.com>
` Re: Index on a function and SELECT DISTINCT
  2005-01-17 16:09 UTC  Frank Wiles <frank@wiles.org>
` Re: Index on a function and SELECT DISTINCT
  2005-01-17 17:59 UTC  Adrian Holovaty <postgresql@holovaty.com>
` Re: Index on a function and SELECT DISTINCT
  2005-01-17 18:17 UTC  PFC <lists@boutiquenumerique.com>
  [4+ messages in thread]

IN() Optimization issue in 8.0rc5
  2005-01-15 20:23 UTC  Josh Berkus <josh@agliodbs.com>
` Re: IN() Optimization issue in 8.0rc5
  2005-01-15 20:53 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: IN() Optimization issue in 8.0rc5
  2005-01-15 21:32 UTC  Josh Berkus <josh@agliodbs.com>
  [3+ messages in thread]

sum of all values
  2005-01-14 03:31 UTC  Madison Kelly <linux@alteeve.com>
` Re: sum of all values
  2005-01-14 09:39 UTC  Richard Huxton <dev@archonet.com>
` Re: sum of all values
  2005-01-14 15:37 UTC  Madison Kelly <linux@alteeve.com>
` Re: sum of all values
  2005-01-14 18:34 UTC  Richard Huxton <dev@archonet.com>
  [4+ messages in thread]

Best filesystem for PostgreSQL Database Cluster under Linux
  2005-01-11 09:23 UTC  Pete de Zwart <dezwart@froob.net>
` Re: Best filesystem for PostgreSQL Database Cluster under Linux
  2005-01-11 13:15 UTC  Christopher Browne <cbbrowne@acm.org>
` Re: Best filesystem for PostgreSQL Database Cluster under Linux
  2005-01-11 20:25 UTC  Pete de Zwart <dezwart@froob.net>
` Re: Best filesystem for PostgreSQL Database Cluster under Linux
  2005-01-14 15:51 UTC  Alex Turner <armtuk@gmail.com>
  [4+ messages in thread]

Postgres Optimizer is not smart enough?
  2005-01-12 22:25 UTC  Litao Wu <litaowu@yahoo.com>
` Re: Postgres Optimizer is not smart enough?
  2005-01-12 22:55 UTC  Mike Mascari <mascarm@mascari.com>
` Re: Postgres Optimizer is not smart enough?
  2005-01-12 23:14 UTC  Mark Kirkwood <markir@coretech.co.nz>
` Re: Postgres Optimizer is not smart enough?
  2005-01-13 00:50 UTC  Ragnar Hafstað <gnari@simnet.is>
` Re: Postgres Optimizer is not smart enough?
  2005-01-13 02:11 UTC  Mark Kirkwood <markir@coretech.co.nz>
` Re: Postgres Optimizer is not smart enough?
  2005-01-13 02:39 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Postgres Optimizer is not smart enough?
  2005-01-13 09:02 UTC  Mark Kirkwood <markir@coretech.co.nz>
` Re: Postgres Optimizer is not smart enough?
  2005-01-13 15:24 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [8+ messages in thread]

Performance delay
  2005-01-13 08:34 UTC  Hasnul Fadhly bin Hasan <hasnulfadhly.h@mimos.my>
` Re: Performance delay
  2005-01-13 11:02 UTC  Richard Huxton <dev@archonet.com>
` Re: Performance delay
  2005-01-13 11:14 UTC  Hasnul Fadhly bin Hasan <hasnulfadhly.h@mimos.my>
` Re: Performance delay
  2005-01-13 13:45 UTC  Jim C. Nasby <decibel@decibel.org>
  [4+ messages in thread]

MOVE command
  2005-01-13 12:16 UTC  PFC <lists@boutiquenumerique.com>

Assimilation of these "versus" and hardware threads
  2005-01-11 18:05 UTC  Christian Fowler <spider@viovio.com>
` Re: [PERFORM] Assimilation of these "versus" and hardware threads
  2005-01-11 19:36 UTC  Josh Berkus <josh@agliodbs.com>
` Re: [ADMIN] Assimilation of these "versus" and hardware threads
  2005-01-11 20:52 UTC  Josh Berkus <josh@agliodbs.com>
` Re: [ADMIN] Assimilation of these "versus" and hardware
  2005-01-11 21:44 UTC  Matthew T. O'Connor <matthew@tocr.com>
  [4+ messages in thread]

Help with EXPLAIN ANALYZE runtimes
  2005-01-09 04:44 UTC  Guenzl, Martin <martin@guenzl.com>
` Re: Help with EXPLAIN ANALYZE runtimes
  2005-01-09 05:23 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Help with EXPLAIN ANALYZE runtimes
  2005-01-09 05:45 UTC  Guenzl, Martin <martin@guenzl.com>
` Re: Help with EXPLAIN ANALYZE runtimes
  2005-01-09 07:06 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: Help with EXPLAIN ANALYZE runtimes
  2005-01-09 08:30 UTC  Guenzl, Martin <martin@guenzl.com>
  [5+ messages in thread]

Null integer columns
  2005-01-05 19:09 UTC  Jeffrey Tenny <jeffrey.tenny@comcast.net>
` Null integer columns
  2005-01-08 21:07 UTC  Jeffrey Tenny <jeffrey.tenny@comcast.net>
` Re: Null integer columns
  2005-01-08 21:55 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [3+ messages in thread]

TEXT field and Postgresql Perfomance
  2005-01-08 03:36 UTC  Loren M. Lang <lorenl@alzatex.com>
` Re: TEXT field and Postgresql Perfomance
  2005-01-08 04:03 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: TEXT field and Postgresql Perfomance
  2005-01-08 05:02 UTC  Alex Turner <armtuk@gmail.com>
` Re: TEXT field and Postgresql Perfomance
  2005-01-08 05:23 UTC  Michael Fuhr <mike@fuhr.org>
` Re: TEXT field and Postgresql Perfomance
  2005-01-08 05:49 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [5+ messages in thread]

Re: Does "HYPERTHREADING" do any harm if we use with RH9.0
  2005-01-07 18:48 UTC  Steve Poe <spoe@sfnet.cc>
` Does "HYPERTHREADING" do any harm if we use with RH9.0 and postgresql?
  2005-01-08 00:29 UTC  amrit@health2.moph.go.th
` Re: Does "HYPERTHREADING" do any harm if we use with RH9.0 and postgresql?
  2005-01-08 01:20 UTC  Josh Berkus <josh@agliodbs.com>
  [3+ messages in thread]

Query across a date range
  2005-01-07 19:17 UTC  David Jaquay <djaquay@gmail.com>
` Re: Query across a date range
  2005-01-07 19:35 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Query across a date range
  2005-01-07 19:35 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Query across a date range
  2005-01-07 20:04 UTC  David Jaquay <djaquay@gmail.com>
` Re: Query across a date range
  2005-01-07 20:15 UTC  Josh Berkus <josh@agliodbs.com>
  [5+ messages in thread]

Low Performance for big hospital server ..
  2005-01-02 02:54 UTC  amrit@health2.moph.go.th
` Re: Low Performance for big hospital server ..
  2005-01-02 09:23 UTC  Mark Kirkwood <markir@coretech.co.nz>
` Re: Low Performance for big hospital server ..
  2005-01-02 14:08 UTC  Michael Adler <adler@pobox.com>
` Re: Low Performance for big hospital server ..
  2005-01-02 16:28 UTC  amrit@health2.moph.go.th
` Re: Low Performance for big hospital server ..
  2005-01-02 16:56 UTC  Dave Cramer <pg@fastcrypt.com>
` Re: Low Performance for big hospital server ..
  2005-01-03 01:54 UTC  amrit@health2.moph.go.th
` Re: Low Performance for big hospital server ..
  2005-01-03 02:26 UTC  Mark Kirkwood <markir@coretech.co.nz>
` Re: Low Performance for big hospital server ..
  2005-01-03 04:54 UTC  amrit@health2.moph.go.th
` Re: Low Performance for big hospital server ..
  2005-01-03 06:19 UTC  Mark Kirkwood <markir@coretech.co.nz>
` Re: Low Performance for big hospital server ..
  2005-01-03 08:18 UTC  amrit@health2.moph.go.th
` Re: Low Performance for big hospital server ..
  2005-01-03 08:32 UTC  William Yu <wyu@talisys.com>
` Re: Low Performance for big hospital server ..
  2005-01-03 08:51 UTC  Mike Mascari <mascarm@mascari.com>
` Re: Low Performance for big hospital server ..
  2005-01-03 09:32 UTC  Gregory S. Williamson <gsw@globexplorer.com>
` Re: Low Performance for big hospital server ..
  2005-01-03 10:08 UTC  Pierre-Frédéric Caillaud <lists@boutiquenumerique.com>
` Re: Low Performance for big hospital server ..
  2005-01-03 14:01 UTC  Dave Cramer <pg@fastcrypt.com>
` Re: Low Performance for big hospital server ..
  2005-01-03 14:10 UTC  Dave Cramer <pg@fastcrypt.com>
` Re: Low Performance for big hospital server ..
  2005-01-03 14:55 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: Low Performance for big hospital server ..
  2005-01-03 15:40 UTC  amrit@health2.moph.go.th
` Re: Low Performance for big hospital server ..
  2005-01-03 18:51 UTC  Robert Treat <xzilla@users.sourceforge.net>
` Re: Low Performance for big hospital server ..
  2005-01-03 19:57 UTC  William Yu <wyu@talisys.com>
` Re: Low Performance for big hospital server ..
  2005-01-04 00:57 UTC  Dave Cramer <pg@fastcrypt.com>
` Re: Low Performance for big hospital server ..
  2005-01-04 00:58 UTC  Dave Cramer <pg@fastcrypt.com>
` Re: Low Performance for big hospital server ..
  2005-01-04 09:31 UTC  amrit@health2.moph.go.th
` Re: Low Performance for big hospital server ..
  2005-01-04 11:13 UTC  Gavin Sherry <swm@alcove.com.au>
` Re: Low Performance for big hospital server ..
  2005-01-05 05:07 UTC  amrit@health2.moph.go.th
` Re: Low Performance for big hospital server ..
  2005-01-05 15:35 UTC  amrit@health2.moph.go.th
` Re: Low Performance for big hospital server ..
  2005-01-05 18:21 UTC  Dave Cramer <pg@fastcrypt.com>
` Re: Low Performance for big hospital server ..
  2005-01-06 03:31 UTC  William Yu <wyu@talisys.com>
` Re: Low Performance for big hospital server ..
  2005-01-06 12:15 UTC  Dawid Kuroczko <qnex42@gmail.com>
` Re: Low Performance for big hospital server ..
  2005-01-06 16:34 UTC  amrit@health2.moph.go.th
` Re: Low Performance for big hospital server ..
  2005-01-06 17:06 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Low Performance for big hospital server ..
  2005-01-06 17:12 UTC  Frank Wiles <frank@wiles.org>
` Re: Low Performance for big hospital server ..
  2005-01-06 17:35 UTC  Dave Cramer <pg@fastcrypt.com>
` Re: Low Performance for big hospital server ..
  2005-01-06 17:51 UTC  Rod Taylor <pg@rbt.ca>
` Re: Low Performance for big hospital server ..
  2005-01-06 18:33 UTC  Richard_D_Levine@raytheon.com
` Re: Low Performance for big hospital server ..
  2005-01-06 19:09 UTC  Yann Michel <yann-postgresql@spline.de>
` Re: Low Performance for big hospital server ..
  2005-01-06 19:47 UTC  Greg Stark <gsstark@mit.edu>
` Re: Low Performance for big hospital server ..
  2005-01-06 20:21 UTC  Joshua D. Drake <jd@commandprompt.com>
  [38+ messages in thread]

Some Performance Advice Needed
  2004-12-23 14:27 UTC  Alex <alex@meerkatsoft.com>
` Re: Some Performance Advice Needed
  2004-12-23 14:44 UTC  Jeff <threshar@torgo.978.org>
` Re: Some Performance Advice Needed
  2004-12-23 20:49 UTC  William Yu <wyu@talisys.com>
` Re: Some Performance Advice Needed
  2004-12-23 21:27 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: Some Performance Advice Needed
  2004-12-23 21:45 UTC  William Yu <wyu@talisys.com>
` Re: Some Performance Advice Needed
  2004-12-27 13:46 UTC  Jeff <threshar@torgo.978.org>
` Re: Some Performance Advice Needed
  2005-01-06 19:14 UTC  Randolf Richardson <rr@8x.ca>
  [7+ messages in thread]

Re: Denormalization WAS: Low Performance for big hospital server ..
  2005-01-06 17:38 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Denormalization WAS: Low Performance for big hospital
  2005-01-06 18:24 UTC  Frank Wiles <frank@wiles.org>
  [2+ messages in thread]

Benchmark two separate SELECTs versus one LEFT JOIN
  2005-01-06 02:31 UTC  Miles Keaton <mileskeaton@gmail.com>
` Re: Benchmark two separate SELECTs versus one LEFT JOIN
  2005-01-06 16:57 UTC  Josh Berkus <josh@agliodbs.com>
  [2+ messages in thread]

first postgrreSQL tunning
  2005-01-06 13:19 UTC  Vinicius Caldeira Carvalho <vinicius.carvalho@squadra.com.br>
` Re: first postgrreSQL tunning
  2005-01-06 13:34 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: first postgrreSQL tunning
  2005-01-06 13:46 UTC  Vinicius Caldeira Carvalho <vinicius.carvalho@squadra.com.br>
` Re: first postgrreSQL tunning
  2005-01-06 15:52 UTC  Frank Wiles <frank@wiles.org>
  [4+ messages in thread]

Problems with high traffic
  2005-01-06 08:02 UTC  Ben Bostow <ben@viatornetworks.com>
` Re: Problems with high traffic
  2005-01-06 13:06 UTC  Dave Cramer <pg@fastcrypt.com>
` Re: Problems with high traffic
  2005-01-06 13:18 UTC  Ben Bostow <ben@viatornetworks.com>
` Re: Problems with high traffic
  2005-01-06 13:32 UTC  Dave Cramer <pg@fastcrypt.com>
` Re: Problems with high traffic
  2005-01-06 13:57 UTC  Ben Bostow <ben@viatornetworks.com>
` Re: Problems with high traffic
  2005-01-06 15:16 UTC  Dave Cramer <pg@fastcrypt.com>
  [6+ messages in thread]

query rewrite using materialized views
  2005-01-03 16:55 UTC  Yann Michel <yann-postgresql@spline.de>
` Re: query rewrite using materialized views
  2005-01-04 18:06 UTC  Josh Berkus <josh@agliodbs.com>
` Re: query rewrite using materialized views
  2005-01-04 18:41 UTC  Wager, Ryan D [NTK] <Ryan.D.Wager@mail.sprint.com>
` Re: query rewrite using materialized views
  2005-01-04 19:02 UTC  Rod Taylor <pg@rbt.ca>
` Re: query rewrite using materialized views
  2005-01-04 19:16 UTC  Josh Berkus <josh@agliodbs.com>
` Re: query rewrite using materialized views
  2005-01-04 19:26 UTC  Wager, Ryan D [NTK] <Ryan.D.Wager@mail.sprint.com>
` Re: query rewrite using materialized views
  2005-01-04 19:54 UTC  Rod Taylor <pg@rbt.ca>
` Re: query rewrite using materialized views
  2005-01-04 21:37 UTC  Josh Berkus <josh@agliodbs.com>
` Re: query rewrite using materialized views
  2005-01-04 23:20 UTC  Simon Riggs <simon@2ndquadrant.com>
` Re: query rewrite using materialized views
  2005-01-05 08:11 UTC  Yann Michel <yann-postgresql@spline.de>
  [10+ messages in thread]

Very Bad Performance.
  2005-01-03 22:19 UTC  Pallav Kalva <pkalva@deg.cc>
` Re: Very Bad Performance.
  2005-01-03 23:44 UTC  Dave Cramer <pg@fastcrypt.com>
` Re: Very Bad Performance.
  2005-01-04 14:38 UTC  Pallav Kalva <pkalva@deg.cc>
` Re: Very Bad Performance.
  2005-01-04 19:58 UTC  Christopher Browne <cbbrowne@acm.org>
  [4+ messages in thread]

Bad Index Choices with user defined data type
  2005-01-03 21:44 UTC  Adam Palmblad <adam@aers.ca>
` Re: Bad Index Choices with user defined data type
  2005-01-04 05:06 UTC  Michael Fuhr <mike@fuhr.org>
  [2+ messages in thread]

Hardware purchase question
  2004-11-24 17:58 UTC  Bo Stewart <bstewart@marketingsolutionsinc.com>
` Re: Hardware purchase question
  2004-12-01 00:26 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Hardware purchase question
  2004-12-13 16:33 UTC  Vivek Khera <khera@kcilink.com>
` Re: Hardware purchase question
  2004-12-13 17:23 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: Hardware purchase question
  2004-12-13 18:31 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Hardware purchase question
  2004-12-14 09:33 UTC  Andrew Hood <ahood.lists@ambergreen.co.uk>
` Re: Hardware purchase question
  2005-01-03 19:20 UTC  Mitch Pirtle <mitch.pirtle@gmail.com>
` Re: Hardware purchase question
  2005-01-03 19:35 UTC  Madison Kelly <linux@alteeve.com>
` Re: Hardware purchase question
  2005-01-03 20:19 UTC  Madison Kelly <linux@alteeve.com>
` Re: Hardware purchase question
  2005-01-03 20:36 UTC  Greg Stark <gsstark@mit.edu>
` Re: Hardware purchase question
  2005-01-03 20:44 UTC  Mitch Pirtle <mitch.pirtle@gmail.com>
` Re: Hardware purchase question
  2005-01-04 01:21 UTC  Grega Bremec <gregab@p0f.net>
  [12+ 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