pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedNew performance documentation released
2007-05-16 03:55 UTC Greg Smith <gsmith@gregsmith.com>
` Re: New performance documentation released
2007-05-16 15:38 UTC Luke Lonergan <llonergan@greenplum.com>
[2+ messages in thread]
How to Run a pg_stats Query
2007-05-15 22:42 UTC Y Sidhu <ysidhu@gmail.com>
` Re: How to Run a pg_stats Query
2007-05-15 22:50 UTC Alvaro Herrera <alvherre@commandprompt.com>
[2+ messages in thread]
Many to many join seems slow?
2007-05-15 13:57 UTC Drew Wilson <drewmwilson@gmail.com>
` Re: Many to many join seems slow?
2007-05-15 14:05 UTC Alvaro Herrera <alvherre@commandprompt.com>
` Re: Many to many join seems slow?
2007-05-15 14:11 UTC Drew Wilson <drewmwilson@gmail.com>
` Re: Many to many join seems slow?
2007-05-15 14:17 UTC Heikki Linnakangas <heikki@enterprisedb.com>
` Re: Many to many join seems slow?
2007-05-15 16:00 UTC Daniel Cristian Cruz <danielcristian@gmail.com>
` Re: Many to many join seems slow?
2007-05-15 16:43 UTC Drew Wilson <drewmwilson@gmail.com>
` Re: Many to many join seems slow?
2007-05-15 16:45 UTC Drew Wilson <drewmwilson@gmail.com>
[7+ messages in thread]
bitmap index and IS NULL predicate
2007-05-15 15:16 UTC Jason Pinnix <pinnixjason@yahoo.com>
` Re: bitmap index and IS NULL predicate
2007-05-15 15:22 UTC Alexander Staubo <alex@purefiction.net>
[2+ messages in thread]
Re: Transaction prioritization from java possible?
2007-05-14 17:22 UTC Josh Berkus <josh@agliodbs.com>
Kernel cache vs shared_buffers
2007-05-12 11:10 UTC Michael van Rooyen <mvanr@bigfoot.com>
` Re: Kernel cache vs shared_buffers
2007-05-12 14:28 UTC Heikki Linnakangas <heikki@enterprisedb.com>
` Re: Kernel cache vs shared_buffers
2007-05-12 16:55 UTC Jim C. Nasby <jim@nasby.net>
` Re: Kernel cache vs shared_buffers
2007-05-13 08:39 UTC Harald Armin Massa <haraldarminmassa@gmail.com>
` Re: Kernel cache vs shared_buffers
2007-05-13 09:41 UTC Heikki Linnakangas <heikki@enterprisedb.com>
` Re: Kernel cache vs shared_buffers
2007-05-13 09:57 UTC Harald Armin Massa <haraldarminmassa@gmail.com>
` Re: Kernel cache vs shared_buffers
2007-05-13 10:39 UTC Magnus Hagander <magnus@hagander.net>
[7+ messages in thread]
Best OS for Postgres 8.2
2007-05-07 21:55 UTC David Levy <dvid.levy@gmail.com>
` Re: Best OS for Postgres 8.2
2007-05-07 21:59 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: Best OS for Postgres 8.2
2007-05-07 22:04 UTC Bill Moran <wmoran@collaborativefusion.com>
` Re: Best OS for Postgres 8.2
2007-05-07 22:14 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: Best OS for Postgres 8.2
2007-05-07 22:57 UTC Steve Atkins <steve@blighty.com>
` Re: Best OS for Postgres 8.2
2007-05-08 00:40 UTC Chris <dmagick@gmail.com>
` Re: Best OS for Postgres 8.2
2007-05-08 00:53 UTC david@lang.hm
` Re: Best OS for Postgres 8.2
2007-05-08 01:14 UTC Chris <dmagick@gmail.com>
` Re: Best OS for Postgres 8.2
2007-05-08 03:41 UTC Ron <rjpeace@earthlink.net>
` Re: Best OS for Postgres 8.2
2007-05-08 03:56 UTC Greg Smith <gsmith@gregsmith.com>
` Re: Best OS for Postgres 8.2
2007-05-08 04:37 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Best OS for Postgres 8.2
2007-05-08 04:41 UTC 李彦 Ian Li <liyan82@gmail.com>
` Re: Best OS for Postgres 8.2
2007-05-08 07:59 UTC david@lang.hm
` Re: Best OS for Postgres 8.2
2007-05-08 08:21 UTC Heikki Linnakangas <heikki@enterprisedb.com>
` Re: Best OS for Postgres 8.2
2007-05-08 08:22 UTC Claus Guttesen <kometen@gmail.com>
` Re: Best OS for Postgres 8.2
2007-05-08 08:45 UTC david@lang.hm
` Re: Best OS for Postgres 8.2
2007-05-08 08:49 UTC Trygve Laugstøl <trygvis@inamo.no>
` Re: Best OS for Postgres 8.2
2007-05-08 09:35 UTC Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Best OS for Postgres 8.2
2007-05-08 09:43 UTC Alexander Staubo <alex@purefiction.net>
` Re: Best OS for Postgres 8.2
2007-05-08 09:48 UTC Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Best OS for Postgres 8.2
2007-05-08 10:16 UTC david@lang.hm
` Re: Best OS for Postgres 8.2
2007-05-08 10:27 UTC david@lang.hm
` Re: Best OS for Postgres 8.2
2007-05-08 10:29 UTC Trygve Laugstøl <trygvis@inamo.no>
` Re: [OT] Best OS for Postgres 8.2
2007-05-08 10:55 UTC "C. Bergström" <cbergstrom@netsyncro.com>
` Re: Best OS for Postgres 8.2
2007-05-08 12:01 UTC Luke Lonergan <LLonergan@greenplum.com>
` Re: [OT] Best OS for Postgres 8.2
2007-05-08 12:25 UTC Adam Tauno Williams <adamtaunowilliams@gmail.com>
` Re: Best OS for Postgres 8.2
2007-05-08 16:08 UTC Ron <rjpeace@earthlink.net>
` Re: Best OS for Postgres 8.2
2007-05-08 16:58 UTC 李彦 Ian Li <liyan82@gmail.com>
` Re: Best OS for Postgres 8.2
2007-05-08 20:49 UTC Charles Sprickman <spork@bway.net>
` Re: Best OS for Postgres 8.2
2007-05-09 03:31 UTC Greg Smith <gsmith@gregsmith.com>
` Re: Best OS for Postgres 8.2
2007-05-09 03:51 UTC Greg Smith <gsmith@gregsmith.com>
` Re: Best OS for Postgres 8.2
2007-05-09 08:57 UTC david@lang.hm
` Re: Best OS for Postgres 8.2
2007-05-09 09:38 UTC Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Best OS for Postgres 8.2
2007-05-09 09:44 UTC david@lang.hm
` Re: Best OS for Postgres 8.2
2007-05-09 17:10 UTC Jim Nasby <decibel@decibel.org>
` Re: Best OS for Postgres 8.2
2007-05-11 13:35 UTC Adam Witney <awitney@sgul.ac.uk>
` Re: Best OS for Postgres 8.2
2007-05-12 03:12 UTC Robert Treat <xzilla@users.sourceforge.net>
` Re: Best OS for Postgres 8.2
2007-05-13 06:34 UTC Andrew McMillan <andrew@catalyst.net.nz>
[38+ messages in thread]
estimating the need for VACUUM FULL and REINDEX
2007-05-08 12:08 UTC Guillaume Cottenceau <gc@mnc.ch>
` Re: estimating the need for VACUUM FULL and REINDEX
2007-05-08 12:40 UTC Heikki Linnakangas <heikki@enterprisedb.com>
` Re: estimating the need for VACUUM FULL and REINDEX
2007-05-08 12:46 UTC Bill Moran <wmoran@collaborativefusion.com>
` Re: estimating the need for VACUUM FULL and REINDEX
2007-05-09 09:18 UTC Guillaume Cottenceau <gc@mnc.ch>
` Re: estimating the need for VACUUM FULL and REINDEX
2007-05-11 15:31 UTC Guillaume Cottenceau <gc@mnc.ch>
` Re: estimating the need for VACUUM FULL and REINDEX
2007-05-11 17:25 UTC Alvaro Herrera <alvherre@commandprompt.com>
` Re: estimating the need for VACUUM FULL and REINDEX
2007-05-12 16:51 UTC Jim C. Nasby <jim@nasby.net>
[7+ messages in thread]
BUG #3270: limit < 16 optimizer behaviour
2007-05-11 14:07 UTC Liviu Ionescu <ilgb@livius.net>
` Re: BUG #3270: limit < 16 optimizer behaviour
2007-05-11 19:10 UTC Bruno Wolff III <bruno@wolff.to>
[2+ messages in thread]
REVISIT specific query (not all) on Pg8 MUCH slower than Pg7
2007-05-10 13:23 UTC Susan Russo <russo@morgan.harvard.edu>
` Re: REVISIT specific query (not all) on Pg8 MUCH slower than Pg7
2007-05-10 13:38 UTC Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: REVISIT specific query (not all) on Pg8 MUCH slower than Pg7
2007-05-10 13:47 UTC Bill Moran <wmoran@collaborativefusion.com>
` Re: REVISIT specific query (not all) on Pg8 MUCH slower than Pg7
2007-05-10 14:08 UTC Susan Russo <russo@morgan.harvard.edu>
` Re: REVISIT specific query (not all) on Pg8 MUCH slower than Pg7
2007-05-11 02:05 UTC Susan Russo <russo@morgan.harvard.edu>
[5+ messages in thread]
Nested loops overpriced
2007-05-08 15:22 UTC Peter Eisentraut <peter_e@gmx.net>
` Re: Nested loops overpriced
2007-05-08 15:53 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Nested loops overpriced
2007-05-09 11:58 UTC Peter Eisentraut <peter_e@gmx.net>
` Re: Nested loops overpriced
2007-05-09 13:38 UTC Daniel Cristian Cruz <danielcristian@gmail.com>
` Re: Nested loops overpriced
2007-05-09 14:11 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Nested loops overpriced
2007-05-09 14:34 UTC Gregory Stark <stark@enterprisedb.com>
` Re: Nested loops overpriced
2007-05-09 14:51 UTC Daniel Cristian Cruz <danielcristian@gmail.com>
` Re: Nested loops overpriced
2007-05-09 16:17 UTC Peter Eisentraut <peter_e@gmx.net>
` Re: Nested loops overpriced
2007-05-09 17:40 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Nested loops overpriced
2007-05-10 15:30 UTC Peter Eisentraut <peter_e@gmx.net>
` Re: Nested loops overpriced
2007-05-10 15:35 UTC Peter Eisentraut <peter_e@gmx.net>
` Re: Nested loops overpriced
2007-05-10 15:47 UTC Tom Lane <tgl@sss.pgh.pa.us>
[12+ messages in thread]
Cannot make GIN intarray index be used by the planner
2007-05-09 13:12 UTC Valentine Gogichashvili <valgog@gmail.com>
` Re: Cannot make GIN intarray index be used by the planner
2007-05-09 13:31 UTC Oleg Bartunov <oleg@sai.msu.su>
` Re: Cannot make GIN intarray index be used by the planner
2007-05-09 13:36 UTC Valentine Gogichashvili <valgog@gmail.com>
` Re: Cannot make GIN intarray index be used by the planner
2007-05-09 13:49 UTC Oleg Bartunov <oleg@sai.msu.su>
` Re: [PERFORM] Cannot make GIN intarray index be used by the planner
2007-05-09 19:18 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] Cannot make GIN intarray index be used by the planner
2007-05-10 09:07 UTC Valentine Gogichashvili <valgog@gmail.com>
[6+ messages in thread]
Performance Woes
2007-05-09 23:51 UTC Ralph Mason <ralph.mason@telogis.com>
` Re: Performance Woes
2007-05-10 00:26 UTC CAJ CAJ <pguser@gmail.com>
` Re: Performance Woes
2007-05-10 00:29 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: Performance Woes
2007-05-10 00:34 UTC Ralph Mason <ralph.mason@telogis.com>
` Re: Performance Woes
2007-05-10 00:40 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: Performance Woes
2007-05-10 00:42 UTC Jeff Davis <pgsql@j-davis.com>
` Re: Performance Woes
2007-05-10 01:45 UTC Ralph Mason <ralph.mason@telogis.com>
` Re: Performance Woes
2007-05-10 01:50 UTC Scott Mohekey <scott.mohekey@telogis.com>
` Re: Performance Woes
2007-05-10 02:05 UTC Alvaro Herrera <alvherre@commandprompt.com>
` Re: Performance Woes
2007-05-10 04:30 UTC Tom Lane <tgl@sss.pgh.pa.us>
[10+ messages in thread]
Vacuum Times - Verbose and maintenance_work_mem
2007-05-09 22:00 UTC Y Sidhu <ysidhu@gmail.com>
ZFS and Postgresql - WASRe: Best OS for Postgres 8.2
2007-05-09 16:27 UTC Jignesh Shah <J.K.Shah@Sun.COM>
` Re: ZFS and Postgresql - WASRe: Best OS for Postgres 8.2
2007-05-09 17:01 UTC Alvaro Herrera <alvherre@commandprompt.com>
` Re: ZFS and Postgresql - WASRe: Best OS for Postgres 8.2
2007-05-09 17:49 UTC Jignesh Shah <J.K.Shah@Sun.COM>
` Re: ZFS and Postgresql - WASRe: Best OS for Postgres 8.2
2007-05-09 17:55 UTC david@lang.hm
[4+ messages in thread]
How to Find Cause of Long Vacuum Times - NOOB Question
2007-05-05 22:57 UTC Yudhvir Singh Sidhu <ysidhu@gmail.com>
` Re: How to Find Cause of Long Vacuum Times - NOOB Question
2007-05-05 23:40 UTC Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: How to Find Cause of Long Vacuum Times - NOOB Question
2007-05-06 04:52 UTC Yudhvir Singh Sidhu <ysidhu@gmail.com>
` Re: How to Find Cause of Long Vacuum Times - NOOB Question
2007-05-06 08:15 UTC Heikki Linnakangas <heikki@enterprisedb.com>
` Re: How to Find Cause of Long Vacuum Times - NOOB Question
2007-05-06 09:17 UTC Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: How to Find Cause of Long Vacuum Times - NOOB Question
2007-05-06 09:35 UTC Yudhvir Singh Sidhu <ysidhu@gmail.com>
` Re: How to Find Cause of Long Vacuum Times - NOOB Question
2007-05-07 15:54 UTC Jim Nasby <decibel@decibel.org>
` Re: How to Find Cause of Long Vacuum Times - NOOB Question
2007-05-08 04:10 UTC Yudhvir Singh Sidhu <ysidhu@gmail.com>
` Re: How to Find Cause of Long Vacuum Times - NOOB Question
2007-05-09 17:14 UTC Jim Nasby <decibel@decibel.org>
[9+ messages in thread]
Apparently useless bitmap scans
2007-05-09 12:10 UTC Peter Eisentraut <peter_e@gmx.net>
` Re: Apparently useless bitmap scans
2007-05-09 14:29 UTC Alvaro Herrera <alvherre@commandprompt.com>
` Re: Apparently useless bitmap scans
2007-05-09 14:49 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Apparently useless bitmap scans
2007-05-09 15:26 UTC Peter Eisentraut <peter_e@gmx.net>
` Re: Apparently useless bitmap scans
2007-05-09 15:56 UTC Tom Lane <tgl@sss.pgh.pa.us>
[5+ messages in thread]
Poor performance with queries using clause: sth IN (...)
2007-05-09 13:22 UTC Andrzej Zawadzki <zawadaa@wp.pl>
` Re: Poor performance with queries using clause: sth IN (...)
2007-05-09 14:29 UTC Gregory Stark <stark@enterprisedb.com>
[2+ messages in thread]
Throttling PostgreSQL's CPU usage
2007-05-08 20:27 UTC Daniel Griscom <griscom@suitable.com>
` Re: Throttling PostgreSQL's CPU usage
2007-05-08 20:51 UTC Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Throttling PostgreSQL's CPU usage
2007-05-08 20:55 UTC Bill Moran <wmoran@collaborativefusion.com>
` Re: Throttling PostgreSQL's CPU usage
2007-05-08 20:59 UTC david@lang.hm
` Re: Throttling PostgreSQL's CPU usage
2007-05-08 21:10 UTC Mark Lewis <mark.lewis@mir3.com>
` Re: Throttling PostgreSQL's CPU usage
2007-05-08 22:32 UTC Carlos Moreno <moreno_pg@mochima.com>
` Re: Throttling PostgreSQL's CPU usage
2007-05-08 22:39 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: Throttling PostgreSQL's CPU usage
2007-05-08 22:40 UTC Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Throttling PostgreSQL's CPU usage
2007-05-08 22:46 UTC Carlos Moreno <moreno_pg@mochima.com>
` Re: Throttling PostgreSQL's CPU usage
2007-05-08 23:03 UTC Daniel Griscom <griscom@suitable.com>
` Re: Throttling PostgreSQL's CPU usage
2007-05-08 23:09 UTC Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Throttling PostgreSQL's CPU usage
2007-05-08 23:21 UTC david@lang.hm
` Re: Throttling PostgreSQL's CPU usage
2007-05-08 23:22 UTC Carlos Moreno <moreno_pg@mochima.com>
` Re: Throttling PostgreSQL's CPU usage
2007-05-08 23:24 UTC david@lang.hm
` Re: Throttling PostgreSQL's CPU usage
2007-05-09 04:09 UTC Luke Lonergan <llonergan@greenplum.com>
` Re: Throttling PostgreSQL's CPU usage
2007-05-09 05:56 UTC Magnus Hagander <magnus@hagander.net>
` Re: Throttling PostgreSQL's CPU usage
2007-05-09 13:49 UTC Daniel Griscom <griscom@suitable.com>
` Re: Throttling PostgreSQL's CPU usage
2007-05-09 14:29 UTC Carlos Moreno <moreno_pg@mochima.com>
[18+ messages in thread]
FW:
2007-05-09 01:14 UTC Orhan Aglagul <oaglagul@cittio.com>
` Re: FW:
2007-05-09 01:22 UTC david@lang.hm
` Re: FW:
2007-05-09 11:36 UTC Gregory Stark <stark@enterprisedb.com>
[3+ messages in thread]
What's The Difference Between VACUUM and VACUUM ANALYZE?
2007-05-08 21:43 UTC Y Sidhu <ysidhu@gmail.com>
` Re: What's The Difference Between VACUUM and VACUUM ANALYZE?
2007-05-08 21:46 UTC david@lang.hm
` Re: What's The Difference Between VACUUM and VACUUM ANALYZE?
2007-05-08 21:52 UTC Alvaro Herrera <alvherre@commandprompt.com>
` Re: What's The Difference Between VACUUM and VACUUM ANALYZE?
2007-05-08 22:06 UTC Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: What's The Difference Between VACUUM and VACUUM ANALYZE?
2007-05-08 22:21 UTC Alvaro Herrera <alvherre@commandprompt.com>
` Re: What's The Difference Between VACUUM and VACUUM ANALYZE?
2007-05-09 11:31 UTC Gregory Stark <stark@enterprisedb.com>
[6+ messages in thread]
(no subject)
2007-05-08 22:59 UTC Orhan Aglagul <oaglagul@cittio.com>
` Re:
2007-05-08 23:48 UTC Dan Harris <fbsd@drivefaster.net>
` Re:
2007-05-09 00:05 UTC Joshua D. Drake <jd@commandprompt.com>
` Re:
2007-05-09 00:20 UTC Carlos Moreno <moreno_pg@mochima.com>
` Re:
2007-05-09 00:22 UTC Scott Marlowe <smarlowe@g2switchworks.com>
` Re:
2007-05-09 00:30 UTC Scott Marlowe <smarlowe@g2switchworks.com>
` Re:
2007-05-09 01:12 UTC Orhan Aglagul <oaglagul@cittio.com>
` Re:
2007-05-09 04:14 UTC Greg Smith <gsmith@gregsmith.com>
` Re:
2007-05-09 04:58 UTC Robert Treat <xzilla@users.sourceforge.net>
[9+ messages in thread]
FW:
2007-05-09 01:13 UTC Orhan Aglagul <oaglagul@cittio.com>
DISTINCT Question
2007-05-08 19:52 UTC Y Sidhu <ysidhu@gmail.com>
` Re: DISTINCT Question
2007-05-08 19:55 UTC Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: DISTINCT Question
2007-05-08 19:57 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: DISTINCT Question
2007-05-08 20:28 UTC Scott Marlowe <smarlowe@g2switchworks.com>
[4+ messages in thread]
Query performance problems with partitioned tables
2007-04-30 11:43 UTC Andreas Haumer <andreas@xss.co.at>
` Re: Query performance problems with partitioned tables
2007-04-30 13:05 UTC Guillaume Cottenceau <gc@mnc.ch>
` Re: Query performance problems with partitioned tables
2007-04-30 13:29 UTC Andreas Haumer <andreas@xss.co.at>
` Re: Query performance problems with partitioned tables
2007-04-30 13:45 UTC Richard Huxton <dev@archonet.com>
` Re: Query performance problems with partitioned tables
2007-04-30 13:54 UTC Guillaume Cottenceau <gc@mnc.ch>
` Re: Query performance problems with partitioned tables
2007-04-30 14:06 UTC Neil Peter Braggio <pbraggio@gmail.com>
` Re: Query performance problems with partitioned tables
2007-04-30 15:06 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Query performance problems with partitioned tables
2007-04-30 15:35 UTC Gregory Stark <stark@enterprisedb.com>
` Re: Query performance problems with partitioned tables
2007-04-30 16:58 UTC Andreas Haumer <andreas@xss.co.at>
` Re: Query performance problems with partitioned tables
2007-04-30 17:20 UTC Andreas Haumer <andreas@xss.co.at>
` Re: Query performance problems with partitioned tables
2007-04-30 17:23 UTC Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Query performance problems with partitioned tables
2007-04-30 19:19 UTC Gregory Stark <stark@enterprisedb.com>
` Re: Query performance problems with partitioned tables
2007-05-03 15:02 UTC Fei Liu <fei.liu@aepnetworks.com>
` Re: Query performance problems with partitioned tables
2007-05-04 02:37 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Query performance problems with partitioned tables
2007-05-04 15:11 UTC Scott Marlowe <smarlowe@g2switchworks.com>
` Re: Query performance problems with partitioned tables
2007-05-04 17:10 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Query performance problems with partitioned tables
2007-05-08 18:41 UTC Fei Liu <fei.liu@aepnetworks.com>
` Re: Query performance problems with partitioned tables
2007-05-08 18:58 UTC Scott Marlowe <smarlowe@g2switchworks.com>
[18+ 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