pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedUpdates on large tables are extremely slow
2005-06-12 17:40 UTC Yves Vindevogel <yves.vindevogel@implements.be>
` Re: Updates on large tables are extremely slow
2005-06-12 17:57 UTC Jacques Caron <jc@directinfos.com>
` Re: Updates on large tables are extremely slow
2005-06-13 02:43 UTC Mark Kirkwood <markir@paradise.net.nz>
` Re: Updates on large tables are extremely slow
2005-06-13 08:54 UTC Mark Kirkwood <markir@paradise.net.nz>
` Re: Updates on large tables are extremely slow
2005-06-13 09:02 UTC Yves Vindevogel <yves.vindevogel@implements.be>
` Fwd: Updates on large tables are extremely slow
2005-06-13 11:51 UTC Yves Vindevogel <yves.vindevogel@implements.be>
` Re: Updates on large tables are extremely slow
2005-06-13 12:17 UTC Yves Vindevogel <yves.vindevogel@implements.be>
` Re: Updates on large tables are extremely slow
2005-06-13 14:32 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Fwd: Updates on large tables are extremely slow
2005-06-13 15:49 UTC Yves Vindevogel <yves.vindevogel@implements.be>
` Re: Fwd: Updates on large tables are extremely slow
2005-06-13 16:02 UTC Richard Huxton <dev@archonet.com>
` Re: Updates on large tables are extremely slow
2005-06-13 16:45 UTC Yves Vindevogel <yves.vindevogel@implements.be>
` Re: Updates on large tables are extremely slow
2005-06-13 16:53 UTC Rod Taylor <pg@rbt.ca>
` Re: Updates on large tables are extremely slow
2005-06-13 17:22 UTC Yves Vindevogel <yves.vindevogel@implements.be>
` Re: Updates on large tables are extremely slow
2005-06-13 17:36 UTC Jacques Caron <jc@directinfos.com>
` Re: Updates on large tables are extremely slow
2005-06-14 01:29 UTC Christopher Kings-Lynne <chriskl@familyhealth.com.au>
[15+ messages in thread]
Resource Requirements
2005-06-13 00:30 UTC elein <elein@varlena.com>
` Re: Resource Requirements
2005-06-13 22:06 UTC Josh Berkus <josh@agliodbs.com>
[2+ messages in thread]
Pseudo-Solved was: (Re: Index ot being used)
2005-06-13 21:18 UTC Madison Kelly <linux@alteeve.com>
How to enhance the chance that data is in disk cache
2005-06-13 13:04 UTC Jona <jonanews@oismail.com>
` Re: How to enhance the chance that data is in disk cache
2005-06-13 14:51 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: How to enhance the chance that data is in disk cache
2005-06-13 17:10 UTC Jona <jonanews@oismail.com>
[3+ messages in thread]
PostgreSQL using the wrong Index
2005-06-13 13:02 UTC Alex Stapleton <alexs@advfn.com>
` Re: PostgreSQL using the wrong Index
2005-06-13 13:08 UTC Alex Stapleton <alexs@advfn.com>
` Re: PostgreSQL using the wrong Index
2005-06-13 14:47 UTC John A Meinel <john@arbash-meinel.com>
` Re: PostgreSQL using the wrong Index
2005-06-13 14:54 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: PostgreSQL using the wrong Index
2005-06-13 15:20 UTC Alex Stapleton <alexs@advfn.com>
` Re: PostgreSQL using the wrong Index
2005-06-13 15:47 UTC Wei Weng <wweng@kencast.com>
[6+ messages in thread]
Help with rewriting query
2005-06-08 19:34 UTC Junaili Lie <junaili@gmail.com>
` Re: Help with rewriting query
2005-06-08 19:56 UTC Tobias Brox <tobias@nordicbet.com>
` Re: Help with rewriting query
2005-06-08 20:48 UTC Jim Johannsen <jjsa@gvtc.com>
` Re: Help with rewriting query
2005-06-08 22:48 UTC Junaili Lie <junaili@gmail.com>
` Re: Help with rewriting query
2005-06-09 02:59 UTC Bruno Wolff III <bruno@wolff.to>
` Re: Help with rewriting query
2005-06-09 04:01 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Help with rewriting query
2005-06-10 01:26 UTC Junaili Lie <junaili@gmail.com>
` Re: Help with rewriting query
2005-06-10 01:30 UTC Junaili Lie <junaili@gmail.com>
` Re: Help with rewriting query
2005-06-10 08:49 UTC Tobias Brox <tobias@nordicbet.com>
` Re: Help with rewriting query
2005-06-10 12:06 UTC Bruno Wolff III <bruno@wolff.to>
` Re: Help with rewriting query
2005-06-10 19:49 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Help with rewriting query
2005-06-11 09:59 UTC Tobias Brox <tobias@nordicbet.com>
` Re: Help with rewriting query
2005-06-13 14:21 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
[13+ messages in thread]
View not using index
2005-06-13 06:54 UTC Yves Vindevogel <yves.vindevogel@implements.be>
` Re: View not using index
2005-06-13 07:05 UTC Russell Smith <mr-russ@pws.com.au>
` Re: View not using index
2005-06-13 07:18 UTC Yves Vindevogel <yves.vindevogel@implements.be>
` Re: View not using index
2005-06-13 07:18 UTC Russell Smith <mr-russ@pws.com.au>
` Re: View not using index
2005-06-13 07:35 UTC Yves Vindevogel <yves.vindevogel@implements.be>
` Re: View not using index
2005-06-13 14:18 UTC Tom Lane <tgl@sss.pgh.pa.us>
[6+ messages in thread]
faster search
2005-06-10 17:45 UTC Clark Slater <list@slatech.com>
` Re: faster search
2005-06-10 17:51 UTC Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: faster search
2005-06-10 18:00 UTC John A Meinel <john@arbash-meinel.com>
` Re: faster search
2005-06-10 18:05 UTC Tobias Brox <tobias@nordicbet.com>
` Re: faster search
2005-06-10 20:12 UTC Steve Atkins <steve@blighty.com>
` Re: faster search
2005-06-11 00:07 UTC Clark Slater <list@slatech.com>
` Re: faster search
2005-06-11 00:14 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: faster search
2005-06-11 00:20 UTC Clark Slater <list@slatech.com>
` Re: faster search
2005-06-11 00:46 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: faster search
2005-06-11 00:48 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: faster search
2005-06-11 00:51 UTC John A Meinel <john@arbash-meinel.com>
` Re: faster search
2005-06-11 00:52 UTC Clark Slater <list@slatech.com>
` Re: faster search
2005-06-11 00:55 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: faster search
2005-06-11 11:05 UTC Cosimo Streppone <cosimo@streppone.it>
` Re: faster search
2005-06-11 16:49 UTC Tom Lane <tgl@sss.pgh.pa.us>
[15+ messages in thread]
Whence the Opterons?
2005-05-06 21:39 UTC Mischa Sandberg <mischa.sandberg@telus.net>
` Re: Whence the Opterons?
2005-05-06 22:09 UTC Ian Meyer <ianmmeyer@gmail.com>
` Re: Whence the Opterons?
2005-05-06 22:29 UTC Steve Poe <spoe@sfnet.cc>
` Re: Whence the Opterons?
2005-05-06 22:44 UTC Gavin M. Roy <gmr@ehpg.net>
` Re: Whence the Opterons?
2005-05-07 14:57 UTC Andrew Sullivan <ajs@crankycanuck.ca>
` Re: Whence the Opterons?
2005-05-07 21:00 UTC Josh Berkus <josh@agliodbs.com>
` Re: Whence the Opterons?
2005-05-08 21:59 UTC Sam Vilain <sam@vilain.net>
` Re: Whence the Opterons?
2005-05-08 22:33 UTC Mischa Sandberg <mischa.sandberg@telus.net>
` Re: Whence the Opterons?
2005-05-09 02:17 UTC Geoffrey <esoteric@3times25.net>
` Re: Whence the Opterons?
2005-05-09 15:05 UTC Anjan Dave <adave@vantage.com>
` Re: Whence the Opterons?
2005-05-09 15:18 UTC John A Meinel <john@arbash-meinel.com>
` Re: Whence the Opterons?
2005-05-09 15:22 UTC John A Meinel <john@arbash-meinel.com>
` Re: Whence the Opterons?
2005-05-09 15:29 UTC Anjan Dave <adave@vantage.com>
` Re: Whence the Opterons?
2005-05-09 15:40 UTC John A Meinel <john@arbash-meinel.com>
` Re: Whence the Opterons?
2005-05-09 17:08 UTC Jeff Frost <jeff@frostconsultingllc.com>
` Re: Whence the Opterons?
2005-05-09 17:23 UTC William Yu <wyu@talisys.com>
` Re: Whence the Opterons?
2005-05-09 20:00 UTC Geoffrey <esoteric@3times25.net>
` Re: Whence the Opterons?
2005-05-09 20:10 UTC Anjan Dave <adave@vantage.com>
` Re: Whence the Opterons?
2005-05-10 03:03 UTC Andrew Rawnsley <ronz@ravensfield.com>
` Re: Whence the Opterons?
2005-05-13 21:07 UTC Andrew Sullivan <ajs@crankycanuck.ca>
` Re: Whence the Opterons?
2005-05-13 21:22 UTC Magnus Hagander <mha@sollentuna.net>
` Re: Whence the Opterons?
2005-06-10 12:34 UTC Richard Rowell <richard@bowmansystems.com>
` Re: Whence the Opterons?
2005-06-10 14:59 UTC Mohan, Ross <RMohan@arbinet.com>
[23+ messages in thread]
Importing from pg_dump slow, low Disk IO
2005-06-08 09:09 UTC Steve Pollard <stevep@hostworks.com.au>
` Re: Importing from pg_dump slow, low Disk IO
2005-06-09 03:56 UTC Steve Pollard <stevep@hostworks.com.au>
` Re: Importing from pg_dump slow, low Disk IO
2005-06-10 06:03 UTC Steve Pollard <stevep@hostworks.com.au>
` Re: Importing from pg_dump slow, low Disk IO
2005-06-10 06:46 UTC Martin Fandel <martin.fandel@alphyra-evs.de>
` Re: Importing from pg_dump slow, low Disk IO
2005-06-10 10:14 UTC Martin Fandel <martin.fandel@alphyra-evs.de>
[5+ messages in thread]
Cleaning bloated pg_attribute
2005-06-10 09:05 UTC Michal Taborsky <michal.taborsky@mall.cz>
` Re: Cleaning bloated pg_attribute
2005-06-10 10:07 UTC Richard Huxton <dev@archonet.com>
[2+ messages in thread]
postgresql.conf runtime statistics default
2005-06-09 10:08 UTC Yann Michel <yann-postgresql@spline.de>
` Re: postgresql.conf runtime statistics default
2005-06-09 13:11 UTC Richard Huxton <dev@archonet.com>
` Re: postgresql.conf runtime statistics default
2005-06-10 04:57 UTC Yann Michel <yann-postgresql@spline.de>
` Re: postgresql.conf runtime statistics default
2005-06-10 07:17 UTC Richard Huxton <dev@archonet.com>
[4+ messages in thread]
Help specifying new web server/database machine
2005-06-08 16:34 UTC Rory Campbell-Lange <rory@campbell-lange.net>
` Re: Help specifying new web server/database machine
2005-06-08 16:41 UTC Bjoern Metzdorf <bm@turtle-entertainment.de>
` Re: Help specifying new web server/database machine
2005-06-08 16:48 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: Help specifying new web server/database machine
2005-06-08 18:53 UTC Matthew Nuzum <mattnuzum@gmail.com>
` Re: Help specifying new web server/database machine
2005-06-08 23:33 UTC William Yu <wyu@talisys.com>
` Re: Help specifying new web server/database machine
2005-06-09 16:44 UTC Rory Campbell-Lange <rory@campbell-lange.net>
` Re: Help specifying new web server/database machine
2005-06-09 17:18 UTC Matthew Nuzum <mattnuzum@gmail.com>
` Re: Help specifying new web server/database machine
2005-06-09 18:00 UTC Oliver Elphick <olly@lfix.co.uk>
` Re: Help specifying new web server/database machine
2005-06-09 19:53 UTC William Yu <wyu@talisys.com>
` Re: Help specifying new web server/database machine
2005-06-09 21:01 UTC Rory Campbell-Lange <rory@campbell-lange.net>
` Re: Help specifying new web server/database machine
2005-06-09 21:27 UTC Rory Campbell-Lange <rory@campbell-lange.net>
[11+ messages in thread]
timestamp indexing
2005-05-30 09:19 UTC Tobias Brox <tobias@nordicbet.com>
` Re: timestamp indexing
2005-05-30 13:54 UTC Michael Fuhr <mike@fuhr.org>
` Re: timestamp indexing
2005-05-30 17:08 UTC Tobias Brox <tobias@nordicbet.com>
` Re: timestamp indexing
2005-05-30 17:57 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: timestamp indexing
2005-05-31 02:06 UTC Tobias Brox <tobias@nordicbet.com>
` Re: timestamp indexing
2005-05-31 02:20 UTC Tobias Brox <tobias@nordicbet.com>
` Re: timestamp indexing
2005-06-09 18:04 UTC Jim C. Nasby <decibel@decibel.org>
` Re: timestamp indexing
2005-06-09 19:43 UTC Tobias Brox <tobias@nordicbet.com>
[8+ messages in thread]
random_page_cost = 1?
2005-06-09 16:37 UTC Alex Stapleton <alexs@advfn.com>
` Re: random_page_cost = 1?
2005-06-09 16:55 UTC Tom Lane <tgl@sss.pgh.pa.us>
[2+ messages in thread]
Query plan changes after pg_dump / pg_restore
2005-06-09 06:02 UTC jonanews@oismail.com
` Re: Query plan changes after pg_dump / pg_restore
2005-06-09 07:33 UTC Dennis Bjorklund <db@zigo.dhs.org>
` Re: Query plan changes after pg_dump / pg_restore
2005-06-09 08:12 UTC Jona <jonanews@oismail.com>
` Re: Query plan changes after pg_dump / pg_restore
2005-06-09 08:25 UTC Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: Query plan changes after pg_dump / pg_restore
2005-06-09 08:54 UTC Jona <jonanews@oismail.com>
` Re: Query plan changes after pg_dump / pg_restore
2005-06-09 08:54 UTC Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: Query plan changes after pg_dump / pg_restore
2005-06-09 09:23 UTC Jona <jonanews@oismail.com>
` Re: Query plan changes after pg_dump / pg_restore
2005-06-09 10:48 UTC Dennis Bjorklund <db@zigo.dhs.org>
` Re: Query plan changes after pg_dump / pg_restore
2005-06-09 13:42 UTC Jona <jonanews@oismail.com>
` Re: Query plan changes after pg_dump / pg_restore
2005-06-09 14:54 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Query plan changes after pg_dump / pg_restore
2005-06-09 16:15 UTC Jona <jonanews@oismail.com>
[11+ messages in thread]
Recommendations for configuring a 200 GB database
2005-06-08 21:04 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Recommendations for configuring a 200 GB database
2005-06-09 08:06 UTC Richard Huxton <dev@archonet.com>
` Re: Recommendations for configuring a 200 GB
2005-06-09 14:55 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Recommendations for configuring a 200 GB
2005-06-09 15:01 UTC Christopher Kings-Lynne <chriskl@familyhealth.com.au>
[4+ messages in thread]
Re: [Npgsql-general] index out of range
2005-06-09 13:35 UTC Josh Close <narshe@gmail.com>
pg_autovacuum settings
2005-06-09 09:19 UTC Michael Ryan S. Puncia <mpuncia@census.gov.ph>
How to find the size of a database - reg.
2005-06-09 04:40 UTC Shanmugasundaram Doraisamy <shan@ceedees.com>
` Re: How to find the size of a database - reg.
2005-06-09 05:01 UTC Christopher Kings-Lynne <chriskl@familyhealth.com.au>
[2+ messages in thread]
Postgresql on an AMD64 machine
2005-06-06 17:53 UTC Mark Rinaudo <mark@bowmansystems.com>
` Re: Postgresql on an AMD64 machine
2005-06-06 18:32 UTC Vivek Khera <vivek@khera.org>
` Re: Postgresql on an AMD64 machine
2005-06-06 20:59 UTC Mike Rylander <mrylander@gmail.com>
` Re: Postgresql on an AMD64 machine
2005-06-06 21:15 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Postgresql on an AMD64 machine
2005-06-06 22:28 UTC Mark Rinaudo <mark@bowmansystems.com>
` Re: Postgresql on an AMD64 machine
2005-06-06 23:48 UTC Neil Conway <neilc@samurai.com>
` Re: Postgresql on an AMD64 machine
2005-06-07 04:28 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Postgresql on an AMD64 machine
2005-06-07 19:38 UTC Donald Courtney <Donald.Courtney@Sun.COM>
` Re: Postgresql on an AMD64 machine
2005-06-07 19:54 UTC Tom Arthurs <tarthurs@jobflash.com>
` Re: Postgresql on an AMD64 machine
2005-06-07 20:19 UTC Donald Courtney <Donald.Courtney@Sun.COM>
` Re: Postgresql on an AMD64 machine
2005-06-07 20:27 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: Postgresql on an AMD64 machine
2005-06-07 20:27 UTC Alvaro Herrera <alvherre@surnet.cl>
` Re: Postgresql on an AMD64 machine
2005-06-07 20:39 UTC Tom Arthurs <tarthurs@jobflash.com>
` Re: Postgresql on an AMD64 machine
2005-06-07 21:04 UTC Michael Stone <mstone+postgres@mathom.us>
` Re: Postgresql on an AMD64 machine
2005-06-07 21:11 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Postgresql on an AMD64 machine
2005-06-08 00:20 UTC Neil Conway <neilc@samurai.com>
` Re: Postgresql on an AMD64 machine
2005-06-08 00:44 UTC John A Meinel <john@arbash-meinel.com>
` Re: Postgresql on an AMD64 machine
2005-06-08 03:05 UTC Josh Berkus <josh@agliodbs.com>
` Re: Postgresql on an AMD64 machine
2005-06-08 03:50 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Postgresql on an AMD64 machine
2005-06-08 06:16 UTC Simon Riggs <simon@2ndquadrant.com>
` Re: Postgresql on an AMD64 machine
2005-06-08 09:51 UTC Michael Stone <mstone+postgres@mathom.us>
` Re: Postgresql on an AMD64 machine
2005-06-08 16:43 UTC Tom Arthurs <tarthurs@jobflash.com>
` Re: Postgresql on an AMD64 machine
2005-06-08 16:53 UTC Bjoern Metzdorf <bm@turtle-entertainment.de>
` Re: Postgresql on an AMD64 machine
2005-06-08 21:14 UTC Sam Vilain <sam@vilain.net>
` Re: Postgresql on an AMD64 machine
2005-06-09 00:19 UTC Neil Conway <neilc@samurai.com>
[25+ messages in thread]
full outer performance problem
2005-05-10 09:03 UTC Kim Bisgaard <kib+pg@dmi.dk>
` Re: full outer performance problem
2005-05-10 14:28 UTC John A Meinel <john@arbash-meinel.com>
` Re: full outer performance problem
2005-05-10 14:45 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: full outer performance problem
2005-05-11 07:05 UTC Kim Bisgaard <kib@dmi.dk>
` Re: full outer performance problem
2005-05-11 08:20 UTC Kim Bisgaard <kib@dmi.dk>
` full outer performance problem
2005-06-08 09:37 UTC Kim Bisgaard <kib+pg@dmi.dk>
` Re: full outer performance problem
2005-06-08 12:17 UTC Bruno Wolff III <bruno@wolff.to>
` Re: full outer performance problem
2005-06-08 12:32 UTC Kim Bisgaard <kib+pg@dmi.dk>
` Re: full outer performance problem
2005-06-08 14:03 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: full outer performance problem
2005-06-08 16:23 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: full outer performance problem
2005-06-08 18:46 UTC Kim Bisgaard <kib+pg@dmi.dk>
` Re: full outer performance problem
2005-06-08 18:53 UTC Kim Bisgaard <kib+pg@dmi.dk>
[12+ messages in thread]
Performance problems, bad estimates and plan
2005-06-08 15:04 UTC Allan Wang <allanvv@gmail.com>
` Re: Performance problems, bad estimates and plan
2005-06-08 17:02 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Performance problems, bad estimates and plan
2005-06-08 17:39 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Performance problems, bad estimates and plan
2005-06-08 17:57 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Performance problems, bad estimates and plan
2005-06-08 18:06 UTC Tom Lane <tgl@sss.pgh.pa.us>
[5+ messages in thread]
SELECT DISTINCT Performance Issue
2005-06-03 01:56 UTC K C Lau <KCLau@attglobal.net>
` Re: SELECT DISTINCT Performance Issue
2005-06-06 11:45 UTC PFC <lists@boutiquenumerique.com>
` Re: SELECT DISTINCT Performance Issue
2005-06-06 14:54 UTC K C Lau <kclau60@netvigator.com>
` Re: SELECT DISTINCT Performance Issue
2005-06-08 13:34 UTC George Essig <george.essig@gmail.com>
` Re: SELECT DISTINCT Performance Issue
2005-06-08 14:25 UTC K C Lau <kclau60@netvigator.com>
` Re: SELECT DISTINCT Performance Issue
2005-06-08 14:51 UTC George Essig <george.essig@gmail.com>
[6+ messages in thread]
Filesystem
2005-06-03 07:06 UTC Martin Fandel <martin.fandel@alphyra-evs.de>
` Re: Filesystem
2005-06-03 10:41 UTC Mark Kirkwood <markir@paradise.net.nz>
` Re: Filesystem
2005-06-03 13:18 UTC Alex Turner <armtuk@gmail.com>
` Re: Filesystem
2005-06-03 13:52 UTC Martin Fandel <martin.fandel@alphyra-evs.de>
` Re: Filesystem
2005-06-03 17:18 UTC J. Andrew Rogers <jrogers@neopolitan.com>
` Re: Filesystem
2005-06-08 07:36 UTC Martin Fandel <martin.fandel@alphyra-evs.de>
` Re: Filesystem
2005-06-08 12:10 UTC Michael Stone <mstone+postgres@mathom.us>
` Re: Filesystem
2005-06-08 12:25 UTC Martin Fandel <martin.fandel@alphyra-evs.de>
` Re: Filesystem
2005-06-08 13:49 UTC Grega Bremec <gregab@p0f.net>
[9+ 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