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

is it possible to get the optimizer to use indexes with a like clause
  2003-12-18 23:18 UTC  Dave Cramer <pg@fastcrypt.com>
` Re: is it possible to get the optimizer to use indexes
  2003-12-19 01:38 UTC  Doug McNaught <doug@mcnaught.org>
` Re: is it possible to get the optimizer to use indexes
  2003-12-19 01:38 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: is it possible to get the optimizer to use indexes
  2003-12-19 03:08 UTC  Dave Cramer <pg@fastcrypt.com>
` Re: is it possible to get the optimizer to use indexes with a like clause
  2003-12-19 03:22 UTC  Christopher Browne <cbbrowne@acm.org>
` Re: is it possible to get the optimizer to use indexes
  2003-12-19 03:36 UTC  Stephan Szabo <sszabo@megazone.bigpanda.com>
` Re: is it possible to get the optimizer to use indexes
  2003-12-19 03:44 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: is it possible to get the optimizer to use indexes
  2003-12-19 09:50 UTC  Dave Cramer <pg@fastcrypt.com>
` Re: is it possible to get the optimizer to use indexes
  2003-12-19 14:38 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: is it possible to get the optimizer to use indexes
  2003-12-19 16:00 UTC  Erki Kaldjärv <erki@webware.ee>
` Re: is it possible to get the optimizer to use indexes
  2003-12-24 13:58 UTC  Dave Cramer <pg@fastcrypt.com>
  [11+ messages in thread]

postgresql performance on linux port
  2003-12-22 19:11 UTC  Michael Guerin <guerin@rentec.com>
` Re: postgresql performance on linux port
  2003-12-22 22:32 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: postgresql performance on linux port
  2003-12-23 00:33 UTC  Michael Guerin <guerin@rentec.com>
  [3+ messages in thread]

general peformance question
  2003-12-18 17:04 UTC  Conny Thimren <conny.thimren@servit.se>
` Re: general peformance question
  2003-12-22 20:45 UTC  Rod Taylor <pg@rbt.ca>
` Re: general peformance question
  2003-12-22 22:30 UTC  scott.marlowe <scott.marlowe@ihs.com>
  [3+ messages in thread]

mnogosearch under 7.4 ...
  2003-12-22 21:11 UTC  Marc G. Fournier <scrappy@hub.org>

"select max/count(id)" not using index
  2003-12-22 10:39 UTC  Ryszard Lach <siaco@autograf.pl>
` Re: "select max/count(id)" not using index
  2003-12-22 10:56 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: "select max/count(id)" not using index
  2003-12-22 10:59 UTC  Evil Azrael <evilazrael@evilazrael.de>
` Re: "select max/count(id)" not using index
  2003-12-22 11:03 UTC  Pavel Stehule <stehule@kix.fsv.cvut.cz>
` Re: "select max/count(id)" not using index
  2003-12-22 11:03 UTC  Tomasz Myrta <jasiek@klaster.net>
  [5+ messages in thread]

why do optimizer parameters have to be set manually?
  2003-12-18 18:44 UTC  Marinos J. Yannikos <mjy@geizhals.at>
` Re: why do optimizer parameters have to be set manually?
  2003-12-18 19:17 UTC  Christopher Browne <cbbrowne@libertyrms.info>
` Re: why do optimizer parameters have to be set manually?
  2003-12-18 19:56 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: why do optimizer parameters have to be set manually?
  2003-12-19 13:53 UTC  Marinos J. Yannikos <mjy@geizhals.at>
` Re: why do optimizer parameters have to be set manually?
  2003-12-19 15:07 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: why do optimizer parameters have to be set manually?
  2003-12-19 17:44 UTC  William Yu <wyu@talisys.com>
  [6+ messages in thread]

general performance question
  2003-12-18 19:43 UTC  Conny Thimren <conny.thimren@servit.se>

Why is restored database faster?
  2003-12-17 04:42 UTC  David Shadovitz <david@shadovitz.com>
` Re: Why is restored database faster?
  2003-12-17 06:00 UTC  Neil Conway <neilc@samurai.com>
` Re: Why is restored database faster?
  2003-12-17 06:31 UTC  Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: Why is restored database faster?
  2003-12-17 06:42 UTC  Dennis Bjorklund <db@zigo.dhs.org>
` Re: Why is restored database faster?
  2003-12-18 03:54 UTC  David Shadovitz <david@shadovitz.com>
` Re: Why is restored database faster?
  2003-12-18 06:47 UTC  Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: Why is restored database faster?
  2003-12-18 15:12 UTC  Dennis Bjorklund <db@zigo.dhs.org>
  [7+ messages in thread]

Adding RAM: seeking advice & warnings of hidden "gotchas"
  2003-12-17 19:57 UTC  Nick Fankhauser <nickf@ontko.com>
` Re: Adding RAM: seeking advice & warnings of hidden "gotchas"
  2003-12-17 21:38 UTC  Eric Soroos <eric-psql@soroos.net>
` Re: Adding RAM: seeking advice & warnings of hidden "gotchas"
  2003-12-17 22:18 UTC  Matt Clark <matt@ymogen.net>
  [3+ messages in thread]

Excessive rows/tuples seriously degrading query performance
  2003-12-12 22:40 UTC  Chadwick, Russell <Russell.Chadwick@idc-mcs.com>
` Re: Excessive rows/tuples seriously degrading query
  2003-12-16 21:24 UTC  Hannu Krosing <hannu@tm.ee>
` Re: Excessive rows/tuples seriously degrading query
  2003-12-17 18:34 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [3+ messages in thread]

Nested loop performance
  2003-12-16 17:11 UTC  Nick Fankhauser <nickf@ontko.com>
` Re: Nested loop performance
  2003-12-16 23:55 UTC  Richard Poole <richard@ruthie.org>
` Re: Nested loop performance
  2003-12-17 01:17 UTC  Stephan Szabo <sszabo@megazone.bigpanda.com>
` Re: Nested loop performance
  2003-12-17 15:26 UTC  Nick Fankhauser <nickf@ontko.com>
` Re: Nested loop performance
  2003-12-17 15:26 UTC  Nick Fankhauser <nickf@ontko.com>
  [5+ messages in thread]

Nested loop question
  2003-12-16 17:06 UTC  Nick Fankhauser - Doxpop <nickf@doxpop.com>
` Re: Nested loop question
  2003-12-17 09:52 UTC  Richard Huxton <dev@archonet.com>
` Re: Nested loop question
  2003-12-17 15:26 UTC  Nick Fankhauser <nickf@ontko.com>
  [3+ messages in thread]

Why is VACUUM ANALYZE <table> so slow?
  2003-12-09 21:14 UTC  David Shadovitz <david@www.shadovitz.com>
` Re: Why is VACUUM ANALYZE <table> so slow?
  2003-12-16 22:51 UTC  Neil Conway <neilc@samurai.com>
` Re: Why is VACUUM ANALYZE <table> so slow?
  2003-12-17 04:37 UTC  David Shadovitz <david@shadovitz.com>
  [3+ messages in thread]

Optimizing FK & PK performance...
  2003-12-11 16:38 UTC  Sean P. Thomas <spt@ulanji.com>
` Re: Optimizing FK & PK performance...
  2003-12-16 22:47 UTC  Neil Conway <neilc@samurai.com>
` Re: Optimizing FK & PK performance...
  2003-12-17 01:17 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
  [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