pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedImproving SQL performance
2007-01-11 18:17 UTC Carlos H. Reimer <carlos.reimer@opendb.com.br>
` Re: Improving SQL performance
2007-01-11 18:28 UTC Russell Smith <mr-russ@pws.com.au>
` Re: Improving SQL performance
2007-01-11 18:31 UTC Tom Lane <tgl@sss.pgh.pa.us>
[3+ messages in thread]
Does it matters the column order in indexes and constraints creation?
2007-01-11 10:56 UTC Arnau <arnaulist@andromeiberica.com>
` Re: Does it matters the column order in indexes and constraints
2007-01-11 11:27 UTC Richard Huxton <dev@archonet.com>
[2+ messages in thread]
High inserts, bulk deletes - autovacuum vs scheduled vacuum
2007-01-09 17:26 UTC Jeremy Haile <jhaile@fastmail.fm>
` Re: High inserts, bulk deletes - autovacuum vs scheduled vacuum
2007-01-09 18:02 UTC Florian Weimer <fweimer@bfk.de>
` Re: High inserts, bulk deletes - autovacuum vs scheduled
2007-01-09 20:14 UTC Jeremy Haile <jhaile@fastmail.fm>
` Re: High inserts, bulk deletes - autovacuum vs scheduled vacuum
2007-01-10 09:33 UTC Florian Weimer <fweimer@bfk.de>
` Re: High inserts, bulk deletes - autovacuum vs scheduled vacuum
2007-01-10 20:35 UTC Jim C. Nasby <jim@nasby.net>
` Re: High inserts, bulk deletes - autovacuum vs scheduled vacuum
2007-01-10 21:21 UTC Jim C. Nasby <jim@nasby.net>
` Re: High inserts, bulk deletes - autovacuum vs scheduled
2007-01-10 21:48 UTC Jeremy Haile <jhaile@fastmail.fm>
` Re: High inserts, bulk deletes - autovacuum vs scheduled vacuum
2007-01-11 01:27 UTC Jim C. Nasby <jim@nasby.net>
` Re: High inserts, bulk deletes - autovacuum vs scheduled vacuum
2007-01-11 03:10 UTC Alvaro Herrera <alvherre@commandprompt.com>
` Re: High inserts, bulk deletes - autovacuum vs scheduled vacuum
2007-01-11 03:42 UTC Jim C. Nasby <jim@nasby.net>
[10+ messages in thread]
Performance of PostgreSQL on Windows vs Linux
2007-01-03 17:24 UTC Jeremy Haile <jhaile@fastmail.fm>
` Re: Performance of PostgreSQL on Windows vs Linux
2007-01-03 23:18 UTC Magnus Hagander <magnus@hagander.net>
` Re: Performance of PostgreSQL on Windows vs Linux
2007-01-03 23:46 UTC Dimitri Fontaine <dim@dalibo.com>
` Re: Performance of PostgreSQL on Windows vs Linux
2007-01-04 14:27 UTC Jeremy Haile <jhaile@fastmail.fm>
` Re: Performance of PostgreSQL on Windows vs Linux
2007-01-04 14:46 UTC Jeremy Haile <jhaile@fastmail.fm>
` Re: Performance of PostgreSQL on Windows vs Linux
2007-01-04 15:23 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Performance of PostgreSQL on Windows vs Linux
2007-01-04 15:29 UTC Jeremy Haile <jhaile@fastmail.fm>
` Re: Performance of PostgreSQL on Windows vs Linux
2007-01-10 20:15 UTC Jim C. Nasby <jim@nasby.net>
` Re: Performance of PostgreSQL on Windows vs Linux
2007-01-10 20:32 UTC Jeremy Haile <jhaile@fastmail.fm>
` Re: Performance of PostgreSQL on Windows vs Linux
2007-01-10 20:45 UTC Scott Marlowe <smarlowe@g2switchworks.com>
[10+ messages in thread]
PostgreSQL to host e-mail?
2007-01-04 18:00 UTC Charles A. Landemaine <landemaine@gmail.com>
` PostgreSQL to host e-mail?
2007-01-04 18:04 UTC Charles A. Landemaine <landemaine@gmail.com>
` Re: PostgreSQL to host e-mail?
2007-01-04 18:08 UTC Frank Wiles <frank@wiles.org>
` Re: PostgreSQL to host e-mail?
2007-01-04 18:11 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: PostgreSQL to host e-mail?
2007-01-04 18:42 UTC Matthew Schumacher <matt.s@aptalaska.net>
` Re: PostgreSQL to host e-mail?
2007-01-05 03:10 UTC Grega Bremec <gregab@p0f.net>
` Re: PostgreSQL to host e-mail?
2007-01-05 18:15 UTC Reid Thompson <Reid.Thompson@ateb.com>
` Re: PostgreSQL to host e-mail?
2007-01-10 20:18 UTC Jim C. Nasby <jim@nasby.net>
[8+ messages in thread]
More 8.2 client issues (Was: [Slow dump?)
2007-01-02 21:59 UTC Erik Jones <erik@myemma.com>
` Re: More 8.2 client issues (Was: [Slow dump?)
2007-01-02 22:06 UTC Richard Huxton <dev@archonet.com>
` Re: More 8.2 client issues (Was: [Slow dump?)
2007-01-02 22:16 UTC Erik Jones <erik@myemma.com>
` Re: More 8.2 client issues (Was: [Slow dump?)
2007-01-02 23:09 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: More 8.2 client issues (Was: [Slow dump?)
2007-01-03 16:13 UTC Erik Jones <erik@myemma.com>
` Re: More 8.2 client issues (Was: [Slow dump?)
2007-01-03 16:24 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: More 8.2 client issues (Was: [Slow dump?)
2007-01-03 16:40 UTC Erik Jones <erik@myemma.com>
` Re: More 8.2 client issues (Was: [Slow dump?)
2007-01-03 16:50 UTC Guillaume Smet <guillaume.smet@gmail.com>
` Re: More 8.2 client issues (Was: [Slow dump?)
2007-01-03 16:56 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: More 8.2 client issues (Was: [Slow dump?)
2007-01-03 17:10 UTC Erik Jones <erik@myemma.com>
` Re: More 8.2 client issues (Was: [Slow dump?)
2007-01-03 17:15 UTC Erik Jones <erik@myemma.com>
` Re: More 8.2 client issues (Was: [Slow dump?)
2007-01-03 17:21 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: More 8.2 client issues (Was: [Slow dump?)
2007-01-03 17:58 UTC Erik Jones <erik@myemma.com>
` Re: More 8.2 client issues (Was: [Slow dump?)
2007-01-03 18:26 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: More 8.2 client issues (Was: [Slow dump?)
2007-01-03 18:59 UTC Erik Jones <erik@myemma.com>
` Re: More 8.2 client issues (Was: [Slow dump?)
2007-01-05 18:02 UTC Erik Jones <erik@myemma.com>
` Re: More 8.2 client issues (Was: [Slow dump?)
2007-01-10 20:07 UTC Jim C. Nasby <jim@nasby.net>
[17+ messages in thread]
performance implications of binary placement
2006-12-26 20:37 UTC Bob Dusek <bob@copienttech.com>
` Re: performance implications of binary placement
2007-01-10 20:01 UTC Jim C. Nasby <jim@nasby.net>
[2+ messages in thread]
Slow inner join, but left join is fast
2007-01-10 16:17 UTC Jeremy Haile <jhaile@fastmail.fm>
` Re: Slow inner join, but left join is fast
2007-01-10 17:15 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Slow inner join, but left join is fast
2007-01-10 18:20 UTC Jeremy Haile <jhaile@fastmail.fm>
` Re: Slow inner join, but left join is fast
2007-01-10 18:38 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Slow inner join, but left join is fast
2007-01-10 18:38 UTC Jeremy Haile <jhaile@fastmail.fm>
` Re: Slow inner join, but left join is fast
2007-01-10 18:44 UTC Jeremy Haile <jhaile@fastmail.fm>
` Re: Slow inner join, but left join is fast
2007-01-10 19:22 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Slow inner join, but left join is fast
2007-01-10 19:26 UTC Jeremy Haile <jhaile@fastmail.fm>
[8+ messages in thread]
group by will not use an index?
2007-01-09 23:05 UTC tsuraan <tsuraan@gmail.com>
` Re: group by will not use an index?
2007-01-09 23:32 UTC Adam Rich <adam.r@sbcglobal.net>
` Re: group by will not use an index?
2007-01-09 23:42 UTC Scott Marlowe <smarlowe@g2switchworks.com>
` Re: group by will not use an index?
2007-01-10 01:07 UTC Brian Herlihy <btherl@yahoo.com.au>
` Re: group by will not use an index?
2007-01-10 01:11 UTC Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: group by will not use an index?
2007-01-10 01:41 UTC Andrew Lazarus <andrew@pillette.com>
` Re: group by will not use an index?
2007-01-10 17:14 UTC tsuraan <tsuraan@gmail.com>
[7+ messages in thread]
Horribly slow query/ sequential scan
2007-01-09 11:55 UTC Gregory S. Williamson <gsw@globexplorer.com>
` Re: Horribly slow query/ sequential scan
2007-01-09 12:35 UTC db@zigo.dhs.org
` Re: Horribly slow query/ sequential scan
2007-01-09 12:50 UTC Nörder-Tuitje, Marcus <noerder-tuitje@technology.de>
` Re: Horribly slow query/ sequential scan
2007-01-09 12:56 UTC Gregory S. Williamson <gsw@globexplorer.com>
` Re: Horribly slow query/ sequential scan
2007-01-09 12:59 UTC Gregory S. Williamson <gsw@globexplorer.com>
` Re: Horribly slow query/ sequential scan
2007-01-09 14:16 UTC Dave Cramer <pg@fastcrypt.com>
` Re: Horribly slow query/ sequential scan
2007-01-09 15:13 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Horribly slow query/ sequential scan
2007-01-09 15:36 UTC Plugge, Joe R. <JRPlugge@west.com>
` Re: Horribly slow query/ sequential scan
2007-01-09 23:40 UTC Gregory S. Williamson <gsw@globexplorer.com>
` Re: Horribly slow query/ sequential scan
2007-01-10 05:55 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Horribly slow query/ sequential scan
2007-01-10 14:53 UTC Tom Lane <tgl@sss.pgh.pa.us>
[11+ messages in thread]
Postgresql Configutation and overflow
2006-12-29 01:32 UTC Fabricio Peñuelas <fabrixio1@hotmail.com>
` Postgresql Configutation and overflow
2006-12-29 01:58 UTC fabrix peñuelas <fabrixio1@gmail.com>
` Re: Postgresql Configutation and overflow
2006-12-29 02:12 UTC Adam Rich <adam.r@sbcglobal.net>
` Re: Postgresql Configutation and overflow
2006-12-29 03:35 UTC Dave Cramer <pg@fastcrypt.com>
` Re: Postgresql Configutation and overflow
2007-01-09 16:44 UTC Jim C. Nasby <jim@nasby.net>
[5+ messages in thread]
Running PG on cluster files systems
2007-01-09 14:15 UTC Hannes Dorbath <light@theendofthetunnel.de>
` Re: Running PG on cluster files systems
2007-01-09 14:16 UTC Devrim GUNDUZ <devrim@CommandPrompt.com>
[2+ messages in thread]
Worse perfomance on 8.2.0 than on 7.4.14
2006-12-31 11:33 UTC Rolf Østvik <rolfostvik@yahoo.no>
` Re: Worse perfomance on 8.2.0 than on 7.4.14
2006-12-31 12:16 UTC Claus Guttesen <kometen@gmail.com>
` Re: Worse perfomance on 8.2.0 than on 7.4.14
2006-12-31 12:54 UTC Rolf Østvik <rolfostvik@yahoo.no>
` Re: Worse perfomance on 8.2.0 than on 7.4.14
2006-12-31 15:27 UTC Dennis Bjorklund <db@zigo.dhs.org>
` Re: Worse perfomance on 8.2.0 than on 7.4.14
2006-12-31 16:26 UTC Dave Cramer <pg@fastcrypt.com>
` Re: Worse perfomance on 8.2.0 than on 7.4.14
2006-12-31 17:11 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Worse perfomance on 8.2.0 than on 7.4.14
2007-01-01 15:04 UTC Rolf Østvik <rolfostvik@yahoo.no>
` Re: Worse perfomance on 8.2.0 than on 7.4.14
2007-01-01 15:14 UTC Rolf Østvik <rolfostvik@yahoo.no>
` Re: Worse perfomance on 8.2.0 than on 7.4.14
2007-01-01 15:19 UTC Rolf Østvik <rolfostvik@yahoo.no>
` Re: Worse perfomance on 8.2.0 than on 7.4.14
2007-01-01 23:30 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Worse perfomance on 8.2.0 than on 7.4.14
2007-01-02 12:45 UTC Rolf Østvik <rolfostvik@yahoo.no>
` Re: Worse perfomance on 8.2.0 than on 7.4.14
2007-01-02 15:07 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Worse perfomance on 8.2.0 than on 7.4.14
2007-01-03 08:01 UTC Rolf Østvik <rolfostvik@yahoo.no>
` Re: Worse perfomance on 8.2.0 than on 7.4.14
2007-01-03 15:31 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Worse perfomance on 8.2.0 than on 7.4.14
2007-01-05 18:28 UTC Rolf Østvik <rolfostvik@yahoo.no>
` Re: Worse perfomance on 8.2.0 than on 7.4.14
2007-01-06 10:17 UTC Simon Riggs <simon@2ndquadrant.com>
` Re: Worse perfomance on 8.2.0 than on 7.4.14
2007-01-09 14:15 UTC Rolf Østvik <rolfostvik@yahoo.no>
[17+ messages in thread]
Slow Query on Postgres 8.2
2007-01-04 23:31 UTC Dave Dutcher <dave@tridecap.com>
` Re: Slow Query on Postgres 8.2
2007-01-05 01:12 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Slow Query on Postgres 8.2
2007-01-05 01:19 UTC Adam Rich <adam.r@sbcglobal.net>
` Re: Slow Query on Postgres 8.2
2007-01-05 01:51 UTC Dave Dutcher <dave@tridecap.com>
` Re: Slow Query on Postgres 8.2
2007-01-05 02:01 UTC Dave Dutcher <dave@tridecap.com>
` Re: Slow Query on Postgres 8.2
2007-01-05 03:04 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Slow Query on Postgres 8.2
2007-01-08 18:59 UTC Dave Dutcher <dave@tridecap.com>
[7+ messages in thread]
tweaking under repeatable load
2007-01-07 19:03 UTC Ben <bench@silentmedia.com>
` Re: tweaking under repeatable load
2007-01-08 09:18 UTC Dimitri Fontaine <dim@dalibo.com>
[2+ messages in thread]
Missing the point of autovacuum
2007-01-06 18:59 UTC Daryl Herzmann <akrherz@iastate.edu>
` Re: Missing the point of autovacuum
2007-01-06 19:33 UTC Tobias Brox <tobias@nordicbet.com>
` Re: Missing the point of autovacuum
2007-01-06 19:46 UTC Tom Lane <tgl@sss.pgh.pa.us>
[3+ messages in thread]
Trivial function query optimized badly
2007-01-04 03:11 UTC Craig A. James <cjames@modgraph-usa.com>
` Re: Trivial function query optimized badly
2007-01-04 04:17 UTC Adam Rich <adam.r@sbcglobal.net>
` Re: Trivial function query optimized badly
2007-01-04 05:42 UTC Craig A. James <cjames@modgraph-usa.com>
` Re: Trivial function query optimized badly
2007-01-04 05:46 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Trivial function query optimized badly
2007-01-04 06:57 UTC Craig A. James <cjames@modgraph-usa.com>
[5+ messages in thread]
Config parameters
2007-01-02 16:22 UTC Jeremy Haile <jhaile@fastmail.fm>
` Re: Config parameters
2007-01-02 16:34 UTC Richard Huxton <dev@archonet.com>
` Re: Config parameters
2007-01-02 17:06 UTC Jeremy Haile <jhaile@fastmail.fm>
` Re: Config parameters
2007-01-02 18:49 UTC Richard Huxton <dev@archonet.com>
` Re: Config parameters
2007-01-02 19:19 UTC Jeremy Haile <jhaile@fastmail.fm>
` Re: Config parameters
2007-01-02 19:51 UTC Scott Marlowe <smarlowe@g2switchworks.com>
` Re: Config parameters
2007-01-02 20:01 UTC Jeremy Haile <jhaile@fastmail.fm>
[7+ messages in thread]
Slow dump?
2007-01-02 16:41 UTC Erik Jones <erik@myemma.com>
` Re: Slow dump?
2007-01-02 17:30 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Slow dump?
2007-01-02 17:40 UTC Erik Jones <erik@myemma.com>
[3+ messages in thread]
what work_mem needs a query needs?
2007-01-02 09:55 UTC Arnau <arnaulist@andromeiberica.com>
glibc double-free error
2007-01-02 01:29 UTC Craig A. James <cjames@modgraph-usa.com>
` Re: glibc double-free error
2007-01-02 01:39 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: glibc double-free error
2007-01-02 06:03 UTC Craig A. James <cjames@modgraph-usa.com>
` Re: glibc double-free error
2007-01-02 06:11 UTC Tom Lane <tgl@sss.pgh.pa.us>
[4+ messages in thread]
Backup/Restore too slow
2006-12-22 14:32 UTC Sebastián Baioni <sebastianbaioni@yahoo.com.ar>
` Re: Backup/Restore too slow
2006-12-29 17:28 UTC Rod Taylor <rod.taylor@gmail.com>
` Re: Backup/Restore too slow
2006-12-29 17:44 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Backup/Restore too slow
2006-12-29 18:03 UTC Sebastián Baioni <sebaioni-postgresql@yahoo.com.ar>
` Re: Backup/Restore too slow
2006-12-29 21:25 UTC Russell Smith <mr-russ@pws.com.au>
[5+ messages in thread]
URGENT: Out of disk space pg_xlog
2006-12-22 16:06 UTC Jeremy Haile <jhaile@fastmail.fm>
` Re: URGENT: Out of disk space pg_xlog
2006-12-22 16:52 UTC Jeremy Haile <jhaile@fastmail.fm>
` Re: URGENT: Out of disk space pg_xlog
2006-12-22 16:55 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: URGENT: Out of disk space pg_xlog
2006-12-22 17:02 UTC Simon Riggs <simon@2ndquadrant.com>
` Re: URGENT: Out of disk space pg_xlog
2006-12-22 17:24 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: URGENT: Out of disk space pg_xlog
2006-12-22 17:30 UTC Jeremy Haile <jhaile@fastmail.fm>
` Re: URGENT: Out of disk space pg_xlog
2006-12-22 17:36 UTC Simon Riggs <simon@2ndquadrant.com>
` Re: URGENT: Out of disk space pg_xlog
2006-12-22 17:39 UTC Jeremy Haile <jhaile@fastmail.fm>
` Re: URGENT: Out of disk space pg_xlog
2006-12-22 18:14 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: URGENT: Out of disk space pg_xlog
2006-12-22 18:37 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: URGENT: Out of disk space pg_xlog
2006-12-22 18:46 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: URGENT: Out of disk space pg_xlog
2006-12-22 18:47 UTC ohp@pyrenet.fr
` Re: URGENT: Out of disk space pg_xlog
2006-12-22 20:13 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: URGENT: Out of disk space pg_xlog
2006-12-22 20:25 UTC Alvaro Herrera <alvherre@commandprompt.com>
` Re: URGENT: Out of disk space pg_xlog
2006-12-22 20:29 UTC Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: URGENT: Out of disk space pg_xlog
2006-12-22 22:15 UTC Bruce Momjian <bruce@momjian.us>
` Re: URGENT: Out of disk space pg_xlog
2006-12-23 14:00 UTC ohp@pyrenet.fr
` Re: URGENT: Out of disk space pg_xlog
2006-12-23 17:32 UTC Jeremy Haile <jhaile@fastmail.fm>
` Re: URGENT: Out of disk space pg_xlog
2006-12-23 18:13 UTC Bruce Momjian <bruce@momjian.us>
` Re: URGENT: Out of disk space pg_xlog
2006-12-29 18:18 UTC Simon Riggs <simon@2ndquadrant.com>
[20+ messages in thread]
What you would consider as heavy traffic?
2006-12-23 08:12 UTC oliver@obeattie.com <oliver@obeattie.com>
` Re: What you would consider as heavy traffic?
2006-12-29 17:32 UTC Rod Taylor <rod.taylor@gmail.com>
[2+ messages in thread]
Advice on selecting good values for work_mem?
2006-12-07 16:35 UTC Bill Moran <wmoran@collaborativefusion.com>
` Re: Advice on selecting good values for work_mem?
2006-12-07 17:02 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Advice on selecting good values for work_mem?
2006-12-07 18:16 UTC Stephen Frost <sfrost@snowman.net>
` Re: Advice on selecting good values for work_mem?
2006-12-18 21:18 UTC Bill Moran <wmoran@collaborativefusion.com>
` Re: Advice on selecting good values for work_mem?
2006-12-18 21:43 UTC Bill Moran <wmoran@collaborativefusion.com>
` Re: Advice on selecting good values for work_mem?
2006-12-28 13:19 UTC Simon Riggs <simon@2ndquadrant.com>
[6+ 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