pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Remote access to Postgresql slow
  2012-09-14 09:02 UTC  Manoj Agarwal <ma@ockham.be>
` Re: Remote access to Postgresql slow
  2012-09-15 21:17 UTC  Andrew Barnham <andrew.barnham@gmail.com>
` Re: Remote access to Postgresql slow
  2012-09-15 21:20 UTC  Scott Marlowe <scott.marlowe@gmail.com>
  [3+ messages in thread]

Setting autovacuum_vacuum_scale_factor to 0 a good idea ?
  2012-09-14 20:11 UTC  Sébastien Lorion <sl@thestrangefactory.com>
` Re: Setting autovacuum_vacuum_scale_factor to 0 a good idea ?
  2012-09-14 21:49 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Setting autovacuum_vacuum_scale_factor to 0 a good idea ?
  2012-09-15 02:35 UTC  Sébastien Lorion <sl@thestrangefactory.com>
  [3+ messages in thread]

AppScale backend datastore (NoSQL again kind of)
  2012-09-13 18:11 UTC  Ross Reedstrom <reedstrm@rice.edu>
` Re: AppScale backend datastore (NoSQL again kind of)
  2012-09-13 18:30 UTC  Marcos Ortiz <mlortiz@uci.cu>
` Re: AppScale backend datastore (NoSQL again kind of)
  2012-09-13 22:15 UTC  Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
  [3+ messages in thread]

Linux machine aggressively clearing cache
  2012-03-27 20:06 UTC  Joshua Berkus <josh@agliodbs.com>
` Re: Linux machine aggressively clearing cache
  2012-03-27 20:10 UTC  Claudio Freire <klaussfreire@gmail.com>
` Re: Linux machine aggressively clearing cache
  2012-03-27 20:40 UTC  Dave Crooke <dcrooke@gmail.com>
` Re: Linux machine aggressively clearing cache
  2012-03-28 18:37 UTC  Joshua Berkus <josh@agliodbs.com>
` Re: Linux machine aggressively clearing cache
  2012-03-31 00:51 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Linux machine aggressively clearing cache
  2012-04-12 15:47 UTC  Steve Crawford <scrawford@pinpointresearch.com>
` Re: Linux machine aggressively clearing cache
  2012-04-19 00:09 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Linux machine aggressively clearing cache
  2012-09-13 19:00 UTC  Ross Reedstrom <reedstrm@rice.edu>
  [8+ messages in thread]

(no subject)
  2012-09-13 18:25 UTC  Feridun türk <feridunturk@gmail.com>

: PostgreSQL Index behavior
  2012-09-10 12:39 UTC  Venkat Balaji <venkat.balaji@verse.in>
` Re: : PostgreSQL Index behavior
  2012-09-10 15:36 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: : PostgreSQL Index behavior
  2012-09-12 06:57 UTC  Venkat Balaji <venkat.balaji@verse.in>
` Re: : PostgreSQL Index behavior
  2012-09-12 14:12 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: : PostgreSQL Index behavior
  2012-09-13 09:22 UTC  Venkat Balaji <venkat.balaji@verse.in>
` Re: : PostgreSQL Index behavior
  2012-09-13 09:39 UTC  Tomas Vondra <tv@fuzzy.cz>
  [6+ messages in thread]

add column with default value is very slow
  2012-09-11 13:20 UTC  AI Rumman <rummandba@gmail.com>
` Re: add column with default value is very slow
  2012-09-11 13:41 UTC  Albe Laurenz <laurenz.albe@wien.gv.at>
` Re: add column with default value is very slow
  2012-09-11 13:44 UTC  hubert depesz lubaczewski <depesz@depesz.com>
` Re: add column with default value is very slow
  2012-09-11 13:55 UTC  AI Rumman <rummandba@gmail.com>
` Re: add column with default value is very slow
  2012-09-11 13:59 UTC  hubert depesz lubaczewski <depesz@depesz.com>
` Re: add column with default value is very slow
  2012-09-11 14:04 UTC  AI Rumman <rummandba@gmail.com>
` Re: add column with default value is very slow
  2012-09-11 14:05 UTC  hubert depesz lubaczewski <depesz@depesz.com>
` Re: add column with default value is very slow
  2012-09-11 14:07 UTC  Andrew Dunstan <andrew@dunslane.net>
  [8+ messages in thread]

Slow Performance on a XEON E5504
  2012-08-24 09:47 UTC  Felix Schubert <input@fescon.de>
