pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Re: Postgres vs. DSpam
  2004-11-26 01:37 UTC  Andrew McMillan <andrew@catalyst.net.nz>
` Re: Postgres vs. DSpam
  2004-11-26 03:25 UTC  Neil Conway <neilc@samurai.com>
` Re: Postgres vs. DSpam
  2004-11-29 21:50 UTC  Jim C. Nasby <decibel@decibel.org>
  [3+ messages in thread]

Postgres vs. MySQL
  2004-11-24 13:14 UTC  Evilio del Rio <edelrio@cmima.csic.es>
` Re: Postgres vs. MySQL
  2004-11-24 14:16 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Postgres vs. MySQL
  2004-11-24 14:27 UTC  Richard Huxton <dev@archonet.com>
` Re: Postgres vs. MySQL
  2004-11-24 14:57 UTC  Christian Fowler <spider@viovio.com>
` Re: Postgres vs. MySQL
  2004-11-24 15:57 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: Postgres vs. MySQL
  2004-11-24 16:26 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Postgres vs. MySQL
  2004-11-25 01:18 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Postgres vs. MySQL
  2004-11-25 12:38 UTC  Dave Cramer <pg@fastcrypt.com>
` Re: [dspam-users] Postgres vs. MySQL
  2004-11-26 20:35 UTC  Clifton Royston <cliftonr@tikitechnologies.com>
` Re: [dspam-users] Postgres vs. MySQL
  2004-11-27 02:11 UTC  Casey Allen Shobe <cshobe@osss.net>
` Re: [dspam-users] Postgres vs. MySQL
  2004-11-27 10:14 UTC  Lionel Bouton <lionel-subscription@bouton.name>
` Re: [dspam-users] Postgres vs. MySQL
  2004-11-27 18:43 UTC  Christopher Browne <cbbrowne@acm.org>
  [12+ messages in thread]

time to stop tuning?
  2004-11-26 17:13 UTC  David Parker <dparker@tazznetworks.com>
` Re: time to stop tuning?
  2004-11-26 18:29 UTC  Rod Taylor <rbt@sitesell.com>
` Re: time to stop tuning?
  2004-11-26 19:04 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: time to stop tuning?
  2004-11-26 19:16 UTC  David Parker <dparker@tazznetworks.com>
` Re: time to stop tuning?
  2004-11-26 21:48 UTC  Rod Taylor <rbt@sitesell.com>
  [5+ messages in thread]

Postgres backend using huge amounts of ram
  2004-11-25 20:35 UTC  Gary Doades <gpd@gpdnet.co.uk>
` Re: Postgres backend using huge amounts of ram
  2004-11-26 09:12 UTC  Richard Huxton <dev@archonet.com>
` Re: Postgres backend using huge amounts of ram
  2004-11-26 19:25 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Postgres backend using huge amounts of ram
  2004-11-26 19:42 UTC  Gary Doades <gpd@gpdnet.co.uk>
  [4+ messages in thread]

HELP speed up my Postgres
  2004-11-25 06:00 UTC  JM <jerome@gmanmi.tv>
` Re: [PERFORM] HELP speed up my Postgres
  2004-11-25 06:12 UTC  Vishal Kashyap @ [SaiHertz] <vishalonlist@gmail.com>
` Re: [PERFORM] HELP speed up my Postgres
  2004-11-25 06:29 UTC  JM <jerome@gmanmi.tv>
` Re: [PERFORM] HELP speed up my Postgres
  2004-11-25 06:40 UTC  Iain <iain@mst.co.jp>
` Re: [PERFORM] HELP speed up my Postgres
  2004-11-25 06:55 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] HELP speed up my Postgres
  2004-11-25 07:06 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: [PERFORM] HELP speed up my Postgres
  2004-11-25 07:08 UTC  Klint Gore <kg@kgb.une.edu.au>
` Re: HELP speed up my Postgres
  2004-11-25 09:21 UTC  Anatoly Okishev <rolly74@mail.ru>
` Re: [PERFORM] HELP speed up my Postgres
  2004-11-26 08:28 UTC  Jerome Macaranas <jerome@gmanmi.tv>
  [9+ messages in thread]

Trigger before insert
  2004-11-25 11:37 UTC  ON.KG <skyer@on.kg>
