pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Looking for bottleneck during load test
  2008-04-07 12:16 UTC  Hell, Robert <Robert.Hell@fabasoft.com>
` Re: Looking for bottleneck during load test
  2008-04-07 12:37 UTC  Ivan Voras <ivoras@geri.cc.fer.hr>
` Re: Looking for bottleneck during load test
  2008-04-07 20:12 UTC  Hell, Robert <Robert.Hell@fabasoft.com>
` Re: Looking for bottleneck during load test
  2008-04-07 20:20 UTC  Bill Moran <wmoran@collaborativefusion.com>
` Re: Looking for bottleneck during load test
  2008-04-07 20:40 UTC  Greg Smith <gsmith@gregsmith.com>
` Re: Looking for bottleneck during load test
  2008-04-07 20:49 UTC  Bill Moran <wmoran@collaborativefusion.com>
` Re: Looking for bottleneck during load test
  2008-04-08 09:01 UTC  Ivan Voras <ivoras@freebsd.org>
` Re: Looking for bottleneck during load test
  2008-04-08 09:02 UTC  Ivan Voras <ivoras@geri.cc.fer.hr>
` Re: Looking for bottleneck during load test
  2008-04-08 09:16 UTC  Hell, Robert <Robert.Hell@fabasoft.com>
  [9+ messages in thread]

bulk data loading
  2008-04-08 03:41 UTC  Potluri  Srikanth <spotluri@ismartpanache.com>
` Re: bulk data loading
  2008-04-08 07:40 UTC  Magnus Hagander <magnus@hagander.net>
  [2+ messages in thread]

per-review of  PgBouncer / Slony design
  2008-04-07 19:50 UTC  Mark Stosberg <mark@summersault.com>

Severe performance problems for simple query
  2008-04-07 15:21 UTC  Dimi Paun <dimi@lattica.com>
` Re: Severe performance problems for simple query
  2008-04-07 16:19 UTC  Matthew <matthew@flymine.org>
` Re: Severe performance problems for simple query
  2008-04-07 16:27 UTC  Matthew <matthew@flymine.org>
` Re: Severe performance problems for simple query
  2008-04-07 16:32 UTC  Heikki Linnakangas <heikki@enterprisedb.com>
` Re: Severe performance problems for simple query
  2008-04-07 16:41 UTC  Dimi Paun <dimi@lattica.com>
` Re: Severe performance problems for simple query
  2008-04-07 16:45 UTC  Dimi Paun <dimi@lattica.com>
` Re: Severe performance problems for simple query
  2008-04-07 17:02 UTC  Matthew <matthew@flymine.org>
` Re: Severe performance problems for simple query
  2008-04-07 18:53 UTC  Florian Weimer <fw@deneb.enyo.de>
  [8+ messages in thread]

performance using table partitions in Postgres 8.2.6
  2008-04-07 16:57 UTC  Janet Jacobsen <jsjacobsen@lbl.gov>
` Re: performance using table partitions in Postgres 8.2.6
  2008-04-07 18:06 UTC  Albert Cervera Areny <albert@sedifa.com>
  [2+ messages in thread]

Query plan excluding index on view
  2008-04-03 23:31 UTC  Matt Klinker <mklinker@gmail.com>
` Re: Query plan excluding index on view
  2008-04-03 23:50 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Query plan excluding index on view
  2008-04-04 04:58 UTC  Matt Klinker <mklinker@gmail.com>
` Re: Query plan excluding index on view
  2008-04-04 05:49 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Query plan excluding index on view
  2008-04-04 14:26 UTC  Matt Klinker <mklinker@gmail.com>
` Re: Query plan excluding index on view
  2008-04-05 04:20 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: [SOLVED] Query plan excluding index on view
  2008-04-07 15:46 UTC  Matt Klinker <mklinker@gmail.com>
  [7+ messages in thread]

[Fwd: Re: Max shared_buffers]
  2008-04-03 18:21 UTC  Justin <justin@emproshunts.com>

Max shared_buffers
  2008-04-03 04:56 UTC  bitaoxiao <bitaoxiao@gmail.com>
` Re: Max shared_buffers
  2008-04-03 10:10 UTC  sathiya psql <sathiya.psql@gmail.com>
` Re: Max shared_buffers
  2008-04-03 16:49 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Max shared_buffers
  2008-04-03 17:16 UTC  Andrej Ricnik-Bay <andrej.groups@gmail.com>
` Re: Max shared_buffers
  2008-04-03 17:20 UTC  Matthew <matthew@flymine.org>
` Re: Max shared_buffers
  2008-04-03 17:48 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Max shared_buffers
  2008-04-03 17:58 UTC  Craig Ringer <craig@postnewspapers.com.au>
  [7+ messages in thread]

