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

update slows down in pl/pgsql function
  2003-12-16 23:52 UTC  Jenny Zhang <jenny@osdl.org>
` Re: update slows down in pl/pgsql function
  2003-12-16 23:54 UTC  Stephan Szabo <sszabo@megazone.bigpanda.com>
` Re: update slows down in pl/pgsql function
  2003-12-17 00:07 UTC  Jenny Zhang <jenny@osdl.org>
  [3+ messages in thread]

a lot of problems with pg 7.4
  2003-12-13 18:38 UTC  Kari Lavikka <tuner@bdb.fi>
` Re: a lot of problems with pg 7.4
  2003-12-14 09:54 UTC  Tarhon-Onu Victor <mituc@iasi.rdsnet.ro>
` Re: a lot of problems with pg 7.4
  2003-12-14 17:14 UTC  Dennis Bjorklund <db@zigo.dhs.org>
` Re: a lot of problems with pg 7.4
  2003-12-16 16:37 UTC  scott.marlowe <scott.marlowe@ihs.com>
  [4+ messages in thread]

Postgres respond after toomany times to a query view
  2003-12-16 15:40 UTC  Claudia D'amato <claudia.damato@allaxia.com>

TRUNCATE veeeery slow compared to DELETE in 7.4
  2003-12-08 14:03 UTC  Hartmut Raschick <hartmut.raschick@ke-elektronik.de>
` Re: TRUNCATE veeeery slow compared to DELETE in 7.4
  2003-12-10 17:18 UTC  Josh Berkus <josh@agliodbs.com>
` Re: TRUNCATE veeeery slow compared to DELETE in 7.4
  2003-12-10 19:54 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: TRUNCATE veeeery slow compared to DELETE in 7.4
  2003-12-12 10:47 UTC  Hartmut Raschick <hartmut.raschick@ke-elektronik.de>
` Re: TRUNCATE veeeery slow compared to DELETE in 7.4
  2003-12-15 18:21 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [5+ messages in thread]

Index problem or function problem?
  2003-12-09 23:24 UTC  LIANHE SHAO <lshao2@jhmi.edu>
` Re: Index problem or function problem?
  2003-12-15 18:05 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [2+ messages in thread]

Hardware suggestions for Linux/PGSQL server
  2003-12-11 20:19 UTC  Jeff Bohmer <bohmer@visionlink.org>
` Re: Hardware suggestions for Linux/PGSQL server
  2003-12-11 20:50 UTC  William Yu <wyu@talisys.com>
` Re: Hardware suggestions for Linux/PGSQL server
  2003-12-11 22:02 UTC  Jeff Bohmer <bohmer@visionlink.org>
` Re: Hardware suggestions for Linux/PGSQL server
  2003-12-11 22:48 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Re: Hardware suggestions for Linux/PGSQL server
  2003-12-11 23:32 UTC  William Yu <wyu@talisys.com>
` Re: Hardware suggestions for Linux/PGSQL server
  2003-12-12 06:35 UTC  Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: Hardware suggestions for Linux/PGSQL server
  2003-12-12 16:35 UTC  William Yu <wyu@talisys.com>
` Re: Hardware suggestions for Linux/PGSQL server
  2003-12-13 22:57 UTC  Jeff Bohmer <bohmer@visionlink.org>
` Re: Hardware suggestions for Linux/PGSQL server
  2003-12-13 23:00 UTC  Jeff Bohmer <bohmer@visionlink.org>
` Re: Hardware suggestions for Linux/PGSQL server
  2003-12-15 04:17 UTC  Andrew G. Hammond <drew@xyzzy.dhs.org>
` Re: Hardware suggestions for Linux/PGSQL server
  2003-12-15 05:14 UTC  Christopher Browne <cbbrowne@acm.org>
` Re: Hardware suggestions for Linux/PGSQL server
  2003-12-15 16:37 UTC  Jeff Bohmer <bohmer@visionlink.org>
  [12+ messages in thread]

Tables Without OIDS and its effect
  2003-12-12 16:13 UTC  Sai Hertz And Control Systems <sank89@sancharnet.in>
` Re: [PERFORM] Tables Without OIDS and its effect
  2003-12-12 23:10 UTC  Neil Conway <neilc@samurai.com>
` Re: [PERFORM] Tables Without OIDS and its effect
  2003-12-13 10:33 UTC  Sai Hertz And Control Systems <sank89@sancharnet.in>
