pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
analyzer/planner and clustered rows
  2004-04-29 23:09 UTC  Joseph Shraibman <jks@selectacast.net>
` Re: analyzer/planner and clustered rows
  2004-04-30 07:33 UTC  Manfred Koizar <mkoi-pg@aon.at>
  [2+ messages in thread]

Use arrays or not?
  2004-04-29 16:41 UTC  Roelant Ossewaarde <miep@belboek.com>
` Re: Use arrays or not?
  2004-04-29 17:23 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Use arrays or not?
  2004-04-29 20:26 UTC  Roelant Ossewaarde <miep@belboek.com>
` Re: Use arrays or not?
  2004-04-29 20:47 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Use arrays or not?
  2004-04-30 05:49 UTC  Achilleus Mantzios <achill@matrix.gatewaynet.com>
  [5+ messages in thread]

why can't 2 indexes be used at once?
  2004-04-29 23:19 UTC  Joseph Shraibman <jks@selectacast.net>
` Re: why can't 2 indexes be used at once?
  2004-04-30 03:57 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [2+ messages in thread]

Simply join in PostrgeSQL takes too long
  2004-04-27 21:27 UTC  Vitaly Belman <vitalib@012.net.il>
` Re: Simply join in PostrgeSQL takes too long
  2004-04-27 21:56 UTC  Atesz <atesz@ritek.hu>
` Re: Simply join in PostrgeSQL takes too long
  2004-04-27 22:00 UTC  Nick Barr <nicky@chuckie.co.uk>
` Re: Simply join in PostrgeSQL takes too long
  2004-04-27 22:01 UTC  Rod Taylor <pg@rbt.ca>
` Re: Simply join in PostrgeSQL takes too long
  2004-04-27 22:37 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Simply join in PostrgeSQL takes too long
  2004-04-28 08:24 UTC  Manfred Koizar <mkoi-pg@aon.at>
` Re: Simply join in PostrgeSQL takes too long
  2004-04-28 12:23 UTC  Rod Taylor <pg@rbt.ca>
` Re: Simply join in PostrgeSQL takes too long
  2004-04-29 17:13 UTC  Manfred Koizar <mkoi-pg@aon.at>
` Re: Simply join in PostrgeSQL takes too long
  2004-04-29 17:36 UTC  Rod Taylor <pg@rbt.ca>
` Re: Simply join in PostrgeSQL takes too long
  2004-04-29 17:59 UTC  Manfred Koizar <mkoi-pg@aon.at>
` Re: Simply join in PostrgeSQL takes too long
  2004-04-29 21:09 UTC  Vitaly Belman <vitalib@012.net.il>
` Re: Simply join in PostrgeSQL takes too long
  2004-04-29 22:10 UTC  Josh Berkus <josh@agliodbs.com>
  [12+ messages in thread]

Re: Number of pages in a random sample
  2004-04-26 15:08 UTC  Sailesh Krishnamurthy <sailesh@cs.berkeley.edu>
` Re: [HACKERS] Number of pages in a random sample
  2004-04-29 16:56 UTC  Manfred Koizar <mkoi-pg@aon.at>
  [2+ messages in thread]

7.4.2 out of memory
  2004-04-28 18:12 UTC  Jie Liang <jie@stbernard.com>
` Re: [ADMIN] 7.4.2 out of memory
  2004-04-28 19:57 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Re: [ADMIN] 7.4.2 out of memory
  2004-04-28 20:41 UTC  Jie Liang <jie@stbernard.com>
  [3+ messages in thread]

Join problem
  2004-04-27 17:32 UTC  Silke Trissl <trissl@informatik.hu-berlin.de>
` Re: Join problem
  2004-04-28 08:15 UTC  Suller András <suan2@freemail.hu>
` Re: Join problem
  2004-04-28 12:52 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [3+ messages in thread]

is a good practice to create an index on the oid?
  2004-04-26 16:38 UTC  Edoardo Ceccarelli <eddy@axa.it>
