pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedanalyzer/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