pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedToo slow query, do you have an idea to optimize?
2005-09-09 06:32 UTC Choe, Cheng-Dae <whitekid@gmail.com>
` Re: Too slow query, do you have an idea to optimize?
2005-09-09 07:00 UTC Christopher Kings-Lynne <chriskl@familyhealth.com.au>
[2+ messages in thread]
Poor performance of delete by primary key
2005-09-06 15:04 UTC Brian Choate <brianc@nimblefish.com>
` Re: Poor performance of delete by primary key
2005-09-06 15:32 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Poor performance of delete by primary key
2005-09-06 15:43 UTC Matthew Sackman <matthew@lshift.net>
` Re: Poor performance of delete by primary key
2005-09-06 15:51 UTC Richard Huxton <dev@archonet.com>
` Re: Poor performance of delete by primary key
2005-09-06 17:04 UTC Mark Lewis <mark.lewis@mir3.com>
` Re: Poor performance of delete by primary key
2005-09-06 17:42 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Poor performance of delete by primary key
2005-09-07 03:07 UTC Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: Poor performance of delete by primary key
2005-09-07 21:38 UTC Jim C. Nasby <jnasby@pervasive.com>
[8+ messages in thread]
Query take 101 minutes, help, please
2005-09-07 16:22 UTC Christian Compagnon <ccompagnon@gmail.com>
` Re: Query take 101 minutes, help, please
2005-09-07 16:57 UTC Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Query take 101 minutes, help, please
2005-09-07 17:09 UTC Meetesh Karia <meetesh.karia@gmail.com>
` Re: Query take 101 minutes, help, please
2005-09-07 17:57 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Query take 101 minutes, help, please
2005-09-07 18:40 UTC Alex Hayward <xelah-pgsql@xelah.com>
[5+ messages in thread]
Postgresql Hardware - Recommendations
2005-09-05 13:50 UTC Christian.Kastner@gutmann.at
` Re: Postgresql Hardware - Recommendations
2005-09-06 07:03 UTC J. Andrew Rogers <jrogers@neopolitan.com>
` Re: Postgresql Hardware - Recommendations
2005-09-06 15:09 UTC Matthew Nuzum <mattnuzum@gmail.com>
` Re: Postgresql Hardware - Recommendations
2005-09-07 09:04 UTC Christian.Kastner@gutmann.at
[4+ messages in thread]
poor VACUUM performance on large tables
2005-09-04 06:16 UTC Jan Peterson <jan.l.peterson@gmail.com>
` Re: poor VACUUM performance on large tables
2005-09-04 14:58 UTC Thomas F. O'Connell <tfo@sitening.com>
` Re: poor VACUUM performance on large tables
2005-09-04 23:01 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: poor VACUUM performance on large tables
2005-09-07 00:54 UTC Jan Peterson <jan.l.peterson@gmail.com>
` Re: poor VACUUM performance on large tables
2005-09-07 01:07 UTC Tom Lane <tgl@sss.pgh.pa.us>
[5+ messages in thread]
log_duration times
2005-09-06 20:34 UTC Carlos Henrique Reimer <carlosreimer@yahoo.com.br>
Massive performance issues
2005-09-01 17:42 UTC Matthew Sackman <matthew@lshift.net>
` Re: Massive performance issues
2005-09-01 18:04 UTC Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: Massive performance issues
2005-09-01 18:10 UTC Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: Massive performance issues
2005-09-01 18:42 UTC Joel Fradkin <jfradkin@wazagua.com>
` Re: Massive performance issues
2005-09-01 18:47 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Massive performance issues
2005-09-01 18:52 UTC Matthew Sackman <matthew@lshift.net>
` Re: Massive performance issues
2005-09-01 19:08 UTC Matthew Sackman <matthew@lshift.net>
` Re: Massive performance issues
2005-09-01 19:33 UTC Alvaro Herrera <alvherre@alvh.no-ip.org>
` Re: Massive performance issues
2005-09-01 19:43 UTC Ron <rjpeace@earthlink.net>
` Re: Massive performance issues
2005-09-01 19:51 UTC Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: Massive performance issues
2005-09-01 19:53 UTC Alvaro Herrera <alvherre@alvh.no-ip.org>
` Re: Massive performance issues
2005-09-01 20:09 UTC Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Massive performance issues
2005-09-01 20:25 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Massive performance issues
2005-09-01 20:39 UTC Sebastian Hennebrueder <usenet@laliluna.de>
` Re: Massive performance issues
2005-09-01 20:54 UTC Arjen van der Meijden <acmmailing@tweakers.net>
` Re: Massive performance issues
2005-09-01 21:05 UTC Ron <rjpeace@earthlink.net>
` Re: Massive performance issues
2005-09-01 21:06 UTC Matthew Sackman <matthew@lshift.net>
` Re: Massive performance issues
2005-09-01 21:13 UTC Matthew Sackman <matthew@lshift.net>
` Re: Massive performance issues
2005-09-01 21:26 UTC Jeff Frost <jeff@frostconsultingllc.com>
` Re: Massive performance issues
2005-09-01 21:52 UTC Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Massive performance issues
2005-09-01 22:00 UTC Matthew Sackman <matthew@lshift.net>
` Re: Massive performance issues
2005-09-01 22:01 UTC Matthew Sackman <matthew@lshift.net>
` Re: Massive performance issues
2005-09-01 22:05 UTC Ron <rjpeace@earthlink.net>
` Re: Massive performance issues
2005-09-01 22:22 UTC Matthew Sackman <matthew@lshift.net>
` Re: Massive performance issues
2005-09-01 22:34 UTC Michael Fuhr <mike@fuhr.org>
` Re: Massive performance issues
2005-09-01 23:09 UTC Ron <rjpeace@earthlink.net>
` Re: Massive performance issues
2005-09-02 03:19 UTC Mark Kirkwood <markir@paradise.net.nz>
` Re: Massive performance issues
2005-09-02 04:24 UTC Mark Kirkwood <markir@paradise.net.nz>
` Re: Massive performance issues
2005-09-02 09:23 UTC Akshay Mathur <akshay.mathur@airtightnetworks.net>
` Re: Massive performance issues
2005-09-02 16:50 UTC Josh Berkus <josh@agliodbs.com>
` Re: Massive performance issues
2005-09-02 18:00 UTC Chris Travers <chris@travelamericas.com>
` Re: Massive performance issues
2005-09-03 01:22 UTC Mark Kirkwood <markir@paradise.net.nz>
` Re: Massive performance issues
2005-09-06 15:51 UTC Matthew Sackman <matthew@lshift.net>
[33+ messages in thread]
Improving performance of a query
2005-09-03 21:02 UTC Carlos Benkendorf <carlosbenkendorf@yahoo.com.br>
` Re: Improving performance of a query
2005-09-03 22:11 UTC Michael Fuhr <mike@fuhr.org>
` Re: Improving performance of a query
2005-09-06 12:59 UTC Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: Improving performance of a query
2005-09-06 14:09 UTC Stephan Szabo <sszabo@megazone.bigpanda.com>
` Re: Improving performance of a query
2005-09-06 14:47 UTC Merlin Moncure <merlin.moncure@rcsonline.com>
[5+ messages in thread]
When to do a vacuum for highly active table
2005-08-30 21:13 UTC Markus Benne <thing@m-bass.com>
` Re: When to do a vacuum for highly active table
2005-08-30 21:25 UTC Rigmor Ukuhe <rigmor.ukuhe@finestmedia.ee>
` Re: When to do a vacuum for highly active table
2005-08-30 21:29 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: When to do a vacuum for highly active table
2005-08-30 22:05 UTC mark@mark.mielke.cc
` Re: When to do a vacuum for highly active table
2005-08-30 22:05 UTC Chris Browne <cbbrowne@acm.org>
` Re: When to do a vacuum for highly active table
2005-08-30 23:05 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: When to do a vacuum for highly active table
2005-09-06 12:48 UTC Chris Browne <cbbrowne@acm.org>
[7+ messages in thread]
Query slow after VACUUM ANALYZE
2005-08-31 10:22 UTC gdh@eyjar.is
` Re: Query slow after VACUUM ANALYZE
2005-08-31 10:26 UTC gdh@eyjar.is
` Re: Query slow after VACUUM ANALYZE
2005-09-06 03:53 UTC Tom Lane <tgl@sss.pgh.pa.us>
[3+ messages in thread]
Re: Poor performance on HP Package Cluster
2005-09-01 13:27 UTC Ron <rjpeace@earthlink.net>
` Poor performance on HP Package Cluster
2005-09-01 14:16 UTC Ernst Einstein <Crusader@gmx.ch>
` Re: Poor performance on HP Package Cluster
2005-09-01 20:24 UTC Luke Lonergan <llonergan@greenplum.com>
` Re: Poor performance on HP Package Cluster
2005-09-01 23:02 UTC Dan Harris <fbsd@drivefaster.net>
` Re: Poor performance on HP Package Cluster
2005-09-02 04:54 UTC Luke Lonergan <llonergan@greenplum.com>
` Re: Poor performance on HP Package Cluster
2005-09-04 15:47 UTC Ernst Einstein <Crusader@gmx.ch>
` Re: Poor performance on HP Package Cluster
2005-09-04 17:19 UTC Luke Lonergan <llonergan@greenplum.com>
[7+ messages in thread]
Poor SQL performance
2005-09-02 16:12 UTC Patrick Hatcher <PHatcher@macys.com>
` Re: Poor SQL performance
2005-09-02 22:56 UTC Alexander Kirpa <postgres@bilteks.com>
[2+ messages in thread]
ORDER BY and LIMIT not propagated on inherited tables / UNIONs
2005-09-02 10:20 UTC Matteo Beccati <php@beccati.com>
` Re: ORDER BY and LIMIT not propagated on inherited
2005-09-02 12:35 UTC Simon Riggs <simon@2ndquadrant.com>
` Re: ORDER BY and LIMIT not propagated on inherited
2005-09-02 12:54 UTC Matteo Beccati <php@beccati.com>
` Re: ORDER BY and LIMIT not propagated on inherited
2005-09-02 14:40 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: ORDER BY and LIMIT not propagated on inherited
2005-09-02 15:00 UTC Matteo Beccati <php@beccati.com>
` Re: ORDER BY and LIMIT not propagated on inherited
2005-09-02 15:09 UTC Jens-Wolfhard Schicke <ml+pgsql-performance@asco.de>
` Re: ORDER BY and LIMIT not propagated on inherited
2005-09-02 17:54 UTC Simon Riggs <simon@2ndquadrant.com>
` Re: ORDER BY and LIMIT not propagated on inherited
2005-09-02 18:33 UTC Matteo Beccati <php@beccati.com>
` Re: ORDER BY and LIMIT not propagated on inherited
2005-09-02 20:08 UTC Ramesh kumar <mbrameshkumar@gmail.com>
[9+ messages in thread]
Avoid using swap in a cluster
2005-09-02 01:04 UTC Ricardo Humphreys <ricardoainati@gmail.com>
` Re: Avoid using swap in a cluster
2005-09-02 09:42 UTC Richard Huxton <dev@archonet.com>
` Re: Avoid using swap in a cluster
2005-09-02 11:18 UTC Alex Stapleton <alexs@advfn.com>
[3+ messages in thread]
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]
[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