` Slow Performance on a XEON E5504
  2012-08-25 12:07 UTC  Felix Schubert <input@fescon.de>
` Re: Slow Performance on a XEON E5504
  2012-08-25 12:42 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Slow Performance on a XEON E5504
  2012-08-25 12:53 UTC  Felix Schubert <input@fescon.de>
` Re: Slow Performance on a XEON E5504
  2012-08-25 12:59 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Slow Performance on a XEON E5504
  2012-08-25 13:04 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Slow Performance on a XEON E5504
  2012-08-25 21:26 UTC  Felix Schubert <input@fescon.de>
` Re: Slow Performance on a XEON E5504
  2012-08-25 21:47 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Slow Performance on a XEON E5504
  2012-09-10 20:58 UTC  Marcos Ortiz <mlortiz@uci.cu>
  [9+ messages in thread]

force defaults
  2012-09-10 14:40 UTC  Willy-Bas Loos <willybas@gmail.com>

libpq or postgresql performance
  2012-09-06 20:04 UTC  Aryan Ariel Rodriguez Chalas <wimogan@yahoo.com>
` Re: libpq or postgresql performance
  2012-09-07 05:35 UTC  Andreas Kretschmer <akretschmer@spamfence.net>
` Re: libpq or postgresql performance
  2012-09-07 06:45 UTC  Albe Laurenz <laurenz.albe@wien.gv.at>
` Re: libpq or postgresql performance
  2012-09-07 06:52 UTC  Ireneusz Pluta <ipluta@wp.pl>
` Re: libpq or postgresql performance
  2012-09-07 17:24 UTC  Ireneusz Pluta <ipluta@wp.pl>
` Re: libpq or postgresql performance
  2012-09-10 09:01 UTC  Ireneusz Pluta <ipluta@wp.pl>
  [6+ messages in thread]

exponential performance decrease in ISD transaction
  2012-08-31 12:27 UTC  John Nash <postgres.dba.needs.help@gmail.com>
` Re: exponential performance decrease in ISD transaction
  2012-08-31 13:36 UTC  Heikki Linnakangas <hlinnaka@iki.fi>
` Re: exponential performance decrease in ISD transaction
  2012-08-31 16:17 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: exponential performance decrease in ISD transaction
  2012-09-03 11:22 UTC  John Nash <postgres.dba.needs.help@gmail.com>
` Re: exponential performance decrease in ISD transaction
  2012-09-03 17:27 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: exponential performance decrease in ISD transaction
  2012-09-06 03:55 UTC  Greg Smith <greg@2ndQuadrant.com>
` Re: exponential performance decrease in ISD transaction
  2012-09-07 10:55 UTC  John Nash <postgres.dba.needs.help@gmail.com>
` Re: exponential performance decrease in ISD transaction
  2012-09-07 10:57 UTC  John Nash <postgres.dba.needs.help@gmail.com>
  [8+ messages in thread]

HELP!!!-----Need to Sql commands to monitoring  Postgresql
  2012-09-04 07:12 UTC  charles_xie <xqwyy163@163.com>
` Re: HELP!!!-----Need to Sql commands to monitoring Postgresql
  2012-09-06 07:43 UTC  Daniel Farina <daniel@heroku.com>
` Re: HELP!!!-----Need to Sql commands to monitoring  Postgresql
  2012-09-06 19:44 UTC  Josh Berkus <josh@agliodbs.com>
` Re: HELP!!!-----Need to Sql commands to monitoring Postgresql
  2012-09-06 19:50 UTC  Steven Crandell <steven.crandell@gmail.com>
` Re: HELP!!!-----Need to Sql commands to monitoring Postgresql
  2012-09-07 01:50 UTC  charles_xie <xqwyy163@163.com>
` Re: HELP!!!-----Need to Sql commands to monitoring Postgresql
  2012-09-07 05:45 UTC  Daniel Farina <daniel@heroku.com>
  [6+ messages in thread]

query performance, where goes time?
  2012-09-05 21:48 UTC  Anibal David Acosta <aa@devshock.com>
` Re: query performance, where goes time?
  2012-09-06 01:26 UTC  Craig Ringer <ringerc@ringerc.id.au>
  [2+ messages in thread]

JDBC 5 million function insert returning Single Transaction Lock Access Exclusive Problem
  2012-08-30 06:34 UTC  Eileen <hey_here@yahoo.com>
` Re: JDBC 5 million function insert returning Single Transaction Lock Access Exclusive Problem
  2012-08-31 13:50 UTC  Dave Cramer <pg@fastcrypt.com>
` Re: JDBC 5 million function insert returning Single Transaction Lock Access Exclusive Problem
  2012-08-31 14:18 UTC  Albe Laurenz <laurenz.albe@wien.gv.at>
