pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedMy quick and dirty "solution" (Re: Performance Problem with Vacuum of bytea table (PG 8.0.13))
2007-05-25 12:30 UTC Bastian Voigt <post@bastian-voigt.de>
` Re: My quick and dirty "solution" (Re: Performance Problem with Vacuum of bytea table (PG 8.0.13))
2007-05-25 12:57 UTC Kristo Kaiv <kristo.kaiv@skype.net>
` Re: My quick and dirty "solution" (Re: Performance Problem with Vacuum of bytea table (PG 8.0.13))
2007-05-25 13:16 UTC Richard Huxton <dev@archonet.com>
` Re: My quick and dirty "solution" (Re: Performance Problem with Vacuum of bytea table (PG 8.0.13))
2007-05-25 13:56 UTC Alvaro Herrera <alvherre@commandprompt.com>
` Re: My quick and dirty "solution" (Re: Performance Problem with Vacuum of bytea table (PG 8.0.13))
2007-05-25 14:06 UTC Bastian Voigt <post@bastian-voigt.de>
` Re: My quick and dirty "solution" (Re: Performance Problem with Vacuum of bytea table (PG 8.0.13))
2007-05-25 14:11 UTC Bastian Voigt <post@bastian-voigt.de>
` Re: My quick and dirty "solution" (Re: Performance P roblem with Vacuum of bytea table (PG 8.0.13))
2007-05-25 15:20 UTC Andreas Kostyrka <andreas@kostyrka.org>
[7+ messages in thread]
Auto-ANALYZE?
2007-05-23 23:46 UTC Craig James <craig_james@emolecules.com>
` Re: Auto-ANALYZE?
2007-05-23 23:55 UTC Tom Lane <tgl@sss.pgh.pa.us>
[2+ messages in thread]
does VACUUM ANALYZE complete with this error?
2007-05-23 13:26 UTC Susan Russo <russo@morgan.harvard.edu>
` Re: does VACUUM ANALYZE complete with this error?
2007-05-23 14:01 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: does VACUUM ANALYZE complete with this error?
2007-05-23 15:57 UTC Vivek Khera <vivek@khera.org>
` Re: does VACUUM ANALYZE complete with this error?
2007-05-23 18:18 UTC Susan Russo <russo@morgan.harvard.edu>
` Re: does VACUUM ANALYZE complete with this error?
2007-05-23 18:31 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: does VACUUM ANALYZE complete with this error?
2007-05-23 19:03 UTC Susan Russo <russo@morgan.harvard.edu>
` Re: does VACUUM ANALYZE complete with this error?
2007-05-23 22:38 UTC Scott Marlowe <smarlowe@g2switchworks.com>
[7+ messages in thread]
Drop table vs Delete record
2007-05-22 18:38 UTC Orhan Aglagul <oaglagul@cittio.com>
` Re: Drop table vs Delete record
2007-05-22 18:48 UTC Andreas Kostyrka <andreas@kostyrka.org>
` Re: Drop table vs Delete record
2007-05-22 18:53 UTC Orhan Aglagul <oaglagul@cittio.com>
` Re: Drop table vs Delete record
2007-05-23 20:24 UTC Chris Mair <chris@1006.org>
[4+ messages in thread]
Tips & Tricks for validating hardware/os
2007-05-22 13:10 UTC Stephane Bailliez <sbailliez@gmail.com>
` Re: Tips & Tricks for validating hardware/os
2007-05-22 13:45 UTC Alexander Staubo <alex@purefiction.net>
` Re: Tips & Tricks for validating hardware/os
2007-05-22 13:55 UTC PFC <lists@peufeu.com>
` Re: Tips & Tricks for validating hardware/os
2007-05-23 04:11 UTC Greg Smith <gsmith@gregsmith.com>
` Re: Tips & Tricks for validating hardware/os
2007-05-23 06:32 UTC Andreas Kostyrka <andreas@kostyrka.org>
` Re: Tips & Tricks for validating hardware/os
2007-05-23 15:51 UTC Vivek Khera <vivek@khera.org>
[6+ messages in thread]
Key/Value reference table generation: INSERT/UPDATE performance
2007-05-22 08:23 UTC valgog <valgog@gmail.com>
` Re: Key/Value reference table generation: INSERT/UPDATE performance
2007-05-22 09:05 UTC Peter Childs <peterachilds@gmail.com>
` Re: Key/Value reference table generation: INSERT/UPDATE performance
2007-05-22 09:21 UTC Richard Huxton <dev@archonet.com>
` Re: Key/Value reference table generation: INSERT/UPDATE performance
2007-05-22 10:00 UTC valgog <valgog@gmail.com>
` Re: Key/Value reference table generation: INSERT/UPDATE performance
2007-05-22 10:14 UTC PFC <lists@peufeu.com>
` Re: Key/Value reference table generation: INSERT/UPDATE performance
2007-05-22 10:35 UTC valgog <valgog@gmail.com>
` Re: Key/Value reference table generation: INSERT/UPDATE performance
2007-05-22 10:38 UTC valgog <valgog@gmail.com>
` Re: Key/Value reference table generation: INSERT/UPDATE performance
2007-05-22 12:28 UTC cedric <cedric.villemain@dalibo.com>
` Re: Key/Value reference table generation: INSERT/UPDATE performance
2007-05-23 08:04 UTC Guillaume Smet <guillaume.smet@gmail.com>
[9+ messages in thread]
Performace comparison of indexes over timestamp fields
2007-05-22 10:39 UTC Arnau <arnaulist@andromeiberica.com>
` Re: Performace comparison of indexes over timestamp fields
2007-05-22 12:39 UTC Alexander Staubo <alex@purefiction.net>
` Re: Performace comparison of indexes over timestamp fields
2007-05-22 12:43 UTC Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Performace comparison of indexes over timestamp fields
2007-05-22 13:00 UTC Alexander Staubo <alex@purefiction.net>
` Re: Performace comparison of indexes over timestamp fields
2007-05-22 14:11 UTC Tom Lane <tgl@sss.pgh.pa.us>
[5+ messages in thread]
is file size relevant in choosing index or table scan?
2007-05-22 09:29 UTC Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
` Re: is file size relevant in choosing index or table scan?
2007-05-22 09:42 UTC Richard Huxton <dev@archonet.com>
[2+ messages in thread]
500 requests per second
2007-05-12 06:43 UTC Tarhon-Onu Victor <mituc@iasi.rdsnet.ro>
` Re: 500 requests per second
2007-05-14 09:03 UTC Richard Huxton <dev@archonet.com>
` Re: 500 requests per second
2007-05-15 09:17 UTC Tarhon-Onu Victor <mituc@iasi.rdsnet.ro>
` Re: 500 requests per second
2007-05-15 10:47 UTC Richard Huxton <dev@archonet.com>
` Re: 500 requests per second
2007-05-15 23:28 UTC Jim C. Nasby <decibel@decibel.org>
` Re: 500 requests per second
2007-05-21 19:50 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: 500 requests per second
2007-05-21 20:46 UTC Jim C. Nasby <decibel@decibel.org>
` Re: 500 requests per second
2007-05-21 20:48 UTC PFC <lists@peufeu.com>
` Re: 500 requests per second
2007-05-22 00:52 UTC Dave Cramer <pg@fastcrypt.com>
[9+ messages in thread]
Rewriting DISTINCT and losing performance
2007-05-21 04:28 UTC Chuck D. <pgsql-performance@nullmx.com>
` Re: Rewriting DISTINCT and losing performance
2007-05-21 09:14 UTC Josh Berkus <josh@agliodbs.com>
` Re: Rewriting DISTINCT and losing performance
2007-05-21 11:40 UTC Richard Huxton <dev@archonet.com>
` Re: Rewriting DISTINCT and losing performance
2007-05-21 15:09 UTC Chuck D. <pgsql-performance@nullmx.com>
` Re: Rewriting DISTINCT and losing performance
2007-05-21 17:13 UTC Chuck D. <pgsql-performance@nullmx.com>
` Re: Rewriting DISTINCT and losing performance
2007-05-21 17:34 UTC Richard Huxton <dev@archonet.com>
` Re: Rewriting DISTINCT and losing performance
2007-05-21 18:17 UTC Chuck D. <pgsql-performance@nullmx.com>
` Re: Rewriting DISTINCT and losing performance
2007-05-21 21:32 UTC Tom Lane <tgl@sss.pgh.pa.us>
[8+ messages in thread]
121+ million record table perf problems
2007-05-18 17:43 UTC cyber-postgres@midnightfantasy.com
` Re: 121+ million record table perf problems
2007-05-18 18:30 UTC Andrew Sullivan <ajs@crankycanuck.ca>
` Re: 121+ million record table perf problems
2007-05-18 18:51 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: 121+ million record table perf problems
2007-05-18 18:53 UTC Brian Hurt <bhurt@janestcapital.com>
` Re: 121+ million record table perf problems
2007-05-18 19:08 UTC Alan Hodgson <ahodgson@simkin.ca>
` Re: 121+ million record table perf problems
2007-05-18 19:37 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: 121+ million record table perf problems
2007-05-18 22:33 UTC Craig James <craig_james@emolecules.com>
` Re: 121+ million record table perf problems
2007-05-18 23:20 UTC Alvaro Herrera <alvherre@commandprompt.com>
` Re: 121+ million record table perf problems
2007-05-19 05:00 UTC Greg Smith <gsmith@gregsmith.com>
` Re: 121+ million record table perf problems
2007-05-21 21:24 UTC Vivek Khera <vivek@khera.org>
[10+ messages in thread]
pg_stats how-to?
2007-05-14 00:43 UTC Yudhvir Singh Sidhu <ysidhu@gmail.com>
` Re: pg_stats how-to?
2007-05-14 00:51 UTC Shoaib Mir <shoaibmir@gmail.com>
` Re: pg_stats how-to?
2007-05-14 01:44 UTC Adam Tauno Williams <adamtaunowilliams@gmail.com>
` Re: pg_stats how-to?
2007-05-14 16:16 UTC Y Sidhu <ysidhu@gmail.com>
` Re: pg_stats how-to?
2007-05-14 16:26 UTC Jim C. Nasby <decibel@decibel.org>
` Re: pg_stats how-to?
2007-05-14 17:45 UTC Jim C. Nasby <decibel@decibel.org>
` Re: pg_stats how-to?
2007-05-14 18:09 UTC Y Sidhu <ysidhu@gmail.com>
` Re: pg_stats how-to?
2007-05-14 18:36 UTC Jim C. Nasby <decibel@decibel.org>
` Re: pg_stats how-to?
2007-05-14 19:02 UTC Y Sidhu <ysidhu@gmail.com>
` Re: pg_stats how-to?
2007-05-14 19:07 UTC Jim C. Nasby <decibel@decibel.org>
` Re: pg_stats how-to?
2007-05-14 20:53 UTC Y Sidhu <ysidhu@gmail.com>
` Re: pg_stats how-to?
2007-05-14 21:09 UTC Bill Moran <wmoran@collaborativefusion.com>
` Re: pg_stats how-to?
2007-05-14 22:15 UTC Y Sidhu <ysidhu@gmail.com>
` Re: pg_stats how-to?
2007-05-15 00:20 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: pg_stats how-to?
2007-05-15 23:38 UTC Jim C. Nasby <decibel@decibel.org>
` Re: pg_stats how-to?
2007-05-18 23:26 UTC Y Sidhu <ysidhu@gmail.com>
` Re: pg_stats how-to?
2007-05-21 17:24 UTC Jim C. Nasby <decibel@decibel.org>
` Re: pg_stats how-to?
2007-05-21 20:19 UTC Y Sidhu <ysidhu@gmail.com>
[18+ messages in thread]
Increasing Shared_buffers = slow commits?
2007-05-21 14:42 UTC Chris Hoover <revoohc@gmail.com>
` Re: Increasing Shared_buffers = slow commits?
2007-05-21 18:40 UTC Merlin Moncure <mmoncure@gmail.com>
[2+ messages in thread]
Ever Increasing IOWAIT
2007-05-17 22:45 UTC Ralph Mason <ralph.mason@telogis.com>
` Re: Ever Increasing IOWAIT
2007-05-17 23:02 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: Ever Increasing IOWAIT
2007-05-17 23:19 UTC Ralph Mason <ralph.mason@telogis.com>
` Re: Ever Increasing IOWAIT
2007-05-18 09:12 UTC Richard Huxton <dev@archonet.com>
` Re: Ever Increasing IOWAIT
2007-05-18 13:58 UTC Mark Lewis <mark.lewis@mir3.com>
` Re: Ever Increasing IOWAIT
2007-05-20 20:40 UTC Ralph Mason <ralph.mason@telogis.com>
` Re: Ever Increasing IOWAIT
2007-05-20 20:41 UTC Ralph Mason <ralph.mason@telogis.com>
` Re: Ever Increasing IOWAIT
2007-05-20 21:55 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Ever Increasing IOWAIT
2007-05-21 05:17 UTC Ralph Mason <ralph.mason@telogis.com>
[9+ messages in thread]
Re: Diminishing bandwidth performance with multiple quad core X5355s
2007-05-13 22:00 UTC jlmarin <jlmarin@gmail.com>
` Re: Diminishing bandwidth performance with multiple quad core X5355s
2007-05-20 17:13 UTC Arjen van der Meijden <acmmailing@tweakers.net>
[2+ messages in thread]
QP Problem
2007-05-19 22:08 UTC s d <s.d.sauron@gmail.com>
` Re: QP Problem
2007-05-19 23:20 UTC Tom Lane <tgl@sss.pgh.pa.us>
[2+ messages in thread]
Background vacuum
2007-05-10 04:38 UTC Daniel Haensse <daniel.haensse@swissembedded.com>
` Re: Background vacuum
2007-05-10 05:05 UTC Dan Harris <fbsd@drivefaster.net>
` Re: Background vacuum
2007-05-11 00:10 UTC Ron Mayer <rm_pg@cheapcomplexdevices.com>
` Re: Background vacuum
2007-05-17 13:55 UTC Andrew Sullivan <ajs@crankycanuck.ca>
` Re: Background vacuum
2007-05-18 01:44 UTC Ron Mayer <rm_pg@cheapcomplexdevices.com>
` Re: Background vacuum
2007-05-18 02:50 UTC Greg Smith <gsmith@gregsmith.com>
` Re: Background vacuum
2007-05-18 03:09 UTC Ron Mayer <rm_pg@cheapcomplexdevices.com>
` Re: Background vacuum
2007-05-18 03:22 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Background vacuum
2007-05-18 19:21 UTC Ron Mayer <rm_pg@cheapcomplexdevices.com>
` Re: Background vacuum
2007-05-19 05:27 UTC Greg Smith <gsmith@gregsmith.com>
` Re: Background vacuum
2007-05-19 22:38 UTC Ron Mayer <rm_pg@cheapcomplexdevices.com>
[11+ messages in thread]
Efficient recursion
2007-05-18 22:41 UTC C Storm <christian.storm@gmail.com>
` Re: Efficient recursion
2007-05-19 18:12 UTC Tom Lane <tgl@sss.pgh.pa.us>
[2+ messages in thread]
CPU Intensive query
2007-05-18 16:02 UTC Abu Mushayeed <abumushayeed@yahoo.com>
` Re: CPU Intensive query
2007-05-18 16:42 UTC Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: CPU Intensive query
2007-05-18 21:37 UTC Abu Mushayeed <abumushayeed@yahoo.com>
` Re: CPU Intensive query
2007-05-18 21:51 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: CPU Intensive query
2007-05-18 22:26 UTC Abu Mushayeed <abumushayeed@yahoo.com>
` Re: CPU Intensive query
2007-05-18 22:32 UTC Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: CPU Intensive query
2007-05-18 22:35 UTC Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: CPU Intensive query
2007-05-19 13:20 UTC Andrew Sullivan <ajs@crankycanuck.ca>
[8+ messages in thread]
Slow queries on big table
2007-05-18 18:30 UTC Tyrrill, Ed <tyrrill_ed@emc.com>
` Re: Slow queries on big table
2007-05-18 19:36 UTC Scott Marlowe <smarlowe@g2switchworks.com>
` Re: Slow queries on big table
2007-05-18 19:59 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Slow queries on big table
2007-05-18 20:05 UTC Andrew Kroeger <andrew@sprocks.gotdns.com>
` Re: Slow queries on big table
2007-05-18 20:06 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Slow queries on big table
2007-05-18 21:22 UTC Tyrrill, Ed <tyrrill_ed@emc.com>
` Re: Slow queries on big table
2007-05-18 21:28 UTC Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Slow queries on big table
2007-05-18 21:36 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Slow queries on big table
2007-05-18 23:16 UTC Tyrrill, Ed <tyrrill_ed@emc.com>
[9+ messages in thread]
choosing fillfactor
2007-05-18 18:57 UTC Gene Hart <genekhart@gmail.com>
` Re: choosing fillfactor
2007-05-18 20:19 UTC Heikki Linnakangas <heikki@enterprisedb.com>
[2+ messages in thread]
reading large BYTEA type is slower than expected
2007-05-18 17:11 UTC Mark Harris <mharris@esri.com>
` Re: reading large BYTEA type is slower than expected
2007-05-18 17:48 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: reading large BYTEA type is slower than expected
2007-05-18 17:50 UTC Y Sidhu <ysidhu@gmail.com>
` Re: reading large BYTEA type is slower than expected
2007-05-18 18:51 UTC Mark Harris <mharris@esri.com>
` Re: reading large BYTEA type is slower than expected
2007-05-18 19:37 UTC Mark Harris <mharris@esri.com>
[5+ messages in thread]
Automatic adjustment of bgwriter_lru_maxpages (was: Dead Space Map version 2)
2007-03-05 04:10 UTC ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>
` Automatic adjustment of bgwriter_lru_maxpages (was: Dead Space Map version 2)
2007-03-05 04:11 UTC ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>
` Re: Automatic adjustment of bgwriter_lru_maxpages
2007-03-05 08:22 UTC ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>
` Re: Automatic adjustment of bgwriter_lru_maxpages
2007-03-25 01:44 UTC Bruce Momjian <bruce@momjian.us>
` Re: Automatic adjustment of bgwriter_lru_maxpages
2007-04-12 10:57 UTC Heikki Linnakangas <heikki@enterprisedb.com>
` Re: Automatic adjustment of bgwriter_lru_maxpages
2007-05-13 01:32 UTC Greg Smith <gsmith@gregsmith.com>
` Re: Automatic adjustment of bgwriter_lru_maxpages
2007-05-13 16:27 UTC Heikki Linnakangas <heikki@enterprisedb.com>
` Re: Automatic adjustment of bgwriter_lru_maxpages
2007-05-13 18:54 UTC Greg Smith <gsmith@gregsmith.com>
` Re: Automatic adjustment of bgwriter_lru_maxpages
2007-05-14 09:04 UTC ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>
` Re: Automatic adjustment of bgwriter_lru_maxpages
2007-05-14 13:34 UTC Greg Smith <gsmith@gregsmith.com>
` Re: Automatic adjustment of bgwriter_lru_maxpages
2007-05-14 13:41 UTC Heikki Linnakangas <heikki@enterprisedb.com>
` Re: Automatic adjustment of bgwriter_lru_maxpages
2007-05-14 13:52 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Automatic adjustment of bgwriter_lru_maxpages
2007-05-14 13:57 UTC Greg Smith <gsmith@gregsmith.com>
` Re: Automatic adjustment of bgwriter_lru_maxpages
2007-05-15 03:19 UTC Greg Smith <gsmith@gregsmith.com>
` Re: Automatic adjustment of bgwriter_lru_maxpages
2007-05-15 04:55 UTC daveg <daveg@sonic.net>
` Re: Automatic adjustment of bgwriter_lru_maxpages
2007-05-15 12:45 UTC Heikki Linnakangas <heikki@enterprisedb.com>
` Re: Automatic adjustment of bgwriter_lru_maxpages
2007-05-16 00:08 UTC Jim C. Nasby <decibel@decibel.org>
` Re: [PATCHES] Automatic adjustment of bgwriter_lru_maxpages
2007-05-16 03:02 UTC Greg Smith <gsmith@gregsmith.com>
` Re: Automatic adjustment of bgwriter_lru_maxpages
2007-05-17 22:47 UTC Bruce Momjian <bruce@momjian.us>
[19+ messages in thread]
WAL log performance/efficiency question
2007-05-17 14:04 UTC Keaton Adams <kadams@mxlogic.com>
` Re: WAL log performance/efficiency question
2007-05-17 14:23 UTC Heikki Linnakangas <heikki@enterprisedb.com>
` Re: WAL log performance/efficiency question
2007-05-17 14:55 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: WAL log performance/efficiency question
2007-05-17 15:34 UTC Keaton Adams <kadams@mxlogic.com>
` Re: WAL log performance/efficiency question
2007-05-17 15:52 UTC Heikki Linnakangas <heikki@enterprisedb.com>
` Re: WAL log performance/efficiency question
2007-05-17 16:01 UTC Keaton Adams <kadams@mxlogic.com>
[6+ messages in thread]
Disk Fills Up and fsck "Compresses" it
2007-05-15 20:18 UTC Y Sidhu <ysidhu@gmail.com>
` Re: Disk Fills Up and fsck "Compresses" it
2007-05-15 23:41 UTC Jim C. Nasby <decibel@decibel.org>
` Re: Disk Fills Up and fsck "Compresses" it
2007-05-16 15:21 UTC Y Sidhu <ysidhu@gmail.com>
` Re: Disk Fills Up and fsck "Compresses" it
2007-05-16 15:51 UTC Jim C. Nasby <decibel@decibel.org>
` Re: Disk Fills Up and fsck "Compresses" it
2007-05-16 23:28 UTC Mark Kirkwood <markir@paradise.net.nz>
[5+ 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