pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Update is more affected( taking more time) than Select ( if Auto vacuum is not running)
  2005-09-02 03:51 UTC  Hemant Pandey <hemant.pandey@flextronicssoftware.com>
` Re: Update is more affected( taking more time) than Select
  2005-09-02 09:48 UTC  Richard Huxton <dev@archonet.com>
  [2+ messages in thread]

(no subject)
  2005-09-02 05:12 UTC  apoc9009@yahoo.de <apoc9009@yahoo.de>

lots of updates on small table
  2005-07-14 05:08 UTC  Alison Winters <alison@mirrabooka.com>
` Re: lots of updates on small table
  2005-07-14 16:21 UTC  Alvaro Herrera <alvherre@alvh.no-ip.org>
` Re: lots of updates on small table
  2005-07-14 16:37 UTC  Rod Taylor <pg@rbt.ca>
` Re: lots of updates on small table
  2005-07-14 23:42 UTC  Alison Winters <alison@mirrabooka.com>
` Re: lots of updates on small table
  2005-07-14 23:52 UTC  John A Meinel <john@arbash-meinel.com>
` Re: lots of updates on small table
  2005-07-14 23:57 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: lots of updates on small table
  2005-07-15 00:28 UTC  Alvaro Herrera <alvherre@alvh.no-ip.org>
` Re: lots of updates on small table
  2005-07-15 00:37 UTC  Alvaro Herrera <alvherre@alvh.no-ip.org>
` Re: lots of updates on small table
  2005-07-15 02:26 UTC  Alison Winters <alison@mirrabooka.com>
` Re: lots of updates on small table
  2005-09-01 23:23 UTC  Alison Winters <alison@mirrabooka.com>
  [10+ messages in thread]

Need for speed 3
  2005-09-01 13:25 UTC  Ulrich Wisser <ulrich.wisser@relevanttraffic.se>
` Re: Need for speed 3
  2005-09-01 13:42 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: Need for speed 3
  2005-09-01 14:06 UTC  Ulrich Wisser <ulrich.wisser@relevanttraffic.se>
` Re: Need for speed 3
  2005-09-01 15:28 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: Need for speed 3
  2005-09-01 16:37 UTC  Luke Lonergan <llonergan@greenplum.com>
` Re: Need for speed 3
  2005-09-01 17:30 UTC  Nicholas E. Wakefield <nwakefield@KineticNetworks.com>
  [6+ messages in thread]

Big question on insert performance/using COPY FROM
  2005-08-31 19:17 UTC  Morgan Kita <mkita@verseon.com>
` Re: Big question on insert performance/using COPY FROM
  2005-09-01 10:45 UTC  Richard Huxton <dev@archonet.com>
  [2+ messages in thread]

Swapping
  2005-08-31 18:25 UTC  Carlos Henrique Reimer <carlosreimer@yahoo.com.br>
` Re: Swapping
  2005-08-31 18:49 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Swapping
  2005-08-31 19:22 UTC  Tobias Brox <tobias@nordicbet.com>
` Re: Swapping
  2005-08-31 19:33 UTC  Tobias Brox <tobias@nordicbet.com>
  [4+ messages in thread]

'Real' auto vacuum?
  2005-08-30 22:21 UTC  Ralph Mason <ralph.mason@telogis.com>
` Re: 'Real' auto vacuum?
  2005-08-30 22:35 UTC  mark@mark.mielke.cc
` Re: 'Real' auto vacuum?
  2005-08-30 22:58 UTC  Josh Berkus <josh@agliodbs.com>
` Re: 'Real' auto vacuum?
  2005-08-30 23:39 UTC  Ralph Mason <ralph.mason@telogis.com>
` Re: 'Real' auto vacuum?
  2005-08-31 05:17 UTC  Mindaugas Riauba <mind@bi.lt>
` Re: 'Real' auto vacuum?
  2005-08-31 13:51 UTC  Brad Nicholson <bnichols@ca.afilias.info>
  [6+ messages in thread]

RAID Configuration Sugestion
  2005-08-30 12:37 UTC  Alvaro Nunes Melo <al_nunes@atua.com.br>
` Re: RAID Configuration Sugestion
  2005-08-30 12:58 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: RAID Configuration Sugestion
  2005-08-30 13:50 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: RAID Configuration Sugestion
  2005-08-30 14:45 UTC  Ron <rjpeace@earthlink.net>
` Re: RAID Configuration Sugestion
  2005-08-30 16:10 UTC  Matthew Nuzum <mattnuzum@gmail.com>
