pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Sort performance on large tables
  2005-11-08 07:05 UTC  Charlie Savage <cfis@interserv.com>
` Re: Sort performance on large tables
  2005-11-08 11:14 UTC  Richard Huxton <dev@archonet.com>
` Re: Sort performance on large tables
  2005-11-08 13:19 UTC  Marc Morin <marc@sandvine.com>
` Re: Sort performance on large tables
  2005-11-08 16:21 UTC  Luke Lonergan <LLonergan@greenplum.com>
` Re: Sort performance on large tables
  2005-11-08 17:38 UTC  Stephan Szabo <sszabo@megazone.bigpanda.com>
` Re: Sort performance on large tables
  2005-11-08 19:09 UTC  Luke Lonergan <llonergan@greenplum.com>
` Re: Sort performance on large tables
  2005-11-08 20:48 UTC  Stephan Szabo <sszabo@megazone.bigpanda.com>
` Re: Sort performance on large tables
  2005-11-08 22:06 UTC  Charlie Savage <cfis@interserv.com>
` Re: Sort performance on large tables
  2005-11-08 22:26 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Sort performance on large tables
  2005-11-08 23:47 UTC  Charlie Savage <cfis@interserv.com>
` Re: Sort performance on large tables
  2005-11-09 01:49 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: Sort performance on large tables
  2005-11-09 05:49 UTC  Charlie Savage <cfis@interserv.com>
` Re: Sort performance on large tables
  2005-11-09 09:35 UTC  Simon Riggs <simon@2ndquadrant.com>
` Re: Sort performance on large tables
  2005-11-09 17:13 UTC  Charlie Savage <cfis@interserv.com>
` Re: Sort performance on large tables
  2005-11-09 18:26 UTC  Ron Peacetree <rjpeace@earthlink.net>
` Re: Sort performance on large tables
  2005-11-10 16:23 UTC  Ron Peacetree <rjpeace@earthlink.net>
` Re: Sort performance on large tables
  2005-11-10 16:34 UTC  Alex Turner <armtuk@gmail.com>
  [17+ messages in thread]

Some help on buffers and other performance tricks
  2005-11-09 20:11 UTC  Yves Vindevogel <yves.vindevogel@implements.be>
` Re: Some help on buffers and other performance tricks
  2005-11-09 21:24 UTC  Ron Peacetree <rjpeace@earthlink.net>
` Re: Some help on buffers and other performance tricks
  2005-11-09 23:07 UTC  Alvaro Herrera <alvherre@commandprompt.com>
` Re: Some help on buffers and other performance tricks
  2005-11-09 23:53 UTC  Frank Wiles <frank@wiles.org>
` Re: Some help on buffers and other performance tricks
  2005-11-10 00:43 UTC  Alvaro Herrera <alvherre@alvh.no-ip.org>
` Re: Some help on buffers and other performance tricks
  2005-11-10 00:54 UTC  Frank Wiles <frank@wiles.org>
` Re: Some help on buffers and other performance tricks
  2005-11-10 04:20 UTC  Ron Peacetree <rjpeace@earthlink.net>
` Re: Some help on buffers and other performance tricks
  2005-11-10 15:16 UTC  Scott Marlowe <smarlowe@g2switchworks.com>
` Re: Some help on buffers and other performance tricks
  2005-11-10 15:25 UTC  Frank Wiles <frank@wiles.org>
` Re: Some help on buffers and other performance tricks
  2005-11-10 15:43 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: Some help on buffers and other performance tricks
  2005-11-10 15:51 UTC  Scott Marlowe <smarlowe@g2switchworks.com>
  [11+ messages in thread]

(View and SQL) VS plpgsql
  2005-11-09 20:43 UTC  Eric Lauzon <eric.lauzon@abovesecurity.com>
` Re: (View and SQL) VS plpgsql
  2005-11-10 08:45 UTC  Nörder-Tuitje, Marcus <noerder-tuitje@technology.de>
  [2+ messages in thread]

Improving performance on multicolumn query
  2005-11-09 12:08 UTC  Jan Kesten <jan.kesten@web.de>