` Re: JDBC 5 million function insert returning Single Transaction Lock Access Exclusive Problem
  2012-08-31 15:18 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: JDBC 5 million function insert returning Single Transaction Lock Access Exclusive Problem
  2012-09-01 00:43 UTC  Craig Ringer <ringerc@ringerc.id.au>
` Re: JDBC 5 million function insert returning Single Transaction Lock Access Exclusive Problem
  2012-09-04 23:34 UTC  Eileen <hey_here@yahoo.com>
  [6+ messages in thread]

Execution from java - slow
  2012-08-27 12:37 UTC  Jayadevan M <Jayadevan.Maymala@ibsplc.com>
` Re: Execution from java - slow
  2012-08-27 12:47 UTC  Albe Laurenz <laurenz.albe@wien.gv.at>
` Re: Execution from java - slow
  2012-08-28 07:11 UTC  Pavan Deolasee <pavan.deolasee@gmail.com>
` Re: Execution from java - slow
  2012-08-28 13:32 UTC  Merlin Moncure <mmoncure@gmail.com>
` Re: Execution from java - slow
  2012-09-03 08:35 UTC  Jayadevan M <Jayadevan.Maymala@ibsplc.com>
  [5+ messages in thread]

Loose Index Scans by Planner?
  2012-08-24 16:20 UTC  Shaun Thomas <sthomas@optionshouse.com>
` Re: Loose Index Scans by Planner?
  2012-08-24 19:40 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Loose Index Scans by Planner?
  2012-08-24 21:22 UTC  Shaun Thomas <sthomas@optionshouse.com>
` Re: Loose Index Scans by Planner?
  2012-08-25 03:42 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: Loose Index Scans by Planner?
  2012-08-25 14:39 UTC  Shaun Thomas <sthomas@optionshouse.com>
` Fwd: [PERFORM] Loose Index Scans by Planner?
  2012-09-02 21:53 UTC  Jeff Janes <jeff.janes@gmail.com>
  [6+ messages in thread]

Bad query plan when the wrong data type is used
  2011-02-08 14:15 UTC  Laszlo Nagy <gandalf@shopzeus.com>
` Re: Bad query plan when the wrong data type is used
  2011-02-08 22:04 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Bad query plan when the wrong data type is used
  2011-02-08 23:14 UTC  Dave Crooke <dcrooke@gmail.com>
` Re: Bad query plan when the wrong data type is used
  2011-02-09 09:52 UTC  Vitalii Tymchyshyn <tivv00@gmail.com>
` Re: Bad query plan when the wrong data type is used
  2011-02-27 18:16 UTC  Robert Haas <robertmhaas@gmail.com>
` Re: Bad query plan when the wrong data type is used
  2011-02-27 18:39 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Bad query plan when the wrong data type is used
  2011-02-28 19:04 UTC  Robert Haas <robertmhaas@gmail.com>
` Re: Bad query plan when the wrong data type is used
  2012-09-01 16:25 UTC  Bruce Momjian <bruce@momjian.us>
  [8+ messages in thread]

NOTIFY performance
  2012-08-24 18:46 UTC  Artur Zając <azajac@ang.com.pl>
` Re: NOTIFY performance
  2012-08-24 19:12 UTC  Merlin Moncure <mmoncure@gmail.com>
` Re: NOTIFY performance
  2012-08-24 21:11 UTC  Artur Zając <azajac@ang.com.pl>
` Re: NOTIFY performance
  2012-08-28 15:11 UTC  Merlin Moncure <mmoncure@gmail.com>
` Re: NOTIFY performance
  2012-08-31 19:54 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: NOTIFY performance
  2012-08-31 20:22 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: NOTIFY performance
  2012-09-01 02:12 UTC  Jeff Janes <jeff.janes@gmail.com>
  [7+ messages in thread]

Question about caching on full table scans
  2012-08-30 08:13 UTC  Markus Innerebner <markus.innerebner@inf.unibz.it>
` Re: Question about caching on full table scans
  2012-08-30 09:31 UTC  Albe Laurenz <laurenz.albe@wien.gv.at>
` Re: Question about caching on full table scans
  2012-08-30 17:34 UTC  Markus Innerebner <markus.innerebner@inf.unibz.it>
` Re: Question about caching on full table scans
  2012-08-30 18:00 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: Question about caching on full table scans
  2012-08-30 18:13 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Question about caching on full table scans
  2012-08-31 07:30 UTC  Markus Innerebner <markus.innerebner@inf.unibz.it>
  [6+ messages in thread]

Investigating the reason for a very big TOAST table size
  2012-08-26 12:46 UTC  Liron Shiri <lirons@checkpoint.com>
` Investigating the reason for a very big TOAST table size
  2012-08-26 12:51 UTC  Liron Shiri <lirons@checkpoint.com>