` Re: [JDBC] is a good practice to create an index on the oid?
  2004-04-26 23:04 UTC  Dave Cramer <pg@fastcrypt.com>
` Re: [PERFORM] is a good practice to create an index on the oid?
  2004-04-27 02:48 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: [JDBC] [PERFORM] is a good practice to create an index on the
  2004-04-27 11:59 UTC  Dave Cramer <pg@fastcrypt.com>
` Re: [JDBC] [PERFORM] is a good practice to create an index on the
  2004-04-27 15:01 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: [JDBC] [PERFORM] is a good practice to create an index on the
  2004-04-27 15:18 UTC  Dave Cramer <pg@fastcrypt.com>
` Re: [JDBC] [PERFORM] is a good practice to create an index on the
  2004-04-27 21:42 UTC  Edoardo Ceccarelli <eddy@axa.it>
` Re: [JDBC] [PERFORM] is a good practice to create an index on the
  2004-04-28 01:30 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: [JDBC] [PERFORM] is a good practice to create an index on the
  2004-04-28 08:13 UTC  Edoardo Ceccarelli <eddy@axa.it>
` Re: [JDBC] [PERFORM] is a good practice to create an index on the
  2004-04-28 08:25 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: [JDBC] [PERFORM] is a good practice to create an index on the
  2004-04-28 08:32 UTC  Bruno Wolff III <bruno@wolff.to>
  [11+ messages in thread]

Re: Wierd context-switching issue on Xeon patch for 7.4.1
  2004-04-21 20:49 UTC  Dave Cramer <pg@fastcrypt.com>
` Re: Wierd context-switching issue on Xeon patch for 7.4.1
  2004-04-22 02:35 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Wierd context-switching issue on Xeon patch for 7.4.1
  2004-04-22 02:53 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Wierd context-switching issue on Xeon patch for 7.4.1
  2004-04-22 03:06 UTC  Dave Cramer <pg@fastcrypt.com>
` Re: Wierd context-switching issue on Xeon patch for 7.4.1
  2004-04-22 03:18 UTC  Dave Cramer <pg@fastcrypt.com>
` Re: Wierd context-switching issue on Xeon patch for 7.4.1
  2004-04-22 04:23 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Wierd context-switching issue on Xeon patch for 7.4.1
  2004-04-22 04:44 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: Wierd context-switching issue on Xeon patch for 7.4.1
  2004-04-22 04:56 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
` Re: Wierd context-switching issue on Xeon patch for 7.4.1
  2004-04-22 05:13 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Wierd context-switching issue on Xeon patch for 7.4.1
  2004-04-22 12:36 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Wierd context-switching issue on Xeon patch for 7.4.1
  2004-04-22 17:37 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Wierd context-switching issue on Xeon patch for 7.4.1
  2004-04-22 17:55 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Wierd context-switching issue on Xeon patch for 7.4.1
  2004-04-22 18:11 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Wierd context-switching issue on Xeon patch for 7.4.1
  2004-04-22 18:31 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
` Re: Wierd context-switching issue on Xeon patch for 7.4.1
  2004-04-22 21:21 UTC  Magnus Hagander <mha@sollentuna.net>
` Re: Wierd context-switching issue on Xeon patch for 7.4.1
  2004-04-22 21:22 UTC  Rod Taylor <pg@rbt.ca>
` Re: Wierd context-switching issue on Xeon patch for 7.4.1
  2004-04-25 07:13 UTC  Andrew McMillan <andrew@catalyst.net.nz>
` Re: Wierd context-switching issue on Xeon patch for 7.4.1
  2004-04-27 00:03 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Wierd context-switching issue on Xeon patch for 7.4.1
  2004-04-27 00:16 UTC  Dave Cramer <pg@fastcrypt.com>
