pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Upgraded to 8.2.3 --- still having performance issues
  2007-02-28 17:11 UTC  Carlos Moreno <moreno_pg@mochima.com>
` Re: Upgraded to 8.2.3 --- still having performance issues
  2007-02-28 17:20 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Upgraded to 8.2.3 --- still having performance issues
  2007-02-28 18:37 UTC  Carlos Moreno <carlos.moreno@mochima.com>
` Re: Upgraded to 8.2.3 --- still having performance issues
  2007-02-28 19:36 UTC  Carlos Moreno <moreno_pg@mochima.com>
` Re: Upgraded to 8.2.3 --- still having performance issues
  2007-02-28 20:20 UTC  Rodrigo Gonzalez <rjgonzale@gmail.com>
` Re: Upgraded to 8.2.3 --- still having performance issues
  2007-02-28 20:53 UTC  Carlos Moreno <moreno_pg@mochima.com>
` Re: Upgraded to 8.2.3 --- still having performance issues
  2007-02-28 21:33 UTC  Carlos Moreno <moreno_pg@mochima.com>
` Re: Upgraded to 8.2.3 --- still having performance issues
  2007-03-03 06:41 UTC  Dennis Bjorklund <db@zigo.dhs.org>
  [8+ messages in thread]

Performance Query
  2007-03-01 14:13 UTC  Abu Mushayeed <abumushayeed@yahoo.com>
` Re: Performance Query
  2007-03-03 00:52 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Performance Query
  2007-03-03 02:12 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [3+ messages in thread]

stats collector process high CPU utilization
  2007-02-08 16:48 UTC  Benjamin Minshall <minshall@intellicon.biz>
` Re: stats collector process high CPU utilization
  2007-02-08 17:17 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: stats collector process high CPU utilization
  2007-02-08 17:25 UTC  Benjamin Minshall <minshall@intellicon.biz>
` Re: stats collector process high CPU utilization
  2007-02-08 18:46 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: stats collector process high CPU utilization
  2007-02-08 21:16 UTC  Benjamin Minshall <minshall@intellicon.biz>
` Re: stats collector process high CPU utilization
  2007-02-08 21:24 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: stats collector process high CPU utilization
  2007-02-08 21:55 UTC  Benjamin Minshall <minshall@intellicon.biz>
` Re: stats collector process high CPU utilization
  2007-02-08 22:07 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: stats collector process high CPU utilization
  2007-02-08 22:29 UTC  Benjamin Minshall <minshall@intellicon.biz>
` Re: stats collector process high CPU utilization
  2007-02-09 02:04 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: stats collector process high CPU utilization
  2007-02-09 04:13 UTC  minshall@intellicon.biz
` Re: stats collector process high CPU utilization
  2007-02-09 04:26 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: stats collector process high CPU utilization
  2007-02-09 14:24 UTC  Alvaro Herrera <alvherre@commandprompt.com>
` Re: stats collector process high CPU utilization
  2007-02-09 15:08 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: stats collector process high CPU utilization
  2007-02-09 15:55 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: stats collector process high CPU utilization
  2007-02-09 16:27 UTC  Benjamin Minshall <minshall@intellicon.biz>
` Re: stats collector process high CPU utilization
  2007-02-09 16:33 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: stats collector process high CPU utilization
  2007-02-09 18:36 UTC  Benjamin Minshall <minshall@intellicon.biz>
` Re: stats collector process high CPU utilization
  2007-03-01 20:12 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: stats collector process high CPU utilization
  2007-03-01 20:41 UTC  Benjamin Minshall <minshall@intellicon.biz>
` Re: stats collector process high CPU utilization
  2007-03-01 21:58 UTC  Merlin Moncure <mmoncure@gmail.com>
` Re: stats collector process high CPU utilization
  2007-03-01 22:44 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: stats collector process high CPU utilization
  2007-03-02 01:30 UTC  Merlin Moncure <mmoncure@gmail.com>
` Re: stats collector process high CPU utilization
  2007-03-02 01:35 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: stats collector process high CPU utilization
  2007-03-02 10:32 UTC  Magnus Hagander <magnus@hagander.net>
` Re: stats collector process high CPU utilization
  2007-03-02 23:06 UTC  Bruce Momjian <bruce@momjian.us>