` Re: [PERFORM] Tables Without OIDS and its effect
  2003-12-14 22:52 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] Tables Without OIDS and its effect
  2003-12-15 02:10 UTC  Neil Conway <neilc@samurai.com>
  [5+ messages in thread]

Tuning for mid-size server
  2003-10-21 14:28 UTC  Anjan Dave <adave@vantage.com>
` Re: Tuning for mid-size server
  2003-10-21 15:56 UTC  Richard Huxton <dev@archonet.com>
` Re: Tuning for mid-size server
  2003-10-21 16:20 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Tuning for mid-size server
  2003-10-21 16:25 UTC  William Yu <wyu@talisys.com>
` Re: Tuning for mid-size server
  2003-10-21 16:26 UTC  Anjan Dave <adave@vantage.com>
` Re: Tuning for mid-size server
  2003-10-21 16:48 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Re: Tuning for mid-size server
  2003-10-21 17:02 UTC  Anjan Dave <adave@vantage.com>
` Re: Tuning for mid-size server
  2003-10-21 17:12 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Tuning for mid-size server
  2003-10-21 17:15 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Tuning for mid-size server
  2003-10-21 17:22 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Tuning for mid-size server
  2003-10-21 17:30 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Re: Tuning for mid-size server
  2003-10-21 17:33 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Re: Tuning for mid-size server
  2003-10-21 17:48 UTC  Andrew Sullivan <andrew@libertyrms.info>
` Re: Tuning for mid-size server
  2003-10-21 17:50 UTC  Jeff <threshar@torgo.978.org>
` Re: Tuning for mid-size server
  2003-10-21 17:50 UTC  Andrew Sullivan <andrew@libertyrms.info>
` Re: Tuning for mid-size server
  2003-10-21 18:27 UTC  William Yu <wyu@talisys.com>
` Re: Tuning for mid-size server
  2003-10-21 18:43 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Tuning for mid-size server
  2003-10-21 18:51 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Tuning for mid-size server
  2003-10-21 18:53 UTC  Anjan Dave <adave@vantage.com>
` Re: Tuning for mid-size server
  2003-10-21 18:59 UTC  Anjan Dave <adave@vantage.com>
` Re: Tuning for mid-size server
  2003-10-21 19:00 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Tuning for mid-size server
  2003-10-21 19:27 UTC  Christopher Browne <cbbrowne@acm.org>
` Re: Tuning for mid-size server
  2003-10-21 20:55 UTC  Andrew Sullivan <andrew@libertyrms.info>
` Re: Tuning for mid-size server
  2003-10-21 21:11 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Re: Tuning for mid-size server
  2003-10-21 21:32 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Tuning for mid-size server
  2003-10-21 21:34 UTC  Andrew Sullivan <andrew@libertyrms.info>
` Re: Tuning for mid-size server
  2003-10-22 21:36 UTC  Ron Johnson <ron.l.johnson@cox.net>
` Re: Tuning for mid-size server
  2003-12-14 05:42 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
` Re: Tuning for mid-size server
  2003-12-14 17:55 UTC  Andrew Sullivan <andrew@libertyrms.info>
  [29+ messages in thread]

Query plan - now what?
  2003-12-12 08:18 UTC  David Shadovitz <david@shadovitz.com>
` Re: Query plan - now what?
  2003-12-12 09:14 UTC  Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: Query plan - now what?
  2003-12-12 15:33 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Query plan - now what?
  2003-12-12 15:46 UTC  David Shadovitz <david@shadovitz.com>
` Re: Query plan - now what?
  2003-12-12 16:52 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Query plan - now what?
  2003-12-14 07:21 UTC  David Shadovitz <david@shadovitz.com>
  [6+ messages in thread]

Update performance doc
  2003-12-14 05:44 UTC  Bruce Momjian <pgman@candle.pha.pa.us>

Update on putting WAL on ramdisk/
  2003-12-12 22:02 UTC  William Yu <wyu@talisys.com>
` Re: Update on putting WAL on ramdisk/
  2003-12-12 22:36 UTC  Russell Garrett <rg@tcslon.com>
` Re: Update on putting WAL on ramdisk/
  2003-12-12 22:45 UTC  William Yu <wyu@talisys.com>
  [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