pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
VACUUM ANALYZE downgrades performance
  2004-11-30 13:30 UTC  Dmitry Karasik <dmitry@karasik.eu.org>
` Re: VACUUM ANALYZE downgrades performance
  2004-11-30 15:33 UTC  Mike Rylander <mrylander@gmail.com>
` Re: VACUUM ANALYZE downgrades performance
  2004-11-30 15:42 UTC  Thomas Swan <tswan@idigx.com>
` Re: VACUUM ANALYZE downgrades performance
  2004-12-02 16:07 UTC  Dmitry Karasik <dmitry@karasik.eu.org>
` Re: VACUUM ANALYZE downgrades performance
  2004-12-02 16:25 UTC  Rod Taylor <pg@rbt.ca>
` Re: VACUUM ANALYZE downgrades performance
  2004-12-02 16:30 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: VACUUM ANALYZE downgrades performance
  2004-12-02 16:38 UTC  Shridhar Daithankar <ghodechhap@ghodechhap.net>
` Re: VACUUM ANALYZE downgrades performance
  2004-12-03 10:42 UTC  Dmitry Karasik <dmitry@karasik.eu.org>
  [8+ messages in thread]

Poor Performance on a table
  2004-12-02 19:11 UTC  Pallav Kalva <pkalva@deg.cc>
` Re: Poor Performance on a table
  2004-12-02 19:20 UTC  Frank Wiles <frank@wiles.org>
` Re: Poor Performance on a table
  2004-12-02 19:32 UTC  Pallav Kalva <pkalva@deg.cc>
` Re: Poor Performance on a table
  2004-12-02 19:36 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Poor Performance on a table
  2004-12-02 19:38 UTC  Frank Wiles <frank@wiles.org>
` Re: Poor Performance on a table
  2004-12-02 19:54 UTC  Pallav Kalva <pkalva@deg.cc>
` Re: Poor Performance on a table
  2004-12-02 20:10 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Poor Performance on a table
  2004-12-03 05:57 UTC  Josh Berkus <josh@agliodbs.com>
  [8+ messages in thread]

pg replication tools?
  2004-12-02 14:38 UTC  sarlav kumar <sarlavk@yahoo.com>
` Re: pg replication tools?
  2004-12-02 16:50 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: pg replication tools?
  2004-12-02 16:58 UTC  Darcy Buskermolen <darcy@wavefire.com>
` Re: pg replication tools?
  2004-12-03 02:39 UTC  Christopher Browne <cbbrowne@acm.org>
` Re: pg replication tools?
  2004-12-03 05:16 UTC  Vishal Kashyap @ [SaiHertz] <vishalonlist@gmail.com>
  [5+ messages in thread]

Normalization or Performance
  2004-12-02 17:05 UTC  Alvaro Nunes Melo <al_nunes@atua.com.br>
` Re: Normalization or Performance
  2004-12-02 18:34 UTC  Richard Huxton <dev@archonet.com>
` Re: Normalization or Performance
  2004-12-02 23:03 UTC  Jim C. Nasby <decibel@decibel.org>
` Re: Normalization or Performance
  2004-12-03 01:44 UTC  Iain <iain@mst.co.jp>
  [4+ messages in thread]

scalability issues on win32
  2004-11-22 22:07 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: scalability issues on win32
  2004-11-22 23:15 UTC  Pierre-Frédéric Caillaud <lists@boutiquenumerique.com>
` Re: scalability issues on win32
  2004-11-23 02:26 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
` Re: scalability issues on win32
  2004-11-23 10:19 UTC  Reini Urban <rurban@x-ray.at>
` Re: scalability issues on win32
  2004-11-23 10:35 UTC  Dave Page <dpage@vale-housing.co.uk>
` Re: scalability issues on win32
  2004-11-23 13:05 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: scalability issues on win32
  2004-11-23 15:06 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
` Re: scalability issues on win32
  2004-11-23 16:25 UTC  Magnus Hagander <mha@sollentuna.net>
` Re: [pgsql-hackers-win32] scalability issues on win32
  2004-11-23 17:06 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: scalability issues on win32
  2004-11-23 20:12 UTC  Dave Page <dpage@vale-housing.co.uk>
` Re: scalability issues on win32
  2004-11-24 04:38 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
