pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedmanaging database with thousands of tables
2006-07-05 13:07 UTC Eugeny N Dzhurinsky <bofh@redwerk.com>
` Re: managing database with thousands of tables
2006-07-05 13:39 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: managing database with thousands of tables
2006-07-05 15:57 UTC Eugeny N Dzhurinsky <bofh@redwerk.com>
` Re: managing database with thousands of tables
2006-07-06 00:33 UTC Chris <dmagick@gmail.com>
[4+ messages in thread]
Is postgresql ca do the job for software deployed in ASP ou SaaS mode?
2006-07-03 11:41 UTC David Gagnon <dgagnon@siunik.com>
` Re: Is postgresql ca do the job for software deployed in ASP ou SaaS mode?
2006-07-03 17:00 UTC Richard Broersma Jr <rabroersma@yahoo.com>
` Re: Is postgresql ca do the job for software deployed in ASP ou SaaS mode?
2006-07-03 17:20 UTC Chris Hoover <revoohc@gmail.com>
` Re: Is postgresql ca do the job for software deployed in
2006-07-03 17:35 UTC Craig A. James <cjames@modgraph-usa.com>
` Re: Is postgresql ca do the job for software deployed in ASP ou SaaS mode?
2006-07-04 04:35 UTC Guoping Zhang <guoping.zhang@nec.com.au>
` Re: Is postgresql ca do the job for software deployed in ASP ou SaaS mode?
2006-07-04 08:03 UTC Mikael Carneholm <Mikael.Carneholm@WirelessCar.com>
` Re: Is postgresql ca do the job for software deployed in ASP
2006-07-04 11:55 UTC David Gagnon <dgagnon@siunik.com>
` Re: Is postgresql ca do the job for software deployed in ASP ou SaaS mode?
2006-07-04 13:05 UTC Mikael Carneholm <Mikael.Carneholm@WirelessCar.com>
` Re: Is postgresql ca do the job for software deployed in ASP
2006-07-04 13:33 UTC David Gagnon <dgagnon@siunik.com>
` Re: Is postgresql ca do the job for software deployed in
2006-07-05 10:38 UTC Markus Schaber <schabi@logix-tt.com>
` Re: Is postgresql ca do the job for software deployed in
2006-07-05 11:06 UTC Gregory S. Williamson <gsw@globexplorer.com>
` Re: Is postgresql ca do the job for software deployed in
2006-07-05 19:18 UTC Markus Schaber <schabi@logix-tt.com>
[12+ messages in thread]
query very slow when enable_seqscan=on
2006-07-03 20:31 UTC Tomasz Ostrowski <tometzky@batory.org.pl>
` Re: query very slow when enable_seqscan=on
2006-07-03 23:05 UTC Simon Riggs <simon@2ndquadrant.com>
` Re: query very slow when enable_seqscan=on
2006-07-03 23:05 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: query very slow when enable_seqscan=on
2006-07-04 08:37 UTC Tomasz Ostrowski <tometzky@batory.org.pl>
` Re: query very slow when enable_seqscan=on
2006-07-04 13:56 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: query very slow when enable_seqscan=on
2006-07-04 14:44 UTC Tomasz Ostrowski <tometzky@batory.org.pl>
` Re: query very slow when enable_seqscan=on
2006-07-04 16:24 UTC tomas@tuxteam.de
` Re: query very slow when enable_seqscan=on
2006-07-04 18:15 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: query very slow when enable_seqscan=on
2006-07-05 08:33 UTC Tomasz Ostrowski <tometzky@batory.org.pl>
[9+ messages in thread]
optimizing LIKE '%2345' queries
2006-07-02 21:50 UTC Gene <genekhart@gmail.com>
` Re: optimizing LIKE '%2345' queries
2006-07-03 07:33 UTC Mario Weilguni <mweilguni@sime.com>
` Re: optimizing LIKE '%2345' queries
2006-07-04 11:14 UTC Tarhon-Onu Victor <mituc@iasi.rdsnet.ro>
` Re: optimizing LIKE '%2345' queries
2006-07-04 20:27 UTC Gene <genekhart@gmail.com>
` Re: optimizing LIKE '%2345' queries
2006-07-05 00:22 UTC Chris <dmagick@gmail.com>
[5+ messages in thread]
FWD: Update touches unrelated indexes?
2006-06-30 06:33 UTC Josh Berkus <josh@agliodbs.com>
` Re: FWD: Update touches unrelated indexes?
2006-06-30 06:43 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: FWD: Update touches unrelated indexes?
2006-06-30 15:26 UTC Jozsef Szalay <jszalay@storediq.com>
` Re: FWD: Update touches unrelated indexes?
2006-06-30 17:27 UTC Alvaro Herrera <alvherre@commandprompt.com>
` Re: FWD: Update touches unrelated indexes?
2006-07-02 14:36 UTC Jaime Casanova <systemguards@gmail.com>
[5+ messages in thread]
100% CPU
2006-06-30 07:32 UTC Peter Newman <Peter.Newman@iop.org>
` Re: 100% CPU
2006-06-30 17:58 UTC Jim C. Nasby <jnasby@pervasive.com>
` Re: [pgadmin-support] 100% CPU
2006-07-02 06:25 UTC Mark Kirkwood <markir@paradise.net.nz>
[3+ messages in thread]
Index Being Ignored?
2006-06-30 13:31 UTC Joe Lester <joe_lester@sweetwater.com>
` Re: Index Being Ignored?
2006-06-30 14:14 UTC Alvaro Herrera <alvherre@commandprompt.com>
` Re: Index Being Ignored?
2006-06-30 14:29 UTC Markus Schaber <schabi@logix-tt.com>
` Re: Index Being Ignored?
2006-06-30 14:41 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Index Being Ignored?
2006-06-30 16:32 UTC Joe Lester <joe_lester@sweetwater.com>
[5+ messages in thread]
newly created database makes queries run 300% faster
2006-06-30 14:13 UTC Ksenia Marasanova <ksenia.marasanova@gmail.com>
` Re: newly created database makes queries run 300% faster
2006-06-30 14:36 UTC Brad Nicholson <bnichols@ca.afilias.info>
[2+ messages in thread]
Sort order in sub-select
2006-06-25 18:15 UTC Craig A. James <cjames@emolecules.com>
` Sort order in sub-select
2006-06-30 04:55 UTC Craig A. James <cjames@modgraph-usa.com>
` Re: Sort order in sub-select
2006-06-30 06:21 UTC Tom Lane <tgl@sss.pgh.pa.us>
[3+ messages in thread]
explain analyze reports 20x more time than actual
2006-06-30 04:52 UTC Craig A. James <cjames@modgraph-usa.com>
` Re: explain analyze reports 20x more time than actual
2006-06-30 06:04 UTC Tom Lane <tgl@sss.pgh.pa.us>
[2+ messages in thread]
Some performance numbers, with thoughts
2006-06-20 00:09 UTC Brian Hurt <bhurt@janestcapital.com>
` Re: Some performance numbers, with thoughts
2006-06-20 01:17 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Some performance numbers, with thoughts
2006-06-20 01:24 UTC Luke Lonergan <llonergan@greenplum.com>
` Re: Some performance numbers, with thoughts
2006-06-26 19:33 UTC Simon Riggs <simon@2ndquadrant.com>
` Re: Some performance numbers, with thoughts
2006-06-26 21:20 UTC Michael Stone <mstone+postgres@mathom.us>
` Re: Some performance numbers, with thoughts
2006-06-27 07:12 UTC Simon Riggs <simon@2ndquadrant.com>
` Re: Some performance numbers, with thoughts
2006-06-28 15:41 UTC Ron Mayer <rm_pg@cheapcomplexdevices.com>
[7+ messages in thread]
Large index scan perfomance and indexCorrelation (PG 8.1.4 Win32)
2006-06-27 12:14 UTC Andrew Sagulin <andrews42@yandex.ru>
` Re: Large index scan perfomance and indexCorrelation (PG
2006-06-27 22:04 UTC Simon Riggs <simon@2ndquadrant.com>
` Large index scan perfomance and indexCorrelation (PG 8.1.4 Win32)
2006-06-28 09:33 UTC Andrew Sagulin <andrews42@yandex.ru>
` Re: Large index scan perfomance and indexCorrelation (PG 8.1.4 Win32)
2006-06-28 14:37 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Large index scan perfomance and indexCorrelation (PG 8.1.4 Win32)
2006-06-28 15:08 UTC Jim C. Nasby <jnasby@pervasive.com>
[5+ messages in thread]
why group expressions cause query to run forever
2006-06-22 18:22 UTC Andrus <eetasoft@online.ee>
` Re: why group expressions cause query to run forever
2006-06-22 19:30 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: why group expressions cause query to run forever
2006-06-26 08:48 UTC Andrus <eetasoft@online.ee>
` Re: why group expressions cause query to run forever
2006-06-27 17:50 UTC Andrus <eetasoft@online.ee>
[4+ messages in thread]
unregister
2006-06-27 14:04 UTC Gourish Singbal <gourish@gmail.com>
` unregister
2006-06-27 16:46 UTC Leandro Guimarães dos Santos <lgsantos@contax.com.br>
[2+ messages in thread]
Occupation bloc in pages of table
2006-06-23 10:12 UTC luchot <luchot@voila.fr>
` Re: Occupation bloc in pages of table
2006-06-23 16:09 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Occupation bloc in pages of table
2006-06-26 07:52 UTC luchot <luchot@voila.fr>
` Re: Occupation bloc in pages of table
2006-06-26 08:03 UTC luchot <luchot@voila.fr>
` Re: Occupation bloc in pages of table
2006-06-26 08:07 UTC luchot <luchot@voila.fr>
[5+ messages in thread]
Optimizer internals
2006-06-15 18:05 UTC John Vincent <pgsql-performance@lusis.org>
` Re: Optimizer internals
2006-06-15 18:33 UTC Mark Lewis <mark.lewis@mir3.com>
` Re: Optimizer internals
2006-06-15 18:46 UTC John Vincent <pgsql-performance@lusis.org>
` Re: Optimizer internals
2006-06-15 19:01 UTC Mark Lewis <mark.lewis@mir3.com>
` Re: Optimizer internals
2006-06-15 19:21 UTC John Vincent <pgsql-performance@lusis.org>
` Re: Optimizer internals
2006-06-15 19:26 UTC Scott Marlowe <smarlowe@g2switchworks.com>
` Re: Optimizer internals
2006-06-15 19:38 UTC John Vincent <lusis.org@gmail.com>
` Re: Optimizer internals
2006-06-15 19:43 UTC John Vincent <pgsql-performance@lusis.org>
` Re: Optimizer internals
2006-06-15 22:23 UTC Jim C. Nasby <jnasby@pervasive.com>
` Re: Optimizer internals
2006-06-15 23:23 UTC John Vincent <pgsql-performance@lusis.org>
` Re: Optimizer internals
2006-06-16 00:36 UTC Mischa Sandberg <mischa@ca.sophos.com>
` Re: Optimizer internals
2006-06-16 11:23 UTC Greg Stark <gsstark@mit.edu>
` Re: Optimizer internals
2006-06-16 12:51 UTC Jonah H. Harris <jonah.harris@gmail.com>
` Re: Optimizer internals
2006-06-16 13:21 UTC Greg Stark <gsstark@mit.edu>
` Re: Optimizer internals
2006-06-16 13:43 UTC Jonah H. Harris <jonah.harris@gmail.com>
` Re: Optimizer internals
2006-06-17 19:33 UTC Jim Nasby <decibel@decibel.org>
` Re: Optimizer internals
2006-06-24 04:32 UTC Bruno Wolff III <bruno@wolff.to>
[17+ messages in thread]
RES: Temporary table
2006-06-24 00:27 UTC Franklin Haut <franklin.haut@gmail.com>
Temporary Table
2005-10-25 07:28 UTC Christian Paul B. Cosinas <cpc@cybees.com>
` Re: Temporary Table
2005-10-26 02:15 UTC Christian Paul B. Cosinas <cpc@cybees.com>
` Re: Temporary Table
2005-11-07 11:07 UTC Alvaro Herrera <alvherre@commandprompt.com>
` Temporary Table
2005-11-07 15:35 UTC Christian Paul B. Cosinas <cpc@cybees.com>
` Re: Temporary Table
2005-11-07 21:40 UTC Ralph Mason <ralph.mason@telogis.com>
` Re: Temporary Table
2005-11-08 02:10 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: Temporary Table
2005-11-08 02:14 UTC Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: Temporary Table
2005-11-08 02:15 UTC Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: Temporary Table
2005-11-08 02:22 UTC Jeff Frost <jeff@frostconsultingllc.com>
` Re: Temporary Table
2005-11-08 02:24 UTC Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: Temporary Table
2005-11-08 02:35 UTC Andrew McMillan <andrew@catalyst.net.nz>
` Re: Temporary Table
2005-11-08 10:04 UTC Christian Paul B. Cosinas <cpc@cybees.com>
` Re: Temporary Table
2005-11-08 10:09 UTC Christian Paul B. Cosinas <cpc@cybees.com>
` Re: Temporary Table
2005-11-08 10:22 UTC Christian Paul B. Cosinas <cpc@cybees.com>
` Temporary table
2006-06-23 21:58 UTC Franklin Haut <franklin.haut@gmail.com>
` Re: Temporary table
2006-06-23 22:04 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Temporary table
2006-06-23 22:08 UTC Larry Rosenman <ler@lerctr.org>
[17+ messages in thread]
Buffers to Nest Loop Join
2006-06-23 18:32 UTC Daniel Xavier de Sousa <danielucg@yahoo.com.br>
Help tuning autovacuum - seeing lots of relation bloat
2006-06-21 13:52 UTC jody brownell <jody.brownell@q1labs.com>
` Re: Help tuning autovacuum - seeing lots of relation
2006-06-21 14:08 UTC Csaba Nagy <nagy@ecircle-ag.com>
` Re: Help tuning autovacuum - seeing lots of relation
2006-06-21 14:17 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Help tuning autovacuum - seeing lots of relationbloat
2006-06-21 15:27 UTC jody brownell <jody.brownell@q1labs.com>
` Re: Help tuning autovacuum - seeing lots of relationbloat
2006-06-21 15:42 UTC Csaba Nagy <nagy@ecircle-ag.com>
` Re: Help tuning autovacuum - seeing lots of relationbloat
2006-06-21 16:21 UTC jody brownell <jody.brownell@q1labs.com>
` Re: Help tuning autovacuum - seeing lots of relationbloat
2006-06-21 16:33 UTC jody brownell <jody.brownell@q1labs.com>
` Re: Help tuning autovacuum - seeing lots of relationbloat
2006-06-21 16:36 UTC Csaba Nagy <nagy@ecircle-ag.com>
` Re: Help tuning autovacuum - seeing lots of relationbloat
2006-06-21 16:39 UTC jody brownell <jody.brownell@q1labs.com>
` Re: Help tuning autovacuum - seeing lots of relationbloat
2006-06-21 16:44 UTC Csaba Nagy <nagy@ecircle-ag.com>
` Re: Help tuning autovacuum - seeing lots of relationbloat
2006-06-21 16:49 UTC jody brownell <jody.brownell@q1labs.com>
` Re: Help tuning autovacuum - seeing lots of relation bloat
2006-06-21 18:57 UTC Jim C. Nasby <jnasby@pervasive.com>
` Re: Help tuning autovacuum - seeing lots of relationbloat
2006-06-21 19:38 UTC Jim C. Nasby <jnasby@pervasive.com>
` Re: Help tuning autovacuum - seeing lots of relationbloat
2006-06-21 19:40 UTC jody brownell <jody.brownell@q1labs.com>
` Re: Help tuning autovacuum - seeing lots of relationbloat
2006-06-21 19:41 UTC jody brownell <jody.brownell@q1labs.com>
` Re: Help tuning autovacuum - seeing lots of relationbloat
2006-06-21 22:11 UTC Jim C. Nasby <jnasby@pervasive.com>
` Re: Help tuning autovacuum - seeing lots of relationbloat
2006-06-21 23:08 UTC jody brownell <jody.brownell@q1labs.com>
` Re: Help tuning autovacuum - seeing lots of relationbloat
2006-06-23 12:32 UTC Markus Schaber <schabi@logix-tt.com>
` Re: Help tuning autovacuum - seeing lots of relationbloat
2006-06-23 12:40 UTC Markus Schaber <schabi@logix-tt.com>
[19+ messages in thread]
SAN performance mystery
2006-06-15 21:50 UTC Tim Allen <tim@proximity.com.au>
` Re: SAN performance mystery
2006-06-15 21:56 UTC Scott Marlowe <smarlowe@g2switchworks.com>
` Re: SAN performance mystery
2006-06-15 22:02 UTC Brian Hurt <bhurt@janestcapital.com>
` Re: SAN performance mystery
2006-06-15 22:15 UTC John Vincent <pgsql-performance@lusis.org>
` Re: SAN performance mystery
2006-06-15 22:24 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: SAN performance mystery
2006-06-15 23:25 UTC Mark Lewis <mark.lewis@mir3.com>
` Re: SAN performance mystery
2006-06-15 23:58 UTC Alex Turner <armtuk@gmail.com>
` Re: SAN performance mystery
2006-06-16 07:48 UTC Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>
` Re: SAN performance mystery
2006-06-16 09:11 UTC Tim Allen <tim@proximity.com.au>
` Re: SAN performance mystery
2006-06-16 11:28 UTC Greg Stark <gsstark@mit.edu>
` Re: SAN performance mystery
2006-06-16 11:45 UTC Mikael Carneholm <Mikael.Carneholm@WirelessCar.com>
` Re: SAN performance mystery
2006-06-16 14:19 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: SAN performance mystery
2006-06-16 17:58 UTC Jeff Trout <threshar@torgo.978.org>
` Re: SAN performance mystery
2006-06-17 19:53 UTC Jim Nasby <jnasby@pervasive.com>
` Re: SAN performance mystery
2006-06-19 06:12 UTC Tim Allen <tim@proximity.com.au>
` Re: SAN performance mystery
2006-06-19 10:09 UTC Tim Allen <tim@proximity.com.au>
` Re: SAN performance mystery
2006-06-19 10:24 UTC Michael Stone <mstone+postgres@mathom.us>
` Re: SAN performance mystery
2006-06-19 10:28 UTC Tim Allen <tim@proximity.com.au>
` Re: SAN performance mystery
2006-06-19 12:41 UTC Stephen Frost <sfrost@snowman.net>
` Re: SAN performance mystery
2006-06-19 12:54 UTC John Vincent <pgsql-performance@lusis.org>
` Re: SAN performance mystery
2006-06-19 12:58 UTC John Vincent <lusis.org@gmail.com>
` Re: SAN performance mystery
2006-06-19 12:59 UTC John Vincent <pgsql-performance@lusis.org>
` Re: SAN performance mystery
2006-06-19 15:04 UTC Stephen Frost <sfrost@snowman.net>
` Re: SAN performance mystery
2006-06-19 23:16 UTC Mark Kirkwood <markir@paradise.net.nz>
` Re: SAN performance mystery
2006-06-23 11:56 UTC Markus Schaber <schabi@logix-tt.com>
` Re: SAN performance mystery
2006-06-23 12:02 UTC Markus Schaber <schabi@logix-tt.com>
[26+ messages in thread]
Why is my (empty) partial index query slow?
2006-06-16 07:17 UTC Richard Frith-Macdonald <richard@tiptree.demon.co.uk>
` Re: Why is my (empty) partial index query slow?
2006-06-22 16:04 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Why is my (empty) partial index query slow?
2006-06-23 00:43 UTC Tom Lane <tgl@sss.pgh.pa.us>
[3+ messages in thread]
Query hanging/not finishing inconsistently
2006-05-22 17:20 UTC Meetesh Karia <meetesh.karia@gmail.com>
` Re: Query hanging/not finishing inconsistently
2006-05-22 18:49 UTC Craig A. James <cjames@modgraph-usa.com>
` Re: Query hanging/not finishing inconsistently
2006-05-22 20:40 UTC Meetesh Karia <meetesh.karia@gmail.com>
` Re: Query hanging/not finishing inconsistently
2006-06-20 17:25 UTC Meetesh Karia <meetesh.karia@gmail.com>
` Re: Query hanging/not finishing inconsistently
2006-06-23 00:31 UTC Tom Lane <tgl@sss.pgh.pa.us>
[5+ messages in thread]
Tuning New Server (slow function)
2006-06-21 15:37 UTC Ron St-Pierre <ronDOTpgsql@shaw.ca>
` Tuning New Server (slow function)
2006-06-21 15:57 UTC Ron St-Pierre <ronDOTpgsql@shaw.ca>
` Tuning New Server (slow function)
2006-06-21 21:27 UTC Ron St-Pierre <ron.pgsql@shaw.ca>
` Re: Tuning New Server (slow function)
2006-06-21 22:21 UTC Jim C. Nasby <jnasby@pervasive.com>
` Re: Tuning New Server (slow function)
2006-06-21 22:53 UTC Ron St-Pierre <ron.pgsql@shaw.ca>
` Re: Tuning New Server (slow function)
2006-06-22 16:19 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Tuning New Server (slow function)
2006-06-22 21:15 UTC Jim Nasby <jnasby@pervasive.com>
[7+ messages in thread]
Performance of DOMAINs
2006-06-21 18:26 UTC David Wheeler <david@kineticode.com>
` Re: Performance of DOMAINs
2006-06-21 19:02 UTC Jim C. Nasby <jnasby@pervasive.com>
` Re: Performance of DOMAINs
2006-06-21 20:08 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Performance of DOMAINs
2006-06-22 01:19 UTC Josh Berkus <josh@agliodbs.com>
` Re: Performance of DOMAINs
2006-06-22 02:24 UTC Michael Glaesemann <grzm@seespotcode.net>
` Re: Performance of DOMAINs
2006-06-22 18:11 UTC David Wheeler <david@kineticode.com>
` Re: Performance of DOMAINs
2006-06-22 18:18 UTC David Wheeler <david@kineticode.com>
` Re: Performance of DOMAINs
2006-06-22 18:18 UTC David Wheeler <david@kineticode.com>
[8+ 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