pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedshared_buffers performance
2008-04-14 09:13 UTC Gaetano Mendola <mendola@gmail.com>
` Re: shared_buffers performance
2008-04-14 10:56 UTC Gregory Stark <stark@enterprisedb.com>
` Re: shared_buffers performance
2008-04-14 11:25 UTC Richard Huxton <dev@archonet.com>
` Re: shared_buffers performance
2008-04-14 15:42 UTC Greg Smith <gsmith@gregsmith.com>
` Re: shared_buffers performance
2008-04-14 15:44 UTC Greg Smith <gsmith@gregsmith.com>
` Re: shared_buffers performance
2008-04-14 19:31 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: shared_buffers performance
2008-04-14 19:58 UTC Gregory Stark <stark@enterprisedb.com>
` Re: shared_buffers performance
2008-04-14 20:08 UTC Greg Smith <gsmith@gregsmith.com>
` Re: shared_buffers performance
2008-04-15 09:05 UTC Gaetano Mendola <mendola@gmail.com>
` Re: shared_buffers performance
2008-04-15 09:11 UTC Gaetano Mendola <mendola@gmail.com>
` Re: shared_buffers performance
2008-04-15 15:08 UTC Gaetano Mendola <mendola@gmail.com>
` Re: shared_buffers performance
2008-05-24 17:55 UTC Decibel! <decibel@decibel.org>
[12+ messages in thread]
index performance on large tables with update and insert
2008-05-23 13:21 UTC Jessica Richard <rjessil@yahoo.com>
` Re: index performance on large tables with update and insert
2008-05-23 16:35 UTC Magnus Hagander <magnus@hagander.net>
[2+ messages in thread]
IBM ServRAID-MR10M / LSI1078ROC advice
2008-05-23 15:15 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
join/from_collapse_limit and geqo_threshold default values
2008-05-23 09:01 UTC Vlad Arkhipov <arhipov@dc.baikal.ru>
Index creation time and distribution
2008-05-22 12:32 UTC Guillaume Smet <guillaume.smet@gmail.com>
` Re: Index creation time and distribution
2008-05-22 13:14 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Index creation time and distribution
2008-05-22 13:38 UTC Guillaume Smet <guillaume.smet@gmail.com>
` Re: Index creation time and distribution
2008-05-22 14:10 UTC Matthew Wakeling <matthew@flymine.org>
` Re: Index creation time and distribution
2008-05-22 16:50 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Index creation time and distribution
2008-05-22 18:34 UTC Guillaume Smet <guillaume.smet@gmail.com>
` Re: Index creation time and distribution
2008-05-22 19:18 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Index creation time and distribution
2008-05-22 21:52 UTC Guillaume Smet <guillaume.smet@gmail.com>
[8+ messages in thread]
Varchar pkey instead of integer
2008-05-21 05:40 UTC Robins Tharakan <tharakan@gmail.com>
` Re: Varchar pkey instead of integer
2008-05-21 06:16 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: Varchar pkey instead of integer
2008-05-21 06:34 UTC Craig Ringer <craig@postnewspapers.com.au>
` Re: Varchar pkey instead of integer
2008-05-21 07:33 UTC Shane Ambler <pgsql@Sheeky.Biz>
` Re: Varchar pkey instead of integer
2008-05-21 07:57 UTC J. Andrew Rogers <jrogers@neopolitan.com>
` Re: Varchar pkey instead of integer
2008-05-21 08:00 UTC Craig Ringer <craig@postnewspapers.com.au>
` Re: Varchar pkey instead of integer
2008-05-22 00:54 UTC Robins Tharakan <tharakan@gmail.com>
[7+ messages in thread]
"append" takes a lot of time in a query
2008-05-09 08:09 UTC Frank Dekervel <frank.dekervel@smartlounge.be>
` Re: "append" takes a lot of time in a query
2008-05-09 14:12 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: "append" takes a lot of time in a query
2008-05-21 10:37 UTC Frank Dekervel <frank.dekervel@smartlounge.be>
` Re: "append" takes a lot of time in a query
2008-05-21 18:44 UTC Scott Marlowe <scott.marlowe@gmail.com>
[4+ messages in thread]
improving performance for a delete
2008-05-20 19:51 UTC kevin kempter <kevin@kevinkempterllc.com>
` Re: improving performance for a delete
2008-05-20 20:03 UTC kevin kempter <kevin@kevinkempterllc.com>
` Re: improving performance for a delete
2008-05-20 20:54 UTC PFC <lists@peufeu.com>
[3+ messages in thread]
Slow update
2005-04-12 14:12 UTC Bendik R.Johansen <bendik.johansen@gmail.com>
` Re: Slow update
2005-04-12 14:35 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Slow update
2005-04-12 15:03 UTC Bendik R.Johansen <bendik.johansen@gmail.com>
` Re: Slow update
2005-04-12 15:16 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Slow update
2005-04-12 15:37 UTC Bendik R.Johansen <bendik.johansen@gmail.com>
` Re: Slow update
2005-04-12 15:40 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Slow update
2005-09-12 09:14 UTC Hilary Forbes <hforbes@dmr.co.uk>
` Re: Slow update
2005-09-12 10:51 UTC Richard Huxton <dev@archonet.com>
` Re: Slow update
2005-09-12 13:34 UTC Bruno Wolff III <bruno@wolff.to>
` Re: Slow update
2005-09-12 14:07 UTC Tom Lane <tgl@sss.pgh.pa.us>
` slow update
2005-10-13 16:34 UTC Patrick Hatcher <PHatcher@macys.com>
` Re: slow update
2005-10-13 18:34 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: slow update
2005-10-13 18:37 UTC Patrick Hatcher <PHatcher@macys.com>
` Slow update
2007-02-01 00:57 UTC Abu Mushayeed <abumushayeed@yahoo.com>
` Re: Slow update
2007-02-01 01:32 UTC Tomas Vondra <tv@fuzzy.cz>
` slow update
2008-05-20 05:56 UTC kevin kempter <kevin@kevinkempterllc.com>
` Re: slow update
2008-05-20 06:15 UTC A. Kretschmer <andreas.kretschmer@schollglas.com>
` Re: slow update
2008-05-20 17:47 UTC Scott Marlowe <scott.marlowe@gmail.com>
[18+ messages in thread]
Author Wanted
2008-05-20 11:21 UTC Markus Feilner <lists@feilner-it.net>
` Re: Author Wanted
2008-05-20 12:32 UTC Bill Moran <wmoran@collaborativefusion.com>
[2+ messages in thread]
Strange behavior: pgbench and new Linux kernels
2008-04-17 07:58 UTC Greg Smith <gsmith@gregsmith.com>
` Re: Strange behavior: pgbench and new Linux kernels
2008-04-17 15:52 UTC Matthew <matthew@flymine.org>
` Re: Strange behavior: pgbench and new Linux kernels
2008-04-17 17:09 UTC Jeffrey Baker <jwbaker@gmail.com>
` Re: Strange behavior: pgbench and new Linux kernels
2008-04-17 17:48 UTC Matthew <matthew@flymine.org>
` Re: Strange behavior: pgbench and new Linux kernels
2008-04-17 18:15 UTC Greg Smith <gsmith@gregsmith.com>
` Re: Strange behavior: pgbench and new Linux kernels
2008-04-18 00:26 UTC Greg Smith <gsmith@gregsmith.com>
` Re: Strange behavior: pgbench and new Linux kernels
2008-04-18 00:41 UTC david@lang.hm
` Re: Strange behavior: pgbench and new Linux kernels
2008-04-18 03:25 UTC Greg Smith <gsmith@gregsmith.com>
` Re: Strange behavior: pgbench and new Linux kernels
2008-04-18 05:18 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Strange behavior: pgbench and new Linux kernels
2008-04-18 06:47 UTC Greg Smith <gsmith@gregsmith.com>
` Re: Strange behavior: pgbench and new Linux kernels
2008-04-18 11:01 UTC Matthew <matthew@flymine.org>
` Re: Strange behavior: pgbench and new Linux kernels
2008-04-18 17:19 UTC Greg Smith <gsmith@gregsmith.com>
` Re: Strange behavior: pgbench and new Linux kernels
2008-05-18 16:25 UTC Greg Smith <gsmith@gregsmith.com>
[13+ messages in thread]
Regexps - never completing join.
2008-05-14 05:45 UTC Rusty Conover <rconover@infogears.com>
` Re: Regexps - never completing join.
2008-05-14 07:08 UTC Rusty Conover <rconover@infogears.com>
` Re: Regexps - never completing join.
2008-05-14 15:33 UTC Rusty Conover <rconover@infogears.com>
` Re: Regexps - never completing join.
2008-05-16 20:35 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Regexps - never completing join.
2008-05-16 21:37 UTC Rusty Conover <rconover@infogears.com>
` Re: Regexps - never completing join.
2008-05-16 21:44 UTC Scott Marlowe <scott.marlowe@gmail.com>
[6+ messages in thread]
Please ignore ...
2008-05-01 04:16 UTC Marc G. Fournier <scrappy@hub.org>
` Re: Please ignore ...
2008-05-01 05:23 UTC D'Arcy J.M. Cain <darcy@druid.net>
` Re: Please ignore ...
2008-05-01 06:55 UTC Greg Smith <gsmith@gregsmith.com>
` Re: Please ignore ...
2008-05-01 07:21 UTC Justin <justin@emproshunts.com>
` Re: Please ignore ...
2008-05-01 07:35 UTC Tino Wildenhain <tino@wildenhain.de>
` Re: Please ignore ...
2008-05-01 12:35 UTC D'Arcy J.M. Cain <darcy@druid.net>
` Re: Please ignore ...
2008-05-02 14:29 UTC Alvaro Herrera <alvherre@commandprompt.com>
` Re: Please ignore ...
2008-05-16 21:03 UTC Alvaro Herrera <alvherre@commandprompt.com>
[8+ messages in thread]
very slow left join
2008-05-16 17:56 UTC Ben <bench@silentmedia.com>
` Re: very slow left join
2008-05-16 18:09 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: very slow left join
2008-05-16 18:21 UTC Ben <bench@silentmedia.com>
` Re: very slow left join
2008-05-16 18:27 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: very slow left join
2008-05-16 18:43 UTC Ben <bench@silentmedia.com>
` Re: very slow left join
2008-05-16 19:25 UTC Craig Ringer <craig@postnewspapers.com.au>
[6+ messages in thread]
which 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]
[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