` Re: RAID Configuration Sugestion
  2005-08-30 16:56 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: RAID Configuration Sugestion
  2005-08-30 18:16 UTC  Ron <rjpeace@earthlink.net>
` Re: RAID Configuration Sugestion
  2005-08-30 18:50 UTC  Matthew Nuzum <mattnuzum@gmail.com>
` Re: RAID Configuration Sugestion
  2005-08-30 19:27 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: RAID Configuration Sugestion
  2005-08-30 23:02 UTC  Ron <rjpeace@earthlink.net>
` Re: RAID Configuration Sugestion
  2005-08-31 00:04 UTC  Michael Stone <mstone+postgres@mathom.us>
` Re: RAID Configuration Sugestion
  2005-08-31 00:41 UTC  Ron <rjpeace@earthlink.net>
` Re: RAID Configuration Sugestion
  2005-08-31 00:43 UTC  Michael Stone <mstone+postgres@mathom.us>
` Re: RAID Configuration Sugestion
  2005-08-31 02:50 UTC  Ron <rjpeace@earthlink.net>
  [14+ messages in thread]

High load and iowait but no disk access
  2005-08-29 13:42 UTC  Rémy Beaumont <remyb@medrium.com>
` Re: High load and iowait but no disk access
  2005-08-30 16:15 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: High load and iowait but no disk access
  2005-08-30 16:19 UTC  Rémy Beaumont <remyb@medrium.com>
` Re: High load and iowait but no disk access
  2005-08-30 16:25 UTC  Michael Stone <mstone+postgres@mathom.us>
` Re: High load and iowait but no disk access
  2005-08-30 16:29 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: High load and iowait but no disk access
  2005-08-30 16:42 UTC  Rémy Beaumont <remyb@medrium.com>
` Re: High load and iowait but no disk access
  2005-08-30 18:30 UTC  Woody Woodring <george.woodring@iglass.net>
` Re: High load and iowait but no disk access
  2005-08-30 18:32 UTC  Josh Berkus <josh@agliodbs.com>
` Re: High load and iowait but no disk access
  2005-08-30 18:42 UTC  Rémy Beaumont <remyb@medrium.com>
` Re: High load and iowait but no disk access
  2005-08-30 18:46 UTC  Anjan Dave <adave@vantage.com>
` Re: High load and iowait but no disk access
  2005-08-30 18:50 UTC  Rémy Beaumont <remyb@medrium.com>
` Re: High load and iowait but no disk access
  2005-08-30 19:34 UTC  mudfoot@rawbw.com
  [12+ messages in thread]

Observation about db response time
  2005-08-27 15:58 UTC  akshay@airtightnetworks.net
` Observation about db response time
  2005-08-30 13:05 UTC  Akshay Mathur <akshay.mathur@airtightnetworks.net>
` Re: Observation about db response time
  2005-08-30 13:13 UTC  Frank Wiles <frank@wiles.org>
` Re: Observation about db response time
  2005-08-30 14:53 UTC  Vivek Khera <vivek@khera.org>
` Re: Observation about db response time
  2005-08-30 16:39 UTC  Jeffrey W. Baker <jwb@gghcwest.com>
` Re: Observation about db response time
  2005-08-30 18:36 UTC  george young <gry@ll.mit.edu>
  [6+ messages in thread]

Need indexes on empty tables for good performance ?
  2005-08-23 03:41 UTC  Lenard, Rohan (Rohan) <rlenard@avaya.com>
` Re: Need indexes on empty tables for good performance ?
  2005-08-27 06:19 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: Need indexes on empty tables for good performance ?
  2005-08-27 06:34 UTC  Chris Travers <chris@metatrontech.com>
` Re: Need indexes on empty tables for good performance ?
  2005-08-29 20:15 UTC  Thomas F. O'Connell <tfo@sitening.com>
` Re: Need indexes on empty tables for good performance ?
  2005-08-29 22:13 UTC  Lenard, Rohan (Rohan) <rlenard@avaya.com>