SSDs
  2008-04-02 06:16 UTC  James Mansion <james@mansionfamily.plus.com>
` Re: SSDs
  2008-04-02 06:44 UTC  Arjen van der Meijden <acmmailing@tweakers.net>
` Re: SSDs
  2008-04-03 04:36 UTC  Merlin Moncure <mmoncure@gmail.com>
  [3+ messages in thread]

Cursors and different settings for default_statistics_target
  2008-04-01 12:14 UTC  Hell, Robert <Robert.Hell@fabasoft.com>
` Re: Cursors and different settings for default_statistics_target
  2008-04-01 15:30 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Cursors and different settings for default_statistics_target
  2008-04-01 15:48 UTC  Hell, Robert <Robert.Hell@fabasoft.com>
` Re: Cursors and different settings for default_statistics_target
  2008-04-01 16:16 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Cursors and different settings for default_statistics_target
  2008-04-01 16:33 UTC  Hell, Robert <Robert.Hell@fabasoft.com>
` Re: Cursors and different settings for default_statistics_target
  2008-04-01 16:42 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Cursors and different settings for default_statistics_target
  2008-04-01 19:57 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Cursors and different settings for default_statistics_target
  2008-04-01 21:12 UTC  Hell, Robert <Robert.Hell@fabasoft.com>
` Re: Cursors and different settings for default_statistics_target
  2008-04-01 22:23 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Cursors and different settings for default_statistics_target
  2008-04-02 10:11 UTC  Hell, Robert <Robert.Hell@fabasoft.com>
  [10+ messages in thread]

Too many commands in a transaction
  2008-04-01 20:58 UTC  samantha mahindrakar <sam.mahindrakar@gmail.com>

Insert time
  2008-04-01 15:38 UTC  Ioana Danes <ioanasoftware@yahoo.ca>

check performance parameters
  2008-04-01 11:40 UTC  Sabin Coanda <sabin.coanda@deuromedia.ro>
` Re: check performance parameters
  2008-04-01 13:55 UTC  Matthew <matthew@flymine.org>
  [2+ messages in thread]

Bad prepare performance
  2008-03-31 11:00 UTC  Martin Kjeldsen <martin@martinkjeldsen.dk>
` Re: Bad prepare performance
  2008-03-31 11:59 UTC  Cédric Villemain <cedric.villemain@dalibo.com>
` Re: Bad prepare performance
  2008-04-01 07:53 UTC  Cédric Villemain <cedric.villemain@dalibo.com>
  [3+ messages in thread]

optimizing query performance
  2008-03-31 11:57 UTC  Frits Hoogland <frits.hoogland@gmail.com>

Planning a new server - help needed
  2008-03-28 09:05 UTC  Laszlo Nagy <gandalf@shopzeus.com>
` Re: Planning a new server - help needed
  2008-03-28 10:00 UTC  Reko Turja <reko.turja@liukuma.net>
` Re: Planning a new server - help needed
  2008-03-28 10:03 UTC  Claus Guttesen <kometen@gmail.com>
` Re: Planning a new server - help needed
  2008-03-28 10:47 UTC  Laszlo Nagy <gandalf@shopzeus.com>
` Re: Planning a new server - help needed
  2008-03-28 17:42 UTC  Greg Smith <gsmith@gregsmith.com>
` Re: Planning a new server - help needed
  2008-03-28 18:35 UTC  Dan Harris <fbsd@drivefaster.net>
` Re: Planning a new server - help needed
  2008-03-28 18:38 UTC  Weinzierl Stefan <Stefan@Weinzierl-Stefan.de>
` Re: Planning a new server - help needed
  2008-03-29 10:34 UTC  James Mansion <james@mansionfamily.plus.com>
` Re: Planning a new server - help needed
  2008-03-29 13:57 UTC  PFC <lists@peufeu.com>
` Re: Planning a new server - help needed
  2008-03-29 16:47 UTC  James Mansion <james@mansionfamily.plus.com>
` Re: Planning a new server - help needed
  2008-03-29 23:49 UTC  Peter Eisentraut <peter_e@gmx.net>
` Re: Planning a new server - help needed
  2008-03-30 04:45 UTC  Greg Smith <gsmith@gregsmith.com>
` Re: Planning a new server - help needed
  2008-03-30 05:39 UTC  Craig Ringer <craig@postnewspapers.com.au>
` Re: Planning a new server - help needed
  2008-03-31 02:25 UTC  Guy Rouillier <guyr-ml1@burntmail.com>
  [14+ messages in thread]

using like in a prepare doesnt' use the right index
  2008-03-27 19:14 UTC  Dave Cramer <pg@fastcrypt.com>