` Re: [PERFORM] scalability issues on win32
  2004-12-02 19:21 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: [PERFORM] scalability issues on win32
  2004-12-02 19:28 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
` Re: [PERFORM] scalability issues on win32
  2004-12-02 19:42 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [14+ messages in thread]

Different location or different instance
  2004-12-02 17:16 UTC  Gabriele Bartolini <angusgb@tin.it>

Recommended Specs
  2004-12-02 00:20 UTC  Hasnul Fadhly bin Hasan <hasnulfadhly.h@mimos.my>
` Re: Recommended Specs
  2004-12-02 06:15 UTC  Josh Berkus <josh@agliodbs.com>
  [2+ messages in thread]

query with timestamp not using index
  2004-12-01 16:46 UTC  Brian Hirt <bhirt@mobygames.com>
` Re: query with timestamp not using index
  2004-12-01 17:38 UTC  Richard Huxton <dev@archonet.com>
` Re: query with timestamp not using index
  2004-12-01 20:06 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: query with timestamp not using index
  2004-12-01 22:09 UTC  Brian Hirt <bhirt@mobygames.com>
` Re: query with timestamp not using index
  2004-12-01 22:16 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [5+ messages in thread]

Using "LIMIT" is much faster even though, searching with PK.
  2004-12-01 04:10 UTC  장현성 <siche@siche.net>
` Re: Using "LIMIT" is much faster even though, searching with PK.
  2004-12-01 04:26 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Using "LIMIT" is much faster even though, searching
  2004-12-01 04:38 UTC  Hyun-Sung, Jang <siche@siche.net>
` Re: Using "LIMIT" is much faster even though, searching
  2004-12-01 05:03 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Using "LIMIT" is much faster even though, searching
  2004-12-01 06:03 UTC  Hyun-Sung, Jang <siche@siche.net>
` Re: Using "LIMIT" is much faster even though, searching
  2004-12-01 08:23 UTC  Andrew McMillan <andrew@catalyst.net.nz>
` Re: Using "LIMIT" is much faster even though, searching
  2004-12-01 20:25 UTC  Josh Berkus <josh@agliodbs.com>
  [7+ messages in thread]

Query Performance and IOWait
  2004-11-18 13:42 UTC  Andrew Janian <ajanian@scottrade.com>
` Re: Query Performance and IOWait
  2004-11-18 13:56 UTC  Richard_D_Levine@raytheon.com
` Re: Query Performance and IOWait
  2004-11-18 14:01 UTC  Andrew Janian <ajanian@scottrade.com>
` Re: Query Performance and IOWait
  2004-11-18 14:18 UTC  Woody Woodring <george.woodring@iglass.net>
` Re: Query Performance and IOWait
  2004-11-18 15:39 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Query Performance and IOWait
  2004-11-18 15:57 UTC  Andrew Janian <ajanian@scottrade.com>
` Re: Query Performance and IOWait
  2004-11-18 16:44 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: Query Performance and IOWait
  2004-11-18 17:14 UTC  Dave Cramer <pg@fastcrypt.com>
` Re: Query Performance and IOWait
  2004-11-18 18:33 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Query Performance and IOWait
  2004-11-18 19:04 UTC  Woody Woodring <george.woodring@iglass.net>
` Re: Query Performance and IOWait
  2004-11-19 21:13 UTC  Frank Wiles <frank@wiles.org>
` Re: Query Performance and IOWait
  2004-11-19 21:22 UTC  Andrew Janian <ajanian@scottrade.com>
` Re: Query Performance and IOWait
  2004-11-22 15:20 UTC  Anjan Dave <adave@vantage.com>
` Re: Query Performance and IOWait
  2004-12-01 13:29 UTC  George Woodring <george.woodring@iglass.net>
  [14+ messages in thread]

"Group By " index usage
  2004-11-24 17:36 UTC  sdfasdfas sdfasdfs <descuarinjado@yahoo.es>
` Re: "Group By " index usage
  2004-11-24 17:55 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: "Group By " index usage
  2004-11-30 16:04 UTC  Alban Medici (NetCentrex) <amedici@fr.netcentrex.net>
  [3+ messages in thread]

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]


[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