pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Forcing using index instead of sequential scan?
  2006-07-21 10:40 UTC  robin.c.smith@bt.com
` Re: Forcing using index instead of sequential scan?
  2006-07-21 11:45 UTC  Peter Eisentraut <peter_e@gmx.net>
` Re: Forcing using index instead of sequential scan?
  2006-07-21 12:02 UTC  robin.c.smith@bt.com
` Re: Forcing using index instead of sequential scan?
  2006-07-21 12:10 UTC  robin.c.smith@bt.com
` Re: Forcing using index instead of sequential scan?
  2006-07-22 16:22 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Forcing using index instead of sequential scan?
  2006-07-22 17:26 UTC  Craig A. James <cjames@modgraph-usa.com>
` Re: Forcing using index instead of sequential scan?
  2006-07-22 23:15 UTC  Gregory Stark <gsstark@mit.edu>
` Re: Forcing using index instead of sequential scan?
  2006-07-23 03:28 UTC  Mark Kirkwood <markir@paradise.net.nz>
` Re: Forcing using index instead of sequential scan?
  2006-07-23 03:39 UTC  Mark Kirkwood <markir@paradise.net.nz>
` Re: Forcing using index instead of sequential scan?
  2006-07-23 11:07 UTC  Michael Stone <mstone+postgres@mathom.us>
` Re: Forcing using index instead of sequential scan?
  2006-07-23 14:03 UTC  Craig A. James <cjames@modgraph-usa.com>
  [11+ messages in thread]

Bad Planner Statistics for Uneven distribution.
  2006-07-21 18:15 UTC  Kevin McArthur <Kevin@StormTide.ca>
` Re: Bad Planner Statistics for Uneven distribution.
  2006-07-21 21:29 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Bad Planner Statistics for Uneven distribution.
  2006-07-21 22:00 UTC  Guillaume Smet <guillaume.smet@gmail.com>
` Re: Bad Planner Statistics for Uneven distribution.
  2006-07-22 17:03 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [4+ messages in thread]

Performance penalty for remote access of postgresql (8.1.3)? any experiance?
  2006-07-19 05:40 UTC  Guoping Zhang <guoping.zhang@nec.com.au>
` Re: Performance penalty for remote access of postgresql (8.1.3)? any experiance?
  2006-07-19 06:30 UTC  Florian Weimer <fweimer@bfk.de>
` Re: Performance penalty for remote access of postgresql (8.1.3)? any experiance?
  2006-07-19 07:33 UTC  Guoping Zhang <guoping.zhang@nec.com.au>
` Re: Performance penalty for remote access of postgresql (8.1.3)? any experiance?
  2006-07-19 07:38 UTC  Florian Weimer <fweimer@bfk.de>
` Re: Performance penalty for remote access of postgresql (8.1.3)? any experiance?
  2006-07-19 14:01 UTC  Stephen Frost <sfrost@snowman.net>
` Re: Performance penalty for remote access of postgresql (8.1.3)? any experiance?
  2006-07-19 14:18 UTC  Florian Weimer <fweimer@bfk.de>
` Re: Performance penalty for remote access of postgresql (8.1.3)? any experiance?
  2006-07-19 14:26 UTC  Stephen Frost <sfrost@snowman.net>
` Re: Performance penalty for remote access of postgresql
  2006-07-19 14:41 UTC  Bill Moran <wmoran@collaborativefusion.com>
` Re: Performance penalty for remote access of postgresql
  2006-07-19 15:49 UTC  Joe Conway <mail@joeconway.com>
` Re: Performance penalty for remote access of postgresql (8.1.3)? any experiance?
  2006-07-20 06:32 UTC  Guoping Zhang <guoping.zhang@nec.com.au>
` Re: Performance penalty for remote access of postgresql
  2006-07-20 13:54 UTC  David Boreham <david_list@boreham.org>
  [11+ messages in thread]

Temporary table retains old contents on update eventually causing slow temp file usage.
  2006-07-18 06:42 UTC  Rusty Conover <rconover@infogears.com>
` Re: Temporary table retains old contents on update eventually causing slow temp file usage.
  2006-07-18 06:56 UTC  Rusty Conover <rconover@infogears.com>
` Re: Temporary table retains old contents on update eventually
  2006-07-18 12:22 UTC  Gavin Sherry <swm@alcove.com.au>
` Re: Temporary table retains old contents on update eventually causing slow temp file usage.
  2006-07-18 17:12 UTC  Rusty Conover <rconover@infogears.com>
  [4+ messages in thread]

Problem with bitmap-index-scan plan
  2006-07-05 05:54 UTC  jkapad@csd.uoc.gr
` Re: Problem with bitmap-index-scan plan
  2006-07-13 22:32 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Problem with bitmap-index-scan plan
  2006-07-18 09:25 UTC  Kapadaidakis Yannis <jkapad@csd.uoc.gr>
  [3+ messages in thread]

Big differences in plans between 8.0 and 8.1
  2006-07-15 14:14 UTC  Gabriele Turchi <gabriele.turchi@l39a.com>
` Re: Big differences in plans between 8.0 and 8.1
  2006-07-15 19:02 UTC  Michael Fuhr <mike@fuhr.org>