` Re: using like in a prepare doesnt' use the right index
  2008-03-28 14:53 UTC  Gavin Sherry <swm@alcove.com.au>
  [2+ messages in thread]

Re: vacuum in Postgresql 8.0.x slowing down the database
  2008-03-26 20:02 UTC  Joshua D. Drake <jd@commandprompt.com>
` vacuum in Postgresql 8.0.x slowing down the database
  2008-03-26 20:49 UTC  Vinubalaji Gopal <vgopal@abaca.com>
` Re: vacuum in Postgresql 8.0.x slowing down the database
  2008-03-28 07:28 UTC  Vinubalaji Gopal <vgopal@abaca.com>
  [3+ messages in thread]

"Slow" query or just "Bad hardware"?
  2008-03-27 15:34 UTC  Jesper Krogh <jesper@krogh.cc>
` Re: "Slow" query or just "Bad hardware"?
  2008-03-27 16:06 UTC  Matthew <matthew@flymine.org>
` Re: "Slow" query or just "Bad hardware"?
  2008-03-27 16:45 UTC  PFC <lists@peufeu.com>
` Re: "Slow" query or just "Bad hardware"?
  2008-03-27 16:57 UTC  PFC <lists@peufeu.com>
` Re: "Slow" query or just "Bad hardware"?
  2008-03-27 17:07 UTC  Bill Moran <wmoran@collaborativefusion.com>
` Re: "Slow" query or just "Bad hardware"?
  2008-03-27 17:36 UTC  Luke Lonergan <llonergan@greenplum.com>
` Re: "Slow" query or just "Bad hardware"?
  2008-03-27 17:54 UTC  Alvaro Herrera <alvherre@commandprompt.com>
  [7+ messages in thread]

postgresql is slow with larger table even it is in RAM
  2008-03-25 08:35 UTC  sathiya psql <sathiya.psql@gmail.com>
` Re: postgresql is slow with larger table even it is in RAM
  2008-03-25 08:42 UTC  sathiya psql <sathiya.psql@gmail.com>
` Re: postgresql is slow with larger table even it is in RAM
  2008-03-25 09:08 UTC  hubert depesz lubaczewski <depesz@depesz.com>
` Re: postgresql is slow with larger table even it is in RAM
  2008-03-25 09:34 UTC  Craig Ringer <craig@postnewspapers.com.au>
` Re: postgresql is slow with larger table even it is in RAM
  2008-03-25 11:59 UTC  Alvaro Herrera <alvherre@commandprompt.com>
` Re: postgresql is slow with larger table even it is in RAM
  2008-03-25 13:10 UTC  Bill Moran <wmoran@collaborativefusion.com>
` Re: postgresql is slow with larger table even it is in RAM
  2008-03-25 13:27 UTC  sathiya psql <sathiya.psql@gmail.com>
` Re: postgresql is slow with larger table even it is in RAM
  2008-03-25 14:03 UTC  Bill Moran <wmoran@collaborativefusion.com>
` Re: postgresql is slow with larger table even it is in RAM
  2008-03-25 14:46 UTC  Luke Lonergan <llonergan@greenplum.com>
` Re: postgresql is slow with larger table even it is in RAM
  2008-03-25 15:02 UTC  Chris Browne <cbbrowne@acm.org>
` Re: postgresql is slow with larger table even it is in RAM
  2008-03-25 15:11 UTC  sathiya psql <sathiya.psql@gmail.com>
` Re: postgresql is slow with larger table even it is in RAM
  2008-03-26 23:48 UTC  Peter Koczan <pjkoczan@gmail.com>
` Re: postgresql is slow with larger table even it is in RAM
  2008-03-27 17:32 UTC  Luke Lonergan <llonergan@greenplum.com>
  [13+ messages in thread]

how can a couple of expensive queries drag my system down?
  2008-03-26 19:48 UTC  p prince <pprince127@gmail.com>
` Re: how can a couple of expensive queries drag my system down?
  2008-03-26 20:19 UTC  Alan Hodgson <ahodgson@simkin.ca>
` Re: how can a couple of expensive queries drag my system down?
  2008-03-26 20:31 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: how can a couple of expensive queries drag my system down?
  2008-03-26 21:58 UTC  PFC <lists@peufeu.com>
` Re: how can a couple of expensive queries drag my system down?
  2008-03-27 04:09 UTC  Shane Ambler <pgsql@Sheeky.Biz>
` Re: how can a couple of expensive queries drag my system down?
  2008-03-27 04:57 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: how can a couple of expensive queries drag my system down?
  2008-03-27 15:13 UTC  Erik Jones <erik@myemma.com>
  [7+ messages in thread]

1-/2-dimensional indexes for common columns, rationale?
  2008-03-26 14:18 UTC  Marinos Yannikos <mjy@geizhals.at>
` Re: 1-/2-dimensional indexes for common columns, rationale?
  2008-03-26 15:02 UTC  A. Kretschmer <andreas.kretschmer@schollglas.com>