` Re: stats collector process high CPU utilization
  2007-03-02 23:23 UTC  Joshua D. Drake <jd@commandprompt.com>
  [27+ messages in thread]

Array indexes, GIN?
  2007-03-02 03:59 UTC  Adam L Beberg <beberg@mithral.com>
` Re: Array indexes, GIN?
  2007-03-02 05:47 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Array indexes, GIN?
  2007-03-02 06:45 UTC  Oleg Bartunov <oleg@sai.msu.su>
` Re: Array indexes, GIN?
  2007-03-02 07:50 UTC  Adam L Beberg <beberg@mithral.com>
` Re: Array indexes, GIN?
  2007-03-02 19:50 UTC  Jeff Davis <pgsql@j-davis.com>
  [5+ messages in thread]

Improving query performance
  2007-03-02 04:00 UTC  David Leangen <postgres@leangen.net>
` Re: Improving query performance
  2007-03-02 05:48 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Improving query performance
  2007-03-02 09:06 UTC  David Leangen <postgres@leangen.net>
  [3+ messages in thread]

Identical Queries
  2007-03-01 15:43 UTC  Rob Schall <rschall@callone.net>
` Re: Identical Queries
  2007-03-01 19:39 UTC  Stephan Szabo <sszabo@megazone.bigpanda.com>
` Re: Identical Queries
  2007-03-01 20:55 UTC  Rob Schall <rschall@callone.net>
` Re: Identical Queries
  2007-03-01 21:09 UTC  Chad Wagner <chad.wagner@gmail.com>
` Re: Identical Queries
  2007-03-01 22:23 UTC  Stephan Szabo <sszabo@megazone.bigpanda.com>
` Re: Identical Queries
  2007-03-01 22:41 UTC  Craig A. James <cjames@modgraph-usa.com>
  [6+ messages in thread]

performances with Pentium D
  2007-02-28 15:58 UTC  hatman <joel.winteregg@gmail.com>
` Re: performances with Pentium D
  2007-03-01 11:00 UTC  Ben Trewern <ben.trewern@mowlem.com>
` Re: performances with Pentium D
  2007-03-01 22:28 UTC  hatman <joel.winteregg@gmail.com>
  [3+ messages in thread]

increasing database connections
  2007-03-01 05:18 UTC  Shiva Sarna <shivasarna@yahoo.co.in>
` Re: increasing database connections
  2007-03-01 05:49 UTC  Jonah H. Harris <jonah.harris@gmail.com>
` Re: increasing database connections
  2007-03-01 06:18 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: increasing database connections
  2007-03-01 07:07 UTC  Mark Kirkwood <markir@paradise.net.nz>
` Re: increasing database connections
  2007-03-01 08:58 UTC  Magnus Hagander <magnus@hagander.net>
` Re: increasing database connections
  2007-03-01 11:04 UTC  Florian Weimer <fweimer@bfk.de>
` Re: increasing database connections
  2007-03-01 12:20 UTC  Ron <rjpeace@earthlink.net>
` Re: increasing database connections
  2007-03-01 15:47 UTC  Joshua D. Drake <jd@commandprompt.com>
  [8+ messages in thread]

Dead Space Map version 2
  2007-02-27 03:05 UTC  ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>
` Re: Dead Space Map version 2
  2007-02-27 05:11 UTC  Jim C. Nasby <jim@nasby.net>
` Re: Dead Space Map version 2
  2007-02-27 05:55 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Dead Space Map version 2
  2007-02-27 07:49 UTC  Simon Riggs <simon@2ndquadrant.com>
` Re: Dead Space Map version 2
  2007-02-27 08:11 UTC  Simon Riggs <simon@2ndquadrant.com>
` Re: Dead Space Map version 2
  2007-02-27 08:16 UTC  Simon Riggs <simon@2ndquadrant.com>
` Re: Dead Space Map version 2
  2007-02-27 08:38 UTC  ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>
` Re: Dead Space Map version 2
  2007-02-27 08:56 UTC  ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>
` Re: Dead Space Map version 2
  2007-02-27 09:37 UTC  ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>
` Re: Dead Space Map version 2
  2007-02-27 09:51 UTC  Heikki Linnakangas <heikki@enterprisedb.com>
` Re: Dead Space Map version 2
  2007-02-27 16:58 UTC  Jim C. Nasby <jim@nasby.net>
` Re: Dead Space Map version 2
  2007-02-27 17:06 UTC  Jim C. Nasby <jim@nasby.net>
` Re: Dead Space Map version 2
  2007-02-28 05:34 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Dead Space Map version 2
  2007-02-28 06:04 UTC  ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>
` Re: Dead Space Map version 2
  2007-02-28 07:10 UTC  ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>
