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