` Re: Trigger before insert
  2004-11-25 12:54 UTC  Richard Huxton <dev@archonet.com>
` Re: Trigger before insert
  2004-11-25 15:02 UTC  ON.KG <skyer@on.kg>
  [3+ messages in thread]

Slow execution time when querying view with WHERE clause
  2004-11-22 21:38 UTC  Mike Mascari <mascarm@mascari.com>
` Re: Slow execution time when querying view with WHERE clause
  2004-11-22 21:46 UTC  Mike Mascari <mascarm@mascari.com>
` Re: Slow execution time when querying view with WHERE clause
  2004-11-23 17:54 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Slow execution time when querying view with WHERE clause
  2004-11-24 02:04 UTC  Mike Mascari <mascarm@mascari.com>
` Re: Slow execution time when querying view with WHERE clause
  2004-11-24 05:40 UTC  Jaime Casanova <systemguards@yahoo.com>
` Re: Slow execution time when querying view with WHERE clause
  2004-11-24 06:11 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Slow execution time when querying view with WHERE clause
  2004-11-24 06:31 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Slow execution time when querying view with WHERE clause
  2004-11-24 22:51 UTC  Mike Mascari <mascarm@mascari.com>
  [8+ messages in thread]

Big number of schemas (3500) into a single database
  2004-11-22 07:44 UTC  Constantin Teodorescu <teo@flex.ro>
` Re: Big number of schemas (3500) into a single database
  2004-11-24 05:32 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORMANCE] Big number of schemas (3500) into a single database
  2004-11-24 17:11 UTC  Jaime Casanova <systemguards@yahoo.com>
  [3+ messages in thread]

memcached and PostgreSQL
  2004-11-17 04:00 UTC  Michael Adler <adler@pobox.com>
` Re: memcached and PostgreSQL
  2004-11-17 05:47 UTC  Josh Berkus <josh@agliodbs.com>
` Re: memcached and PostgreSQL
  2004-11-17 07:48 UTC  Troels Arvin <troels@arvin.dk>
` Re: memcached and PostgreSQL
  2004-11-17 08:08 UTC  Greg Stark <gsstark@mit.edu>
` Re: memcached and PostgreSQL
  2004-11-17 16:18 UTC  Mike Rylander <mrylander@gmail.com>
` Re: memcached and PostgreSQL
  2004-11-17 17:13 UTC  Darcy Buskermolen <darcy@wavefire.com>
` Re: memcached and PostgreSQL
  2004-11-17 19:51 UTC  Michael Adler <adler@pobox.com>
` Re: memcached and PostgreSQL
  2004-11-17 21:07 UTC  Josh Berkus <josh@agliodbs.com>
` Re: memcached and PostgreSQL
  2004-11-18 21:10 UTC  Sean Chittenden <sean@chittenden.org>
` Re: memcached and PostgreSQL
  2004-11-22 04:15 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
` Re: memcached and PostgreSQL
  2004-11-22 04:27 UTC  Josh Berkus <josh@agliodbs.com>
` Re: memcached and PostgreSQL
  2004-11-22 04:55 UTC  Sean Chittenden <sean@chittenden.org>
` Re: memcached and PostgreSQL
  2004-11-22 07:59 UTC  Patrick B Kelly <pbk@patrickbkelly.org>
` Re: memcached and PostgreSQL
  2004-11-22 12:30 UTC  Pierre-Frédéric Caillaud <lists@boutiquenumerique.com>
` Re: memcached and PostgreSQL
  2004-11-23 02:18 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
` Re: memcached and PostgreSQL
  2004-11-23 22:20 UTC  Sean Chittenden <sean@chittenden.org>
` Re: memcached and PostgreSQL
  2004-11-24 16:06 UTC  Jim C. Nasby <decibel@decibel.org>
  [17+ messages in thread]

Data type to use for primary key
  2004-11-22 20:32 UTC  Alexandre Leclerc <alexandre.leclerc@gmail.com>
` Re: Data type to use for primary key
  2004-11-22 23:06 UTC  Pierre-Frédéric Caillaud <lists@boutiquenumerique.com>
` Re: Data type to use for primary key
  2004-11-22 23:26 UTC  Alexandre Leclerc <alexandre.leclerc@gmail.com>
` Re: Data type to use for primary key
  2004-11-23 00:54 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Data type to use for primary key
  2004-11-23 01:03 UTC  Rod Taylor <pg@rbt.ca>