` Re: Dead Space Map version 2
  2007-02-28 09:51 UTC  Heikki Linnakangas <heikki@enterprisedb.com>
` Re: Dead Space Map version 2
  2007-03-01 00:45 UTC  Takayuki Tsunakawa <tsunakawa.takay@jp.fujitsu.com>
` Re: Dead Space Map version 2
  2007-03-01 15:45 UTC  Jim C. Nasby <jim@nasby.net>
  [18+ messages in thread]

Two hard drives --- what to do with them?
  2007-02-25 03:39 UTC  Carlos Moreno <moreno_pg@mochima.com>
` Re: Two hard drives --- what to do with them?
  2007-02-25 03:58 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Two hard drives --- what to do with them?
  2007-02-25 04:08 UTC  Alexander Staubo <alex@purefiction.net>
` Re: Two hard drives --- what to do with them?
  2007-02-25 22:11 UTC  Peter Kovacs <maxottovonstirlitz@gmail.com>
` Re: Two hard drives --- what to do with them?
  2007-02-26 21:51 UTC  Jeff Davis <pgsql@j-davis.com>
` Re: Two hard drives --- what to do with them?
  2007-02-27 00:11 UTC  Peter Kovacs <maxottovonstirlitz@gmail.com>
` Re: Two hard drives --- what to do with them?
  2007-02-27 00:25 UTC  Jeff Davis <pgsql@j-davis.com>
` Re: Two hard drives --- what to do with them?
  2007-02-27 05:05 UTC  Shane Ambler <pgsql@Sheeky.Biz>
` Re: Two hard drives --- what to do with them?
  2007-02-27 08:27 UTC  Peter Kovacs <maxottovonstirlitz@gmail.com>
` Re: Two hard drives --- what to do with them?
  2007-02-27 15:57 UTC  Ben <bench@silentmedia.com>
` Re: Two hard drives --- what to do with them?
  2007-02-27 18:51 UTC  Shane Ambler <pgsql@Sheeky.Biz>
` Re: Two hard drives --- what to do with them?
  2007-02-27 19:23 UTC  Jeff Davis <pgsql@j-davis.com>
` Re: Two hard drives --- what to do with them?
  2007-02-27 19:38 UTC  Scott Marlowe <smarlowe@g2switchworks.com>
` Re: Two hard drives --- what to do with them?
  2007-03-01 03:28 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: Two hard drives --- what to do with them?
  2007-03-01 03:31 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: Two hard drives --- what to do with them?
  2007-03-01 03:35 UTC  Bruno Wolff III <bruno@wolff.to>
  [16+ messages in thread]

Writting a "search engine" for a pgsql DB
  2007-02-26 16:29 UTC  Madison Kelly <linux@alteeve.com>
` Re: Writting a "search engine" for a pgsql DB
  2007-02-26 17:04 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: Writting a "search engine" for a pgsql DB
  2007-02-26 17:32 UTC  Mark Stosberg <mark@summersault.com>
` Re: Writting a "search engine" for a pgsql DB
  2007-02-26 17:41 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: Writting a "search engine" for a pgsql DB
  2007-02-26 17:47 UTC  Madison Kelly <linux@alteeve.com>
` Re: Writting a "search engine" for a pgsql DB
  2007-02-26 17:55 UTC  Magnus Hagander <magnus@hagander.net>
` Re: Writting a "search engine" for a pgsql DB
  2007-02-26 18:15 UTC  Mark Stosberg <mark@summersault.com>
` Re: Writting a "search engine" for a pgsql DB
  2007-02-26 18:59 UTC  Madison Kelly <linux@alteeve.com>
` Re: Writting a "search engine" for a pgsql DB
  2007-02-26 19:46 UTC  Mark Stosberg <mark@summersault.com>
` Re: Writting a "search engine" for a pgsql DB
  2007-02-26 20:14 UTC  Jeff Davis <pgsql@j-davis.com>
` Re: Writting a "search engine" for a pgsql DB
  2007-02-26 21:24 UTC  Charles Sprickman <spork@bway.net>
` Re: Writting a "search engine" for a pgsql DB
  2007-02-27 13:15 UTC  Magnus Hagander <magnus@hagander.net>
` Re: Writting a "search engine" for a pgsql DB
  2007-02-27 13:33 UTC  Dave Page <dpage@postgresql.org>
` Re: Writting a "search engine" for a pgsql DB
  2007-02-27 23:05 UTC  Chris <dmagick@gmail.com>
