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