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