` Re: Writting a "search engine" for a pgsql DB
  2007-02-27 23:36 UTC  Charles Sprickman <spork@bway.net>
` Re: Writting a "search engine" for a pgsql DB
  2007-02-28 07:44 UTC  Magnus Hagander <magnus@hagander.net>
` Re: Writting a "search engine" for a pgsql DB
  2007-02-28 08:33 UTC  Dave Page <dpage@postgresql.org>
` Re: Writting a "search engine" for a pgsql DB
  2007-02-28 11:16 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Writting a "search engine" for a pgsql DB
  2007-02-28 11:39 UTC  Dave Page <dpage@postgresql.org>
` Re: Writting a "search engine" for a pgsql DB
  2007-02-28 12:35 UTC  Oleg Bartunov <oleg@sai.msu.su>
` Re: Writting a "search engine" for a pgsql DB
  2007-02-28 12:40 UTC  Dave Page <dpage@postgresql.org>
  [21+ messages in thread]

[kris@obsecurity.org: Anyone interested in improving postgresql scaling?]
  2007-02-27 18:32 UTC  Jim C. Nasby <decibel@decibel.org>
` Re: [kris@obsecurity.org: Anyone interested in improving postgresql scaling?]
  2007-02-27 18:54 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [2+ messages in thread]

[kris@obsecurity.org: Progress on scaling of FreeBSD on 8 CPU systems]
  2007-02-27 18:26 UTC  Jim C. Nasby <decibel@decibel.org>

Postgres performance Linux vs FreeBSD
  2007-02-21 09:57 UTC  Jacek Zaręba <asthma@polok.pl>
` Re: Postgres performance Linux vs FreeBSD
  2007-02-21 15:21 UTC  Merlin Moncure <mmoncure@gmail.com>
` Re: Postgres performance Linux vs FreeBSD
  2007-02-21 15:23 UTC  Bill Moran <wmoran@collaborativefusion.com>
` Re: Postgres performance Linux vs FreeBSD
  2007-02-21 19:27 UTC  Dimitri Fontaine <dim@dalibo.com>
` Re: Postgres performance Linux vs FreeBSD
  2007-02-21 21:12 UTC  Mark Kirkwood <markir@paradise.net.nz>
` Re: Postgres performance Linux vs FreeBSD
  2007-02-27 17:56 UTC  Andrew - Supernews <andrew+nonews@supernews.com>
  [6+ messages in thread]

Vacuumdb - Max_FSM_Pages Problem.
  2007-02-26 14:44 UTC  Pallav Kalva <pkalva@livedatagroup.com>
` Re: Vacuumdb - Max_FSM_Pages Problem.
  2007-02-26 15:53 UTC  Peter Childs <peterachilds@gmail.com>
` Re: Vacuumdb - Max_FSM_Pages Problem.
  2007-02-26 20:33 UTC  Ron <rjpeace@earthlink.net>
  [3+ messages in thread]

does prepareThreshold work? forced to use old driver
  2007-02-26 16:12 UTC  Gene <genekhart@gmail.com>
` Re: does prepareThreshold work? forced to use old driver
  2007-02-26 16:45 UTC  Kris Jurka <books@ejurka.com>
` Re: does prepareThreshold work? forced to use old driver
  2007-02-26 17:28 UTC  Dave Cramer <pg@fastcrypt.com>
` Re: does prepareThreshold work? forced to use old driver
  2007-02-26 17:41 UTC  Gene <genekhart@gmail.com>
  [4+ messages in thread]

low memory usage reported by 'top' indicates poor tuning?
  2007-02-26 16:52 UTC  Mark Stosberg <mark@summersault.com>
` Re: low memory usage reported by 'top' indicates poor tuning?
  2007-02-26 17:08 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: low memory usage reported by 'top' indicates poor tuning?
  2007-02-26 17:26 UTC  Mark Stosberg <mark@summersault.com>
  [3+ messages in thread]

Server Startup Error
  2007-02-26 13:22 UTC  Gauri Kanekar <meetgaurikanekar@gmail.com>
` Re: Server Startup Error
  2007-02-26 13:27 UTC  Rodrigo Gonzalez <rjgonzale@gmail.com>
` Re: Server Startup Error
  2007-02-26 13:28 UTC  Gauri Kanekar <meetgaurikanekar@gmail.com>