` Re: Data type to use for primary key
  2004-11-23 06:00 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Data type to use for primary key
  2004-11-23 08:39 UTC  Pierre-Frédéric Caillaud <lists@boutiquenumerique.com>
` Re: Data type to use for primary key
  2004-11-23 14:59 UTC  Peter Darley <pdarley@kinesis-cem.com>
` Re: Data type to use for primary key
  2004-11-23 16:29 UTC  Alexandre Leclerc <alexandre.leclerc@gmail.com>
` Re: Data type to use for primary key
  2004-11-23 16:45 UTC  Pierre-Frédéric Caillaud <lists@boutiquenumerique.com>
` Re: Data type to use for primary key
  2004-11-24 06:52 UTC  Greg Stark <gsstark@mit.edu>
` Re: Data type to use for primary key
  2004-11-24 07:16 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Data type to use for primary key
  2004-11-24 08:14 UTC  Greg Stark <gsstark@mit.edu>
` Re: Data type to use for primary key
  2004-11-24 15:39 UTC  Alexandre Leclerc <alexandre.leclerc@gmail.com>
  [14+ messages in thread]

Some quick Opteron 32-bit/64-bit results
  2004-11-13 22:59 UTC  William Yu <wyu@talisys.com>
` Re: Some quick Opteron 32-bit/64-bit results
  2004-11-13 23:58 UTC  William Yu <wyu@talisys.com>
` Re: Some quick Opteron 32-bit/64-bit results
  2004-11-14 00:14 UTC  Gustavo Franklin Nóbrega <gfnobrega@planae.com.br>
` Re: Some quick Opteron 32-bit/64-bit results
  2004-11-14 00:52 UTC  William Yu <wyu@talisys.com>
` Re: Some quick Opteron 32-bit/64-bit results
  2004-11-15 07:03 UTC  Greg Stark <gsstark@mit.edu>
` Re: Some quick Opteron 32-bit/64-bit results
  2004-11-15 07:51 UTC  William Yu <wyu@talisys.com>
` Re: Some quick Opteron 32-bit/64-bit results
  2004-11-23 17:20 UTC  Cott Lang <cott@internetstaff.com>
  [7+ messages in thread]

help needed -- sequential scan problem
  2004-11-19 22:31 UTC  sarlav kumar <sarlavk@yahoo.com>
` Re: help needed -- sequential scan problem
  2004-11-20 05:19 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: help needed -- sequential scan problem
  2004-11-22 19:41 UTC  sarlav kumar <sarlavk@yahoo.com>
` Re: help needed -- sequential scan problem
  2004-11-22 19:57 UTC  Josh Berkus <josh@agliodbs.com>
` Re: help needed -- sequential scan problem
  2004-11-22 19:58 UTC  sarlav kumar <sarlavk@yahoo.com>
` Re: help needed -- sequential scan problem
  2004-11-22 20:01 UTC  gnari <gnari@simnet.is>
  [6+ messages in thread]

Index usage for sorted query
  2004-11-20 14:17 UTC  Markus Schaber <schabios@logi-track.com>
` Re: Index usage for sorted query
  2004-11-20 16:12 UTC  Pierre-Frédéric Caillaud <lists@boutiquenumerique.com>
` Re: Index usage for sorted query
  2004-11-20 16:48 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Index usage for sorted query
  2004-11-22 15:01 UTC  Markus Schaber <schabios@logi-track.com>
  [4+ messages in thread]

sort_mem affect on inserts?
  2004-11-17 21:31 UTC  David Parker <dparker@tazznetworks.com>
` Re: sort_mem affect on inserts?
  2004-11-17 22:07 UTC  Josh Berkus <josh@agliodbs.com>
` Re: sort_mem affect on inserts?
  2004-11-19 14:34 UTC  Jan Wieck <JanWieck@Yahoo.com>
` Re: sort_mem affect on inserts?
  2004-11-19 20:25 UTC  Josh Berkus <josh@agliodbs.com>
` Re: sort_mem affect on inserts?
  2004-11-21 14:51 UTC  Neil Conway <neilc@samurai.com>
  [5+ messages in thread]

tablespace + RAM disk?
  2004-11-19 22:32 UTC  David Parker <dparker@tazznetworks.com>
` Re: tablespace + RAM disk?
  2004-11-20 00:35 UTC  Josh Berkus <josh@agliodbs.com>
