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