` Re: Server Startup Error
  2007-02-26 13:29 UTC  Richard Huxton <dev@archonet.com>
` Re: Server Startup Error
  2007-02-26 13:35 UTC  Rodrigo Gonzalez <rjgonzale@gmail.com>
` Re: Server Startup Error
  2007-02-26 14:03 UTC  Richard Huxton <dev@archonet.com>
  [6+ messages in thread]

pg_trgm performance
  2007-01-15 10:16 UTC  Florian Weimer <fweimer@bfk.de>
` Re: pg_trgm performance
  2007-01-15 12:58 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: pg_trgm performance
  2007-02-23 23:09 UTC  Guillaume Smet <guillaume.smet@gmail.com>
` Re: pg_trgm performance
  2007-02-24 00:31 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: pg_trgm performance
  2007-02-24 01:04 UTC  Guillaume Smet <guillaume.smet@gmail.com>
` Re: pg_trgm performance
  2007-02-24 10:07 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: pg_trgm performance
  2007-02-26 12:42 UTC  Guillaume Smet <guillaume.smet@gmail.com>
` Re: pg_trgm performance
  2007-02-26 12:53 UTC  Oleg Bartunov <oleg@sai.msu.su>
` Re: pg_trgm performance
  2007-02-26 12:58 UTC  Guillaume Smet <guillaume.smet@gmail.com>
` Re: pg_trgm performance
  2007-02-26 13:10 UTC  Oleg Bartunov <oleg@sai.msu.su>
  [10+ messages in thread]

Query Planner
  2007-02-26 11:49 UTC  Gauri Kanekar <meetgaurikanekar@gmail.com>
` Re: Query Planner
  2007-02-26 11:52 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
  [2+ messages in thread]

Very slow bytea data extraction
  2007-02-23 10:10 UTC  msmbarabino@virgilio.it <msmbarabino@virgilio.it>
` Re: Very slow bytea data extraction
  2007-02-23 10:46 UTC  Richard Huxton <dev@archonet.com>
` Re: Very slow bytea data extraction
  2007-02-23 17:44 UTC  msmbarabino@virgilio.it <msmbarabino@virgilio.it>
` Re: Very slow bytea data extraction
  2007-02-23 17:55 UTC  msmbarabino@virgilio.it <msmbarabino@virgilio.it>
` Re: Very slow bytea data extraction
  2007-02-26 08:56 UTC  Richard Huxton <dev@archonet.com>
  [5+ messages in thread]

invalid page header in block 428 of relation "pg_attribute"
  2007-02-26 05:44 UTC  ashok@kalculate.com <ashok@kalculate.com>

long checkpoint_timeout
  2007-02-23 18:14 UTC  Jeff Davis <pgsql@j-davis.com>
` Re: long checkpoint_timeout
  2007-02-23 20:02 UTC  Jim C. Nasby <jim@nasby.net>
` Re: long checkpoint_timeout
  2007-02-23 20:23 UTC  Jeff Davis <pgsql@j-davis.com>
` Re: long checkpoint_timeout
  2007-02-23 22:34 UTC  Jim C. Nasby <jim@nasby.net>
  [4+ messages in thread]

Recommended Initial Settings
  2007-02-23 16:08 UTC  Campbell, Lance <lance@uiuc.edu>
` Re: Recommended Initial Settings
  2007-02-23 16:29 UTC  Richard Huxton <dev@archonet.com>
` Re: Recommended Initial Settings
  2007-02-23 17:14 UTC  Campbell, Lance <lance@uiuc.edu>
` Re: Recommended Initial Settings
  2007-02-23 17:19 UTC  Richard Huxton <dev@archonet.com>
` Re: Recommended Initial Settings
  2007-02-23 17:43 UTC  Jim C. Nasby <jim@nasby.net>
` Re: Recommended Initial Settings
  2007-02-23 18:11 UTC  Bill Moran <wmoran@collaborativefusion.com>
  [6+ messages in thread]

Using the 8.2 autovacuum values with 8.1
  2007-02-22 21:53 UTC  Mark Stosberg <mark@summersault.com>
` Re: Using the 8.2 autovacuum values with 8.1
  2007-02-23 09:13 UTC  Csaba Nagy <nagy@ecircle-ag.com>
` Re: Using the 8.2 autovacuum values with 8.1
  2007-02-23 17:37 UTC  Jim C. Nasby <jim@nasby.net>
  [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