pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedR: Very slow bytea data extraction
2007-02-23 12:19 UTC msmbarabino@virgilio.it <msmbarabino@virgilio.it>
` Re: R: Very slow bytea data extraction
2007-02-23 14:39 UTC Richard Huxton <dev@archonet.com>
` Re: R: Very slow bytea data extraction
2007-02-23 16:35 UTC Merlin Moncure <mmoncure@gmail.com>
[3+ messages in thread]
slow update on 1M rows (worse with indexes)
2007-02-22 18:11 UTC Gabriel Biberian <admin@beemotechnologie.com>
` Re: slow update on 1M rows (worse with indexes)
2007-02-22 18:25 UTC Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: slow update on 1M rows (worse with indexes)
2007-02-22 18:42 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: slow update on 1M rows (worse with indexes)
2007-02-23 06:18 UTC ismo.tuononen@solenovo.fi
[4+ messages in thread]
Vacuum full very slow due to nonremovable dead rows...What makes the dead rows non-removable?
2007-02-22 20:19 UTC Barbara Cosentino <bcosentino@ncircle.com>
` Re: Vacuum full very slow due to nonremovable dead rows...What makes the dead rows non-removable?
2007-02-22 20:29 UTC Steinar H. Gunderson <sgunderson@bigfoot.com>
[2+ messages in thread]
Disable result buffering to frontend clients
2007-02-22 11:02 UTC Konstantinos Krikellas <K.Krikellas@sms.ed.ac.uk>
` Re: Disable result buffering to frontend clients
2007-02-22 11:12 UTC Richard Huxton <dev@archonet.com>
[2+ messages in thread]
How to avoid vacuuming a huge logging table
2007-02-21 18:02 UTC Mark Stosberg <mark@summersault.com>
` Re: How to avoid vacuuming a huge logging table
2007-02-21 19:08 UTC Greg Sabino Mullane <greg@turnstep.com>
` Re: How to avoid vacuuming a huge logging table
2007-02-21 21:58 UTC Greg Sabino Mullane <greg@turnstep.com>
` Re: How to avoid vacuuming a huge logging table
2007-02-21 22:04 UTC D'Arcy J.M. Cain <darcy@druid.net>
[4+ messages in thread]
General advice on user functions
2007-02-21 18:33 UTC Dan Harris <fbsd@drivefaster.net>
` Re: General advice on user functions
2007-02-21 19:05 UTC Albert Cervera Areny <albert@sedifa.com>
` Re: General advice on user functions
2007-02-21 19:30 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: General advice on user functions
2007-02-21 21:40 UTC Dan Harris <fbsd@drivefaster.net>
[4+ messages in thread]
Auto-Vacuum in 8.1 was ineffective for me. 8.2 may work better?
2007-02-21 18:37 UTC Mark Stosberg <mark@summersault.com>
` Re: Auto-Vacuum in 8.1 was ineffective for me. 8.2 may work better?
2007-02-21 18:55 UTC Alvaro Herrera <alvherre@commandprompt.com>
` Re: Auto-Vacuum in 8.1 was ineffective for me. 8.2 may work better?
2007-02-21 20:28 UTC Mark Stosberg <mark@summersault.com>
` Re: Auto-Vacuum in 8.1 was ineffective for me. 8.2 may work better?
2007-02-21 20:36 UTC Matthew T. O'Connor <matthew@zeut.net>
` Re: Auto-Vacuum in 8.1 was ineffective for me. 8.2 may work better?
2007-02-21 20:51 UTC Alvaro Herrera <alvherre@commandprompt.com>
[5+ messages in thread]
How to debug performance problems
2007-02-19 10:50 UTC Andreas Tille <tillea@rki.de>
` Re: How to debug performance problems
2007-02-19 18:02 UTC Craig A. James <cjames@modgraph-usa.com>
` Re: How to debug performance problems
2007-02-19 18:18 UTC Jeff Davis <pgsql@j-davis.com>
` Re: How to debug performance problems
2007-02-19 18:24 UTC Scott Marlowe <smarlowe@g2switchworks.com>
` Re: How to debug performance problems
2007-02-21 15:45 UTC Ray Stell <stellr@cns.vt.edu>
` Re: How to debug performance problems
2007-02-21 16:09 UTC Craig A. James <cjames@modgraph-usa.com>
` Re: How to debug performance problems
2007-02-21 16:40 UTC Ray Stell <stellr@cns.vt.edu>
` Re: How to debug performance problems
2007-02-21 17:49 UTC Mark Stosberg <mark@summersault.com>
[8+ messages in thread]
slow subselects
2007-02-20 07:10 UTC Marko Niinimaki <manzikki@gmail.com>
` Re: slow subselects
2007-02-20 07:21 UTC ismo.tuononen@solenovo.fi
` Re: slow subselects
2007-02-20 07:43 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: slow subselects
2007-02-21 05:34 UTC Marko Niinimaki <manzikki@gmail.com>
[4+ messages in thread]
SELECT performance problem
2007-02-20 23:21 UTC Glenn Sullivan <glenn.sullivan@varianinc.com>
` Re: SELECT performance problem
2007-02-20 23:41 UTC Jeff Frost <jeff@frostconsultingllc.com>
` Re: SELECT performance problem
2007-02-20 23:46 UTC Dave Dutcher <dave@tridecap.com>
[3+ messages in thread]
Not Picking Index
2007-02-16 12:56 UTC Gauri Kanekar <meetgaurikanekar@gmail.com>
` Re: Not Picking Index
2007-02-16 14:28 UTC Michael Fuhr <mike@fuhr.org>
` Re: Not Picking Index
2007-02-16 14:31 UTC Gauri Kanekar <meetgaurikanekar@gmail.com>
` Re: Not Picking Index
2007-02-16 14:46 UTC Alvaro Herrera <alvherre@commandprompt.com>
` Re: Not Picking Index
2007-02-16 14:53 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Fwd: Not Picking Index
2007-02-16 16:06 UTC Mike Gargano <mrg@infoplusonline.com>
` Re: Not Picking Index
2007-02-16 18:27 UTC Brad Nicholson <bnichols@ca.afilias.info>
` Re: Not Picking Index
2007-02-16 18:32 UTC Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Not Picking Index
2007-02-16 18:33 UTC George Pavlov <gpavlov@mynewplace.com>
` Re: Not Picking Index
2007-02-16 19:27 UTC Tom Lane <tgl@sss.pgh.pa.us>
[10+ messages in thread]
Re: reindex vs 'analyze'
2007-02-14 19:05 UTC Mark Stosberg <mark@summersault.com>
` Re: reindex vs 'analyze'
2007-02-16 19:25 UTC Mark Stosberg <mark@summersault.com>
[2+ messages in thread]
Proximity query with GIST and row estimation
2007-02-13 17:09 UTC Guillaume Smet <guillaume.smet@gmail.com>
` Re: Proximity query with GIST and row estimation
2007-02-14 03:01 UTC Paul Ramsey <pramsey@refractions.net>
` Re: Proximity query with GIST and row estimation
2007-02-14 18:12 UTC Guillaume Smet <guillaume.smet@gmail.com>
` Re: Proximity query with GIST and row estimation
2007-02-15 16:13 UTC Guillaume Smet <guillaume.smet@gmail.com>
` Re: Proximity query with GIST and row estimation
2007-02-16 18:31 UTC Guillaume Smet <guillaume.smet@gmail.com>
[5+ messages in thread]
Benchmarking PGSQL?
2007-02-14 10:00 UTC Krishna Kumar <kumar.ramanathan@gmail.com>
` Re: Benchmarking PGSQL?
2007-02-14 10:17 UTC Shoaib Mir <shoaibmir@gmail.com>
` Re: Benchmarking PGSQL?
2007-02-14 15:35 UTC Luke Lonergan <llonergan@greenplum.com>
` Re: Benchmarking PGSQL?
2007-02-14 16:20 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Benchmarking PGSQL?
2007-02-14 18:23 UTC Luke Lonergan <llonergan@greenplum.com>
` Re: Benchmarking PGSQL?
2007-02-14 23:42 UTC Josh Berkus <josh@agliodbs.com>
` Re: Benchmarking PGSQL?
2007-02-15 13:39 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Benchmarking PGSQL?
2007-02-16 06:09 UTC Krishna Kumar <kumar.ramanathan@gmail.com>
[8+ messages in thread]
Question about Bitmap Heap Scan/BitmapAnd
2007-02-13 16:32 UTC Guillaume Smet <guillaume.smet@gmail.com>
` Re: Question about Bitmap Heap Scan/BitmapAnd
2007-02-13 16:49 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Question about Bitmap Heap Scan/BitmapAnd
2007-02-13 17:17 UTC Guillaume Smet <guillaume.smet@gmail.com>
` Re: Question about Bitmap Heap Scan/BitmapAnd
2007-02-13 17:51 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Question about Bitmap Heap Scan/BitmapAnd
2007-02-15 16:05 UTC Guillaume Smet <guillaume.smet@gmail.com>
` Re: Question about Bitmap Heap Scan/BitmapAnd
2007-02-15 16:27 UTC Alvaro Herrera <alvherre@commandprompt.com>
` Re: Question about Bitmap Heap Scan/BitmapAnd
2007-02-15 16:34 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Question about Bitmap Heap Scan/BitmapAnd
2007-02-15 18:09 UTC Guillaume Smet <guillaume.smet@gmail.com>
` Re: Question about Bitmap Heap Scan/BitmapAnd
2007-02-16 00:32 UTC Guillaume Smet <guillaume.smet@gmail.com>
[9+ messages in thread]
Slow query with 'or' clause
2007-02-15 14:36 UTC philippe <philippe@camailia.com>
` Re: Slow query with 'or' clause
2007-02-15 15:44 UTC Richard Huxton <dev@archonet.com>
` Re: Slow query with 'or' clause
2007-02-15 17:10 UTC philippe <philippe@camailia.com>
[3+ messages in thread]
strange issue for certain queries
2007-02-15 17:00 UTC Mike Gargano <mrg@infoplusonline.com>
Problem with joining queries.
2007-02-15 12:58 UTC Konstantinos Krikellas <K.Krikellas@sms.ed.ac.uk>
` Re: Problem with joining queries.
2007-02-15 14:01 UTC Richard Huxton <dev@archonet.com>
` Re: Problem with joining queries.
2007-02-15 14:28 UTC Konstantinos Krikellas <K.Krikellas@sms.ed.ac.uk>
[3+ messages in thread]
An unwanted seqscan
2007-02-14 08:40 UTC Brian Herlihy <btherl@yahoo.com.au>
` Re: An unwanted seqscan
2007-02-14 08:53 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: An unwanted seqscan
2007-02-15 01:30 UTC Brian Herlihy <btherl@yahoo.com.au>
[3+ messages in thread]
How long should it take to insert 200,000 records?
2007-02-06 00:35 UTC Karen Hill <karen_hill22@yahoo.com>
` Re: How long should it take to insert 200,000 records?
2007-02-06 05:33 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: How long should it take to insert 200,000 records?
2007-02-06 09:33 UTC Csaba Nagy <nagy@ecircle-ag.com>
` Re: How long should it take to insert 200,000 records?
2007-02-06 16:14 UTC Scott Marlowe <smarlowe@g2switchworks.com>
` Re: How long should it take to insert 200,000 records?
2007-02-06 16:40 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: How long should it take to insert 200,000 records?
2007-02-06 16:55 UTC Scott Marlowe <smarlowe@g2switchworks.com>
` Re: How long should it take to insert 200,000 records?
2007-02-06 17:01 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: How long should it take to insert 200,000 records?
2007-02-06 17:04 UTC Hiltibidal, Robert <Robert.Hiltibidal@argushealth.com>
` Re: How long should it take to insert 200,000 records?
2007-02-06 18:31 UTC Mark Lewis <mark.lewis@mir3.com>
` Re: How long should it take to insert 200,000 records?
2007-02-06 18:37 UTC Bruno Wolff III <bruno@wolff.to>
` Re: How long should it take to insert 200,000 records?
2007-02-06 19:06 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: How long should it take to insert 200,000 records?
2007-02-06 19:10 UTC Mark Lewis <mark.lewis@mir3.com>
` Re: How long should it take to insert 200,000 records?
2007-02-06 21:39 UTC Karen Hill <karen_hill22@yahoo.com>
` Re: How long should it take to insert 200,000 records?
2007-02-07 02:41 UTC Mark Kirkwood <markir@paradise.net.nz>
` Re: How long should it take to insert 200,000 records?
2007-02-07 03:07 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: How long should it take to insert 200,000 records?
2007-02-14 22:24 UTC Lou O'Quin <LOquin@talleyds.com>
[16+ messages in thread]
JOIN to a VIEW makes a real slow query
2007-02-13 18:53 UTC Chuck D. <pgsql-performance@nullmx.com>
` Re: JOIN to a VIEW makes a real slow query
2007-02-13 19:16 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: JOIN to a VIEW makes a real slow query
2007-02-13 20:17 UTC Chuck D. <pgsql-performance@nullmx.com>
` Re: JOIN to a VIEW makes a real slow query
2007-02-13 20:51 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: JOIN to a VIEW makes a real slow query
2007-02-14 19:12 UTC Chuck D. <pgsql-performance@nullmx.com>
[5+ messages in thread]
quad or dual core Intel CPUs
2007-02-13 19:46 UTC Kenji Morishige <kenjim@juniper.net>
` Re: quad or dual core Intel CPUs
2007-02-13 21:05 UTC Arjen van der Meijden <acmmailing@tweakers.net>
` Re: quad or dual core Intel CPUs
2007-02-13 21:28 UTC Mark Kirkwood <markir@paradise.net.nz>
` Re: quad or dual core Intel CPUs
2007-02-13 22:21 UTC Dan Harris <fbsd@drivefaster.net>
` Re: quad or dual core Intel CPUs
2007-02-13 22:49 UTC Guillaume Smet <guillaume.smet@gmail.com>
` Re: quad or dual core Intel CPUs
2007-02-13 22:52 UTC Heikki Linnakangas <heikki@enterprisedb.com>
` Re: quad or dual core Intel CPUs
2007-02-14 09:19 UTC Claus Guttesen <kometen@gmail.com>
` Re: quad or dual core Intel CPUs
2007-02-14 17:25 UTC Kenji Morishige <kenjim@juniper.net>
` Re: quad or dual core Intel CPUs
2007-02-14 18:43 UTC Claus Guttesen <kometen@gmail.com>
[9+ messages in thread]
reindex vs 'analyze' (was: Re: cube operations slower than geo_distance() on production server)
2007-02-14 16:28 UTC Mark Stosberg <mark@summersault.com>
` Re: reindex vs 'analyze' (was: Re: cube operations slower than geo_distance() on production server)
2007-02-14 18:07 UTC Tom Lane <tgl@sss.pgh.pa.us>
[2+ messages in thread]
cube operations slower than geo_distance() on production server
2007-02-09 19:26 UTC Mark Stosberg <mark@summersault.com>
` Re: cube operations slower than geo_distance() on production server
2007-02-10 01:31 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: cube operations slower than geo_distance() on production server
2007-02-12 16:11 UTC Mark Stosberg <mark@summersault.com>
` Re: cube operations slower than geo_distance() on production server
2007-02-12 19:03 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: cube operations slower than geo_distance() on production server
2007-02-12 19:05 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: cube operations slower than geo_distance() on production server
2007-02-12 19:48 UTC Mark Stosberg <mark@summersault.com>
` Re: cube operations slower than geo_distance() on production server
2007-02-13 14:15 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: cube operations slower than geo_distance() on production server
2007-02-13 14:31 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: cube operations slower than geo_distance() on production server
2007-02-13 20:47 UTC Mark Stosberg <mark@summersault.com>
` Re: cube operations slower than geo_distance() on production server
2007-02-14 07:15 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: cube operations slower than geo_distance() on production server
2007-02-14 13:58 UTC Merlin Moncure <mmoncure@gmail.com>
[11+ messages in thread]
Direct I/O issues
2006-11-23 06:30 UTC Greg Smith <gsmith@gregsmith.com>
` Re: [PERFORM] Direct I/O issues
2006-11-23 16:41 UTC Bruce Momjian <bruce@momjian.us>
` Re: Direct I/O issues
2006-11-23 16:45 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] Direct I/O issues
2006-11-23 16:49 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] Direct I/O issues
2006-11-23 17:20 UTC Bruce Momjian <bruce@momjian.us>
` Re: Direct I/O issues
2006-11-23 18:09 UTC Greg Smith <gsmith@gregsmith.com>
` Re: Direct I/O issues
2006-11-24 04:06 UTC Bruce Momjian <bruce@momjian.us>
` Re: [PERFORM] Direct I/O issues
2006-11-24 18:58 UTC Bruce Momjian <bruce@momjian.us>
` Re: [PERFORM] Direct I/O issues
2006-11-24 19:08 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [HACKERS] [PERFORM] Direct I/O issues
2006-11-24 23:43 UTC Bruce Momjian <bruce@momjian.us>
` Re: [PERFORM] Direct I/O issues
2007-02-14 05:01 UTC Bruce Momjian <bruce@momjian.us>
[11+ 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