pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgreSQL performance question.
2005-12-15 01:51 UTC Harry Jackson <harryjackson@gmail.com>
` Re: PostgreSQL performance question.
2005-12-15 02:02 UTC Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: PostgreSQL performance question.
2005-12-15 02:29 UTC Gavin Sherry <swm@alcove.com.au>
` Re: PostgreSQL performance question.
2005-12-18 02:11 UTC Harry Jackson <harryjackson@gmail.com>
[4+ messages in thread]
How much expensive are row level statistics?
2005-12-11 11:53 UTC Carlos Benkendorf <carlosbenkendorf@yahoo.com.br>
` Re: How much expensive are row level statistics?
2005-12-11 19:44 UTC Michael Fuhr <mike@fuhr.org>
` Re: How much expensive are row level statistics?
2005-12-12 13:23 UTC Alvaro Herrera <alvherre@commandprompt.com>
` Re: How much expensive are row level statistics?
2005-12-12 18:33 UTC Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: How much expensive are row level statistics?
2005-12-12 18:50 UTC Michael Fuhr <mike@fuhr.org>
` Re: How much expensive are row level statistics?
2005-12-12 20:37 UTC Michael Fuhr <mike@fuhr.org>
` Re: How much expensive are row level statistics?
2005-12-12 23:01 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: How much expensive are row level statistics?
2005-12-13 01:07 UTC Michael Fuhr <mike@fuhr.org>
` Re: How much expensive are row level statistics?
2005-12-13 03:20 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: How much expensive are row level statistics?
2005-12-15 23:44 UTC Michael Fuhr <mike@fuhr.org>
` Re: How much expensive are row level statistics?
2005-12-16 00:06 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: How much expensive are row level statistics?
2005-12-16 05:44 UTC Kevin Brown <kevin@sysexperts.com>
` Re: How much expensive are row level statistics?
2005-12-16 13:17 UTC Simon Riggs <simon@2ndquadrant.com>
` Re: How much expensive are row level statistics?
2005-12-16 14:40 UTC Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: How much expensive are row level statistics?
2005-12-17 02:44 UTC Bruce Momjian <pgman@candle.pha.pa.us>
[15+ messages in thread]
Lots of postmaster processes (fwd)
2005-12-13 17:25 UTC Ameet Kini <akini@cs.wisc.edu>
` Re: Lots of postmaster processes (fwd)
2005-12-16 21:56 UTC Jim C. Nasby <jnasby@pervasive.com>
[2+ messages in thread]
8.1 - pg_autovacuum question
2005-12-16 19:40 UTC Chris Hoover <revoohc@gmail.com>
` Re: 8.1 - pg_autovacuum question
2005-12-16 20:26 UTC Alvaro Herrera <alvherre@commandprompt.com>
[2+ messages in thread]
ALTER TABLE SET TABLESPACE and pg_toast
2005-12-16 14:25 UTC PostgreSQL <martin@portant.com>
` Re: ALTER TABLE SET TABLESPACE and pg_toast
2005-12-16 15:23 UTC Tom Lane <tgl@sss.pgh.pa.us>
[2+ messages in thread]
Crashing DB or Server?
2005-12-16 13:15 UTC Moritz Bayer <moritz.bayer@googlemail.com>
` Re: Crashing DB or Server?
2005-12-16 13:38 UTC Harry Jackson <harryjackson@gmail.com>
` Re: Crashing DB or Server?
2005-12-16 14:10 UTC Moritz Bayer <moritz.bayer@googlemail.com>
` Re: Crashing DB or Server?
2005-12-16 14:32 UTC Csaba Nagy <nagy@ecircle-ag.com>
[4+ messages in thread]
Re: [postgis-users] Is my query planner failing me, or vice versa?
2005-12-15 00:23 UTC Gregory S. Williamson <gsw@globexplorer.com>
` Re: [postgis-users] Is my query planner failing me, or vice versa?
2005-12-15 05:36 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [postgis-users] Is my query planner failing me, or vice versa?
2005-12-15 11:03 UTC Markus Schaber <schabi@logix-tt.com>
` Re: [postgis-users] Is my query planner failing me, or vice versa?
2005-12-15 12:03 UTC Gregory S. Williamson <gsw@globexplorer.com>
` Re: [postgis-users] Is my query planner failing me,or vice versa?
2005-12-15 14:20 UTC Mark Cave-Ayland <m.cave-ayland@webbased.co.uk>
[5+ messages in thread]
Auto-tuning a VIEW?
2005-12-14 21:30 UTC Zoltan Boszormenyi <zboszor@dunaweb.hu>
` Re: Auto-tuning a VIEW?
2005-12-14 21:38 UTC PFC <lists@peufeu.com>
` Re: Auto-tuning a VIEW?
2005-12-14 22:18 UTC PFC <lists@peufeu.com>
` Re: Auto-tuning a VIEW?
2005-12-14 22:39 UTC Zoltan Boszormenyi <zboszor@dunaweb.hu>
[4+ messages in thread]
Convert IN sublink to join
2005-12-14 13:27 UTC francisco.santos@tagus.ist.utl.pt
` Re: Convert IN sublink to join
2005-12-14 15:26 UTC Tom Lane <tgl@sss.pgh.pa.us>
[2+ messages in thread]
Memory Leakage Problem
2005-12-06 09:22 UTC Kathy Lo <kathy.lo.ky@gmail.com>
` Re: Memory Leakage Problem
2005-12-06 14:45 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Memory Leakage Problem
2005-12-06 17:48 UTC Scott Marlowe <smarlowe@g2switchworks.com>
` Re: Memory Leakage Problem
2005-12-07 21:33 UTC Scott Marlowe <smarlowe@g2switchworks.com>
` Re: Memory Leakage Problem
2005-12-08 02:25 UTC Kathy Lo <kathy.lo.ky@gmail.com>
` Re: Memory Leakage Problem
2005-12-08 03:46 UTC Mike Rylander <mrylander@gmail.com>
` Re: Memory Leakage Problem
2005-12-08 04:38 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Memory Leakage Problem
2005-12-08 14:00 UTC Mike Rylander <mrylander@gmail.com>
` Re: Memory Leakage Problem
2005-12-12 20:19 UTC Will Glynn <wglynn@freedomhealthcare.org>
` Re: Memory Leakage Problem
2005-12-12 20:48 UTC Mike Rylander <mrylander@gmail.com>
` Re: Memory Leakage Problem
2005-12-13 04:17 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Memory Leakage Problem
2005-12-13 04:31 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: Memory Leakage Problem
2005-12-13 07:42 UTC John Sidney-Woollett <johnsw@wardbrook.com>
` Re: Memory Leakage Problem
2005-12-13 07:47 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Memory Leakage Problem
2005-12-13 08:05 UTC John Sidney-Woollett <johnsw@wardbrook.com>
` Re: Memory Leakage Problem
2005-12-13 08:22 UTC Jim C. Nasby <jim@nasby.net>
` Re: Memory Leakage Problem
2005-12-13 15:13 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Memory Leakage Problem
2005-12-13 16:37 UTC John Sidney-Woollett <johnsw@wardbrook.com>
` Re: Memory Leakage Problem
2005-12-13 17:40 UTC Scott Marlowe <smarlowe@g2switchworks.com>
` Re: Memory Leakage Problem
2005-12-13 17:58 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Memory Leakage Problem
2005-12-14 09:21 UTC Martijn van Oosterhout <kleptog@svana.org>
` Re: Memory Leakage Problem
2005-12-14 13:52 UTC John Sidney-Woollett <johnsw@wardbrook.com>
[22+ messages in thread]
Table Partitions / Partial Indexes
2005-12-12 02:07 UTC Mike C <smith.not.western@gmail.com>
` Re: Table Partitions / Partial Indexes
2005-12-12 02:39 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Table Partitions / Partial Indexes
2005-12-12 02:49 UTC Mike C <smith.not.western@gmail.com>
` Re: Table Partitions / Partial Indexes
2005-12-13 23:17 UTC Simon Riggs <simon@2ndquadrant.com>
` Re: Table Partitions / Partial Indexes
2005-12-13 23:54 UTC Mike C <smith.not.western@gmail.com>
[5+ messages in thread]
query from partitions
2005-12-13 15:18 UTC Ключников А.С. <alexs@analytic.mv.ru>
` Re: query from partitions
2005-12-13 15:59 UTC Richard Huxton <dev@archonet.com>
` Re: query from partitions
2005-12-13 16:08 UTC Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: query from partitions
2005-12-13 16:57 UTC Ключников А.С. <alexs@analytic.mv.ru>
` Re: query from partitions
2005-12-13 22:48 UTC Simon Riggs <simon@2ndquadrant.com>
[5+ messages in thread]
Small table or partial index?
2005-12-02 23:28 UTC Francisco Reyes <lists@stringsutils.com>
` Re: Small table or partial index?
2005-12-12 22:24 UTC Jim C. Nasby <jnasby@pervasive.com>
` Re: Small table or partial index?
2005-12-13 16:08 UTC Francisco Reyes <lists@stringsutils.com>
[3+ messages in thread]
opinion on disk speed
2005-12-08 16:52 UTC Vivek Khera <vivek@khera.org>
` Re: opinion on disk speed
2005-12-08 17:03 UTC Dave Page <dpage@vale-housing.co.uk>
` Re: opinion on disk speed
2005-12-08 17:50 UTC Scott Marlowe <smarlowe@g2switchworks.com>
` Re: opinion on disk speed
2005-12-08 19:21 UTC Jeffrey W. Baker <jwbaker@acm.org>
` Re: opinion on disk speed
2005-12-08 23:43 UTC David Lang <dlang@invendra.net>
` Re: opinion on disk speed
2005-12-09 14:15 UTC Jeremy Haile <jhaile@fastmail.fm>
` Re: opinion on disk speed
2005-12-09 15:47 UTC Frank Wiles <frank@wiles.org>
` Re: opinion on disk speed
2005-12-09 15:50 UTC Andreas Pflug <pgadmin@pse-consulting.de>
` Re: opinion on disk speed
2005-12-09 15:50 UTC Frank Wiles <frank@wiles.org>
` Re: opinion on disk speed
2005-12-09 15:58 UTC Frank Wiles <frank@wiles.org>
` Re: opinion on disk speed
2005-12-12 18:42 UTC Vivek Khera <vivek@khera.org>
` Re: opinion on disk speed
2005-12-12 21:59 UTC Vivek Khera <vivek@khera.org>
` Re: opinion on disk speed
2005-12-12 22:16 UTC J. Andrew Rogers <jrogers@neopolitan.com>
` Re: opinion on disk speed
2005-12-12 22:19 UTC Vivek Khera <vivek@khera.org>
` Re: opinion on disk speed
2005-12-12 23:12 UTC Scott Marlowe <smarlowe@g2switchworks.com>
` Re: opinion on disk speed
2005-12-12 23:17 UTC J. Andrew Rogers <jrogers@neopolitan.com>
[16+ messages in thread]
Joining 2 tables with 300 million rows
2005-12-08 16:59 UTC Amit V Shah <ashah@tagaudit.com>
` Re: Joining 2 tables with 300 million rows
2005-12-08 18:47 UTC Dmitri Bichko <dbichko@aveopharma.com>
` Re: Joining 2 tables with 300 million rows
2005-12-08 22:01 UTC Amit V Shah <ashah@tagaudit.com>
` Re: Joining 2 tables with 300 million rows
2005-12-09 15:32 UTC Jeff Trout <threshar@torgo.978.org>
` Re: Joining 2 tables with 300 million rows
2005-12-12 22:34 UTC Manfred Koizar <mkoi-pg@aon.at>
[5+ messages in thread]
Very slow queries - please help.
2005-11-24 13:06 UTC Bealach-na Bo <bealach_na_bo@hotmail.com>
` Re: Very slow queries - please help.
2005-11-24 13:23 UTC Claus Guttesen <kometen@gmail.com>
` Re: Very slow queries - please help.
2005-11-24 14:36 UTC Bealach-na Bo <bealach_na_bo@hotmail.com>
` Re: Very slow queries - please help.
2005-11-24 15:03 UTC Guillaume Smet <guillaume.smet@openwide.fr>
` Re: Very slow queries - please help.
2005-11-24 15:15 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Very slow queries - please help
2005-11-24 18:14 UTC Bealach-na Bo <bealach_na_bo@hotmail.com>
` Very slow queries - please help
2005-11-24 18:51 UTC Bealach-na Bo <bealach_na_bo@hotmail.com>
` Re: Very slow queries - please help
2005-12-04 06:40 UTC Thomas F. O'Connell <tfo@sitening.com>
` Re: Very slow queries - please help
2005-12-12 16:24 UTC Bealach-na Bo <bealach_na_bo@hotmail.com>
[9+ messages in thread]
7.4.7 vs. 8.1
2005-12-12 08:54 UTC Szabolcs BALLA <szballa@confinsystems.com>
` Re: 7.4.7 vs. 8.1
2005-12-12 12:04 UTC Steinar H. Gunderson <sgunderson@bigfoot.com>
[2+ messages in thread]
Is RAID10 the best choice?
2005-12-10 11:34 UTC Carlos Benkendorf <carlosbenkendorf@yahoo.com.br>
` Re: Is RAID10 the best choice?
2005-12-12 04:45 UTC Alex Turner <armtuk@gmail.com>
[2+ messages in thread]
Join the same row
2005-12-06 20:22 UTC Edison Azzi <edisonazzi@terra.com.br>
` Re: Join the same row
2005-12-07 09:27 UTC Richard Huxton <dev@archonet.com>
` Re: Join the same row
2005-12-07 18:45 UTC Edison Azzi <edisonazzi@terra.com.br>
` Re: Join the same row
2005-12-07 18:55 UTC Richard Huxton <dev@archonet.com>
` Re: Join the same row
2005-12-11 20:36 UTC Tom Lane <tgl@sss.pgh.pa.us>
[5+ messages in thread]
Bitmasks
2005-12-10 17:12 UTC Ivan Voras <ivoras@fer.hr>
` Re: Bitmasks
2005-12-11 06:12 UTC Greg Stark <gsstark@mit.edu>
[2+ messages in thread]
Queries taking ages in PG 8.1, have been much faster in PG<=8.0
2005-12-01 15:49 UTC Markus Wollny <Markus.Wollny@computec.de>
` Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0
2005-12-01 16:26 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0
2005-12-01 16:30 UTC Markus Wollny <Markus.Wollny@computec.de>
` Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0
2005-12-01 16:34 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0
2005-12-04 13:24 UTC Markus Wollny <Markus.Wollny@computec.de>
` Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0
2005-12-04 18:31 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0
2005-12-05 10:28 UTC Markus Wollny <Markus.Wollny@computec.de>
` Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0
2005-12-05 14:32 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0
2005-12-05 14:44 UTC Markus Wollny <Markus.Wollny@computec.de>
` Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0
2005-12-05 15:11 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0
2005-12-05 15:40 UTC Markus Wollny <Markus.Wollny@computec.de>
` Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0
2005-12-05 15:45 UTC Markus Wollny <Markus.Wollny@computec.de>
` Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0
2005-12-10 17:14 UTC Manfred Koizar <mkoi-pg@aon.at>
[13+ messages in thread]
Clustered tables and seqscan disabled
2005-12-10 15:29 UTC Henrique Engelmann <henriqueengelmann@yahoo.com.br>
` Re: Clustered tables and seqscan disabled
2005-12-10 16:53 UTC Tom Lane <tgl@sss.pgh.pa.us>
[2+ messages in thread]
Executing a shell command from a PG function
2005-12-10 15:55 UTC Yves Vindevogel <yves.vindevogel@implements.be>
` Re: Executing a shell command from a PG function
2005-12-10 16:14 UTC Jaime Casanova <systemguards@gmail.com>
` Re: Executing a shell command from a PG function
2005-12-10 16:22 UTC Michael Fuhr <mike@fuhr.org>
` Re: Executing a shell command from a PG function
2005-12-10 16:53 UTC Yves Vindevogel <yves.vindevogel@implements.be>
[4+ messages in thread]
Disk tests for a new database server
2005-12-08 12:12 UTC Rory Campbell-Lange <rory@campbell-lange.net>
` Re: Disk tests for a new database server
2005-12-08 15:06 UTC Steve Poe <spoe@sfnet.cc>
` Re: Disk tests for a new database server
2005-12-08 22:56 UTC Rory Campbell-Lange <rory@campbell-lange.net>
[3+ messages in thread]
slow COMMITs
2005-12-08 17:10 UTC Evgeny Gridasov <eugrid@fpm.kubsu.ru>
[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