` Re: Investigating the reason for a very big TOAST table size
  2012-08-27 16:42 UTC  Daniel Farina <daniel@heroku.com>
` Re: Investigating the reason for a very big TOAST table size
  2012-08-28 06:24 UTC  Liron Shiri <lirons@checkpoint.com>
` Re: Investigating the reason for a very big TOAST table size
  2012-08-28 08:57 UTC  Daniel Farina <daniel@heroku.com>
` Re: Investigating the reason for a very big TOAST table size
  2012-08-28 08:59 UTC  Daniel Farina <daniel@heroku.com>
` Re: Investigating the reason for a very big TOAST table size
  2012-08-30 08:10 UTC  Daniel Farina <daniel@heroku.com>
` Re: Investigating the reason for a very big TOAST table size
  2012-08-30 08:34 UTC  Liron Shiri <lirons@checkpoint.com>
` Re: Investigating the reason for a very big TOAST table size
  2012-08-30 08:39 UTC  Daniel Farina <daniel@heroku.com>
  [9+ messages in thread]

pg_trgm and slow bitmap index scan plan
  2012-08-28 07:39 UTC  Mathieu De Zutter <mathieu@dezutter.org>
` Re: pg_trgm and slow bitmap index scan plan
  2012-08-28 13:27 UTC  Merlin Moncure <mmoncure@gmail.com>
  [2+ messages in thread]

Vacuum problems with 9.1
  2012-08-28 04:33 UTC  Nimesh Satam <nimesh.zedo@gmail.com>
` Re: Vacuum problems with 9.1
  2012-08-28 06:33 UTC  Pavan Deolasee <pavan.deolasee@gmail.com>
` Re: Vacuum problems with 9.1
  2012-08-28 06:53 UTC  Craig Ringer <ringerc@ringerc.id.au>
  [3+ messages in thread]

Increasing WAL usage followed by sudden drop
  2012-08-10 17:35 UTC  Joseph Marlin <jmarlin@saucontech.com>
` Re: Increasing WAL usage followed by sudden drop
  2012-08-14 01:09 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Increasing WAL usage followed by sudden drop
  2012-08-16 16:31 UTC  delongboy <sdelong@saucontech.com>
` Re: Increasing WAL usage followed by sudden drop
  2012-08-16 16:39 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Increasing WAL usage followed by sudden drop
  2012-08-17 15:01 UTC  Joshua Berkus <josh@agliodbs.com>
` Re: Increasing WAL usage followed by sudden drop
  2012-08-17 17:53 UTC  delongboy <sdelong@saucontech.com>
` Re: Increasing WAL usage followed by sudden drop
  2012-08-17 18:42 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: Increasing WAL usage followed by sudden drop
  2012-08-20 20:51 UTC  delongboy <sdelong@saucontech.com>
` Re: Increasing WAL usage followed by sudden drop
  2012-08-23 00:28 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: Increasing WAL usage followed by sudden drop
  2012-08-23 14:43 UTC  delongboy <sdelong@saucontech.com>
  [10+ messages in thread]

Performance of Seq Scan from buffer cache
  2012-08-21 22:57 UTC  Matt Daw <matt@shotgunsoftware.com>
` Re: Performance of Seq Scan from buffer cache
  2012-08-21 23:59 UTC  Matt Daw <matt@shotgunsoftware.com>
` Re: Performance of Seq Scan from buffer cache
  2012-08-23 13:32 UTC  Merlin Moncure <mmoncure@gmail.com>
  [3+ messages in thread]

average query performance measuring
  2012-08-21 18:35 UTC  Rick Otten <rotten@manta.com>
` Re: average query performance measuring
  2012-08-21 18:53 UTC  Stephen Frost <sfrost@snowman.net>
` Re: average query performance measuring
  2012-08-21 19:48 UTC  Karl Denninger <karl@denninger.net>
` Re: average query performance measuring
  2012-08-21 20:27 UTC  Stephen Frost <sfrost@snowman.net>
` Re: average query performance measuring
  2012-08-21 21:08 UTC  Tomas Vondra <tv@fuzzy.cz>
` Re: average query performance measuring
  2012-08-21 21:51 UTC  Peter Geoghegan <peter@2ndquadrant.com>
` Re: average query performance measuring
  2012-08-22 14:04 UTC  Rick Otten <rotten@manta.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