pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedfailures on machines using jfs
2004-01-07 23:06 UTC Andrew Sullivan <andrew@libertyrms.info>
` Re: failures on machines using jfs
2004-01-08 18:52 UTC Josh Berkus <josh@agliodbs.com>
` Re: failures on machines using jfs
2004-01-10 03:28 UTC Robert Creager <Robert_Creager@LogicalChaos.org>
` Re: failures on machines using jfs
2004-01-11 02:08 UTC Christopher Browne <cbbrowne@libertyrms.info>
` Re: failures on machines using jfs
2004-01-11 16:21 UTC Spiegelberg, Greg <gspiegelberg@cranel.com>
` Re: failures on machines using jfs
2004-01-11 17:04 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: failures on machines using jfs
2004-01-12 16:12 UTC Hannu Krosing <hannu@tm.ee>
` Re: failures on machines using jfs
2004-01-12 17:03 UTC Greg Spiegelberg <gspiegelberg@cranel.com>
` Re: failures on machines using jfs
2004-01-13 12:46 UTC Hannu Krosing <hannu@tm.ee>
` Re: failures on machines using jfs
2004-01-13 12:59 UTC Bill Moran <wmoran@potentialtech.com>
` Re: failures on machines using jfs
2004-01-13 15:04 UTC Greg Spiegelberg <gspiegelberg@cranel.com>
[11+ messages in thread]
Ignore Some Updates
2004-01-13 03:07 UTC cnliou <cnliou@so-net.net.tw>
` Re: Ignore Some Updates
2004-01-13 04:59 UTC Tom Lane <tgl@sss.pgh.pa.us>
[2+ messages in thread]
annoying query/planner choice
2004-01-12 03:05 UTC Andrew Rawnsley <ronz@ravensfield.com>
` Re: annoying query/planner choice
2004-01-12 03:50 UTC Dennis Bjorklund <db@zigo.dhs.org>
` Re: annoying query/planner choice
2004-01-12 03:56 UTC Christopher Browne <cbbrowne@acm.org>
` Re: annoying query/planner choice
2004-01-12 04:05 UTC Andrew Rawnsley <ronz@ravensfield.com>
` Re: annoying query/planner choice
2004-01-12 05:40 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: annoying query/planner choice
2004-01-12 15:02 UTC Andrew Rawnsley <ronz@ravensfield.com>
[6+ messages in thread]
Explain not accurate
2004-01-09 14:12 UTC Richard van den Berg <richard.vandenberg@trust-factory.com>
` Re: Explain not accurate
2004-01-11 19:55 UTC Dennis Bjorklund <db@zigo.dhs.org>
` Re: Explain not accurate
2004-01-12 00:24 UTC Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: Explain not accurate
2004-01-12 02:55 UTC Greg Stark <gsstark@mit.edu>
[4+ messages in thread]
Postgresql on Quad CPU machine
2004-01-11 15:53 UTC D. Dante Lorenso <dante@lorenso.com>
` Re: Postgresql on Quad CPU machine
2004-01-11 16:07 UTC Doug McNaught <doug@mcnaught.org>
[2+ messages in thread]
Slow query problem
2004-01-08 05:52 UTC Bradley Tate <btate@objectmastery.com>
` Re: Slow query problem
2004-01-09 03:27 UTC Mike Glover <mpg4@duluoz.net>
` Re: Slow query problem
2004-01-09 04:23 UTC Bruno Wolff III <bruno@wolff.to>
` Re: Slow query problem
2004-01-09 05:12 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Slow query problem
2004-01-09 07:29 UTC Dennis Björklund <db@zigo.dhs.org>
` Re: Slow query problem
2004-01-09 08:54 UTC Richard Huxton <dev@archonet.com>
` Re: Slow query problem
2004-01-09 08:57 UTC Dennis Björklund <db@zigo.dhs.org>
` Re: Slow query problem
2004-01-09 09:19 UTC Richard Huxton <dev@archonet.com>
` Re: Slow query problem
2004-01-09 14:53 UTC Bradley Tate <btate@objectmastery.com>
` Re: Slow query problem
2004-01-09 15:07 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Slow query problem
2004-01-09 15:38 UTC Stephan Szabo <sszabo@megazone.bigpanda.com>
[11+ messages in thread]
optimizing Postgres queries
2004-01-05 11:28 UTC David Teran <david.teran@cluster9.com>
` Re: optimizing Postgres queries
2004-01-05 11:35 UTC Shridhar Daithankar <shridhar_daithankar@myrealbox.com>
` Re: optimizing Postgres queries
2004-01-05 12:05 UTC David Teran <david.teran@cluster9.com>
` Re: optimizing Postgres queries
2004-01-05 12:10 UTC Shridhar Daithankar <shridhar_daithankar@myrealbox.com>
` Re: optimizing Postgres queries
2004-01-05 12:18 UTC David Teran <david.teran@cluster9.com>
` Re: optimizing Postgres queries
2004-01-05 12:37 UTC Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: optimizing Postgres queries
2004-01-05 15:15 UTC Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: optimizing Postgres queries
2004-01-05 15:22 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: optimizing Postgres queries
2004-01-05 18:47 UTC David Teran <david.teran@cluster9.com>
` Re: optimizing Postgres queries
2004-01-05 18:52 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: optimizing Postgres queries
2004-01-05 19:02 UTC David Teran <david.teran@cluster9.com>
` Re: optimizing Postgres queries
2004-01-05 19:05 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: optimizing Postgres queries
2004-01-05 19:20 UTC David Teran <david.teran@cluster9.com>
` Re: optimizing Postgres queries
2004-01-05 19:23 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: optimizing Postgres queries
2004-01-05 19:57 UTC David Teran <david.teran@cluster9.com>
` Re: optimizing Postgres queries
2004-01-06 05:25 UTC Bruce Momjian <pgman@candle.pha.pa.us>
` Re: optimizing Postgres queries
2004-01-09 03:16 UTC Rod Taylor <pg@rbt.ca>
[17+ messages in thread]
Index creation
2004-01-07 17:08 UTC Eric Jain <Eric.Jain@isb-sib.ch>
` Re: Index creation
2004-01-07 17:20 UTC Jeff <threshar@torgo.978.org>
` Re: Index creation
2004-01-07 19:51 UTC scott.marlowe <scott.marlowe@ihs.com>
[3+ messages in thread]
RAID array stripe sizes
2004-01-07 19:45 UTC Greg Stark <gsstark@mit.edu>
Find original number of rows before applied LIMIT/OFFSET?
2004-01-07 16:57 UTC D. Dante Lorenso <dante@lorenso.com>
` Re: [PERFORM] Find original number of rows before applied LIMIT/OFFSET?
2004-01-07 19:41 UTC Greg Stark <gsstark@mit.edu>
[2+ messages in thread]
Select max(foo) and select count(*) optimization
2004-01-05 19:03 UTC John Siracusa <siracusa@mindspring.com>
` Re: Select max(foo) and select count(*) optimization
2004-01-05 19:52 UTC Rod Taylor <pg@rbt.ca>
` Re: Select max(foo) and select count(*) optimization
2004-01-05 20:01 UTC John Siracusa <siracusa@mindspring.com>
` Re: Select max(foo) and select count(*) optimization
2004-01-05 20:23 UTC Neil Conway <neilc@samurai.com>
` Re: Select max(foo) and select count(*) optimization
2004-01-05 20:26 UTC Christopher Browne <cbbrowne@acm.org>
` Re: Select max(foo) and select count(*) optimization
2004-01-06 00:24 UTC Paul Tuckfield <paul@tuckfield.com>
` Re: Select max(foo) and select count(*) optimization
2004-01-06 00:29 UTC Doug McNaught <doug@mcnaught.org>
` Re: Select max(foo) and select count(*) optimization
2004-01-06 01:46 UTC Christopher Browne <cbbrowne@acm.org>
` Re: Select max(foo) and select count(*) optimization
2004-01-06 02:31 UTC Christopher Browne <cbbrowne@acm.org>
` Re: Select max(foo) and select count(*) optimization
2004-01-06 06:31 UTC Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: Select max(foo) and select count(*) optimization
2004-01-06 06:42 UTC Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: Select max(foo) and select count(*) optimization
2004-01-06 11:51 UTC CoL <col@mportal.hu>
` Re: Select max(foo) and select count(*) optimization
2004-01-06 12:18 UTC D'Arcy J.M. Cain <darcy@druid.net>
` Re: Select max(foo) and select count(*) optimization
2004-01-06 12:20 UTC Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: Select max(foo) and select count(*) optimization
2004-01-06 16:03 UTC Robert Treat <xzilla@users.sourceforge.net>
` Re: Select max(foo) and select count(*) optimization
2004-01-06 16:31 UTC Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: Select max(foo) and select count(*) optimization
2004-01-06 19:28 UTC Mark Kirkwood <markir@paradise.net.nz>
` Re: Select max(foo) and select count(*) optimization
2004-01-06 22:57 UTC D'Arcy J.M. Cain <darcy@druid.net>
` Re: Select max(foo) and select count(*) optimization
2004-01-06 23:19 UTC Tom Lane <tgl@sss.pgh.pa.us>
[19+ messages in thread]
PgAdmin startup query VERY slow
2004-01-06 20:49 UTC Michael Shapiro <mshapiro@ncsa.edu>
` Re: PgAdmin startup query VERY slow
2004-01-06 21:01 UTC Josh Berkus <josh@agliodbs.com>
` Re: PgAdmin startup query VERY slow
2004-01-06 21:17 UTC Josh Berkus <josh@agliodbs.com>
` Re: PgAdmin startup query VERY slow
2004-01-06 21:31 UTC Michael Shapiro <mshapiro@ncsa.edu>
` Re: PgAdmin startup query VERY slow
2004-01-06 23:12 UTC Tom Lane <tgl@sss.pgh.pa.us>
[5+ messages in thread]
Inefficient SELECT with OFFSET and LIMIT
2004-01-06 15:40 UTC Clive Page <cgp@leicester.ac.uk>
` Re: Inefficient SELECT with OFFSET and LIMIT
2004-01-06 18:12 UTC Greg Stark <gsstark@mit.edu>
` Re: Inefficient SELECT with OFFSET and LIMIT
2004-01-06 18:36 UTC Tom Lane <tgl@sss.pgh.pa.us>
[3+ messages in thread]
deferred foreign keys
2003-12-29 20:33 UTC Vivek Khera <khera@kcilink.com>
` Re: deferred foreign keys
2003-12-31 17:17 UTC Vivek Khera <khera@kcilink.com>
` Re: deferred foreign keys
2004-01-02 04:57 UTC Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: deferred foreign keys
2004-01-05 16:33 UTC Vivek Khera <khera@kcilink.com>
` Re: deferred foreign keys
2004-01-05 18:38 UTC Bruno Wolff III <bruno@wolff.to>
` Re: deferred foreign keys
2004-01-05 18:57 UTC Stephan Szabo <sszabo@megazone.bigpanda.com>
` Re: deferred foreign keys
2004-01-05 18:57 UTC Vivek Khera <khera@kcilink.com>
` Re: deferred foreign keys
2004-01-05 19:02 UTC Vivek Khera <khera@kcilink.com>
` Re: deferred foreign keys
2004-01-05 19:48 UTC Stephan Szabo <sszabo@megazone.bigpanda.com>
` Re: deferred foreign keys
2004-01-05 20:14 UTC Rod Taylor <pg@rbt.ca>
` Re: deferred foreign keys
2004-01-05 22:33 UTC Stephan Szabo <sszabo@megazone.bigpanda.com>
[11+ messages in thread]
Use my (date) index, darn it!
2004-01-04 23:36 UTC John Siracusa <siracusa@mindspring.com>
` Re: Use my (date) index, darn it!
2004-01-05 06:55 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Use my (date) index, darn it!
2004-01-05 16:19 UTC John Siracusa <siracusa@mindspring.com>
` Re: Use my (date) index, darn it!
2004-01-05 16:29 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Use my (date) index, darn it!
2004-01-05 16:45 UTC Christopher Browne <cbbrowne@acm.org>
` Re: Use my (date) index, darn it!
2004-01-05 18:15 UTC John Siracusa <siracusa@mindspring.com>
` Re: Use my (date) index, darn it!
2004-01-05 20:27 UTC Christopher Browne <cbbrowne@acm.org>
[7+ messages in thread]
Indexing a Boolean or Null column?
2004-01-04 01:18 UTC D. Dante Lorenso <dante@lorenso.com>
` Re: Indexing a Boolean or Null column?
2004-01-04 04:26 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Indexing a Boolean or Null column?
2004-01-04 04:32 UTC Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: Indexing a Boolean or Null column?
2004-01-04 05:24 UTC D. Dante Lorenso <dante@lorenso.com>
` Re: Indexing a Boolean or Null column?
2004-01-04 07:21 UTC Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: Indexing a Boolean or Null column?
2004-01-04 07:22 UTC Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: Indexing a Boolean or Null column?
2004-01-04 07:48 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Indexing a Boolean or Null column?
2004-01-04 21:39 UTC Christopher Browne <cbbrowne@acm.org>
[8+ messages in thread]
"fun with multipart primary keys" hobby kit
2004-01-03 05:37 UTC Chris Trawick <ctrawick@cultured.net>
` Re: "fun with multipart primary keys" hobby kit
2004-01-03 05:57 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: "fun with multipart primary keys" hobby kit
2004-01-03 06:07 UTC Chris Trawick <ctrawick@cultured.net>
[3+ messages in thread]
Tuning Techniques To Avoid?
2004-01-02 12:33 UTC Christopher Browne <cbbrowne@acm.org>
` Re: Tuning Techniques To Avoid?
2004-01-03 02:18 UTC Greg Stark <gsstark@mit.edu>
[2+ messages in thread]
Why memory is not used ? Why vacuum so slow ?
2004-01-02 09:42 UTC Hervé Piedvache <herve@elma.fr>
` Re: Why memory is not used ? Why vacuum so slow ?
2004-01-02 14:42 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Why memory is not used ? Why vacuum so slow ?
2004-01-02 15:18 UTC Hervé Piedvache <herve@elma.fr>
` Re: Why memory is not used ? Why vacuum so slow ?
2004-01-02 15:51 UTC Tom Lane <tgl@sss.pgh.pa.us>
[4+ messages in thread]
Very slow update + not using clustered index
2004-01-02 03:34 UTC Mike Glover <mpg4@duluoz.net>
` Re: Very slow update + not using clustered index
2004-01-02 04:06 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Very slow update + not using clustered index
2004-01-02 06:16 UTC Mike Glover <mpg4@duluoz.net>
` Re: Very slow update + not using clustered index
2004-01-02 15:45 UTC Tom Lane <tgl@sss.pgh.pa.us>
[4+ messages in thread]
pg_restore makes disk busy
2004-01-01 17:14 UTC cnliou <cnliou@so-net.net.tw>
DELETE ... WHERE ctid IN (...) vs. Iteration
2003-12-30 16:32 UTC Jonathan Gardner <jgardner@jonathangardner.net>
Question about difference in performance of 2 queries on large table
2003-12-29 16:35 UTC Sean Shanny <shannyconsulting@earthlink.net>
` Re: Question about difference in performance of 2 queries on large table
2003-12-29 16:48 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Question about difference in performance of 2 queries
2003-12-29 16:48 UTC Dennis Bjorklund <db@zigo.dhs.org>
` Re: Question about difference in performance of 2 queries
2003-12-29 17:44 UTC Sean Shanny <shannyconsulting@earthlink.net>
` Re: Question about difference in performance of 2 queries
2003-12-29 18:46 UTC Sean Shanny <shannyconsulting@earthlink.net>
` Re: Question about difference in performance of 2 queries
2003-12-29 19:25 UTC Sean Shanny <shannyconsulting@earthlink.net>
` Re: Question about difference in performance of 2 queries
2003-12-29 19:39 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Question about difference in performance of 2 queries
2003-12-29 19:52 UTC Sean Shanny <shannyconsulting@earthlink.net>
` Re: Question about difference in performance of 2 queries
2003-12-30 15:00 UTC Nicholas Shanny <nshanny@tripadvisor.com>
[9+ messages in thread]
What's faster?
2003-12-27 00:11 UTC Keith Bottner <kbottner@comcast.net>
` Re: What's faster?
2003-12-27 00:49 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: What's faster?
2003-12-27 01:06 UTC Mike Nolan <nolan@gw.tssi.com>
` Re: What's faster?
2003-12-27 04:00 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: What's faster?
2003-12-27 10:52 UTC D'Arcy J.M. Cain <darcy@druid.net>
` Re: What's faster?
2003-12-27 18:30 UTC Tom Lane <tgl@sss.pgh.pa.us>
[6+ messages in thread]
(no subject)
2003-12-24 16:25 UTC Michael Rothschild <michael.r@corigin.co.il>
` Re:
2003-12-25 02:47 UTC Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re:
2003-12-25 16:28 UTC Tom Lane <tgl@sss.pgh.pa.us>
[3+ 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