pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedLarge time difference between explain analyze and normal run
2005-02-10 18:34 UTC Chris Kratz <chris.kratz@vistashare.com>
` Re: Large time difference between explain analyze and normal run
2005-02-10 18:58 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Large time difference between explain analyze and normal run
2005-02-10 19:05 UTC Chris Kratz <chris.kratz@vistashare.com>
` Re: Large time difference between explain analyze and normal run
2005-02-10 20:09 UTC Darcy Buskermolen <darcy@wavefire.com>
` Re: Large time difference between explain analyze and normal run
2005-02-10 20:25 UTC Chris Kratz <chris.kratz@vistashare.com>
[5+ messages in thread]
How can I make use of both CPUs in a dual processor machine
2005-02-09 14:26 UTC Alex <alex@meerkatsoft.com>
` Re: How can I make use of both CPUs in a dual processor
2005-02-09 14:49 UTC John A Meinel <john@arbash-meinel.com>
` Re: How can I make use of both CPUs in a dual processor
2005-02-09 15:00 UTC Alex <alex@meerkatsoft.com>
` Re: How can I make use of both CPUs in a dual processor
2005-02-09 15:14 UTC Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: How can I make use of both CPUs in a dual processor
2005-02-09 15:16 UTC John A Meinel <john@arbash-meinel.com>
` Re: How can I make use of both CPUs in a dual processor
2005-02-10 01:50 UTC Iain <iain@mst.co.jp>
` Re: How can I make use of both CPUs in a dual processor
2005-02-10 13:18 UTC Alex <alex@meerkatsoft.com>
[7+ messages in thread]
GiST indexes and concurrency (tsearch2)
2005-02-03 04:55 UTC Marinos J. Yannikos <mjy@geizhals.at>
` Re: GiST indexes and concurrency (tsearch2)
2005-02-03 05:26 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: GiST indexes and concurrency (tsearch2)
2005-02-03 09:28 UTC Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: GiST indexes and concurrency (tsearch2)
2005-02-03 09:57 UTC Oleg Bartunov <oleg@sai.msu.su>
` Re: GiST indexes and concurrency (tsearch2)
2005-02-03 11:04 UTC Marinos J. Yannikos <mjy@geizhals.at>
` Re: GiST indexes and concurrency (tsearch2)
2005-02-03 12:11 UTC PFC <lists@boutiquenumerique.com>
` Re: GiST indexes and concurrency (tsearch2)
2005-02-03 12:16 UTC Oleg Bartunov <oleg@sai.msu.su>
` Re: GiST indexes and concurrency (tsearch2)
2005-02-03 13:15 UTC Marinos J. Yannikos <mjy@geizhals.at>
` Re: GiST indexes and concurrency (tsearch2)
2005-02-03 16:27 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: GiST indexes and concurrency (tsearch2)
2005-02-03 19:06 UTC Marinos J. Yannikos <mjy@geizhals.at>
` Re: GiST indexes and concurrency (tsearch2)
2005-02-03 19:50 UTC Oleg Bartunov <oleg@sai.msu.su>
` Re: GiST indexes and concurrency (tsearch2)
2005-02-05 13:01 UTC Marinos Yannikos <mjy@geizhals.at>
` Re: GiST indexes and concurrency (tsearch2)
2005-02-05 19:01 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: GiST indexes and concurrency (tsearch2)
2005-02-05 19:42 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: GiST indexes and concurrency (tsearch2)
2005-02-09 19:25 UTC Marinos J. Yannikos <mjy@geizhals.at>
` Re: GiST indexes and concurrency (tsearch2)
2005-02-10 00:55 UTC Marinos J. Yannikos <mjy@geizhals.at>
` Re: GiST indexes and concurrency (tsearch2)
2005-02-10 01:13 UTC Neil Conway <neilc@samurai.com>
[17+ messages in thread]
annotated PostgreSQL.conf now up
2005-02-09 21:50 UTC Josh Berkus <josh@agliodbs.com>
` Re: annotated PostgreSQL.conf now up
2005-02-09 23:18 UTC Jon Asher <jon@vagabond-software.com>
[2+ messages in thread]
Solaris 9 tuning
2005-02-07 22:25 UTC Paul Johnson <paul@oxton.com>
` Re: Solaris 9 tuning
2005-02-08 02:22 UTC Josh Berkus <josh@agliodbs.com>
` Re: Solaris 9 tuning
2005-02-09 19:02 UTC Paul Johnson <paul@oxton.com>
` Re: Solaris 9 tuning
2005-02-09 19:23 UTC Tom Arthurs <tom@jobflash.com>
` Re: Solaris 9 tuning
2005-02-09 19:31 UTC Tom Arthurs <tarthurs@jobflash.com>
` Re: Solaris 9 tuning
2005-02-09 20:49 UTC Paul Johnson <paul@oxton.com>
` Re: Solaris 9 tuning
2005-02-09 22:08 UTC Tom Arthurs <tarthurs@jobflash.com>
[7+ messages in thread]
Tell postgres which index to use?
2005-02-09 15:58 UTC Silke Trissl <trissl@informatik.hu-berlin.de>
` Re: Tell postgres which index to use?
2005-02-09 17:41 UTC Josh Berkus <josh@agliodbs.com>
` Re: Tell postgres which index to use?
2005-02-09 17:58 UTC Silke Trissl <trissl@informatik.hu-berlin.de>
` Re: Tell postgres which index to use?
2005-02-09 18:36 UTC John Arbash Meinel <john@arbash-meinel.com>
` Re: Tell postgres which index to use?
2005-02-09 20:50 UTC Greg Stark <gsstark@mit.edu>
[5+ messages in thread]
Slow Restoration of a template1 Database (ALTER GROUP)
2005-02-08 18:23 UTC Ben Young <Ben.Young@etrials.com>
` Re: Slow Restoration of a template1 Database (ALTER GROUP)
2005-02-08 18:57 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Slow Restoration of a template1 Database (ALTER GROUP)
2005-02-08 19:59 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Slow Restoration of a template1 Database (ALTER GROUP)
2005-02-08 20:08 UTC Ben Young <Ben.Young@etrials.com>
` Re: Slow Restoration of a template1 Database (ALTER GROUP)
2005-02-08 20:32 UTC Tom Lane <tgl@sss.pgh.pa.us>
[5+ messages in thread]
Retry: Is this possible / slow performance?
2005-02-07 16:37 UTC Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
` Re: Retry: Is this possible / slow performance?
2005-02-07 17:03 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Retry: Is this possible / slow performance?
2005-02-07 18:16 UTC PFC <lists@boutiquenumerique.com>
` Re: Retry: Is this possible / slow performance?
2005-02-07 19:27 UTC Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
` Re: Retry: Is this possible / slow performance?
2005-02-07 19:52 UTC Merlin Moncure <merlin.moncure@rcsonline.com>
[5+ messages in thread]
Are JOINs allowed with DELETE FROM
2005-02-06 17:16 UTC Steven Rosenstein <srosenst@us.ibm.com>
` Re: Are JOINs allowed with DELETE FROM
2005-02-06 17:36 UTC Gaetano Mendola <mendola@bigfoot.com>
` Re: Are JOINs allowed with DELETE FROM
2005-02-06 17:50 UTC Michael Fuhr <mike@fuhr.org>
` Re: Are JOINs allowed with DELETE FROM
2005-02-06 17:58 UTC John Arbash Meinel <john@arbash-meinel.com>
` Re: Are JOINs allowed with DELETE FROM
2005-02-06 19:33 UTC Steven Rosenstein <srosenst@us.ibm.com>
` Re: Are JOINs allowed with DELETE FROM
2005-02-06 19:49 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Are JOINs allowed with DELETE FROM
2005-02-06 21:57 UTC Steven Rosenstein <srosenst@us.ibm.com>
` Re: Are JOINs allowed with DELETE FROM
2005-02-07 17:22 UTC Gaetano Mendola <mendola@bigfoot.com>
[8+ messages in thread]
Can the V7.3 EXPLAIN ANALYZE be trusted?
2005-02-06 19:50 UTC Steven Rosenstein <srosenst@us.ibm.com>
` Re: Can the V7.3 EXPLAIN ANALYZE be trusted?
2005-02-06 22:09 UTC Leeuw van der, Tim <tim.leeuwvander@nl.unisys.com>
` Re: Can the V7.3 EXPLAIN ANALYZE be trusted?
2005-02-06 22:34 UTC Greg Stark <gsstark@mit.edu>
` Re: Can the V7.3 EXPLAIN ANALYZE be trusted?
2005-02-06 22:46 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Can the V7.3 EXPLAIN ANALYZE be trusted?
2005-02-07 02:43 UTC Steven Rosenstein <srosenst@us.ibm.com>
` Re: Can the V7.3 EXPLAIN ANALYZE be trusted?
2005-02-07 14:39 UTC Markus Schaber <schabios@logi-track.com>
[6+ messages in thread]
Bad query optimizer misestimation because of TOAST tables
2005-02-02 17:21 UTC Markus Schaber <schabios@logi-track.com>
` Re: Bad query optimizer misestimation because of TOAST tables
2005-02-02 17:44 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Bad query optimizer misestimation because of TOAST
2005-02-02 18:25 UTC Markus Schaber <schabios@logi-track.com>
` Re: Bad query optimizer misestimation because of TOAST
2005-02-02 23:49 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Bad query optimizer misestimation because of TOAST
2005-02-03 10:30 UTC Markus Schaber <schabios@logi-track.com>
` Re: [postgis-users] Bad query optimizer misestimation because of
2005-02-03 13:59 UTC Markus Schaber <schabios@logi-track.com>
` Re: Bad query optimizer misestimation because of TOAST
2005-02-07 14:07 UTC Markus Schaber <schabios@logi-track.com>
[7+ messages in thread]
Index not used with or condition
2005-02-07 09:07 UTC Antony Paul <antonypaul24@gmail.com>
` Re: Index not used with or condition
2005-02-07 11:14 UTC Antony Paul <antonypaul24@gmail.com>
` Re: Index not used with or condition
2005-02-07 11:46 UTC Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Index not used with or condition
2005-02-07 11:53 UTC Jan Poslusny <pajout@gingerall.cz>
` Re: Index not used with or condition
2005-02-07 11:57 UTC Antony Paul <antonypaul24@gmail.com>
` Re: Index not used with or condition
2005-02-07 11:58 UTC Antony Paul <antonypaul24@gmail.com>
[6+ messages in thread]
Is this possible / slow performance?
2005-02-07 11:36 UTC Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
horizontal partition
2005-02-02 00:16 UTC Gaetano Mendola <mendola@bigfoot.com>
` Re: horizontal partition
2005-02-02 20:09 UTC Josh Berkus <josh@agliodbs.com>
` Re: horizontal partition
2005-02-03 01:10 UTC Gaetano Mendola <mendola@bigfoot.com>
` Re: horizontal partition
2005-02-03 03:16 UTC Josh Berkus <josh@agliodbs.com>
` Re: horizontal partition
2005-02-03 03:31 UTC Klint Gore <kg@kgb.une.edu.au>
` Re: horizontal partition
2005-02-03 06:41 UTC Josh Berkus <josh@agliodbs.com>
` Re: horizontal partition
2005-02-03 06:55 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: horizontal partition
2005-02-03 10:40 UTC Gaetano Mendola <mendola@bigfoot.com>
` Re: horizontal partition
2005-02-06 15:50 UTC Gaetano Mendola <mendola@bigfoot.com>
[9+ messages in thread]
Flattening a kind of 'dynamic' table
2005-01-27 15:23 UTC Alexandre Leclerc <alexandre.leclerc@gmail.com>
` Re: Flattening a kind of 'dynamic' table
2005-01-27 15:44 UTC Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: Flattening a kind of 'dynamic' table
2005-01-27 16:27 UTC Dawid Kuroczko <qnex42@gmail.com>
` Re: Flattening a kind of 'dynamic' table
2005-01-27 16:41 UTC Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: Flattening a kind of 'dynamic' table
2005-01-27 17:43 UTC Alexandre Leclerc <alexandre.leclerc@gmail.com>
` Re: Flattening a kind of 'dynamic' table
2005-01-27 17:43 UTC Alexandre Leclerc <alexandre.leclerc@gmail.com>
` Re: Flattening a kind of 'dynamic' table
2005-01-27 18:02 UTC Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: Flattening a kind of 'dynamic' table
2005-01-27 20:02 UTC Alexandre Leclerc <alexandre.leclerc@gmail.com>
` Re: Flattening a kind of 'dynamic' table
2005-01-27 21:05 UTC Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: Flattening a kind of 'dynamic' table
2005-01-27 22:07 UTC Alexandre Leclerc <alexandre.leclerc@gmail.com>
` Re: Flattening a kind of 'dynamic' table
2005-01-28 08:07 UTC Dawid Kuroczko <qnex42@gmail.com>
` Re: Flattening a kind of 'dynamic' table
2005-01-28 14:25 UTC Alexandre Leclerc <alexandre.leclerc@gmail.com>
` Re: Flattening a kind of 'dynamic' table
2005-01-28 16:34 UTC Joe Conway <mail@joeconway.com>
` Re: Flattening a kind of 'dynamic' table
2005-01-28 18:15 UTC Alexandre Leclerc <alexandre.leclerc@gmail.com>
` Re: Flattening a kind of 'dynamic' table
2005-01-28 18:24 UTC Joe Conway <mail@joeconway.com>
` Re: Flattening a kind of 'dynamic' table
2005-01-28 19:26 UTC Alexandre Leclerc <alexandre.leclerc@gmail.com>
` Re: Flattening a kind of 'dynamic' table
2005-01-28 19:59 UTC Dawid Kuroczko <qnex42@gmail.com>
` Re: Flattening a kind of 'dynamic' table
2005-02-04 17:48 UTC Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: Flattening a kind of 'dynamic' table
2005-02-04 20:08 UTC Alexandre Leclerc <alexandre.leclerc@gmail.com>
[19+ messages in thread]
Postgres odbc performance on windows
2005-02-04 19:29 UTC Sanketh Indarapu <sanketh_indarapu@yahoo.com>
Planner really hates nested loops
2005-02-03 11:10 UTC David Brown <time@bigpond.net.au>
` Re: Planner really hates nested loops
2005-02-03 16:25 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Planner really hates nested loops
2005-02-03 16:41 UTC Magnus Hagander <mha@sollentuna.net>
` Re: Planner really hates nested loops
2005-02-03 17:10 UTC Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: Planner really hates nested loops
2005-02-03 23:22 UTC David Brown <time@bigpond.net.au>
` Re: Planner really hates nested loops
2005-02-04 04:39 UTC Bruce Momjian <pgman@candle.pha.pa.us>
[6+ messages in thread]
Tunning postgresql on linux (fedora core 3)
2005-02-03 09:55 UTC Din Adrian <adrian.din@easynet.ro>
` Re: Tunning postgresql on linux (fedora core 3)
2005-02-03 10:54 UTC Richard Huxton <dev@archonet.com>
` Re: Tunning postgresql on linux (fedora core 3)
2005-02-03 13:56 UTC Richard Huxton <dev@archonet.com>
` Re: Tunning postgresql on linux (fedora core 3)
2005-02-03 14:52 UTC Richard Huxton <dev@archonet.com>
` Re: [PERFORM] Tunning postgresql on linux (fedora core 3)
2005-02-03 15:15 UTC Richard Huxton <dev@archonet.com>
` Re: [PERFORM] Tunning postgresql on linux (fedora core 3)
2005-02-03 16:59 UTC Din Adrian <adrian.din@easynet.ro>
[6+ messages in thread]
Accessing insert values in triggers
2005-02-02 10:02 UTC Hasnul Fadhly bin Hasan <hasnulfadhly.h@mimos.my>
` Re: [PERFORM] Accessing insert values in triggers
2005-02-03 08:01 UTC Michael Fuhr <mike@fuhr.org>
[2+ messages in thread]
Bitmap indexes
2005-01-28 15:39 UTC Alex Turner <armtuk@gmail.com>
` Re: Bitmap indexes
2005-01-28 16:04 UTC PFC <lists@boutiquenumerique.com>
` Re: Bitmap indexes
2005-01-28 16:13 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Bitmap indexes
2005-01-28 17:14 UTC PFC <lists@boutiquenumerique.com>
` Re: Bitmap indexes
2005-01-28 19:45 UTC Christopher Browne <cbbrowne@ca.afilias.info>
` Re: Bitmap indexes
2005-02-02 16:08 UTC Bruce Momjian <pgman@candle.pha.pa.us>
` Re: Bitmap indexes
2005-02-02 23:18 UTC Daniel Ceregatti <daniel@omnis.com>
[7+ messages in thread]
Swapping on Solaris
2005-01-18 22:49 UTC Kevin Schroeder <kschroeder@mirageworks.com>
` Re: Swapping on Solaris
2005-01-19 07:40 UTC Mark Kirkwood <markir@coretech.co.nz>
` Re: Swapping on Solaris
2005-01-19 09:57 UTC Matt Casters <Matt.Casters@advalvas.be>
` Re: Swapping on Solaris
2005-01-19 13:51 UTC Alan Stange <stange@rentec.com>
` Re: Swapping on Solaris
2005-01-19 14:31 UTC Kevin Schroeder <kschroeder@mirageworks.com>
` Re: Swapping on Solaris
2005-01-19 14:52 UTC Kevin Schroeder <kschroeder@mirageworks.com>
` Re: Swapping on Solaris
2005-01-19 14:57 UTC Kevin Schroeder <kschroeder@mirageworks.com>
` Re: Swapping on Solaris
2005-01-19 15:07 UTC Greg Spiegelberg <gspiegelberg@cranel.com>
` Re: Swapping on Solaris
2005-01-19 15:17 UTC Kevin Schroeder <kschroeder@mirageworks.com>
` Re: Swapping on Solaris
2005-01-19 15:30 UTC Alan Stange <stange@rentec.com>
` Re: Swapping on Solaris
2005-01-19 15:40 UTC Kevin Schroeder <kschroeder@mirageworks.com>
` Re: Swapping on Solaris
2005-01-19 15:42 UTC Alan Stange <stange@rentec.com>
` Re: Swapping on Solaris
2005-01-19 15:53 UTC Kevin Schroeder <kschroeder@mirageworks.com>
` Re: Swapping on Solaris
2005-01-19 16:58 UTC Jeff <threshar@torgo.978.org>
` Re: Swapping on Solaris
2005-01-19 17:04 UTC Alan Stange <stange@rentec.com>
` Re: Swapping on Solaris
2005-01-19 17:08 UTC Kevin Schroeder <kschroeder@mirageworks.com>
` Re: Swapping on Solaris
2005-01-19 17:36 UTC Jeff <threshar@torgo.978.org>
` Re: Swapping on Solaris
2005-01-19 19:01 UTC Matt Clark <matt@ymogen.net>
` Re: Swapping on Solaris
2005-01-19 19:46 UTC Kevin Schroeder <kschroeder@mirageworks.com>
` Re: Swapping on Solaris
2005-01-19 23:47 UTC Simon Riggs <simon@2ndquadrant.com>
` Re: Swapping on Solaris
2005-01-27 21:36 UTC Andrew Sullivan <ajs@crankycanuck.ca>
` Re: Swapping on Solaris
2005-02-02 15:54 UTC Bruce Momjian <pgman@candle.pha.pa.us>
[22+ messages in thread]
Ideal disk setup for Postgresql 7.4?
2005-01-25 11:57 UTC Steve Poe <spoe@sfnet.cc>
` Re: Ideal disk setup for Postgresql 7.4?
2005-01-25 23:52 UTC Steve Poe <spoe@sfnet.cc>
` Re: Ideal disk setup for Postgresql 7.4?
2005-01-26 03:03 UTC Josh Berkus <josh@agliodbs.com>
` Re: Ideal disk setup for Postgresql 7.4?
2005-01-26 13:07 UTC Steve Poe <spoe@sfnet.cc>
` Re: Ideal disk setup for Postgresql 7.4?
2005-01-26 18:03 UTC Josh Berkus <josh@agliodbs.com>
` Re: Ideal disk setup for Postgresql 7.4?
2005-01-26 21:39 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Ideal disk setup for Postgresql 7.4?
2005-01-26 23:49 UTC Steve Poe <spoe@sfnet.cc>
` Re: Ideal disk setup for Postgresql 7.4?
2005-01-27 02:49 UTC Josh Berkus <josh@agliodbs.com>
` Re: Ideal disk setup for Postgresql 7.4?
2005-01-27 16:56 UTC Josh Berkus <josh@agliodbs.com>
` Re: Ideal disk setup for Postgresql 7.4?
2005-01-27 17:03 UTC Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Ideal disk setup for Postgresql 7.4?
2005-01-27 17:35 UTC Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: Ideal disk setup for Postgresql 7.4?
2005-02-01 21:11 UTC Bruce Momjian <pgman@candle.pha.pa.us>
[12+ messages in thread]
Why the difference in query plan and performance pg 7.4.6?
2005-02-01 18:55 UTC Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
` Re: Why the difference in query plan and performance pg
2005-02-01 20:06 UTC John Arbash Meinel <john@arbash-meinel.com>
[2+ messages in thread]
Effect of database encoding on performance
2005-02-01 16:38 UTC Igor Postelnik <Igor_Postelnik@messageone.com>
Performance of count(*) on large tables vs SQL Server
2005-02-01 12:41 UTC Andrew Mayo <ajmayo@kohuconsulting.com>
` Re: Performance of count(*) on large tables vs SQL Server
2005-02-01 13:02 UTC Shridhar Daithankar <ghodechhap@ghodechhap.net>
` Re: Performance of count(*) on large tables vs SQL Server
2005-02-01 13:22 UTC Stef <stef@ummon.com>
` Re: Performance of count(*) on large tables vs SQL Server
2005-02-01 13:36 UTC PFC <lists@boutiquenumerique.com>
[4+ 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