` Re: Improving performance on multicolumn query
  2005-11-09 12:44 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Improving performance on multicolumn query
  2005-11-09 12:54 UTC  Richard Huxton <dev@archonet.com>
` Re: Improving performance on multicolumn query
  2005-11-09 13:00 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Improving performance on multicolumn query
  2005-11-09 13:19 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: Improving performance on multicolumn query
  2005-11-09 17:31 UTC  Jan Kesten <jan.kesten@web.de>
  [6+ messages in thread]

(no subject)
  2005-11-09 02:23 UTC  William Lai <wlai2768@gmail.com>

Figuring out which command failed
  2005-11-07 21:30 UTC  Ralph Mason <ralph.mason@telogis.com>
` Re: Figuring out which command failed
  2005-11-08 23:26 UTC  Thomas F. O'Connell <tfo@sitening.com>
  [2+ messages in thread]

8.1 iss
  2005-11-06 09:55 UTC  PostgreSQL <martin@portant.com>
` Re: 8.1 iss
  2005-11-06 16:31 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: 8.1 iss
  2005-11-06 19:24 UTC  Greg Stark <gsstark@mit.edu>
` Re: 8.1 iss
  2005-11-06 20:19 UTC  Luke Lonergan <LLonergan@greenplum.com>
` Re: 8.1 iss
  2005-11-07 05:44 UTC  Dennis Bjorklund <db@zigo.dhs.org>
` Re: 8.1 iss
  2005-11-07 17:22 UTC  PostgreSQL <martin@portant.com>
` Re: 8.1 iss
  2005-11-08 10:34 UTC  Mario Weilguni <mweilguni@sime.com>
  [7+ messages in thread]

Expensive function and the optimizer
  2005-11-08 01:58 UTC  Craig A. James <cjames@modgraph-usa.com>