` Re: Wierd context-switching issue on Xeon patch for 7.4.1
  2004-04-27 18:05 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Wierd context-switching issue on Xeon patch for 7.4.1
  2004-04-27 18:27 UTC  Dave Cramer <pg@fastcrypt.com>
` Re: Wierd context-switching issue on Xeon patch for 7.4.1
  2004-04-27 21:03 UTC  Josh Berkus <josh@agliodbs.com>
  [22+ messages in thread]

Re: OT: Help with performance problems
  2004-04-26 09:01 UTC  Rob Fielding <rob@dsvr.net>
` Re: OT: Help with performance problems
  2004-04-27 18:02 UTC  scott.marlowe <scott.marlowe@ihs.com>
  [2+ messages in thread]

Shared buffers, Sort memory, Effective Cache Size
  2004-04-21 16:29 UTC  Frédéric Robinet <Fr@Mims.be>
` Re: Shared buffers, Sort memory, Effective Cache Size
  2004-04-21 17:01 UTC  Qing Zhao <qzhao@supplyfx.com>
` Re: Shared buffers, Sort memory, Effective Cache Size
  2004-04-27 12:12 UTC  Manfred Koizar <mkoi-pg@aon.at>
  [3+ messages in thread]

Help with performance problems
  2004-04-23 13:31 UTC  Chris Hoover <revoohc@sermonaudio.com>
` Re: Help with performance problems
  2004-04-23 15:16 UTC  Aaron Werman <awerman2@hotmail.com>
` Re: Help with performance problems
  2004-04-23 16:42 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Help with performance problems
  2004-04-23 17:16 UTC  Chris Hoover <revoohc@sermonaudio.com>
` Re: Help with performance problems
  2004-04-23 17:21 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Re: Help with performance problems
  2004-04-23 17:53 UTC  Chris Hoover <revoohc@sermonaudio.com>
` Re: Help with performance problems
  2004-04-23 18:01 UTC  Chris Hoover <revoohc@sermonaudio.com>
` Re: Help with performance problems
  2004-04-23 18:15 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Help with performance problems
  2004-04-23 18:57 UTC  Ron St-Pierre <rstpierre@syscor.com>
` Re: Help with performance problems
  2004-04-23 19:27 UTC  Chris Hoover <revoohc@sermonaudio.com>
` Re: Help with performance problems
  2004-04-23 19:58 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Re: Help with performance problems
  2004-04-23 21:36 UTC  Ron St-Pierre <rstpierre@syscor.com>
` Re: Help with performance problems
  2004-04-24 02:58 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Help with performance problems
  2004-04-26 17:20 UTC  Chris Hoover <revoohc@sermonaudio.com>
  [14+ messages in thread]

Why will vacuum not end?
  2004-04-20 03:37 UTC  Shea,Dan [CIS] <Dan.Shea@ec.gc.ca>
` Re: Why will vacuum not end?
  2004-04-20 04:02 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: Why will vacuum not end?
  2004-04-20 12:58 UTC  Shea,Dan [CIS] <Dan.Shea@ec.gc.ca>
` Re: Why will vacuum not end?
  2004-04-20 13:14 UTC  Bill Moran <wmoran@potentialtech.com>
` Re: Why will vacuum not end?
  2004-04-21 01:26 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: Why will vacuum not end?
  2004-04-23 18:19 UTC  Shea,Dan [CIS] <Dan.Shea@ec.gc.ca>
` Re: Why will vacuum not end?
  2004-04-23 18:47 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Why will vacuum not end?
  2004-04-24 14:45 UTC  Shea,Dan [CIS] <Dan.Shea@ec.gc.ca>
` Re: Why will vacuum not end?
  2004-04-24 15:35 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Why will vacuum not end?
  2004-04-24 17:57 UTC  Manfred Koizar <mkoi-pg@aon.at>
