pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedCommit slower on faster PC
2006-07-12 16:16 UTC Koth, Christian (DWBI) <Christian.Koth@smiths-heimann.com>
` Re: Commit slower on faster PC
2006-07-12 17:26 UTC Mark Lewis <mark.lewis@mir3.com>
` Re: Commit slower on faster PC
2006-07-12 17:26 UTC D'Arcy J.M. Cain <darcy@druid.net>
` Re: Commit slower on faster PC
2006-07-12 17:46 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: Commit slower on faster PC
2006-07-12 19:25 UTC Bruno Wolff III <bruno@wolff.to>
` Re: Commit slower on faster PC
2006-07-13 08:59 UTC Koth, Christian (DWBI) <Christian.Koth@smiths-heimann.com>
[6+ messages in thread]
[Fwd: Delivery Status Notification (Failure)]
2006-07-12 16:39 UTC Craig A. James <cjames@modgraph-usa.com>
` Re: [Fwd: Delivery Status Notification (Failure)]
2006-07-12 20:23 UTC Michael Glaesemann <grzm@seespotcode.net>
` Re: [Fwd: Delivery Status Notification (Failure)]
2006-07-12 20:38 UTC Richard Broersma Jr <rabroersma@yahoo.com>
` Re: [Fwd: Delivery Status Notification (Failure)]
2006-07-12 20:47 UTC Craig A. James <cjames@modgraph-usa.com>
` Re: [Fwd: Delivery Status Notification (Failure)]
2006-07-13 00:54 UTC Richard Broersma Jr <rabroersma@yahoo.com>
` Re: [Fwd: Delivery Status Notification (Failure)]
2006-07-13 03:07 UTC Tom Lane <tgl@sss.pgh.pa.us>
[6+ messages in thread]
High CPU Usage - PostgreSQL 7.3
2006-07-10 00:52 UTC Neil Hepworth <nhepworth@gmail.com>
` Re: High CPU Usage - PostgreSQL 7.3
2006-07-10 01:24 UTC Jeff Frost <jeff@frostconsultingllc.com>
` Re: High CPU Usage - PostgreSQL 7.3
2006-07-10 07:55 UTC Neil Hepworth <nhepworth@gmail.com>
` Re: High CPU Usage - PostgreSQL 7.3
2006-07-10 09:12 UTC Neil Hepworth <nhepworth@gmail.com>
` Re: High CPU Usage - PostgreSQL 7.3
2006-07-10 15:26 UTC Jeff Frost <jeff@frostconsultingllc.com>
` Re: High CPU Usage - PostgreSQL 7.3
2006-07-10 16:04 UTC Scott Marlowe <smarlowe@g2switchworks.com>
` Re: High CPU Usage - PostgreSQL 7.3
2006-07-12 01:37 UTC Bruno Wolff III <bruno@wolff.to>
` Re: High CPU Usage - PostgreSQL 7.3
2006-07-12 03:10 UTC Neil Hepworth <nhepworth@gmail.com>
` Re: High CPU Usage - PostgreSQL 7.3
2006-07-12 03:27 UTC Jeff Frost <jeff@frostconsultingllc.com>
` Re: High CPU Usage - PostgreSQL 7.3
2006-07-12 03:43 UTC Jeff Frost <jeff@frostconsultingllc.com>
` Re: High CPU Usage - PostgreSQL 7.3
2006-07-12 03:48 UTC Neil Hepworth <nhepworth@gmail.com>
` Re: High CPU Usage - PostgreSQL 7.3
2006-07-12 14:52 UTC Jeff Frost <jeff@frostconsultingllc.com>
` Re: High CPU Usage - PostgreSQL 7.3
2006-07-12 20:40 UTC Jeff Frost <jeff@frostconsultingllc.com>
[13+ messages in thread]
Performance Problem between Ora 10g and Psql
2006-07-12 08:33 UTC Thomas Radnetter <tr75@gmx.net>
` Re: Performance Problem between Ora 10g and Psql
2006-07-12 09:47 UTC Guillaume Smet <guillaume.smet@gmail.com>
` Re: Performance Problem between Ora 10g and Psql
2006-07-12 14:33 UTC Joshua D. Drake <jd@commandprompt.com>
[3+ messages in thread]
suggested RAID controller for FreeBSD 6.1 + PostgreSQL 8.1
2006-07-05 23:46 UTC Kenji Morishige <kenjim@juniper.net>
` Re: suggested RAID controller for FreeBSD 6.1 + PostgreSQL
2006-07-06 00:52 UTC Mark Kirkwood <markir@paradise.net.nz>
` Re: suggested RAID controller for FreeBSD 6.1 + PostgreSQL 8.1
2006-07-06 18:10 UTC Kenji Morishige <kenjim@juniper.net>
` Re: suggested RAID controller for FreeBSD 6.1 +
2006-07-06 18:17 UTC Scott Marlowe <smarlowe@g2switchworks.com>
` Re: suggested RAID controller for FreeBSD 6.1 +PostgreSQL 8.1
2006-07-06 18:21 UTC Paul Khavkine <paul.khavkine@distributel.ca>
` Re: suggested RAID controller for FreeBSD 6.1 + PostgreSQL
2006-07-06 22:51 UTC Mark Kirkwood <markir@paradise.net.nz>
` Re: suggested RAID controller for FreeBSD 6.1 +PostgreSQL
2006-07-07 05:08 UTC Michael Loftis <mloftis@wgops.com>
` Re: suggested RAID controller for FreeBSD 6.1 +
2006-07-07 13:57 UTC Ron Peacetree <rjpeace@earthlink.net>
` Re: suggested RAID controller for FreeBSD 6.1 + PostgreSQL 8.1
2006-07-10 14:52 UTC Vivek Khera <vivek@khera.org>
[9+ messages in thread]
Opteron/FreeBSD/PostgreSQL performance poor
2006-07-05 14:43 UTC andy rost <andy.rost@noaa.gov>
` Re: Opteron/FreeBSD/PostgreSQL performance poor
2006-07-05 15:46 UTC Stephen Frost <sfrost@snowman.net>
` Re: Opteron/FreeBSD/PostgreSQL performance poor
2006-07-05 17:55 UTC Vivek Khera <vivek@khera.org>
` Re: Opteron/FreeBSD/PostgreSQL performance poor
2006-07-05 18:11 UTC andy rost <andy.rost@noaa.gov>
` Re: Opteron/FreeBSD/PostgreSQL performance poor
2006-07-05 23:49 UTC Mark Kirkwood <markir@paradise.net.nz>
` Re: Opteron/FreeBSD/PostgreSQL performance poor
2006-07-06 14:44 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Opteron/FreeBSD/PostgreSQL performance poor
2006-07-07 20:38 UTC andy rost <andy.rost@noaa.gov>
` Re: Opteron/FreeBSD/PostgreSQL performance poor
2006-07-07 21:11 UTC andy rost <andy.rost@noaa.gov>
` Re: Opteron/FreeBSD/PostgreSQL performance poor
2006-07-07 22:05 UTC Jeff Frost <jeff@frostconsultingllc.com>
` Re: Opteron/FreeBSD/PostgreSQL performance poor
2006-07-09 14:47 UTC Merlin Moncure <mmoncure@gmail.com>
[10+ messages in thread]
VACUUM vs. REINDEX
2006-07-07 22:29 UTC William Scott Jordan <wsjordan@brownpapertickets.com>
` Re: VACUUM vs. REINDEX
2006-07-07 23:15 UTC Richard Broersma Jr <rabroersma@yahoo.com>
` Re: VACUUM vs. REINDEX
2006-07-07 23:18 UTC Jeff Frost <jeff@frostconsultingllc.com>
` Re: VACUUM vs. REINDEX
2006-07-08 00:02 UTC William Scott Jordan <wsjordan@brownpapertickets.com>
` Re: VACUUM vs. REINDEX
2006-07-08 00:22 UTC Jeff Frost <jeff@frostconsultingllc.com>
` Re: VACUUM vs. REINDEX
2006-07-08 00:48 UTC William Scott Jordan <wsjordan@brownpapertickets.com>
` Re: VACUUM vs. REINDEX
2006-07-08 01:15 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: VACUUM vs. REINDEX
2006-07-08 01:28 UTC Chris Hoover <revoohc@gmail.com>
` Re: VACUUM vs. REINDEX
2006-07-08 03:24 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: VACUUM vs. REINDEX
2006-07-08 08:13 UTC Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: VACUUM vs. REINDEX
2006-07-08 09:16 UTC Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>
[11+ messages in thread]
Delete is very slow; PG not using existing index to check foreign keys
2006-07-07 21:59 UTC K-Bob body <xgoober99@hotmail.com>
Update INSERT RULE while running for Partitioning
2006-07-07 07:51 UTC Gene <genekhart@gmail.com>
` Re: Update INSERT RULE while running for Partitioning
2006-07-07 08:33 UTC Markus Schaber <schabi@logix-tt.com>
` Re: Update INSERT RULE while running for Partitioning
2006-07-07 16:05 UTC Dave Chapeskie <dchapeskie+pgsql@phaedrus.sandvine.com>
[3+ messages in thread]
Calling a SP from Curosor loop
2006-06-29 17:00 UTC satishchandra999@gmail.com
` Re: Calling a SP from Curosor loop
2006-07-07 13:21 UTC Merlin Moncure <mmoncure@gmail.com>
[2+ messages in thread]
longest prefix match querries
2006-07-07 08:48 UTC Hripchenko Sergey <hripchenko@linkey.ru>
need vacuum after insert/truncate/insert?
2006-07-07 01:49 UTC Craig A. James <cjames@modgraph-usa.com>
` Re: need vacuum after insert/truncate/insert?
2006-07-07 08:32 UTC Markus Schaber <schabi@logix-tt.com>
[2+ messages in thread]
getting better performance
2006-07-06 06:40 UTC Eugeny N Dzhurinsky <bofh@redwerk.com>
` Re: getting better performance
2006-07-06 06:48 UTC A. Kretschmer <andreas.kretschmer@schollglas.com>
` Re: getting better performance
2006-07-06 08:48 UTC Ivan Zolotukhin <ivan.zolotukhin@gmail.com>
` Re: getting better performance
2006-07-06 14:28 UTC Scott Marlowe <smarlowe@g2switchworks.com>
` Re: getting better performance
2006-07-06 15:11 UTC Eugeny N Dzhurinsky <bofh@redwerk.com>
` Re: getting better performance
2006-07-06 15:26 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: getting better performance
2006-07-06 15:32 UTC Scott Marlowe <smarlowe@g2switchworks.com>
` Re: getting better performance
2006-07-07 08:28 UTC Markus Schaber <schabi@logix-tt.com>
[8+ messages in thread]
victory!
2006-07-06 17:53 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: victory!
2006-07-06 18:01 UTC A.M. <agentm@themactionfaction.com>
[2+ messages in thread]
managing 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]
[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