pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedVACUUM 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