pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedsub select performance due to seq scans
2006-07-31 01:50 UTC H Hale <hhale21@rogers.com>
` Re: sub select performance due to seq scans
2006-07-31 09:20 UTC Richard Huxton <dev@archonet.com>
` Re: sub select performance due to seq scans
2006-07-31 12:09 UTC Rod Taylor <rbt@rbt.ca>
` Re: sub select performance due to seq scans
2006-07-31 12:53 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: sub select performance due to seq scans
2006-07-31 14:14 UTC H Hale <hhale21@rogers.com>
` Re: sub select performance due to seq scans
2006-07-31 14:28 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: sub select performance due to seq scans
2006-07-31 16:09 UTC H Hale <hhale21@rogers.com>
` Re: sub select performance due to seq scans
2006-08-01 23:07 UTC H Hale <hhale21@rogers.com>
` Re: sub select performance due to seq scans
2006-08-02 12:17 UTC H Hale <hhale21@rogers.com>
` Re: sub select performance due to seq scans
2006-08-02 16:48 UTC Scott Marlowe <smarlowe@g2switchworks.com>
` Re: sub select performance due to seq scans
2006-08-07 13:32 UTC Markus Schaber <schabi@logix-tt.com>
[11+ messages in thread]
Disk writes
2006-07-28 01:25 UTC carlosreimer <carlosreimer@terra.com.br>
` Re: Disk writes
2006-07-28 06:32 UTC Florian Weimer <fweimer@bfk.de>
` Re: Disk writes
2006-07-28 14:03 UTC Scott Marlowe <smarlowe@g2switchworks.com>
` Re: Disk writes
2006-08-07 11:51 UTC Markus Schaber <schabi@logix-tt.com>
[4+ messages in thread]
Query Plan - Bitmap Index Scan and Views
2006-08-04 22:37 UTC Rusty Conover <rconover@infogears.com>
` Re: Query Plan - Bitmap Index Scan and Views
2006-08-05 02:15 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Query Plan - Bitmap Index Scan and Views
2006-08-05 02:56 UTC Rusty Conover <rconover@infogears.com>
` Re: Query Plan - Bitmap Index Scan and Views
2006-08-05 03:27 UTC Tom Lane <tgl@sss.pgh.pa.us>
[4+ messages in thread]
FW: XFS filessystem for Datawarehousing -2
2006-08-01 22:19 UTC Milen Kulev <makulev@gmx.net>
` Re: XFS filessystem for Datawarehousing -2
2006-08-02 02:44 UTC Luke Lonergan <llonergan@greenplum.com>
` Re: XFS filessystem for Datawarehousing -2
2006-08-03 05:36 UTC Denis Lussier <denisl@enterprisedb.com>
` Re: XFS filessystem for Datawarehousing -2
2006-08-03 19:56 UTC Milen Kulev <makulev@gmx.net>
` Re: XFS filessystem for Datawarehousing -2
2006-08-03 21:00 UTC Chris Browne <cbbrowne@acm.org>
` Re: XFS filessystem for Datawarehousing -2
2006-08-04 20:13 UTC Denis Lussier <denisl@enterprisedb.com>
[6+ messages in thread]
RAID stripe size question
2006-07-16 22:52 UTC Mikael Carneholm <Mikael.Carneholm@WirelessCar.com>
` Re: RAID stripe size question
2006-07-16 23:10 UTC Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: RAID stripe size question
2006-07-17 00:03 UTC Michael Stone <mstone+postgres@mathom.us>
` Re: RAID stripe size question
2006-07-17 06:13 UTC Alex Turner <armtuk@gmail.com>
` Re: RAID stripe size question
2006-07-17 08:00 UTC Mikael Carneholm <Mikael.Carneholm@WirelessCar.com>
` Re: RAID stripe size question
2006-07-17 09:47 UTC Markus Schaber <schabi@logix-tt.com>
` Re: RAID stripe size question
2006-07-17 11:33 UTC Mikael Carneholm <Mikael.Carneholm@WirelessCar.com>
` Re: RAID stripe size question
2006-07-17 11:40 UTC Markus Schaber <schabi@logix-tt.com>
` Re: RAID stripe size question
2006-07-17 12:52 UTC Mikael Carneholm <Mikael.Carneholm@WirelessCar.com>
` Re: RAID stripe size question
2006-07-17 13:40 UTC Ron Peacetree <rjpeace@earthlink.net>
` Re: RAID stripe size question
2006-07-17 14:51 UTC Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: RAID stripe size question
2006-07-17 15:23 UTC Alex Turner <armtuk@gmail.com>
` Re: RAID stripe size question
2006-07-17 21:16 UTC Mikael Carneholm <Mikael.Carneholm@WirelessCar.com>
` Re: RAID stripe size question
2006-07-18 00:22 UTC Mark Kirkwood <markir@paradise.net.nz>
` Re: RAID stripe size question
2006-07-18 03:07 UTC Ron Peacetree <rjpeace@earthlink.net>
` Re: RAID stripe size question
2006-07-18 04:21 UTC Alex Turner <armtuk@gmail.com>
` Re: RAID stripe size question
2006-07-18 12:32 UTC Ron Peacetree <rjpeace@earthlink.net>
` Re: RAID stripe size question
2006-07-18 13:34 UTC Mikael Carneholm <Mikael.Carneholm@WirelessCar.com>
` Re: RAID stripe size question
2006-07-18 18:56 UTC Luke Lonergan <llonergan@greenplum.com>
` Re: RAID stripe size question
2006-07-18 19:27 UTC Alex Turner <armtuk@gmail.com>
` Re: RAID stripe size question
2006-07-18 19:37 UTC Scott Marlowe <smarlowe@g2switchworks.com>
` Re: RAID stripe size question
2006-07-18 19:43 UTC Ron Peacetree <rjpeace@earthlink.net>
` Re: RAID stripe size question
2006-07-18 19:48 UTC Scott Marlowe <smarlowe@g2switchworks.com>
` Re: RAID stripe size question
2006-07-18 20:01 UTC Milen Kulev <makulev@gmx.net>
` Re: RAID stripe size question
2006-08-03 04:46 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: RAID stripe size question
2006-08-03 04:51 UTC Luke Lonergan <LLonergan@greenplum.com>
` Re: RAID stripe size question
2006-08-03 20:36 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: RAID stripe size question
2006-08-04 08:08 UTC Mikael Carneholm <Mikael.Carneholm@WirelessCar.com>
[28+ messages in thread]
Partitioning / constrain exlusion not working with %-operator
2006-07-31 12:17 UTC Martin Lesser <ml-pgsql@bettercom.de>
` Re: Partitioning / constrain exlusion not working with %-operator
2006-07-31 12:42 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Partitioning / constrain exlusion not working with %-operator
2006-08-04 07:36 UTC Martin Lesser <ml-pgsql@bettercom.de>
[3+ messages in thread]
(no subject)
2006-08-03 18:33 UTC Jim Nasby <jnasby@pervasive.com>
` Re:
2006-08-03 19:15 UTC Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re:
2006-08-03 19:29 UTC Chris Hoover <revoohc@gmail.com>
` Re:
2006-08-03 19:30 UTC Ian Westmacott <ianw@intellivid.com>
` Re:
2006-08-03 20:31 UTC Chris Hoover <revoohc@gmail.com>
` Re:
2006-08-03 20:55 UTC Ian Westmacott <ianw@intellivid.com>
[6+ messages in thread]
Strange behaviour
2006-07-27 21:37 UTC Richard Rowell <richard@bowmansystems.com>
` Re: Strange behaviour
2006-08-03 16:39 UTC Tom Lane <tgl@sss.pgh.pa.us>
[2+ messages in thread]
PITR performance overhead?
2006-08-01 16:15 UTC George Pavlov <gpavlov@mynewplace.com>
` Re: PITR performance overhead?
2006-08-01 16:59 UTC Bill Moran <wmoran@collaborativefusion.com>
` Re: PITR performance overhead?
2006-08-02 01:17 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: PITR performance overhead?
2006-08-03 05:21 UTC Denis Lussier <denisl@enterprisedb.com>
[4+ messages in thread]
Performances with new Intel Core* processors
2006-07-31 12:53 UTC Jonathan Ballet <jon@multani.info>
` Re: Performances with new Intel Core* processors
2006-07-31 15:52 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Performances with new Intel Core* processors
2006-07-31 16:30 UTC Arjen van der Meijden <acmmailing@tweakers.net>
` Re: Performances with new Intel Core* processors
2006-07-31 19:57 UTC Bruce Momjian <bruce@momjian.us>
` Re: Performances with new Intel Core* processors
2006-07-31 20:27 UTC Scott Marlowe <smarlowe@g2switchworks.com>
` Re: Performances with new Intel Core* processors
2006-07-31 21:04 UTC Vivek Khera <vivek@khera.org>
` Re: Performances with new Intel Core* processors
2006-08-01 04:26 UTC Luke Lonergan <llonergan@greenplum.com>
` Re: Performances with new Intel Core* processors
2006-08-01 07:28 UTC Florian Weimer <fweimer@bfk.de>
` Re: Performances with new Intel Core* processors
2006-08-03 05:08 UTC Denis Lussier <denisl@enterprisedb.com>
[9+ messages in thread]
Query/database optimization
2006-08-01 13:18 UTC Eugeny N Dzhurinsky <bofh@redwerk.com>
` Re: Query/database optimization
2006-08-02 03:15 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Query/database optimization
2006-08-02 10:56 UTC Eugeny N Dzhurinsky <bofh@redwerk.com>
[3+ messages in thread]
How to speed up this "translation" query?
2006-08-01 18:09 UTC tlm <tlm1905@gmail.com>
` Re: How to speed up this "translation" query?
2006-08-01 18:38 UTC Niklas Johansson <spot@tele2.se>
[2+ messages in thread]
Savepoint performance
2006-07-27 17:19 UTC Mark Lewis <mark.lewis@mir3.com>
` Re: Savepoint performance
2006-07-27 19:35 UTC Alvaro Herrera <alvherre@commandprompt.com>
` Re: Savepoint performance
2006-07-28 00:52 UTC Jaime Casanova <systemguards@gmail.com>
` Re: Savepoint performance
2006-07-28 01:13 UTC Denis Lussier <denisl@enterprisedb.com>
` Re: Savepoint performance
2006-07-28 01:34 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Savepoint performance
2006-07-28 02:33 UTC Denis Lussier <denisl@enterprisedb.com>
` Re: Fwd: Savepoint performance
2006-08-01 13:09 UTC Ernest Nishiseki <ernie@enterprisedb.com>
[7+ messages in thread]
Are there any performance penalty for opposite edian platform combinations....
2006-08-01 05:01 UTC Guoping Zhang <guoping.zhang@nec.com.au>
` Re: Are there any performance penalty for opposite edian platform combinations....
2006-08-01 12:10 UTC Tom Lane <tgl@sss.pgh.pa.us>
[2+ messages in thread]
directory tree query with big planner variation
2006-07-31 10:48 UTC Axel Rau <Axel.Rau@Chaos1.DE>
` Re: directory tree query with big planner variation
2006-07-31 11:15 UTC Michael Stone <mstone+postgres@mathom.us>
` Re: directory tree query with big planner variation
2006-07-31 11:54 UTC Axel Rau <Axel.Rau@Chaos1.DE>
` Re: directory tree query with big planner variation
2006-07-31 13:30 UTC Michael Stone <mstone+postgres@mathom.us>
` Re: directory tree query with big planner variation
2006-07-31 13:53 UTC Mark Lewis <mark.lewis@mir3.com>
` Re: directory tree query with big planner variation
2006-07-31 15:06 UTC Axel Rau <Axel.Rau@Chaos1.DE>
` Re: directory tree query with big planner variation
2006-07-31 15:21 UTC Michael Stone <mstone+postgres@mathom.us>
` Re: directory tree query with big planner variation
2006-07-31 15:54 UTC Axel Rau <Axel.Rau@Chaos1.DE>
` Re: directory tree query with big planner variation
2006-07-31 16:19 UTC Axel Rau <Axel.Rau@Chaos1.DE>
` Re: directory tree query with big planner variation
2006-07-31 16:20 UTC Axel Rau <Axel.Rau@Chaos1.DE>
` Re: directory tree query with big planner variation
2006-07-31 17:08 UTC Michael Stone <mstone+postgres@mathom.us>
` Re: directory tree query with big planner variation
2006-07-31 18:49 UTC Axel Rau <Axel.Rau@Chaos1.DE>
[12+ messages in thread]
Query 200x slower on server [PART 2]
2006-07-27 16:45 UTC NbForYou <nbforyou@hotmail.com>
` Re: Query 200x slower on server [PART 2]
2006-07-31 09:26 UTC Richard Huxton <dev@archonet.com>
[2+ messages in thread]
How to increase performance?
2006-07-27 16:29 UTC Hristo Markov <hristomarkov@yahoo.com>
` Re: How to increase performance?
2006-07-31 09:23 UTC Richard Huxton <dev@archonet.com>
[2+ messages in thread]
performance issue with a specific query
2006-07-27 14:23 UTC Eliott <eliott100@gmail.com>
` Re: performance issue with a specific query
2006-07-27 14:46 UTC Scott Marlowe <smarlowe@g2switchworks.com>
` Re: performance issue with a specific query
2006-07-27 14:52 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: performance issue with a specific query
2006-07-27 15:39 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: performance issue with a specific query
2006-07-27 17:25 UTC Alvaro Herrera <alvherre@commandprompt.com>
` Re: performance issue with a specific query
2006-07-27 20:18 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: performance issue with a specific query
2006-07-28 10:04 UTC Eliott <eliott100@gmail.com>
[7+ messages in thread]
Query plan issue when upgrading to postgres 8.14 (from postgres 8.12 or 7.4)
2006-07-06 20:06 UTC Ioana Danes <ioanasoftware@yahoo.ca>
` Query plan issue when upgrading to postgres 8.14 (from postgres 8.12 or 7.4)
2006-07-06 21:34 UTC Ioana Danes <ioanasoftware@yahoo.ca>
` Re: Query plan issue when upgrading to postgres 8.14 (from
2006-07-07 01:51 UTC Chris <dmagick@gmail.com>
` Re: Query plan issue when upgrading to postgres 8.14 (from
2006-07-18 16:02 UTC Ioana Danes <ioanasoftware@yahoo.ca>
` Re: Query plan issue when upgrading to postgres 8.14 (from
2006-07-27 18:55 UTC Ioana Danes <ioanasoftware@yahoo.ca>
` Re: Query plan issue when upgrading to postgres 8.14 (from
2006-07-27 22:22 UTC Tom Lane <tgl@sss.pgh.pa.us>
[6+ messages in thread]
Is it possible to speed this query up?
2006-07-26 17:01 UTC Arnau <arnaulist@andromeiberica.com>
` Re: Is it possible to speed this query up?
2006-07-26 20:24 UTC Tom Lane <tgl@sss.pgh.pa.us>
[2+ messages in thread]
loading increase into huge table with 50.000.000 records
2006-07-26 15:34 UTC nuggets72@free.fr
` Re: loading increase into huge table with 50.000.000 records
2006-07-26 16:02 UTC Sven Geisler <sgeisler@aeccom.com>
` Re: loading increase into huge table with 50.000.000 records
2006-07-26 16:39 UTC Markus Schaber <schabi@logix-tt.com>
` Re: loading increase into huge table with 50.000.000 records
2006-07-26 16:56 UTC Merlin Moncure <mmoncure@gmail.com>
[4+ messages in thread]
Partitioned tables in queries
2006-07-21 19:17 UTC Kevin Keith <kkeith@borderware.com>
` Re: Partitioned tables in queries
2006-07-21 19:34 UTC Steve Atkins <steve@blighty.com>
` Re: Partitioned tables in queries
2006-07-21 20:28 UTC Kevin Keith <kkeith@borderware.com>
` Re: Partitioned tables in queries
2006-07-25 20:48 UTC Andrew Hammond <andrew.george.hammond@gmail.com>
[4+ messages in thread]
BUG #2543: Performance delay acrros the same day
2006-07-21 07:41 UTC Alaa El Gohary <alaaelgohary@bftech.com.eg>
` Re: BUG #2543: Performance delay acrros the same day
2006-07-21 18:33 UTC Bruno Wolff III <bruno@wolff.to>
` Re: BUG #2543: Performance delay acrros the same day
2006-07-24 07:54 UTC Markus Schaber <schabi@logix-tt.com>
[3+ messages in thread]
Sun Donated a Sun Fire T2000 to the PostgreSQL community
2006-06-16 15:18 UTC Robert Lor <Robert.Lor@Sun.COM>
` Re: Sun Donated a Sun Fire T2000 to the PostgreSQL community
2006-06-16 17:01 UTC Josh Berkus <josh@agliodbs.com>
` Re: Sun Donated a Sun Fire T2000 to the PostgreSQL community
2006-06-16 22:34 UTC Arjen van der Meijden <acmmailing@tweakers.net>
` Re: [HACKERS] Sun Donated a Sun Fire T2000 to the PostgreSQL community
2006-06-16 23:24 UTC Josh Berkus <josh@agliodbs.com>
` Re: Sun Donated a Sun Fire T2000 to the PostgreSQL
2006-06-17 01:15 UTC Tatsuo Ishii <ishii@sraoss.co.jp>
` Re: Sun Donated a Sun Fire T2000 to the PostgreSQL
2006-06-17 02:18 UTC Tatsuo Ishii <ishii@sraoss.co.jp>
` Re: Sun Donated a Sun Fire T2000 to the PostgreSQL
2006-06-17 02:34 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Sun Donated a Sun Fire T2000 to the PostgreSQL community
2006-06-17 04:17 UTC Robert Lor <Robert.Lor@Sun.COM>
` Re: [HACKERS] Sun Donated a Sun Fire T2000 to the PostgreSQL
2006-06-17 19:19 UTC Josh Berkus <josh@agliodbs.com>
` Re: Sun Donated a Sun Fire T2000 to the PostgreSQL community
2006-06-17 19:53 UTC Jim Nasby <jnasby@pervasive.com>
` Re: Sun Donated a Sun Fire T2000 to the PostgreSQL community
2006-06-17 19:54 UTC Jim Nasby <decibel@decibel.org>
` Re: [HACKERS] Sun Donated a Sun Fire T2000 to the PostgreSQL
2006-06-17 21:46 UTC Andrew Dunstan <andrew@dunslane.net>
` Re: [HACKERS] Sun Donated a Sun Fire T2000 to the PostgreSQL
2006-06-18 09:17 UTC Arjen van der Meijden <acmmailing@tweakers.net>
` Re: [HACKERS] Sun Donated a Sun Fire T2000 to the PostgreSQL
2006-06-22 13:03 UTC David Roussel <pgsql-performance@diroussel.xsmail.com>
` Re: [HACKERS] Sun Donated a Sun Fire T2000 to the PostgreSQL
2006-06-22 14:03 UTC Craig A. James <cjames@modgraph-usa.com>
` Re: [HACKERS] Sun Donated a Sun Fire T2000 to the PostgreSQL
2006-06-22 14:19 UTC Arjen van der Meijden <acmmailing@tweakers.net>
` Re: Sun Donated a Sun Fire T2000 to the PostgreSQL
2006-07-13 09:02 UTC Tatsuo Ishii <ishii@sraoss.co.jp>
` Re: Sun Donated a Sun Fire T2000 to the PostgreSQL
2006-07-13 14:44 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Sun Donated a Sun Fire T2000 to the PostgreSQL
2006-07-20 19:01 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Sun Donated a Sun Fire T2000 to the PostgreSQL
2006-07-21 07:56 UTC Robert Lor <Robert.Lor@Sun.COM>
` Re: Sun Donated a Sun Fire T2000 to the PostgreSQL
2006-07-21 13:42 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [HACKERS] Sun Donated a Sun Fire T2000 to the PostgreSQL
2006-07-21 13:56 UTC Jim C. Nasby <jnasby@pervasive.com>
` Re: [HACKERS] Sun Donated a Sun Fire T2000 to the PostgreSQL
2006-07-21 14:59 UTC Sven Geisler <sgeisler@aeccom.com>
` Re: Sun Donated a Sun Fire T2000 to the PostgreSQL
2006-07-21 15:11 UTC Robert Lor <Robert.Lor@Sun.COM>
` Re: Sun Donated a Sun Fire T2000 to the PostgreSQL
2006-07-22 03:05 UTC Robert Lor <Robert.Lor@Sun.COM>
` Re: Sun Donated a Sun Fire T2000 to the PostgreSQL
2006-07-23 18:10 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Sun Donated a Sun Fire T2000 to the PostgreSQL
2006-07-23 23:52 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Sun Donated a Sun Fire T2000 to the PostgreSQL
2006-07-24 00:52 UTC Robert Lor <Robert.Lor@Sun.COM>
` Re: Sun Donated a Sun Fire T2000 to the PostgreSQL
2006-07-24 01:29 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Sun Donated a Sun Fire T2000 to the PostgreSQL
2006-07-24 03:34 UTC Robert Lor <Robert.Lor@Sun.COM>
[30+ messages in thread]
postgres benchmarks
2006-07-21 13:35 UTC Petronenko D.S. <petronenko@gmail.com>
` Re: postgres benchmarks
2006-07-23 23:47 UTC Denis Lussier <denisl@enterprisedb.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