` Re: Why will vacuum not end?
  2004-04-24 19:48 UTC  Shea,Dan [CIS] <Dan.Shea@ec.gc.ca>
` Re: Why will vacuum not end?
  2004-04-24 19:58 UTC  Shea,Dan [CIS] <Dan.Shea@ec.gc.ca>
` Re: Why will vacuum not end?
  2004-04-25 00:05 UTC  Manfred Koizar <mkoi-pg@aon.at>
` Re: Why will vacuum not end?
  2004-04-25 00:28 UTC  Manfred Koizar <mkoi-pg@aon.at>
` Re: Why will vacuum not end?
  2004-04-25 01:49 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Why will vacuum not end?
  2004-04-25 13:05 UTC  Shea,Dan [CIS] <Dan.Shea@ec.gc.ca>
` Re: Why will vacuum not end?
  2004-04-25 20:46 UTC  Manfred Koizar <mkoi-pg@aon.at>
  [17+ messages in thread]

Number of pages in a random sample (was: query slows down with more accurate stats)
  2004-04-25 20:26 UTC  Manfred Koizar <mkoi-pg@aon.at>

Setting Shared Buffers , Effective Cache, Sort Mem Parameters
  2004-04-22 17:51 UTC  Pallav Kalva <pkalva@deg.cc>
` Re: Setting Shared Buffers , Effective Cache, Sort Mem
  2004-04-22 21:16 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Re: Setting Shared Buffers , Effective Cache, Sort Mem Parameters
  2004-04-22 22:50 UTC  Manfred Koizar <mkoi-pg@aon.at>
` Re: Setting Shared Buffers , Effective Cache, Sort Mem Parameters
  2004-04-23 21:44 UTC  Manfred Koizar <mkoi-pg@aon.at>
` Re: Setting Shared Buffers , Effective Cache, Sort Mem
  2004-04-23 22:10 UTC  Ron Mayer <rm_pg@cheapcomplexdevices.com>
` Re: Setting Shared Buffers , Effective Cache, Sort Mem
  2004-04-24 02:50 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Setting Shared Buffers , Effective Cache, Sort Mem
  2004-04-24 15:37 UTC  Josh Berkus <josh@agliodbs.com>
  [7+ messages in thread]

Looking for ideas on how to speed up warehouse loading
  2004-04-22 21:56 UTC  Sean Shanny <shannyconsulting@earthlink.net>
` Re: Looking for ideas on how to speed up warehouse loading
  2004-04-22 23:05 UTC  CoL <col@mportal.hu>
` Re: Looking for ideas on how to speed up warehouse loading
  2004-04-22 23:30 UTC  Sean Shanny <shannyconsulting@earthlink.net>
` Re: Looking for ideas on how to speed up warehouse loading
  2004-04-23 00:54 UTC  Nicholas Shanny <nshanny@tripadvisor.com>
` Re: Looking for ideas on how to speed up warehouse loading
  2004-04-23 02:03 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Looking for ideas on how to speed up warehouse loading
  2004-04-23 04:38 UTC  Joe Conway <mail@joeconway.com>
` Re: Looking for ideas on how to speed up warehouse loading
  2004-04-23 12:19 UTC  Aaron Werman <awerman2@hotmail.com>
` Re: Looking for ideas on how to speed up warehouse loading
  2004-04-23 16:25 UTC  scott.marlowe <scott.marlowe@ihs.com>
  [8+ messages in thread]

Re: 225 times slower
  2004-04-20 17:10 UTC  Pailloncy Jean-Gérard <pailloncy@ifrance.com>
` Re: 225 times slower
  2004-04-22 04:15 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: 225 times slower
  2004-04-22 18:46 UTC  Pailloncy Jean-Gérard <pailloncy@ifrance.com>
  [3+ messages in thread]

order by index, and inheritance
  2004-04-19 11:30 UTC  Michiel Meeuwissen <Michiel.Meeuwissen@omroep.nl>
` Re: order by index, and inheritance
  2004-04-22 11:02 UTC  Michiel Meeuwissen <Michiel.Meeuwissen@omroep.nl>