` Re: tablespace + RAM disk?
  2004-11-20 01:34 UTC  David Parker <dparker@tazznetworks.com>
` Re: tablespace + RAM disk?
  2004-11-20 04:18 UTC  David Parker <dparker@tazznetworks.com>
` Re: tablespace + RAM disk?
  2004-11-20 09:36 UTC  Dawid Kuroczko <qnex42@gmail.com>
` Re: tablespace + RAM disk?
  2004-11-20 19:38 UTC  Josh Berkus <josh@agliodbs.com>
` Re: tablespace + RAM disk?
  2004-11-21 14:48 UTC  Neil Conway <neilc@samurai.com>
  [7+ messages in thread]

index use
  2004-11-19 19:18 UTC  Arshavir Grigorian <ag@m-cam.com>
` Re: index use
  2004-11-19 20:00 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: index use
  2004-11-19 20:09 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: index use
  2004-11-19 20:27 UTC  Josh Berkus <josh@agliodbs.com>
` Re: index use
  2004-11-19 20:29 UTC  Stephan Szabo <sszabo@megazone.bigpanda.com>
` Re: index use
  2004-11-19 20:39 UTC  Arshavir Grigorian <ag@m-cam.com>
` Re: index use
  2004-11-20 19:40 UTC  Josh Berkus <josh@agliodbs.com>
  [7+ messages in thread]

When to bump up statistics?
  2004-11-19 13:59 UTC  Dawid Kuroczko <qnex42@gmail.com>
` Re: When to bump up statistics?
  2004-11-19 20:23 UTC  Chris Browne <cbbrowne@acm.org>
` Re: When to bump up statistics?
  2004-11-19 20:32 UTC  Josh Berkus <josh@agliodbs.com>
  [3+ messages in thread]

Interaction between Free Space Map an alternate location for a database
  2004-11-18 17:09 UTC  Dave Cramer <pg@fastcrypt.com>
` Re: Interaction between Free Space Map an alternate location for a database
  2004-11-18 18:18 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Interaction between Free Space Map an alternate location for a database
  2004-11-18 18:38 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Interaction between Free Space Map an alternate location
  2004-11-18 18:42 UTC  Dave Cramer <pg@fastcrypt.com>
` Re: Interaction between Free Space Map an alternate location
  2004-11-18 19:46 UTC  Dave Cramer <pg@fastcrypt.com>
  [5+ messages in thread]

Timing of pgstats updates
  2004-11-18 16:43 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Timing of pgstats updates
  2004-11-18 19:29 UTC  Jan Wieck <JanWieck@Yahoo.com>
  [2+ messages in thread]

query plan question
  2004-11-17 03:54 UTC  David Parker <dparker@tazznetworks.com>
` Re: query plan question
  2004-11-17 04:35 UTC  Russell Smith <mr-russ@pws.com.au>
` Re: query plan question
  2004-11-17 06:40 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: query plan question
  2004-11-17 12:32 UTC  David Parker <dparker@tazznetworks.com>
` Re: query plan question
  2004-11-17 13:08 UTC  David Parker <dparker@tazznetworks.com>
` Re: query plan question
  2004-11-17 14:00 UTC  Jeff <threshar@torgo.978.org>
` Re: query plan question
  2004-11-17 14:43 UTC  David Parker <dparker@tazznetworks.com>
` Re: query plan question
  2004-11-17 15:06 UTC  David Parker <dparker@tazznetworks.com>
` Re: query plan question
  2004-11-17 15:46 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: query plan question
  2004-11-17 15:59 UTC  David Parker <dparker@tazznetworks.com>
` Re: query plan question
  2004-11-17 16:41 UTC  Matthew T. O'Connor <matthew@zeut.net>
` Re: query plan question
  2004-11-17 19:01 UTC  Matthew T. O'Connor <matthew@zeut.net>
` Re: query plan question
  2004-11-18 16:12 UTC  David Parker <dparker@tazznetworks.com>
  [13+ messages in thread]

Tsearch2 really slower than ilike ?
  2004-11-16 14:55 UTC  Hervé Piedvache <herve@elma.fr>
` Re: Tsearch2 really slower than ilike ?
  2004-11-16 15:32 UTC  Michael Fuhr <mike@fuhr.org>
