pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
FiberChannel cards for FreeBSD on AMD64
  2007-01-15 17:55 UTC  Andrew Hammond <andrew.george.hammond@gmail.com>

Re: max() versus order/limit (WAS: High update
  2007-01-15 07:42 UTC  Luke Lonergan <LLonergan@greenplum.com>
` Re: max() versus order/limit (WAS: High update
  2007-01-15 10:38 UTC  Alvaro Herrera <alvherre@commandprompt.com>
` Re: max() versus order/limit (WAS: High update
  2007-01-15 15:51 UTC  Joshua D. Drake <jd@commandprompt.com>
  [3+ messages in thread]

Re: max() versus order/limit  (WAS: High update activity, PostgreSQL vs BigDBMS)
  2007-01-15 04:52 UTC  Adam Rich <adam.r@sbcglobal.net>
` Re: max() versus order/limit  (WAS: High update activity, PostgreSQL vs BigDBMS)
  2007-01-15 10:35 UTC  Alvaro Herrera <alvherre@commandprompt.com>
  [2+ messages in thread]

Problem with grouping, uses Sort and GroupAggregate, HashAggregate is better(?)
  2007-01-14 12:43 UTC  Rolf Østvik (HA/EXA) <rolf.ostvik@ericsson.com>
` Re: Problem with grouping, uses Sort and GroupAggregate, HashAggregate is better(?)
  2007-01-14 15:34 UTC  Rolf Østvik (HA/EXA) <rolf.ostvik@ericsson.com>
` Re: Problem with grouping, uses Sort and GroupAggregate, HashAggregate is better(?)
  2007-01-14 16:12 UTC  Dave Dutcher <dave@tridecap.com>
` Re: Problem with grouping, uses Sort and GroupAggregate, HashAggregate is better(?)
  2007-01-14 16:52 UTC  Dave Cramer <pg@fastcrypt.com>
` Re: Problem with grouping, uses Sort and GroupAggregate, HashAggregate is better(?)
  2007-01-15 08:58 UTC  Rolf Østvik (HA/EXA) <rolf.ostvik@ericsson.com>
  [5+ messages in thread]

Large table performance
  2007-01-13 00:31 UTC  Mark Dobbrow <mdobbrow@yahoo.com>
` Re: Large table performance
  2007-01-13 00:40 UTC  Dave Cramer <pg@fastcrypt.com>
` Re: Large table performance
  2007-01-13 01:33 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Large table performance
  2007-01-13 15:55 UTC  Daniel Cristian Cruz <danielcristian@gmail.com>
` Re: Large table performance
  2007-01-14 02:40 UTC  Dave Dutcher <dave@tridecap.com>
` Re: Large table performance
  2007-01-14 11:47 UTC  Shoaib Mir <shoaibmir@gmail.com>
` Re: Large table performance
  2007-01-14 19:02 UTC  Luke Lonergan <llonergan@greenplum.com>
` Re: Large table performance
  2007-01-14 19:20 UTC  Luke Lonergan <llonergan@greenplum.com>
  [8+ messages in thread]

(no subject)
  2007-01-14 12:31 UTC  Rolf Østvik (HA/EXA) <rolf.ostvik@ericsson.com>
` Re:
  2007-01-14 13:46 UTC  Dave Cramer <pg@fastcrypt.com>
  [2+ messages in thread]

Performance of Parser?
  2007-01-13 23:38 UTC  Jignesh Shah <J.K.Shah@Sun.COM>
` Re: Performance of Parser?
  2007-01-14 00:24 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Performance of Parser?
  2007-01-14 00:48 UTC  Andrew Dunstan <andrew@dunslane.net>
` Re: Performance of Parser?
  2007-01-14 03:08 UTC  Dave Cramer <pg@fastcrypt.com>
  [4+ messages in thread]

Physical separation of  tables and indexes - where pg_xlog should go?
  2007-01-13 09:21 UTC  Ireneusz Pluta <ipluta@wp.pl>

table partioning performance
  2007-01-07 04:37 UTC  Colin Taylor <colin.taylor@gmail.com>
` Re: table partioning performance
  2007-01-08 15:39 UTC  Luke Lonergan <llonergan@greenplum.com>
` Re: table partioning performance
  2007-01-08 20:02 UTC  Steven Flatt <steven.flatt@gmail.com>
` Re: table partioning performance
  2007-01-09 00:35 UTC  Merlin Moncure <mmoncure@gmail.com>
` Re: table partioning performance
  2007-01-09 12:48 UTC  Simon Riggs <simon@2ndquadrant.com>
` Re: table partioning performance
  2007-01-10 20:24 UTC  Jim C. Nasby <jim@nasby.net>
` Re: table partioning performance
  2007-01-10 21:00 UTC  Steven Flatt <steven.flatt@gmail.com>
` Re: table partioning performance
  2007-01-10 21:39 UTC  Steven Flatt <steven.flatt@gmail.com>
` Re: table partioning performance
  2007-01-11 01:23 UTC  Jim C. Nasby <jim@nasby.net>
` Re: table partioning performance
  2007-01-11 12:15 UTC  Simon Riggs <simon@2ndquadrant.com>
` Re: [HACKERS] table partioning performance
  2007-01-11 21:01 UTC  Jim C. Nasby <jim@nasby.net>
` Re: [HACKERS] table partioning performance
  2007-01-12 19:50 UTC  Simon Riggs <simon@2ndquadrant.com>
  [12+ messages in thread]

RES: Improving SQL performance
  2007-01-11 21:14 UTC  Carlos H. Reimer <carlos.reimer@opendb.com.br>
` Re: RES: Improving SQL performance
  2007-01-11 23:47 UTC  Cesar Suga <sartre@gmail.com>
` RES: Improving SQL performance
  2007-01-12 17:37 UTC  Carlos H. Reimer <carlos.reimer@opendb.com.br>
  [3+ messages in thread]

Planner statistics, correlations
  2007-01-12 08:16 UTC  Tobias Brox <tobias@nordicbet.com>
` Re: Planner statistics, correlations
  2007-01-12 08:56 UTC  Peter Childs <peterachilds@gmail.com>
` Re: Planner statistics, correlations
  2007-01-12 09:05 UTC  Tobias Brox <tobias@nordicbet.com>
` Re: Planner statistics, correlations
  2007-01-12 09:17 UTC  Richard Huxton <dev@archonet.com>
` Re: Planner statistics, correlations
  2007-01-12 09:56 UTC  Tobias Brox <tobias@nordicbet.com>
` Re: Planner statistics, correlations
  2007-01-12 10:41 UTC  Heikki Linnakangas <heikki@enterprisedb.com>
` Re: Planner statistics, correlations
  2007-01-12 10:44 UTC  Tobias Brox <tobias@nordicbet.com>
` Re: Planner statistics, correlations
  2007-01-12 10:55 UTC  Heikki Linnakangas <heikki@enterprisedb.com>
  [8+ messages in thread]

Improving 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]


[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