` Re: Need indexes on empty tables for good performance ?
  2005-08-30 17:43 UTC  Chris Travers <chris@travelamericas.com>
  [6+ messages in thread]

OSX & Performance
  2005-08-26 18:58 UTC  Jeff Trout <threshar@torgo.978.org>
` Re: OSX & Performance
  2005-08-28 20:00 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: OSX & Performance
  2005-08-29 17:27 UTC  Jeff Trout <threshar@torgo.978.org>
` Re: OSX & Performance
  2005-08-29 17:57 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: OSX & Performance
  2005-08-30 14:04 UTC  Jeff Trout <threshar@torgo.978.org>
  [5+ messages in thread]

How to improve Postgres performance
  2005-08-30 04:35 UTC  Hemant Pandey <hemant.pandey@flextronicssoftware.com>
` Re: How to improve Postgres performance
  2005-08-30 06:04 UTC  Dennis Bjorklund <db@zigo.dhs.org>
  [2+ messages in thread]

Weird performance drop after VACUUM
  2005-08-26 22:04 UTC  Ümit Öztosun <umit@likyabilisim.com>
` Re: Weird performance drop after VACUUM
  2005-08-26 22:52 UTC  asif ali <asif_icrossing@yahoo.com>
` Re: Weird performance drop after VACUUM
  2005-08-26 23:13 UTC  Philip Hallstrom <postgresql@philip.pjkh.com>
` Re: Weird performance drop after VACUUM
  2005-08-26 23:26 UTC  Michael Fuhr <mike@fuhr.org>
` Re: Weird performance drop after VACUUM
  2005-08-26 23:31 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Weird performance drop after VACUUM
  2005-08-27 00:10 UTC  asif ali <asif_icrossing@yahoo.com>
` Re: Weird performance drop after VACUUM
  2005-08-27 01:41 UTC  Michael Fuhr <mike@fuhr.org>
` Re: Weird performance drop after VACUUM
  2005-08-27 09:31 UTC  Umit Oztosun <umit@likyabilisim.com>
` Re: Weird performance drop after VACUUM
  2005-08-27 10:19 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Weird performance drop after VACUUM
  2005-08-27 15:05 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Weird performance drop after VACUUM
  2005-08-27 15:26 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Weird performance drop after VACUUM
  2005-08-27 15:40 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Weird performance drop after VACUUM
  2005-08-29 18:07 UTC  asif ali <asif_icrossing@yahoo.com>
` Re: Weird performance drop after VACUUM
  2005-08-29 20:28 UTC  Michael Fuhr <mike@fuhr.org>
` Re: Weird performance drop after VACUUM
  2005-08-29 22:59 UTC  asif ali <asif_icrossing@yahoo.com>
  [15+ messages in thread]

Performance for relative large DB
  2005-08-23 12:14 UTC  tobbe <tobbe@tripnet.se>
` Re: Performance for relative large DB
  2005-08-23 15:12 UTC  Chris Browne <cbbrowne@acm.org>
` Re: Performance for relative large DB
  2005-08-24 06:25 UTC  tobbe <tobbe@tripnet.se>
` Re: Performance for relative large DB
  2005-08-24 16:34 UTC  Chris Browne <cbbrowne@acm.org>
` Re: Performance for relative large DB
  2005-08-27 06:30 UTC  Chris Travers <chris@travelamericas.com>
` Re: Performance for relative large DB
  2005-08-29 21:09 UTC  Jim C. Nasby <jnasby@pervasive.com>
  [6+ messages in thread]

getting an index to work with partial indices ...
  2005-08-29 19:56 UTC  Marc G. Fournier <scrappy@postgresql.org>
` Re: getting an index to work with partial indices ...
  2005-08-29 20:19 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [2+ messages in thread]

Limit + group + join
  2005-08-26 00:27 UTC  Tobias Brox <tobias@nordicbet.com>
` Re: Limit + group + join
  2005-08-26 01:56 UTC  Jeffrey W. Baker <jwbaker@acm.org>
` Re: Limit + group + join
  2005-08-26 02:06 UTC  Tobias Brox <tobias@nordicbet.com>
` Re: Limit + group + join
  2005-08-26 02:31 UTC  Jeffrey W. Baker <jwbaker@acm.org>
` Re: Limit + group + join
  2005-08-26 03:01 UTC  Mark Kirkwood <markir@paradise.net.nz>
` Re: Limit + group + join
  2005-08-26 06:20 UTC  Tobias Brox <tobias@nordicbet.com>