` Re: 1-/2-dimensional indexes for common columns, rationale?
  2008-03-26 15:15 UTC  Marinos Yannikos <mjy@geizhals.at>
` Re: 1-/2-dimensional indexes for common columns, rationale?
  2008-03-26 15:16 UTC  Matthew <matthew@flymine.org>
` Re: 1-/2-dimensional indexes for common columns, rationale?
  2008-03-26 15:25 UTC  A. Kretschmer <andreas.kretschmer@schollglas.com>
` Re: 1-/2-dimensional indexes for common columns, rationale?
  2008-03-26 15:27 UTC  Craig Ringer <craig@postnewspapers.com.au>
` Re: 1-/2-dimensional indexes for common columns, rationale?
  2008-03-26 16:24 UTC  PFC <lists@peufeu.com>
  [7+ messages in thread]

what is the maximum number of rows in a table in postgresql 8.1
  2008-03-25 11:42 UTC  sathiya psql <sathiya.psql@gmail.com>
` Re: what is the maximum number of rows in a table in postgresql 8.1
  2008-03-25 11:48 UTC  Harald Armin Massa <haraldarminmassa@gmail.com>
` Re: what is the maximum number of rows in a table in postgresql 8.1
  2008-03-25 11:54 UTC  sathiya psql <sathiya.psql@gmail.com>
` Re: what is the maximum number of rows in a table in postgresql 8.1
  2008-03-25 12:01 UTC  Alvaro Herrera <alvherre@commandprompt.com>
` Re: what is the maximum number of rows in a table in postgresql 8.1
  2008-03-25 12:08 UTC  sathiya psql <sathiya.psql@gmail.com>
` Re: what is the maximum number of rows in a table in postgresql 8.1
  2008-03-25 12:24 UTC  Craig Ringer <craig@postnewspapers.com.au>
` Re: what is the maximum number of rows in a table in postgresql 8.1
  2008-03-25 12:50 UTC  sathiya psql <sathiya.psql@gmail.com>
` Re: what is the maximum number of rows in a table in postgresql 8.1
  2008-03-25 13:09 UTC  Craig Ringer <craig@postnewspapers.com.au>
` Re: what is the maximum number of rows in a table in postgresql 8.1
  2008-03-25 13:16 UTC  Ivan Voras <ivoras@geri.cc.fer.hr>
` Re: what is the maximum number of rows in a table in postgresql 8.1
  2008-03-25 13:34 UTC  Bill Moran <wmoran@collaborativefusion.com>
` Re: what is the maximum number of rows in a table in postgresql 8.1
  2008-03-26 12:24 UTC  Matthew <matthew@flymine.org>
  [11+ messages in thread]

PostgreSQL NetApp and NFS
  2008-03-20 19:32 UTC  Chris Hoover <revoohc@gmail.com>
` Re: PostgreSQL NetApp and NFS
  2008-03-20 20:09 UTC  Bruce Momjian <bruce@momjian.us>
` Re: PostgreSQL NetApp and NFS
  2008-03-20 20:45 UTC  Woody Woodring <george.woodring@iglass.net>
` Re: PostgreSQL NetApp and NFS
  2008-03-20 21:23 UTC  Frits Hoogland <frits.hoogland@gmail.com>
` Re: PostgreSQL NetApp and NFS
  2008-03-20 21:52 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: PostgreSQL NetApp and NFS
  2008-03-21 03:30 UTC  Bruce Momjian <bruce@momjian.us>
` Re: PostgreSQL NetApp and NFS
  2008-03-21 03:41 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: PostgreSQL NetApp and NFS
  2008-03-21 09:34 UTC  Dawid Kuroczko <qnex42@gmail.com>
` Re: PostgreSQL NetApp and NFS
  2008-03-21 13:22 UTC  Gregory Stark <stark@enterprisedb.com>
` Re: PostgreSQL NetApp and NFS
  2008-03-21 14:23 UTC  Bruce Momjian <bruce@momjian.us>
` Re: PostgreSQL NetApp and NFS
  2008-03-25 13:33 UTC  Jurgen Haan <jurgen@easyflex.nl>
  [11+ messages in thread]

increasing shared buffer slow downs query performance.
  2008-03-24 09:27 UTC  petchimuthu lingam <spmlingam@gmail.com>
` Re: increasing shared buffer slow downs query performance.
  2008-03-24 10:07 UTC  Andreas Kretschmer <akretschmer@spamfence.net>
` Re: increasing shared buffer slow downs query performance.
  2008-03-25 12:23 UTC  Pavan Deolasee <pavan.deolasee@gmail.com>
  [3+ 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