` Re: Big differences in plans between 8.0 and 8.1
  2006-07-15 19:55 UTC  Gabriele Turchi <gabriele.turchi@l39a.com>
` Re: Big differences in plans between 8.0 and 8.1
  2006-07-15 20:04 UTC  Joe Conway <mail@joeconway.com>
` Re: Big differences in plans between 8.0 and 8.1
  2006-07-15 20:22 UTC  Gabriele Turchi <gabriele.turchi@l39a.com>
` Re: Big differences in plans between 8.0 and 8.1
  2006-07-16 18:08 UTC  Joe Conway <mail@joeconway.com>
` Re: Big differences in plans between 8.0 and 8.1
  2006-07-17 20:19 UTC  Chris Hoover <revoohc@gmail.com>
` Re: Big differences in plans between 8.0 and 8.1
  2006-07-18 07:25 UTC  Gabriele Turchi <gabriele.turchi@l39a.com>
  [8+ messages in thread]

Re: increment Rows in an SQL Result Set postgresql
  2006-07-15 17:27 UTC  Craig A. James <cjames@modgraph-usa.com>
` increment Rows in an SQL Result Set postgresql
  2006-07-15 17:46 UTC  Hassan Adekoya <hechy_man@yahoo.com>
` Re: increment Rows in an SQL Result Set postgresql
  2006-07-15 18:53 UTC  Hassan <hechy_man@yahoo.com>
` Re: increment Rows in an SQL Result Set postgresql
  2006-07-15 23:53 UTC  Peter Eisentraut <peter_e@gmx.net>
  [4+ messages in thread]

Self-join query and index usage
  2006-07-14 18:56 UTC  worky.workerson@gmail.com
` Re: Self-join query and index usage
  2006-07-14 19:19 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [2+ messages in thread]

Kill a session
  2006-07-11 05:50 UTC  Craig A. James <cjames@modgraph-usa.com>
` Re: Kill a session
  2006-07-11 07:39 UTC  Tino Wildenhain <tino@wildenhain.de>
` Re: Kill a session
  2006-07-11 11:39 UTC  Magnus Hagander <mha@sollentuna.net>
` Re: Kill a session
  2006-07-12 15:43 UTC  Craig A. James <cjames@modgraph-usa.com>
` Re: Kill a session
  2006-07-12 17:04 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Kill a session
  2006-07-12 17:20 UTC  Magnus Hagander <mha@sollentuna.net>
` Re: Kill a session
  2006-07-12 17:39 UTC  Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>
` Re: Kill a session
  2006-07-14 01:30 UTC  Mark Kirkwood <markir@paradise.net.nz>
` Re: Kill a session
  2006-07-14 02:17 UTC  Craig A. James <cjames@modgraph-usa.com>
` Re: Kill a session
  2006-07-14 02:23 UTC  Craig A. James <cjames@modgraph-usa.com>
` Re: Kill a session
  2006-07-14 05:50 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Kill a session
  2006-07-14 11:28 UTC  Markus Schaber <schabi@logix-tt.com>
` Re: Kill a session
  2006-07-14 15:17 UTC  Craig A. James <cjames@modgraph-usa.com>
` Re: Kill a session
  2006-07-14 16:25 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [14+ messages in thread]

size of pg_dump files containing bytea values
  2006-07-12 18:36 UTC  Steve McWilliams <smcwilliams@EmprisaNetworks.com>
` Re: size of pg_dump files containing bytea values
  2006-07-13 02:53 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: size of pg_dump files containing bytea values
  2006-07-13 16:30 UTC  Greg Stark <gsstark@mit.edu>
` Re: size of pg_dump files containing bytea values
  2006-07-13 17:42 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: size of pg_dump files containing bytea values
  2006-07-14 07:05 UTC  Florian Weimer <fweimer@bfk.de>
  [5+ messages in thread]

hyper slow after upgrade to 8.1.4
  2006-07-12 20:41 UTC  Medora Schauer <mschauer@fairfield.com>
` Re: hyper slow after upgrade to 8.1.4
  2006-07-12 22:06 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: hyper slow after upgrade to 8.1.4
  2006-07-13 02:53 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: hyper slow after upgrade to 8.1.4
  2006-07-13 13:22 UTC  Medora Schauer <mschauer@fairfield.com>
` Re: hyper slow after upgrade to 8.1.4
  2006-07-13 13:54 UTC  Michael Fuhr <mike@fuhr.org>
` Re: hyper slow after upgrade to 8.1.4
  2006-07-13 17:11 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: hyper slow after upgrade to 8.1.4
  2006-07-13 18:25 UTC  Medora Schauer <mschauer@fairfield.com>
  [7+ messages in thread]

Commit 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]


[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