` Re: Limit + group + join
  2005-08-26 14:18 UTC  Stephan Szabo <sszabo@megazone.bigpanda.com>
` Re: Limit + group + join
  2005-08-26 14:49 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: Limit + group + join
  2005-08-26 15:46 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Limit + group + join
  2005-08-26 23:29 UTC  Mark Kirkwood <markir@paradise.net.nz>
` Re: Limit + group + join
  2005-08-26 23:48 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Limit + group + join
  2005-08-27 02:55 UTC  Mark Kirkwood <markir@paradise.net.nz>
` Re: Limit + group + join
  2005-08-27 03:03 UTC  Greg Stark <gsstark@mit.edu>
` Re: Limit + group + join
  2005-08-27 22:17 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Limit + group + join
  2005-08-28 00:48 UTC  Mark Kirkwood <markir@paradise.net.nz>
` Re: Limit + group + join
  2005-08-28 01:42 UTC  Tobias Brox <tobias@nordicbet.com>
` Re: Limit + group + join
  2005-08-29 18:41 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
  [17+ messages in thread]

Bitmap scan when it is not needed
  2005-08-28 20:48 UTC  Ilia Kantor <ilia@obnovlenie.ru>
` Re: Bitmap scan when it is not needed
  2005-08-28 22:49 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [2+ messages in thread]

Planner improvement suggestion
  2005-08-28 20:59 UTC  Ilia Kantor <ilia@obnovlenie.ru>
` Re: Planner improvement suggestion
  2005-08-28 21:30 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [2+ messages in thread]

intarray is broken ? (8.1b1)
  2005-08-28 20:41 UTC  Ilia Kantor <ilia@obnovlenie.ru>
` Re: intarray is broken ? (8.1b1)
  2005-08-28 21:24 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [2+ messages in thread]

Inefficient queryplan for query with intersectable subselects/joins
  2005-08-26 11:08 UTC  Arjen van der Meijden <acmmailing@tweakers.net>
` Re: Inefficient queryplan for query with intersectable
  2005-08-26 13:05 UTC  Richard Huxton <dev@archonet.com>
` Re: Inefficient queryplan for query with intersectable
  2005-08-26 21:16 UTC  Arjen van der Meijden <acmmailing@tweakers.net>
` Re: Inefficient queryplan for query with intersectable
  2005-08-26 22:56 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Inefficient queryplan for query with intersectable
  2005-08-27 10:50 UTC  Arjen van der Meijden <acmmailing@tweakers.net>
` Re: Inefficient queryplan for query with intersectable
  2005-08-27 14:27 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Inefficient queryplan for query with intersectable
  2005-08-28 14:44 UTC  Arjen van der Meijden <acmmailing@tweakers.net>
  [7+ messages in thread]

Re: Inefficient queryplan for query with
  2005-08-27 15:07 UTC  Ron <rjpeace@earthlink.net>

Sending a select to multiple servers.
  2005-08-26 15:24 UTC  Ligesh <gxlists@gmail.com>
` Re: Sending a select to multiple servers.
  2005-08-26 16:04 UTC  Frank Wiles <frank@wiles.org>
` Re: Sending a select to multiple servers.
  2005-08-26 16:11 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: Sending a select to multiple servers.
  2005-08-26 22:45 UTC  Ligesh <gxlists@gmail.com>
` Re: Sending a select to multiple servers.
  2005-08-26 22:51 UTC  Ligesh <gxlists@gmail.com>
  [5+ messages in thread]

How does the planner execute unions?
  2005-08-26 20:14 UTC  Chris Hoover <revoohc@gmail.com>
` Re: How does the planner execute unions?
  2005-08-26 20:45 UTC  Bruno Wolff III <bruno@wolff.to>
  [2+ messages in thread]

difference in plan between 8.0 and 8.1?
  2005-08-26 14:45 UTC  Alan Stange <stange@rentec.com>
` Re: difference in plan between 8.0 and 8.1?
  2005-08-26 15:12 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: difference in plan between 8.0 and 8.1?
  2005-08-26 15:16 UTC  Michael Fuhr <mike@fuhr.org>
` Re: difference in plan between 8.0 and 8.1?
  2005-08-26 15:16 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: difference in plan between 8.0 and 8.1?
  2005-08-26 19:01 UTC  Alan Stange <stange@rentec.com>
  [5+ 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