` Re: order by index, and inheritance
  2004-04-22 13:46 UTC  Rod Taylor <pg@rbt.ca>
` Re: order by index, and inheritance
  2004-04-22 14:40 UTC  Michiel Meeuwissen <Michiel.Meeuwissen@omroep.nl>
` Re: order by index, and inheritance
  2004-04-22 14:46 UTC  Rod Taylor <pg@rbt.ca>
  [5+ messages in thread]

Moving postgres to FC disks
  2004-04-20 20:20 UTC  Anjan Dave <adave@vantage.com>
` Re: Moving postgres to FC disks
  2004-04-21 00:27 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: Moving postgres to FC disks
  2004-04-21 02:14 UTC  Aaron Werman <awerman2@hotmail.com>
` Re: Moving postgres to FC disks
  2004-04-21 21:50 UTC  Cott Lang <cott@internetstaff.com>
  [4+ messages in thread]

Help understanding stat tables
  2004-04-21 15:34 UTC  Chris Hoover <revoohc@sermonaudio.com>
` Re: Help understanding stat tables
  2004-04-21 16:24 UTC  Chris Hoover <revoohc@sermonaudio.com>
` Re: Help understanding stat tables
  2004-04-21 19:04 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [3+ messages in thread]

slow seqscan
  2004-04-21 07:17 UTC  Edoardo Ceccarelli <eddy@axa.it>
` Re: slow seqscan
  2004-04-21 07:47 UTC  Nick Barr <nicky@chuckie.co.uk>
` Re: slow seqscan
  2004-04-21 07:52 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: slow seqscan
  2004-04-21 08:34 UTC  Edoardo Ceccarelli <eddy@axa.it>
` Re: slow seqscan
  2004-04-21 08:53 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: slow seqscan
  2004-04-21 09:41 UTC  Edoardo Ceccarelli <eddy@axa.it>
` Re: slow seqscan
  2004-04-21 10:10 UTC  Edoardo Ceccarelli <eddy@axa.it>
` Re: slow seqscan
  2004-04-21 10:15 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: slow seqscan
  2004-04-21 11:50 UTC  Edoardo Ceccarelli <eddy@axa.it>
` Re: slow seqscan
  2004-04-21 14:31 UTC  Stephan Szabo <sszabo@megazone.bigpanda.com>
` Re: slow seqscan
  2004-04-21 16:23 UTC  Edoardo Ceccarelli <eddy@axa.it>
` Re: slow seqscan
  2004-04-21 18:20 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [12+ messages in thread]

pgbench written in Pro*C
  2004-04-20 15:48 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
` Re: pgbench written in Pro*C
  2004-04-21 02:51 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: pgbench written in Pro*C
  2004-04-21 03:31 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
  [3+ messages in thread]

Use of subquery causes seq scan???
  2004-04-20 14:20 UTC  Chris Hoover <revoohc@sermonaudio.com>
` Re: Use of subquery causes seq scan???
  2004-04-20 17:56 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: Use of subquery causes seq scan???
  2004-04-20 21:58 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [3+ messages in thread]

seeking consultant for high performance, complex searching with Postgres web app
  2004-04-19 20:42 UTC  Mark Stosberg <mark@summersault.com>
` Re: seeking consultant for high performance, complex searching
  2004-04-20 16:18 UTC  Rajesh Kumar Mallah <mallah@trade-india.com>
  [2+ messages in thread]

Persistent Connections
  2004-01-24 17:32 UTC  postgres@countup.de
` Re: Persistent Connections
  2004-01-25 11:28 UTC  Nick Barr <nicky@chuckie.co.uk>
` Re: Persistent Connections
  2004-01-26 06:35 UTC  Randolf Richardson <rr@8x.ca>
` Re: Persistent Connections
  2004-04-20 15:49 UTC  Thomas Swan <tswan@idigx.com>
  [4+ 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