pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedwhich ext3 fs type should I use for postgresql
2008-05-15 10:11 UTC Philippe Amelant <pamelant@companeo.com>
` Re: which ext3 fs type should I use for postgresql
2008-05-15 11:29 UTC Matthew Wakeling <matthew@flymine.org>
` Re: which ext3 fs type should I use for postgresql
2008-05-15 12:20 UTC david@lang.hm
` Re: which ext3 fs type should I use for postgresql
2008-05-15 12:23 UTC Matthew Wakeling <matthew@flymine.org>
` Re: which ext3 fs type should I use for postgresql
2008-05-15 14:57 UTC Craig James <craig_james@emolecules.com>
` Re: which ext3 fs type should I use for postgresql
2008-05-15 15:08 UTC Guillaume Cottenceau <gc@mnc.ch>
` Re: which ext3 fs type should I use for postgresql
2008-05-15 15:21 UTC Matthew Wakeling <matthew@flymine.org>
` Re: which ext3 fs type should I use for postgresql
2008-05-15 15:32 UTC Guillaume Cottenceau <gc@mnc.ch>
` Re: which ext3 fs type should I use for postgresql
2008-05-15 15:38 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: which ext3 fs type should I use for postgresql
2008-05-15 15:56 UTC Guillaume Cottenceau <gc@mnc.ch>
` Re: which ext3 fs type should I use for postgresql
2008-05-16 09:58 UTC david@lang.hm
` Re: which ext3 fs type should I use for postgresql
2008-05-16 17:07 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: which ext3 fs type should I use for postgresql
2008-05-16 17:15 UTC Joshua D. Drake <jd@commandprompt.com>
[13+ messages in thread]
Join runs for > 10 hours and then fills up >1.3TB of disk space
2008-05-16 06:31 UTC kevin kempter <kevin@kevinkempterllc.com>
` Re: Join runs for > 10 hours and then fills up >1.3TB of disk space
2008-05-16 06:58 UTC kevin kempter <kevin@kevinkempterllc.com>
` Re: Join runs for > 10 hours and then fills up >1.3TB of disk space
2008-05-16 07:08 UTC kevin kempter <kevin@kevinkempterllc.com>
` Re: Join runs for > 10 hours and then fills up >1.3TB of disk space
2008-05-16 07:15 UTC Claus Guttesen <kometen@gmail.com>
` Re: Join runs for > 10 hours and then fills up >1.3TB of disk space
2008-05-16 07:38 UTC Simon Riggs <simon@2ndquadrant.com>
` Re: Join runs for > 10 hours and then fills up >1.3TB of disk space
2008-05-16 07:40 UTC Richard Huxton <dev@archonet.com>
` Re: Join runs for > 10 hours and then fills up >1.3TB of disk space
2008-05-16 08:00 UTC kevin kempter <kevin@kevinkempterllc.com>
` Re: Join runs for > 10 hours and then fills up >1.3TB of disk space
2008-05-16 08:16 UTC Richard Huxton <dev@archonet.com>
` Re: Join runs for > 10 hours and then fills up >1.3TB of disk space
2008-05-16 08:18 UTC Richard Huxton <dev@archonet.com>
` Re: Join runs for > 10 hours and then fills up >1.3TB of disk space
2008-05-16 08:36 UTC Luke Lonergan <LLonergan@greenplum.com>
` Re: Join runs for > 10 hours and then fills up >1.3TB of disk space
2008-05-16 08:38 UTC kevin kempter <kevin@kevinkempterllc.com>
[11+ messages in thread]
Update performance degrades over time
2008-05-14 22:31 UTC Subbiah Stalin-XCGF84 <SSubbiah@Motorola.com>
` Re: Update performance degrades over time
2008-05-15 13:56 UTC Jeffrey Baker <jwbaker@gmail.com>
` Re: Update performance degrades over time
2008-05-15 16:28 UTC Subbiah Stalin-XCGF84 <SSubbiah@Motorola.com>
` Re: Update performance degrades over time
2008-05-15 19:27 UTC Subbiah Stalin-XCGF84 <SSubbiah@Motorola.com>
[4+ messages in thread]
poor row estimates with multi-column joins
2008-05-14 22:34 UTC Robert Treat <xzilla@users.sourceforge.net>
postgres overall performance seems to degrade when large SELECT are requested
2008-05-14 10:00 UTC Valentin Bogdanov <valiouk@yahoo.co.uk>
` Re: postgres overall performance seems to degrade when large SELECT are requested
2008-05-14 11:10 UTC PFC <lists@peufeu.com>
[2+ messages in thread]
can I move sort to first outer join ?
2008-05-14 04:40 UTC fernando castano <Fernando.Castano@Sun.COM>
` Re: can I move sort to first outer join ?
2008-05-14 09:58 UTC PFC <lists@peufeu.com>
[2+ messages in thread]
Problem with 11 M records table
2008-05-13 16:57 UTC idc danny <idcdanny@yahoo.com>
` Re: Problem with 11 M records table
2008-05-13 17:03 UTC Bill Moran <wmoran@collaborativefusion.com>
` Re: Problem with 11 M records table
2008-05-13 17:09 UTC salman <salmanb@quietcaresystems.com>
` Re: Problem with 11 M records table
2008-05-13 17:17 UTC Craig James <craig_james@emolecules.com>
` Re: Problem with 11 M records table
2008-05-13 17:57 UTC Craig James <craig_james@emolecules.com>
` Re: Problem with 11 M records table
2008-05-13 18:02 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Problem with 11 M records table
2008-05-14 05:58 UTC Ramasubramanian G <ramasubramanian.g@renaissance-it.com>
[7+ messages in thread]
Installation Steps to migrate to Postgres 8.3.1
2008-05-13 05:40 UTC Gauri Kanekar <meetgaurikanekar@gmail.com>
` Re: Installation Steps to migrate to Postgres 8.3.1
2008-05-13 06:42 UTC Claus Guttesen <kometen@gmail.com>
` Re: Installation Steps to migrate to Postgres 8.3.1
2008-05-13 08:25 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Installation Steps to migrate to Postgres 8.3.1
2008-05-13 12:00 UTC Knight, Doug <dknight@wsi.com>
` Re: Installation Steps to migrate to Postgres 8.3.1
2008-05-13 14:37 UTC Scott Marlowe <scott.marlowe@gmail.com>
[5+ messages in thread]
Partitioning: INSERT 0 0 but want INSERT 0 1
2008-05-12 16:18 UTC Nikolas Everett <nik9000@gmail.com>
` Re: Partitioning: INSERT 0 0 but want INSERT 0 1
2008-05-12 22:27 UTC Neil Peter Braggio <pbraggio@gmail.com>
` Re: Partitioning: INSERT 0 0 but want INSERT 0 1
2008-05-13 03:46 UTC Nikolas Everett <nik9000@gmail.com>
[3+ messages in thread]
Re: Re: Re: Query Optimization with Kruskal’s Algorithm
2008-05-10 21:17 UTC Jonah H. Harris <jonah.harris@gmail.com>
` Re: Re: Re: Re: Query Optimization with Kruskal’s Algorithm
2008-05-11 00:30 UTC Tom Lane <tgl@sss.pgh.pa.us>
[2+ messages in thread]
Re: Re: Query Optimization with Kruskal’s Algorithm
2008-05-10 20:27 UTC Jonah H. Harris <jonah.harris@gmail.com>
` Re: Re: Re: Query Optimization with Kruskal’s Algorithm
2008-05-10 21:12 UTC Tom Lane <tgl@sss.pgh.pa.us>
[2+ messages in thread]
Re: Re: Query Optimization with Kruskal’s Algorithm
2008-05-10 18:26 UTC Michael Glaesemann <grzm@seespotcode.net>
Re: Query Optimization with Kruskal’s Algorithm
2008-05-10 17:31 UTC Rauan Maemirov <rauan1987@gmail.com>
plan difference between set-returning function with ROWS within IN() and a plain join
2008-05-06 08:21 UTC Frank van Vugt <ftm.van.vugt@foxi.nl>
` Re: plan difference between set-returning function with ROWS within IN() and a plain join
2008-05-06 09:53 UTC PFC <lists@peufeu.com>
` Re: plan difference between set-returning function with ROWS within IN() and a plain join
2008-05-06 11:55 UTC Frank van Vugt <ftm.van.vugt@foxi.nl>
` Re: plan difference between set-returning function with ROWS within IN() and a plain join
2008-05-06 14:17 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: plan difference between set-returning function with ROWS within IN() and a plain join
2008-05-06 15:27 UTC Frank van Vugt <ftm.van.vugt@foxi.nl>
` Re: plan difference between set-returning function with ROWS within IN() and a plain join
2008-05-10 11:42 UTC Merlin Moncure <mmoncure@gmail.com>
[6+ messages in thread]
multiple joins + Order by + LIMIT query performance issue
2008-05-06 15:03 UTC Antoine Baudoux <ab@taktik.be>
` Re: multiple joins + Order by + LIMIT query performance issue
2008-05-06 15:38 UTC Guillaume Smet <guillaume.smet@gmail.com>
` Re: multiple joins + Order by + LIMIT query performance issue
2008-05-06 16:42 UTC Antoine Baudoux <ab@taktik.be>
` Re: multiple joins + Order by + LIMIT query performance issue
2008-05-06 16:43 UTC Shaun Thomas <sthomas@leapfrogonline.com>
` Re: multiple joins + Order by + LIMIT query performance issue
2008-05-06 17:24 UTC Antoine Baudoux <ab@taktik.be>
` Re: multiple joins + Order by + LIMIT query performance issue
2008-05-06 17:59 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: multiple joins + Order by + LIMIT query performance issue
2008-05-06 18:04 UTC Heikki Linnakangas <heikki@enterprisedb.com>
` Re: multiple joins + Order by + LIMIT query performance issue
2008-05-06 18:06 UTC Heikki Linnakangas <heikki@enterprisedb.com>
` Re: multiple joins + Order by + LIMIT query performance issue
2008-05-06 18:14 UTC Shaun Thomas <sthomas@leapfrogonline.com>
` Re: multiple joins + Order by + LIMIT query performance issue
2008-05-06 18:24 UTC Shaun Thomas <sthomas@leapfrogonline.com>
` Re: multiple joins + Order by + LIMIT query performance issue
2008-05-07 07:23 UTC Antoine Baudoux <ab@taktik.be>
` Re: multiple joins + Order by + LIMIT query performance issue
2008-05-07 10:42 UTC Matthew Wakeling <matthew@flymine.org>
` Re: multiple joins + Order by + LIMIT query performance issue
2008-05-09 07:18 UTC Antoine Baudoux <ab@taktik.be>
` Re: multiple joins + Order by + LIMIT query performance issue
2008-05-09 07:53 UTC Scott Marlowe <scott.marlowe@gmail.com>
[14+ messages in thread]
Creating indexes
2008-05-08 19:00 UTC Rauan Maemirov <rauan1987@gmail.com>
` Re: Creating indexes
2008-05-08 19:49 UTC Asche <asche.public@mac.com>
` Re: Creating indexes
2008-05-08 19:52 UTC Alan Hodgson <ahodgson@simkin.ca>
` Re: Creating indexes
2008-05-08 20:08 UTC PFC <lists@peufeu.com>
` Re: Creating indexes
2008-05-09 05:41 UTC Rauan Maemirov <rauan1987@gmail.com>
[5+ messages in thread]
Creating a foreign key
2008-05-08 16:52 UTC Campbell, Lance <lance@uiuc.edu>
` Re: Creating a foreign key
2008-05-08 17:00 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: Creating a foreign key
2008-05-08 17:18 UTC Shaun Thomas <sthomas@leapfrogonline.com>
` Re: Creating a foreign key
2008-05-08 18:11 UTC Campbell, Lance <lance@uiuc.edu>
` Re: Creating a foreign key
2008-05-08 20:02 UTC PFC <lists@peufeu.com>
[5+ messages in thread]
Ubuntu question
2008-05-08 06:52 UTC Q Master <theqmaster@gmail.com>
` Re: Ubuntu question
2008-05-08 07:01 UTC Martijn van Oosterhout <kleptog@svana.org>
` Re: [GENERAL] Ubuntu question
2008-05-08 07:47 UTC Justin <justin@emproshunts.com>
` Re: Ubuntu question
2008-05-08 07:48 UTC Justin <justin@emproshunts.com>
` Re: [GENERAL] Ubuntu question
2008-05-08 07:49 UTC Justin <justin@emproshunts.com>
[5+ messages in thread]
Re: Query Optimization with Kruskal’s Algorithm
2008-05-07 20:09 UTC Alexander Staubo <alex@purefiction.net>
Query Optimization with Kruskal’s Algorithm
2008-05-07 16:28 UTC Tarcizio Bini <tarcizioab@c3sl.ufpr.br>
Possible Redundancy/Performance Solution
2008-05-06 16:33 UTC Dennis Muhlestein <djmuhlestein@gmail.com>
` Re: Possible Redundancy/Performance Solution
2008-05-06 17:39 UTC Greg Smith <gsmith@gregsmith.com>
` Re: Possible Redundancy/Performance Solution
2008-05-06 18:31 UTC Dennis Muhlestein <djmuhlestein@gmail.com>
` Re: Possible Redundancy/Performance Solution
2008-05-06 20:35 UTC Greg Smith <gsmith@gregsmith.com>
` Re: Possible Redundancy/Performance Solution
2008-05-06 21:39 UTC Dennis Muhlestein <djmuhlestein@gmail.com>
` Re: Possible Redundancy/Performance Solution
2008-05-07 01:57 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Possible Redundancy/Performance Solution
2008-05-07 02:37 UTC Greg Smith <gsmith@gregsmith.com>
` Re: Possible Redundancy/Performance Solution
2008-05-07 15:36 UTC Dennis Muhlestein <djmuhlestein@gmail.com>
[8+ messages in thread]
pgfouine - commit details?
2008-05-06 21:10 UTC Josh Cole <Josh.Cole@t8design.com>
` Re: pgfouine - commit details?
2008-05-07 00:31 UTC Guillaume Smet <guillaume.smet@gmail.com>
` Re: pgfouine - commit details?
2008-05-07 05:29 UTC Josh Cole <Josh.Cole@t8design.com>
[3+ messages in thread]
Seqscan problem
2008-05-06 11:14 UTC Vlad Arkhipov <arhipov@dc.baikal.ru>
` Re: Seqscan problem
2008-05-06 14:22 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Seqscan problem
2008-05-07 00:48 UTC Vlad Arkhipov <arhipov@dc.baikal.ru>
[3+ messages in thread]
need to speed up query
2008-05-06 02:01 UTC Justin <justin@emproshunts.com>
` Re: need to speed up query
2008-05-06 03:27 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: need to speed up query
2008-05-06 04:08 UTC Gregory Williamson <Gregory.Williamson@digitalglobe.com>
` Re: need to speed up query
2008-05-06 05:36 UTC Justin <justin@emproshunts.com>
` Re: need to speed up query
2008-05-06 05:48 UTC Justin <justin@emproshunts.com>
` Re: need to speed up query
2008-05-06 07:02 UTC PFC <lists@peufeu.com>
` Re: need to speed up query
2008-05-06 13:22 UTC Justin <justin@emproshunts.com>
` Re: need to speed up query
2008-05-06 16:35 UTC PFC <lists@peufeu.com>
` Re: need to speed up query
2008-05-06 16:43 UTC Shaun Thomas <sthomas@leapfrogonline.com>
` Re: need to speed up query
2008-05-06 17:22 UTC Justin <justin@emproshunts.com>
` Re: need to speed up query
2008-05-06 17:41 UTC Justin <justin@emproshunts.com>
[11+ messages in thread]
What constitutes a complex query
2008-05-06 15:45 UTC Justin <justin@emproshunts.com>
` Re: What constitutes a complex query
2008-05-06 16:26 UTC Craig James <craig_james@emolecules.com>
` Re: What constitutes a complex query
2008-05-06 16:41 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: What constitutes a complex query
2008-05-06 16:56 UTC Steve Atkins <steve@blighty.com>
` Re: What constitutes a complex query
2008-05-06 16:58 UTC Richard Broersma <richard.broersma@gmail.com>
` Re: What constitutes a complex query
2008-05-06 17:23 UTC Justin <justin@emproshunts.com>
` Re: What constitutes a complex query
2008-05-06 17:37 UTC Scott Marlowe <scott.marlowe@gmail.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