pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgreSQL OR performance
2008-11-05 11:12 UTC Віталій Тимчишин <tivv00@gmail.com>
` Re: PostgreSQL OR performance
2008-11-05 15:34 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: PostgreSQL OR performance
2008-11-05 16:31 UTC Jeff Davis <pgsql@j-davis.com>
` Re: PostgreSQL OR performance
2008-11-06 10:46 UTC Віталій Тимчишин <tivv00@gmail.com>
` Re: PostgreSQL OR performance
2008-11-06 12:26 UTC Helio Campos Mello de Andrade <helio.campos@gmail.com>
` Re: PostgreSQL OR performance
2008-11-06 16:33 UTC Віталій Тимчишин <tivv00@gmail.com>
` Re: PostgreSQL OR performance
2008-11-06 16:44 UTC Richard Huxton <dev@archonet.com>
` Re: PostgreSQL OR performance
2008-11-06 16:44 UTC Helio Campos Mello de Andrade <helio.campos@gmail.com>
` Re: PostgreSQL OR performance
2008-11-06 17:37 UTC Віталій Тимчишин <tivv00@gmail.com>
` Re: PostgreSQL OR performance
2008-11-07 09:14 UTC Віталій Тимчишин <tivv00@gmail.com>
` Re: PostgreSQL OR performance
2008-11-07 10:07 UTC David Wilson <david.t.wilson@gmail.com>
` Re: PostgreSQL OR performance
2008-11-07 10:45 UTC Richard Huxton <dev@archonet.com>
` Re: PostgreSQL OR performance
2008-11-15 13:55 UTC Віталій Тимчишин <tivv00@gmail.com>
` Re: PostgreSQL OR performance
2008-11-15 13:57 UTC Віталій Тимчишин <tivv00@gmail.com>
` Re: PostgreSQL OR performance
2008-11-15 17:07 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: PostgreSQL OR performance
2008-11-17 09:52 UTC Віталій Тимчишин <tivv00@gmail.com>
[16+ messages in thread]
Performance Question
2008-11-12 16:27 UTC - - <themanatuf@yahoo.com>
` Re: Performance Question
2008-11-12 16:48 UTC J Sisson <sisson.j@gmail.com>
` Re: Performance Question
2008-11-12 16:56 UTC tv@fuzzy.cz
` Re: Performance Question
2008-11-12 17:16 UTC Fernando Hevia <fhevia@ip-tel.com.ar>
` Re: Performance Question
2008-11-12 20:57 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Performance Question
2008-11-13 02:26 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Performance Question
2008-11-13 08:55 UTC Dave Page <dpage@pgadmin.org>
` Re: Performance Question
2008-11-13 13:05 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Performance Question
2008-11-16 15:20 UTC PFC <lists@peufeu.com>
[9+ messages in thread]
slow full table update
2008-11-10 16:30 UTC firerox@centrum.cz
` Re: slow full table update
2008-11-10 16:41 UTC tv@fuzzy.cz
` Re: slow full table update
2008-11-12 16:25 UTC firerox@centrum.cz
` Re: slow full table update
2008-11-12 16:47 UTC tv@fuzzy.cz
` Re: slow full table update
2008-11-12 17:25 UTC firerox@centrum.cz
` Re: slow full table update
2008-11-12 17:45 UTC Richard Huxton <dev@archonet.com>
` Re: slow full table update
2008-11-12 17:58 UTC Vladimir Sitnikov <sitnikov.vladimir@gmail.com>
` Re: slow full table update
2008-11-12 20:54 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: slow full table update
2008-11-12 20:55 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: slow full table update
2008-11-12 22:47 UTC firerox@centrum.cz
` Re: slow full table update
2008-11-12 22:58 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: slow full table update
2008-11-13 00:13 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: slow full table update
2008-11-13 00:20 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: slow full table update
2008-11-16 14:50 UTC PFC <lists@peufeu.com>
[14+ messages in thread]
Difference in query plan
2008-11-14 16:14 UTC Patrice Beliveau <pbeliveau@avior.ca>
` Re: Difference in query plan
2008-11-14 16:47 UTC Richard Huxton <dev@archonet.com>
` Re: Difference in query plan
2008-11-14 17:07 UTC Patrice Beliveau <pbeliveau@avior.ca>
` Re: Difference in query plan
2008-11-14 17:14 UTC Richard Huxton <dev@archonet.com>
[4+ messages in thread]
crosstab speed
2008-11-13 20:42 UTC Jeremiah Elliott <jeremiah0@gmail.com>
` Re: crosstab speed
2008-11-13 21:41 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: crosstab speed
2008-11-13 22:06 UTC Joe Conway <mail@joeconway.com>
[3+ messages in thread]
Slow SQL query (14-15 seconds)
2008-11-13 11:02 UTC Bruno Baguette <bruno.baguette@gmail.com>
` Re: Slow SQL query (14-15 seconds)
2008-11-13 13:16 UTC Tomasz Myrta <jasiek@klaster.net>
` Re: Slow SQL query (14-15 seconds)
2008-11-13 13:28 UTC Matthew Wakeling <matthew@flymine.org>
` Re: Slow SQL query (14-15 seconds)
2008-11-13 13:31 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Slow SQL query (14-15 seconds)
2008-11-13 14:19 UTC Bruno Baguette <bruno.baguette@gmail.com>
` Re: Slow SQL query (14-15 seconds)
2008-11-13 14:29 UTC Vladimir Sitnikov <sitnikov.vladimir@gmail.com>
` Re: Slow SQL query (14-15 seconds)
2008-11-13 14:30 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Slow SQL query (14-15 seconds)
2008-11-13 14:39 UTC Bruno Baguette <bruno.baguette@gmail.com>
` Re: Slow SQL query (14-15 seconds)
2008-11-13 15:22 UTC Bruno Baguette <bruno.baguette@gmail.com>
[9+ messages in thread]
Using index for IS NULL query
2008-11-11 19:55 UTC Andrus <kobruleht2@hot.ee>
` Re: Using index for IS NULL query
2008-11-11 20:45 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Using index for IS NULL query
2008-11-11 20:47 UTC Andreas Kretschmer <akretschmer@spamfence.net>
` Re: Using index for IS NULL query
2008-11-11 20:50 UTC Andreas Kretschmer <akretschmer@spamfence.net>
` Re: Using index for IS NULL query
2008-11-11 21:01 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: Using index for IS NULL query
2008-11-11 23:00 UTC Vladimir Sitnikov <sitnikov.vladimir@gmail.com>
` Re: Using index for IS NULL query
2008-11-11 23:34 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Using index for IS NULL query
2008-11-12 13:29 UTC Matthew Wakeling <matthew@flymine.org>
` Re: Using index for IS NULL query
2008-11-13 00:27 UTC Tomas Vondra <tv@fuzzy.cz>
[9+ messages in thread]
Disk usage question
2008-11-12 17:02 UTC Franck Routier <franck.routier@axege.com>
` Re: Disk usage question
2008-11-12 23:44 UTC Scott Marlowe <scott.marlowe@gmail.com>
[2+ messages in thread]
Increasing select max(datecol) from bilkaib where datecol<=date'2008-11-01' and (cr='00' or db='00') speed
2008-11-12 17:02 UTC Andrus <kobruleht2@hot.ee>
` Re: Increasing select max(datecol) from bilkaib where datecol<=date'2008-11-01' and (cr='00' or db='00') speed
2008-11-12 17:26 UTC Matthew Wakeling <matthew@flymine.org>
` Re: Increasing select max(datecol) from bilkaib where datecol<=date'2008-11-01' and (cr='00' or db='00') speed
2008-11-12 17:28 UTC Vladimir Sitnikov <sitnikov.vladimir@gmail.com>
` Re: Increasing select max(datecol) from bilkaib where datecol<=date'2008-11-01' and (cr='00' or db='00') speed
2008-11-12 17:33 UTC Matthew Wakeling <matthew@flymine.org>
` Re: Increasing select max(datecol) from bilkaib where datecol<=date'2008-11-01' and (cr='00' or db='00') speed
2008-11-12 18:06 UTC Andrus <kobruleht2@hot.ee>
` Re: Increasing select max(datecol) from bilkaib where datecol<=date'2008-11-01' and (cr='00' or db='00') speed
2008-11-12 19:26 UTC Vladimir Sitnikov <sitnikov.vladimir@gmail.com>
` Re: Increasing select max(datecol) from bilkaib where datecol<=date'2008-11-01' and (cr='00' or db='00') speed
2008-11-12 19:39 UTC hubert depesz lubaczewski <depesz@depesz.com>
` Re: Increasing select max(datecol) from bilkaib where datecol<=date'2008-11-01' and (cr='00' or db='00') speed
2008-11-12 19:44 UTC Andrus <kobruleht2@hot.ee>
` Re: Increasing select max(datecol) from bilkaib wheredatecol<=date'2008-11-01' and (cr='00' or db='00') speed
2008-11-12 19:57 UTC Andrus <kobruleht2@hot.ee>
[9+ messages in thread]
Re: Index usage with sub select or outer joins
2008-11-12 15:09 UTC Julien Theulier <julien@squidsolutions.com>
Index usage with sub select or inner joins
2008-11-12 13:22 UTC Julien Theulier <julien@squidsolutions.com>
` Re: Index usage with sub select or inner joins
2008-11-12 13:54 UTC Joshua Tolley <eggyknap@gmail.com>
[2+ messages in thread]
Re: Oddity with view (now with test case)
2008-11-10 18:36 UTC Jim 'Decibel!' Nasby <jnasby@cashnetusa.com>
` Re: Oddity with view (now with test case)
2008-11-10 19:31 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Oddity with view (now with test case)
2008-11-10 21:06 UTC Jim 'Decibel!' Nasby <jnasby@cashnetusa.com>
` Re: Oddity with view (now with test case)
2008-11-11 03:20 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Oddity with view (now with test case)
2008-11-11 18:08 UTC Jim 'Decibel!' Nasby <jnasby@cashnetusa.com>
` Re: Oddity with view (now with test case)
2008-11-11 19:15 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Oddity with view (now with test case)
2008-11-11 22:42 UTC Jim 'Decibel!' Nasby <jnasby@cashnetusa.com>
` Re: Oddity with view (now with test case)
2008-11-12 02:34 UTC Tom Lane <tgl@sss.pgh.pa.us>
[8+ messages in thread]
Create and drop temp table in 8.3.4
2008-11-05 18:45 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Create and drop temp table in 8.3.4
2008-11-05 19:05 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Create and drop temp table in 8.3.4
2008-11-05 23:16 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Create and drop temp table in 8.3.4
2008-11-06 01:35 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Create and drop temp table in 8.3.4
2008-11-06 19:02 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Create and drop temp table in 8.3.4
2008-11-06 19:17 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: Create and drop temp table in 8.3.4
2008-11-06 19:35 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Create and drop temp table in 8.3.4
2008-11-06 21:05 UTC Scott Carey <scott@richrelevance.com>
` Re: Create and drop temp table in 8.3.4
2008-11-06 21:49 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Create and drop temp table in 8.3.4
2008-11-06 22:05 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Create and drop temp table in 8.3.4
2008-11-06 22:33 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Create and drop temp table in 8.3.4
2008-11-06 22:45 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Create and drop temp table in 8.3.4
2008-11-06 23:04 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Create and drop temp table in 8.3.4
2008-11-07 00:03 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Create and drop temp table in 8.3.4
2008-11-07 02:21 UTC David Rees <drees76@gmail.com>
` Re: Create and drop temp table in 8.3.4
2008-11-11 14:52 UTC Matthew Wakeling <matthew@flymine.org>
` Re: Create and drop temp table in 8.3.4
2008-11-11 15:07 UTC Aidan Van Dyk <aidan@highrise.ca>
[17+ messages in thread]
Oddity with view
2008-11-10 08:27 UTC Jim 'Decibel!' Nasby <jnasby@cashnetusa.com>
` Re: Oddity with view
2008-11-10 13:06 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Oddity with view
2008-11-10 18:16 UTC Jim 'Decibel!' Nasby <jnasby@cashnetusa.com>
` Re: Oddity with view
2008-11-10 18:21 UTC Richard Huxton <dev@archonet.com>
` Re: Oddity with view
2008-11-10 18:31 UTC Tom Lane <tgl@sss.pgh.pa.us>
[5+ messages in thread]
Simple indexed IN query takes 40 seconds
2008-11-10 16:25 UTC Andrus <kobruleht2@hot.ee>
` Re: Simple indexed IN query takes 40 seconds
2008-11-10 16:29 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Simple indexed IN query takes 40 seconds
2008-11-10 17:12 UTC tv@fuzzy.cz
` Re: Simple indexed IN query takes 40 seconds
2008-11-10 18:23 UTC Andrus <kobruleht2@hot.ee>
[4+ messages in thread]
paging on windows
2008-11-10 17:14 UTC Anshul Dutta <Anshul.Dutta@macro4.com>
lru_multiplier and backend page write-outs
2008-11-05 12:28 UTC Peter Schuller <peter.schuller@infidyne.com>
` Re: lru_multiplier and backend page write-outs
2008-11-05 20:44 UTC Greg Smith <gsmith@gregsmith.com>
` Re: lru_multiplier and backend page write-outs
2008-11-06 10:19 UTC Peter Schuller <peter.schuller@infidyne.com>
` Re: lru_multiplier and backend page write-outs
2008-11-06 22:10 UTC Greg Smith <gsmith@gregsmith.com>
` Re: lru_multiplier and backend page write-outs
2008-11-06 23:04 UTC Peter Schuller <peter.schuller@infidyne.com>
[5+ messages in thread]
Occasional Slow Commit
2008-10-28 00:23 UTC David Rees <drees76@gmail.com>
` Re: Occasional Slow Commit
2008-10-28 12:45 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Occasional Slow Commit
2008-10-28 12:47 UTC Andrew Sullivan <ajs@crankycanuck.ca>
` Re: Occasional Slow Commit
2008-10-29 13:26 UTC Greg Smith <gsmith@gregsmith.com>
` Re: Occasional Slow Commit
2008-10-29 22:30 UTC David Rees <drees76@gmail.com>
` Re: Occasional Slow Commit
2008-11-01 00:14 UTC David Rees <drees76@gmail.com>
` Re: Occasional Slow Commit
2008-11-06 03:25 UTC David Rees <drees76@gmail.com>
` Re: Occasional Slow Commit
2008-11-06 10:21 UTC Peter Schuller <peter.schuller@infidyne.com>
` Re: Occasional Slow Commit
2008-11-06 15:47 UTC David Rees <drees76@gmail.com>
` Re: Occasional Slow Commit
2008-11-06 16:07 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Occasional Slow Commit
2008-11-06 18:46 UTC David Rees <drees76@gmail.com>
[11+ messages in thread]
server space increasing very fast but transaction are very low
2008-11-06 10:45 UTC brahma tiwari <prakashr2n5@yahoo.com>
` Re: server space increasing very fast but transaction are very low
2008-11-06 10:57 UTC Tino Schwarze <postgresql@tisc.de>
` Re: server space increasing very fast but transaction are very low
2008-11-06 11:04 UTC Richard Huxton <dev@archonet.com>
` Re: server space increasing very fast but transaction are very low
2008-11-06 11:57 UTC Guillaume Cottenceau <gc@mnc.ch>
[4+ messages in thread]
Installation Error of postgresql-8.1.5 with perl.
2008-11-04 14:20 UTC praveen <praveen.k@renaissance-it.com>
` Re: Installation Error of postgresql-8.1.5 with perl.
2008-11-04 14:47 UTC praveen <praveen.k@renaissance-it.com>
` Re: Installation Error of postgresql-8.1.5 with perl.
2008-11-04 14:49 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Installation Error of postgresql-8.1.5 with perl.
2008-11-05 07:01 UTC praveen <praveen.k@renaissance-it.com>
` Re: Installation Error of postgresql-8.1.5 with perl.
2008-11-05 15:24 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Installation Error of postgresql-8.1.5 with perl.
2008-11-06 05:22 UTC praveen <praveen.k@renaissance-it.com>
[6+ messages in thread]
Query planner cost estimate less than the sum of its parts?
2008-11-05 20:00 UTC Scott Carey <scott@richrelevance.com>
` Re: Query planner cost estimate less than the sum of its parts?
2008-11-05 21:22 UTC Gregory Stark <stark@enterprisedb.com>
` Re: Query planner cost estimate less than the sum of its parts?
2008-11-05 22:19 UTC Scott Carey <scott@richrelevance.com>
[3+ messages in thread]
epqa; postgres performance optimizer support tool; opensource.
2008-11-04 12:25 UTC sathiya psql <sathiya.psql@gmail.com>
` Re: [GENERAL] epqa; postgres performance optimizer support tool; opensource.
2008-11-04 13:08 UTC Sathish Duraiswamy <sathish@leatherlink.net>
` Re: epqa; postgres performance optimizer support tool; opensource.
2008-11-04 16:11 UTC David Fetter <david@fetter.org>
[3+ messages in thread]
Aggregate weirdness
2008-11-04 10:56 UTC Martin Kjeldsen <martin@martinkjeldsen.dk>
` Re: Aggregate weirdness
2008-11-04 13:39 UTC Tom Lane <tgl@sss.pgh.pa.us>
[2+ messages in thread]
Index bloat, reindex weekly, suggestions etc?
2008-10-17 16:05 UTC Tory M Blue <tmblue@gmail.com>
` Re: Index bloat, reindex weekly, suggestions etc?
2008-10-17 16:30 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Index bloat, reindex weekly, suggestions etc?
2008-10-17 16:47 UTC Tory M Blue <tmblue@gmail.com>
` Re: Index bloat, reindex weekly, suggestions etc?
2008-10-17 17:02 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Index bloat, reindex weekly, suggestions etc?
2008-10-17 17:15 UTC Tory M Blue <tmblue@gmail.com>
` Re: Index bloat, reindex weekly, suggestions etc?
2008-10-17 17:35 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Index bloat, reindex weekly, suggestions etc?
2008-10-17 17:48 UTC Tory M Blue <tmblue@gmail.com>
` Re: Index bloat, reindex weekly, suggestions etc?
2008-10-17 17:53 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Index bloat, reindex weekly, suggestions etc?
2008-10-18 07:00 UTC Віталій Тимчишин <tivv00@gmail.com>
` Re: Index bloat, reindex weekly, suggestions etc?
2008-11-04 01:30 UTC Tory M Blue <tmblue@gmail.com>
[10+ messages in thread]
many tables vs large tables
2008-11-04 00:29 UTC Kevin Neufeld <kneufeld@refractions.net>
[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