` Re: Expensive function and the optimizer
  2005-11-08 04:12 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [2+ messages in thread]

Index + mismatching datatypes [WAS: index on custom function; explain]
  2005-11-07 18:07 UTC  Enrico Weigelt <weigelt@metux.de>
` Re: Index + mismatching datatypes [WAS: index on custom
  2005-11-07 20:45 UTC  Neil Conway <neilc@samurai.com>
  [2+ messages in thread]

Used Memory
  2005-10-21 03:40 UTC  Christian Paul B. Cosinas <cpc@cybees.com>
` Re: Used Memory
  2005-10-21 07:23 UTC  Jens-Wolfhard Schicke <ml+pgsql-performance@asco.de>
` Re: Used Memory
  2005-10-21 08:02 UTC  Christian Paul B. Cosinas <cpc@cybees.com>
` Re: Used Memory
  2005-10-21 08:08 UTC  Christian Paul B. Cosinas <cpc@cybees.com>
` Re: Used Memory
  2005-10-21 15:29 UTC  Jon Brisbin <jon.brisbin@npcinternational.com>
` Re: Used Memory
  2005-10-21 15:41 UTC  Alex Turner <armtuk@gmail.com>
` Re: Used Memory
  2005-10-24 01:42 UTC  Christian Paul B. Cosinas <cpc@cybees.com>
` Re: Used Memory
  2005-10-24 01:47 UTC  Christian Paul B. Cosinas <cpc@cybees.com>
` Re: Used Memory
  2005-10-24 03:14 UTC  Mark Kirkwood <markir@paradise.net.nz>
` Re: Used Memory
  2005-10-24 15:50 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Used Memory
  2005-10-24 17:00 UTC  Craig A. James <cjames@modgraph-usa.com>
` Re: Used Memory
  2005-10-24 20:24 UTC  Scott Marlowe <smarlowe@g2switchworks.com>
` Re: Used Memory
  2005-10-24 21:47 UTC  Craig A. James <cjames@modgraph-usa.com>
` Re: Used Memory
  2005-10-25 02:39 UTC  Christian Paul B. Cosinas <cpc@cybees.com>
` Re: Used Memory
  2005-10-25 03:06 UTC  Mark Kirkwood <markir@paradise.net.nz>
` Re: Used Memory
  2005-10-25 03:20 UTC  Christian Paul B. Cosinas <cpc@cybees.com>
` Re: Used Memory
  2005-10-25 04:14 UTC  Mark Kirkwood <markir@paradise.net.nz>
` FW: Used Memory
  2005-10-25 07:28 UTC  Christian Paul B. Cosinas <cpc@cybees.com>
` FW: Used Memory
  2005-11-07 15:34 UTC  Christian Paul B. Cosinas <cpc@cybees.com>
  [19+ messages in thread]

Performance problem with pg8.0
  2005-11-06 18:02 UTC  Jeroen van Iddekinge <iddekingej@lycos.com>
` Re: Performance problem with pg8.0
  2005-11-07 09:46 UTC  Richard Huxton <dev@archonet.com>
  [2+ messages in thread]

insert performance for win32
  2005-09-06 14:12 UTC  Marc Cousin <mcousin@sigma.fr>
` Re: insert performance for win32
  2005-09-06 14:56 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: insert performance for win32
  2005-09-06 15:13 UTC  Marc Cousin <mcousin@sigma.fr>
` Re: insert performance for win32
  2005-09-06 16:16 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: insert performance for win32
  2005-09-06 17:11 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: insert performance for win32
  2005-09-07 12:02 UTC  Marc Cousin <mcousin@sigma.fr>
` Re: insert performance for win32
  2005-09-07 12:04 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: [PERFORM] insert performance for win32
  2005-09-07 13:08 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: [PERFORM] insert performance for win32
  2005-09-07 15:02 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: insert performance for win32
  2005-11-02 13:36 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: insert performance for win32
  2005-11-02 13:54 UTC  Magnus Hagander <mha@sollentuna.net>
` Re: insert performance for win32
  2005-11-02 14:47 UTC  Marc Cousin <mcousin@sigma.fr>
` Re: insert performance for win32
  2005-11-02 15:11 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: insert performance for win32
  2005-11-03 07:11 UTC  Qingqing Zhou <zhouqq@cs.toronto.edu>
` Re: insert performance for win32
  2005-11-03 18:03 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: insert performance for win32
  2005-11-03 18:42 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: insert performance for win32
  2005-11-03 18:47 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: insert performance for win32
  2005-11-03 19:04 UTC  Magnus Hagander <mha@sollentuna.net>
` Re: insert performance for win32
  2005-11-03 20:25 UTC  Qingqing Zhou <zhouqq@cs.toronto.edu>
` Re: insert performance for win32
  2005-11-03 20:30 UTC  Magnus Hagander <mha@sollentuna.net>
` Re: insert performance for win32
  2005-11-03 20:34 UTC  Qingqing Zhou <zhouqq@cs.toronto.edu>
` Re: insert performance for win32
  2005-11-03 20:39 UTC  Magnus Hagander <mha@sollentuna.net>
` Re: insert performance for win32
  2005-11-03 21:04 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: insert performance for win32
  2005-11-03 21:06 UTC  Qingqing Zhou <zhouqq@cs.toronto.edu>
` Re: insert performance for win32
  2005-11-03 21:15 UTC  Magnus Hagander <mha@sollentuna.net>
` Re: insert performance for win32
  2005-11-03 21:46 UTC  Qingqing Zhou <zhouqq@cs.toronto.edu>
` Re: insert performance for win32
  2005-11-03 23:30 UTC  Qingqing Zhou <zhouqq@cs.toronto.edu>
` Re: insert performance for win32
  2005-11-03 23:56 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: insert performance for win32
  2005-11-04 07:29 UTC  Qingqing Zhou <zhouqq@cs.toronto.edu>
` Re: insert performance for win32
  2005-11-04 13:49 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: insert performance for win32
  2005-11-04 14:08 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: insert performance for win32
  2005-11-04 14:59 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: insert performance for win32
  2005-11-04 15:12 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: insert performance for win32
  2005-11-04 15:21 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: insert performance for win32
  2005-11-04 15:31 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: insert performance for win32
  2005-11-04 15:36 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: insert performance for win32
  2005-11-04 15:41 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: insert performance for win32
  2005-11-04 16:16 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: insert performance for win32
  2005-11-04 16:33 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: insert performance for win32
  2005-11-04 17:56 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: insert performance for win32
  2005-11-04 18:01 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: insert performance for win32
  2005-11-04 18:07 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: [PERFORM] insert performance for win32
  2005-11-04 18:14 UTC  David Fetter <david@fetter.org>
` Re: insert performance for win32
  2005-11-04 18:14 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: insert performance for win32
  2005-11-04 18:15 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
` Re: [HACKERS] insert performance for win32
  2005-11-04 18:19 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: insert performance for win32
  2005-11-04 18:21 UTC  Magnus Hagander <mha@sollentuna.net>
` Re: [HACKERS] insert performance for win32
  2005-11-04 18:21 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
` Re: [HACKERS] insert performance for win32
  2005-11-04 18:30 UTC  Magnus Hagander <mha@sollentuna.net>
` Re: insert performance for win32
  2005-11-04 18:30 UTC  Qingqing Zhou <zhouqq@cs.toronto.edu>
` Re: insert performance for win32
  2005-11-04 22:17 UTC  Qingqing Zhou <zhouqq@cs.toronto.edu>
` Re: [HACKERS] insert performance for win32
  2005-11-06 09:00 UTC  Simon Riggs <simon@2ndquadrant.com>
` Re: [PERFORM] insert performance for win32
  2005-11-06 17:10 UTC  Andrew Dunstan <andrew@dunslane.net>
  [53+ messages in thread]

Searching union views not using indices
  2005-11-04 11:38 UTC  Michal Taborsky <michal.taborsky@mall.cz>
` Re: Searching union views not using indices
  2005-11-04 15:01 UTC  Richard Huxton <dev@archonet.com>
` Re: Searching union views not using indices
  2005-11-04 15:07 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: Searching union views not using indices
  2005-11-04 15:12 UTC  Michael Fuhr <mike@fuhr.org>
` Re: Searching union views not using indices
  2005-11-04 15:31 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Searching union views not using indices
  2005-11-04 15:55 UTC  Michal Taborsky <michal.taborsky@mall.cz>
` Re: Searching union views not using indices
  2005-11-04 17:53 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [7+ messages in thread]

Encoding on 8.0.4
  2005-11-03 22:35 UTC  Don Drake <dondrake@gmail.com>

Sorted union
  2005-11-03 05:13 UTC  Scott Lamb <slamb@slamb.org>
` Re: Sorted union
  2005-11-03 05:27 UTC  Scott Lamb <slamb@slamb.org>
` Re: Sorted union
  2005-11-03 13:53 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: Sorted union
  2005-11-03 15:41 UTC  Scott Lamb <slamb@slamb.org>
` Re: Sorted union
  2005-11-03 16:20 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: Sorted union
  2005-11-03 18:02 UTC  Scott Lamb <slamb@slamb.org>
` Re: Sorted union
  2005-11-03 18:21 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: Sorted union
  2005-11-03 18:32 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Sorted union
  2005-11-03 18:37 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: Sorted union
  2005-11-03 18:49 UTC  Scott Lamb <slamb@slamb.org>
` Re: Sorted union
  2005-11-03 19:11 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
  [11+ messages in thread]

Function with table%ROWTYPE globbing
  2005-11-03 15:14 UTC  Sven Willenberger <sven@dmv.com>
` Re: Function with table%ROWTYPE globbing
  2005-11-03 15:37 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
  [2+ messages in thread]

improvise callbacks in plpgsql
  2005-11-01 19:00 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: improvise callbacks in plpgsql
  2005-11-01 21:29 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: improvise callbacks in plpgsql
  2005-11-01 22:13 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: improvise callbacks in plpgsql
  2005-11-01 23:04 UTC  Jim C. Nasby <jnasby@pervasive.com>
` Re: improvise callbacks in plpgsql
  2005-11-02 13:45 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: improvise callbacks in plpgsql
  2005-11-02 16:47 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: improvise callbacks in plpgsql
  2005-11-02 17:04 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: [PERFORM] improvise callbacks in plpgsql
  2005-11-02 23:44 UTC  Jim C. Nasby <jnasby@pervasive.com>
` Re: [PERFORM] improvise callbacks in plpgsql
  2005-11-03 02:52 UTC  David Fetter <david@fetter.org>
` Re: [PERFORM] improvise callbacks in plpgsql
  2005-11-03 14:01 UTC  Merlin Moncure <mmoncure@gmail.com>
  [10+ messages in thread]

Trigger Rowsets
  2005-11-02 23:34 UTC  Ralph Mason <ralph.mason@telogis.com>
` Re: Trigger Rowsets
  2005-11-02 23:50 UTC  Jim C. Nasby <jnasby@pervasive.com>
  [2+ messages in thread]

Performance difference between sql and pgsql function...
  2005-11-02 15:32 UTC  Cristian Prieto <cristian@clickdiario.com>

pgbench results interpretation?
  2005-11-01 08:03 UTC  Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
` Re: pgbench results interpretation?
  2005-11-01 09:16 UTC  Gavin Sherry <swm@alcove.com.au>
` Re: pgbench results interpretation?
  2005-11-01 10:05 UTC  Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
` Re: pgbench results interpretation?
  2005-11-02 10:16 UTC  Gavin Sherry <swm@alcove.com.au>
` Re: pgbench results interpretation?
  2005-11-02 14:41 UTC  Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
  [5+ messages in thread]

8.1beta3 performance
  2005-10-31 23:16 UTC  PostgreSQL <martin@portant.com>
` Re: 8.1beta3 performance
  2005-11-01 02:00 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: 8.1beta3 performance
  2005-11-01 02:06 UTC  Neil Conway <neilc@samurai.com>
` Re: 8.1beta3 performance
  2005-11-01 14:50 UTC  Jon Brisbin <jon.brisbin@npcinternational.com>
` Re: 8.1beta3 performance
  2005-11-01 15:49 UTC  Dave Page <dpage@vale-housing.co.uk>
` Re: 8.1beta3 performance
  2005-11-01 17:24 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: 8.1beta3 performance
  2005-11-02 09:32 UTC  PostgreSQL <martin@portant.com>
` Re: 8.1beta3 performance
  2005-11-02 14:41 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [8+ messages in thread]

performance of implicit join vs. explicit conditions on inet queries?
  2005-10-24 03:58 UTC  Robert Edmonds <edmonds42@bellsouth.net>
` Re: performance of implicit join vs. explicit conditions on inet queries?
  2005-10-31 09:48 UTC  Qingqing Zhou <zhouqq@cs.toronto.edu>
` Re: performance of implicit join vs. explicit conditions on inet queries?
  2005-10-31 14:24 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: performance of implicit join vs. explicit conditions on inet queries?
  2005-11-02 01:19 UTC  Qingqing Zhou <zhouqq@cs.toronto.edu>
` Re: performance of implicit join vs. explicit conditions on inet queries?
  2005-11-02 04:20 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [5+ messages in thread]

Joining views disables indexes?
  2005-11-01 23:16 UTC  Mitch Pirtle <mitch.pirtle@gmail.com>
` Re: Joining views disables indexes?
  2005-11-01 23:23 UTC  Jim C. Nasby <jnasby@pervasive.com>
` Re: Joining views disables indexes?
  2005-11-01 23:28 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Joining views disables indexes?
  2005-11-01 23:28 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [4+ messages in thread]

solutions for new Postgresql application testing
  2005-11-01 14:14 UTC  Geoffrey <esoteric@3times25.net>
` Re: solutions for new Postgresql application testing
  2005-11-01 19:39 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: solutions for new Postgresql application testing
  2005-11-01 23:12 UTC  Geoffrey <esoteric@3times25.net>
  [3+ messages in thread]

Re: SOLVED: insertion of bytea
  2005-10-31 14:29 UTC  Chris Mair <list@1006.org>


[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