` Re: Tsearch2 really slower than ilike ?
  2004-11-16 15:48 UTC  Hervé Piedvache <herve@elma.fr>
` Re: Tsearch2 really slower than ilike ?
  2004-11-16 16:04 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: Tsearch2 really slower than ilike ?
  2004-11-16 16:06 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: Tsearch2 really slower than ilike ?
  2004-11-16 16:17 UTC  Oleg Bartunov <oleg@sai.msu.su>
` Re: Tsearch2 really slower than ilike ?
  2004-11-16 16:21 UTC  Hervé Piedvache <herve@elma.fr>
` Re: Tsearch2 really slower than ilike ?
  2004-11-16 16:27 UTC  Oleg Bartunov <oleg@sai.msu.su>
` Re: Tsearch2 really slower than ilike ?
  2004-11-16 21:13 UTC  Oleg Bartunov <oleg@sai.msu.su>
` Re: Tsearch2 really slower than ilike ?
  2004-11-17 17:16 UTC  Hervé Piedvache <herve@elma.fr>
` Re: Tsearch2 really slower than ilike ?
  2004-11-17 17:23 UTC  Oleg Bartunov <oleg@sai.msu.su>
` Re: Tsearch2 really slower than ilike ?
  2004-11-18 09:27 UTC  Hervé Piedvache <herve@elma.fr>
` Re: Tsearch2 really slower than ilike ?
  2004-11-18 09:37 UTC  Oleg Bartunov <oleg@sai.msu.su>
` Re: Tsearch2 really slower than ilike ?
  2004-11-18 10:30 UTC  Hervé Piedvache <herve@elma.fr>
` Re: Tsearch2 really slower than ilike ?
  2004-11-18 10:34 UTC  Oleg Bartunov <oleg@sai.msu.su>
` Re: Tsearch2 really slower than ilike ?
  2004-11-18 10:53 UTC  Leeuw van der, Tim <tim.leeuwvander@nl.unisys.com>
  [16+ messages in thread]

postgres eating CPU
  2004-11-17 22:13 UTC  silviapg@tiscali.it <silviapg@tiscali.it>
` Re: postgres eating CPU
  2004-11-17 22:27 UTC  Josh Berkus <josh@agliodbs.com>
` Re: postgres eating CPU
  2004-11-17 22:51 UTC  silviapg@tiscali.it <silviapg@tiscali.it>
` Re: postgres eating CPU
  2004-11-17 23:23 UTC  Josh Berkus <josh@agliodbs.com>
` Re: postgres eating CPU
  2004-11-17 23:38 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: postgres eating CPU
  2004-11-18 03:30 UTC  Joshua D. Drake <jd@commandprompt.com>
  [6+ messages in thread]

Re: Analyzer is clueless
  2004-11-17 19:14 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Analyzer is clueless
  2004-11-17 21:02 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: Analyzer is clueless
  2004-11-17 22:32 UTC  Simon Riggs <simon@2ndquadrant.com>
` Re: Analyzer is clueless
  2004-11-18 00:20 UTC  Jim C. Nasby <decibel@decibel.org>
` Re: Analyzer is clueless
  2004-11-18 01:41 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Analyzer is clueless
  2004-11-18 01:57 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Analyzer is clueless
  2004-11-18 02:08 UTC  David Brown <time@bigpond.net.au>
  [7+ messages in thread]

mis-estimation on data-warehouse aggregate creation
  2004-11-16 09:10 UTC  Kris Jurka <books@ejurka.com>
` Re: mis-estimation on data-warehouse aggregate creation
  2004-11-16 10:55 UTC  F. Senault <fred.letter@lacave.net>
` Re: mis-estimation on data-warehouse aggregate creation
  2004-11-16 19:49 UTC  Kris Jurka <books@ejurka.com>
` Re: mis-estimation on data-warehouse aggregate creation
  2004-11-16 21:29 UTC  Simon Riggs <simon@2ndquadrant.com>
` Re: mis-estimation on data-warehouse aggregate creation
  2004-11-17 08:19 UTC  Kris Jurka <books@ejurka.com>
  [5+ messages in thread]

nuderstanding 'explain analyse'
  2004-11-16 21:11 UTC  Alexandre Leclerc <alexandre.leclerc@gmail.com>
` Re: nuderstanding 'explain analyse'
  2004-11-17 06:07 UTC  Josh Berkus <josh@agliodbs.com>
  [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