pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedUpdate 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