pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedstarted Data Warehousing
2004-03-11 13:54 UTC Pablo Marrero <pablo.marrero@bancaqm.com.uy>
` Re: [PERFORM] started Data Warehousing
2004-03-11 14:55 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: [PERFORM] started Data Warehousing
2004-03-11 15:08 UTC brew@theMode.com
[3+ messages in thread]
Postgresql on SAN
2004-02-19 16:28 UTC Anjan Dave <adave@vantage.com>
` Re: Postgresql on SAN
2004-02-19 17:36 UTC Josh Berkus <josh@agliodbs.com>
` Re: Postgresql on SAN
2004-02-19 18:06 UTC Nick Barr <nicky@chuckie.co.uk>
` Re: Postgresql on SAN
2004-03-11 00:43 UTC Joseph Shraibman <jks@selectacast.net>
[4+ messages in thread]
Cluster and vacuum performance
2004-03-09 20:17 UTC Shea,Dan [CIS] <Dan.Shea@ec.gc.ca>
` Re: Cluster and vacuum performance
2004-03-09 22:20 UTC Josh Berkus <josh@agliodbs.com>
` Re: Cluster and vacuum performance
2004-03-09 22:57 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Cluster and vacuum performance
2004-03-09 23:30 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Cluster and vacuum performance
2004-03-10 17:35 UTC Josh Berkus <josh@agliodbs.com>
[5+ messages in thread]
Cluster failure due to space
2004-03-10 13:56 UTC Shea,Dan [CIS] <Dan.Shea@ec.gc.ca>
` Re: Cluster failure due to space
2004-03-10 15:24 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Cluster failure due to space
2004-03-10 15:38 UTC Shea,Dan [CIS] <Dan.Shea@ec.gc.ca>
[3+ messages in thread]
WAL Optimisation - configuration and usage
2004-02-28 18:40 UTC Rob Fielding <rob@dsvr.net>
` Re: WAL Optimisation - configuration and usage
2004-02-28 19:37 UTC Richard Huxton <dev@archonet.com>
` Re: WAL Optimisation - configuration and usage
2004-02-29 00:52 UTC Rod Taylor <pg@rbt.ca>
` Re: WAL Optimisation - configuration and usage
2004-02-29 13:08 UTC Rob Fielding <rob@dsvr.net>
` Re: WAL Optimisation - configuration and usage
2004-03-01 17:30 UTC Rob Fielding <rob@dsvr.net>
` Re: WAL Optimisation - configuration and usage
2004-03-02 00:27 UTC Simon Riggs <simon@2ndquadrant.com>
` Re: WAL Optimisation - configuration and usage
2004-03-02 01:01 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: WAL Optimisation - configuration and usage
2004-03-02 01:10 UTC Josh Berkus <josh@agliodbs.com>
` Re: WAL Optimisation - configuration and usage
2004-03-02 22:16 UTC Simon Riggs <simon@2ndquadrant.com>
` Re: [PERFORM] WAL Optimisation - configuration and usage
2004-03-02 22:16 UTC Simon Riggs <simon@2ndquadrant.com>
` Re: WAL Optimisation - configuration and usage
2004-03-03 00:01 UTC Neil Conway <neilc@samurai.com>
` Re: WAL Optimisation - configuration and usage
2004-03-03 18:58 UTC Josh Berkus <josh@agliodbs.com>
` Re: [PERFORM] WAL Optimisation - configuration and usage
2004-03-03 21:40 UTC Simon Riggs <simon@2ndquadrant.com>
` Re: WAL Optimisation - configuration and usage
2004-03-03 23:44 UTC Neil Conway <neilc@samurai.com>
` Re: [HACKERS] [PERFORM] WAL Optimisation - configuration and usage
2004-03-03 23:46 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] WAL Optimisation - configuration and usage
2004-03-03 23:50 UTC Neil Conway <neilc@samurai.com>
` Re: [PERFORM] WAL Optimisation - configuration and usage
2004-03-08 23:28 UTC Simon Riggs <simon@2ndquadrant.com>
` Re: [HACKERS] WAL Optimisation - configuration and usage
2004-03-09 20:26 UTC Simon Riggs <simon@2ndquadrant.com>
[18+ messages in thread]
[OT] Respository [was Re: [PERFORM] Feature request: smarter use of conditional indexes]
2004-03-09 07:02 UTC Shridhar Daithankar <shridhar@frodo.hserus.net>
` Re: [OT] Respository [was Re: [PERFORM] Feature request: smarter
2004-03-09 17:46 UTC Bruce Momjian <pgman@candle.pha.pa.us>
` Re: [OT] Respository [was Re: [PERFORM] Feature request:
2004-03-09 18:48 UTC Joe Conway <mail@joeconway.com>
[3+ messages in thread]
speeding up a select with C function?
2004-03-07 11:42 UTC David Teran <david.teran@cluster9.com>
` Re: speeding up a select with C function?
2004-03-07 15:02 UTC Rod Taylor <pg@rbt.ca>
` Re: speeding up a select with C function?
2004-03-08 01:29 UTC Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: speeding up a select with C function?
2004-03-08 06:22 UTC Dennis Bjorklund <db@zigo.dhs.org>
` Re: speeding up a select with C function?
2004-03-09 09:54 UTC David Teran <david.teran@cluster9.com>
` Re: speeding up a select with C function?
2004-03-09 12:02 UTC David Teran <david.teran@cluster9.com>
` Re: speeding up a select with C function?
2004-03-09 14:46 UTC Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: speeding up a select with C function?
2004-03-09 15:37 UTC Tom Lane <tgl@sss.pgh.pa.us>
[8+ messages in thread]
simple query join
2004-03-08 06:57 UTC Chris Smith <chris@interspire.com>
` Re: simple query join
2004-03-08 07:11 UTC Steven Butler <stevenb@kjross.com.au>
` Re: simple query join
2004-03-08 07:47 UTC Dennis Bjorklund <db@zigo.dhs.org>
` Re: simple query join
2004-03-08 21:43 UTC Chris Smith <chris@interspire.com>
[4+ messages in thread]
Feature request: smarter use of conditional indexes
2004-03-03 19:56 UTC John Siracusa <siracusa@mindspring.com>
` Re: Feature request: smarter use of conditional indexes
2004-03-03 23:37 UTC CoL <col@mportal.hu>
` Re: Feature request: smarter use of conditional indexes
2004-03-03 23:53 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Feature request: smarter use of conditional indexes
2004-03-04 01:31 UTC Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: Feature request: smarter use of conditional indexes
2004-03-06 20:51 UTC John Siracusa <siracusa@mindspring.com>
` Re: Feature request: smarter use of conditional indexes
2004-03-06 21:06 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Feature request: smarter use of conditional indexes
2004-03-06 21:55 UTC John Siracusa <siracusa@mindspring.com>
` Re: Feature request: smarter use of conditional indexes
2004-03-07 02:29 UTC John Siracusa <siracusa@mindspring.com>
` Re: Feature request: smarter use of conditional indexes
2004-03-07 02:39 UTC Larry Rosenman <ler@lerctr.org>
` Re: Feature request: smarter use of conditional indexes
2004-03-07 03:46 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Feature request: smarter use of conditional indexes
2004-03-08 17:55 UTC Bruce Momjian <pgman@candle.pha.pa.us>
[11+ messages in thread]
Using bigint needs explicit cast to use the index
2004-03-08 00:26 UTC Steven Butler <stevenb@kjross.com.au>
` Re: Using bigint needs explicit cast to use the index
2004-03-08 00:43 UTC Neil Conway <neilc@samurai.com>
` Re: Using bigint needs explicit cast to use the index
2004-03-08 16:05 UTC Andrew Sullivan <ajs@crankycanuck.ca>
` Re: Using bigint needs explicit cast to use the index
2004-03-08 16:22 UTC Neil Conway <neilc@samurai.com>
` Re: Using bigint needs explicit cast to use the index
2004-03-08 16:33 UTC Bruno Wolff III <bruno@wolff.to>
` Re: Using bigint needs explicit cast to use the index
2004-03-08 16:46 UTC Andrew Sullivan <ajs@crankycanuck.ca>
[6+ messages in thread]
Fixed width rows faster?
2004-03-05 13:35 UTC Jeff <threshar@torgo.978.org>
` Re: Fixed width rows faster?
2004-03-05 14:07 UTC Bill Moran <wmoran@potentialtech.com>
` Re: Fixed width rows faster?
2004-03-05 14:31 UTC Dennis Bjorklund <db@zigo.dhs.org>
` Re: Fixed width rows faster?
2004-03-05 23:28 UTC Josh Berkus <josh@agliodbs.com>
` Re: Fixed width rows faster?
2004-03-05 23:37 UTC Josh Berkus <josh@agliodbs.com>
` Re: Fixed width rows faster?
2004-03-05 23:43 UTC Mike Nolan <nolan@gw.tssi.com>
` Re: Fixed width rows faster?
2004-03-05 23:54 UTC Rod Taylor <pg@rbt.ca>
` Re: Fixed width rows faster?
2004-03-06 04:20 UTC Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: Fixed width rows faster?
2004-03-06 04:32 UTC Mike Nolan <nolan@gw.tssi.com>
` Re: Fixed width rows faster?
2004-03-06 05:42 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Fixed width rows faster?
2004-03-06 05:53 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Fixed width rows faster?
2004-03-06 10:01 UTC Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: Fixed width rows faster?
2004-03-06 13:17 UTC Eric Jain <Eric.Jain@isb-sib.ch>
` Re: Fixed width rows faster?
2004-03-06 16:26 UTC Andrew Sullivan <ajs@crankycanuck.ca>
` Re: Fixed width rows faster?
2004-03-06 20:52 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Fixed width rows faster?
2004-03-07 01:16 UTC Mike Nolan <nolan@gw.tssi.com>
` Re: Fixed width rows faster?
2004-03-07 01:22 UTC Rod Taylor <pg@rbt.ca>
` Re: Fixed width rows faster?
2004-03-07 01:32 UTC Neil Conway <neilc@samurai.com>
` Re: Fixed width rows faster?
2004-03-07 02:26 UTC Mike Nolan <nolan@gw.tssi.com>
` Re: Fixed width rows faster?
2004-03-07 03:01 UTC Rod Taylor <pg@rbt.ca>
` Re: Fixed width rows faster?
2004-03-07 13:42 UTC Dennis Bjorklund <db@zigo.dhs.org>
` Re: Fixed width rows faster?
2004-03-07 14:49 UTC Andrew Sullivan <ajs@crankycanuck.ca>
` Re: Fixed width rows faster?
2004-03-08 09:39 UTC Eric Jain <Eric.Jain@isb-sib.ch>
[23+ messages in thread]
Bulk INSERT performance in 7.4.1
2004-03-03 09:25 UTC Florian Weimer <fw@deneb.enyo.de>
` Re: Bulk INSERT performance in 7.4.1
2004-03-03 14:10 UTC Florian Weimer <fw@deneb.enyo.de>
` Re: Bulk INSERT performance in 7.4.1
2004-03-03 20:28 UTC Vivek Khera <khera@kcilink.com>
` Re: Bulk INSERT performance in 7.4.1
2004-03-03 21:37 UTC Greg Spiegelberg <gspiegelberg@cranel.com>
` Re: Bulk INSERT performance in 7.4.1
2004-03-03 21:39 UTC Vivek Khera <khera@kcilink.com>
` Re: Bulk INSERT performance in 7.4.1
2004-03-04 10:06 UTC Florian Weimer <fw@deneb.enyo.de>
[6+ messages in thread]
FreeBSD config
2004-02-26 18:03 UTC Dror Matalon <dror@zapatec.com>
` Re: FreeBSD config
2004-02-26 18:55 UTC scott.marlowe <scott.marlowe@ihs.com>
` Re: FreeBSD config
2004-02-26 19:16 UTC Dror Matalon <dror@zapatec.com>
` Re: FreeBSD config
2004-02-26 19:36 UTC scott.marlowe <scott.marlowe@ihs.com>
` Re: FreeBSD config
2004-02-26 21:47 UTC Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: FreeBSD config
2004-02-26 21:58 UTC Dror Matalon <dror@zapatec.com>
` Re: FreeBSD config
2004-02-26 22:36 UTC Kevin Barnard <kbarnard@speedfc.com>
` Re: FreeBSD config
2004-02-26 23:02 UTC Dror Matalon <dror@zapatec.com>
` Re: FreeBSD config
2004-02-26 23:06 UTC Christopher Weimann <cweimann@k12hq.com>
` Re: FreeBSD config
2004-02-26 23:10 UTC Christopher Weimann <cweimann@k12hq.com>
` Re: FreeBSD config
2004-02-26 23:42 UTC Dror Matalon <dror@zapatec.com>
` Re: FreeBSD config
2004-02-27 07:16 UTC Shridhar Daithankar <shridhar@frodo.hserus.net>
` Re: FreeBSD config
2004-02-27 15:33 UTC scott.marlowe <scott.marlowe@ihs.com>
` Re: FreeBSD config
2004-02-27 18:27 UTC Dror Matalon <dror@zapatec.com>
` Re: FreeBSD config
2004-02-27 18:33 UTC Vivek Khera <khera@kcilink.com>
` Re: FreeBSD config
2004-02-28 08:38 UTC Shridhar Daithankar <shridhar@frodo.hserus.net>
` Re: FreeBSD config
2004-03-01 07:30 UTC Mark Kirkwood <markir@paradise.net.nz>
` Re: FreeBSD config
2004-03-01 07:39 UTC Dror Matalon <dror@zapatec.com>
` Re: FreeBSD config
2004-03-01 08:19 UTC Mark Kirkwood <markir@paradise.net.nz>
` Re: FreeBSD config
2004-03-02 20:45 UTC Vivek Khera <khera@kcilink.com>
[20+ messages in thread]
Materialized View Summary
2004-02-24 16:11 UTC Jonathan M. Gardner <jgardner@jonathangardner.net>
` Re: [SQL] Materialized View Summary
2004-02-24 17:11 UTC Richard Huxton <dev@archonet.com>
` Re: [HACKERS] [SQL] Materialized View Summary
2004-02-24 17:40 UTC Hans-Jürgen Schönig <postgres@cybertec.at>
` Re: [HACKERS] [SQL] Materialized View Summary
2004-02-24 21:48 UTC Robert Treat <xzilla@users.sourceforge.net>
` Re: [HACKERS] [SQL] Materialized View Summary
2004-02-24 22:19 UTC Jonathan Gardner <jonagard@amazon.com>
` Re: [HACKERS] [SQL] Materialized View Summary
2004-02-25 08:19 UTC Jonathan M. Gardner <jgardner@jonathangardner.net>
` Re: [HACKERS] Materialized View Summary
2004-02-25 11:35 UTC Mark Gibson <gibsonm@cromwell.co.uk>
` Re: [HACKERS] [SQL] Materialized View Summary
2004-02-25 15:46 UTC Robert Treat <xzilla@users.sourceforge.net>
` Re: [PERFORM] Materialized View Summary
2004-03-02 16:40 UTC Bruce Momjian <pgman@candle.pha.pa.us>
` Re: [PERFORM] Materialized View Summary
2004-03-02 16:54 UTC Robert Treat <xzilla@users.sourceforge.net>
[10+ messages in thread]
Select-Insert-Query
2004-02-27 16:52 UTC postgres@countup.de
` Re: Select-Insert-Query
2004-02-27 19:47 UTC Richard Huxton <dev@archonet.com>
` Re: Select-Insert-Query
2004-03-02 00:49 UTC postgres@countup.de
` Re: Select-Insert-Query
2004-03-02 11:48 UTC Oliver Elphick <olly@lfix.co.uk>
[4+ messages in thread]
A cache for the results of queries ?
2004-02-26 13:30 UTC David Pradier <dpradier@apartia.fr>
` Re: A cache for the results of queries ?
2004-02-26 14:26 UTC Richard Huxton <dev@archonet.com>
` Re: A cache for the results of queries ?
2004-02-26 17:15 UTC scott.marlowe <scott.marlowe@ihs.com>
` Re: A cache for the results of queries ?
2004-02-27 00:40 UTC William Yu <wyu@talisys.com>
[4+ messages in thread]
Slow join using network address function
2004-02-23 11:48 UTC Eric Jain <Eric.Jain@isb-sib.ch>
` Re: Slow join using network address function
2004-02-23 16:07 UTC Steve Atkins <steve@blighty.com>
` Re: Slow join using network address function
2004-02-23 20:04 UTC Josh Berkus <josh@agliodbs.com>
` Re: Slow join using network address function
2004-02-24 01:23 UTC Markus Bertheau <twanger@bluetwanger.de>
` Re: Slow join using network address function
2004-02-24 12:07 UTC Eric Jain <Eric.Jain@isb-sib.ch>
` Re: Slow join using network address function
2004-02-24 15:23 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Slow join using network address function
2004-02-24 16:44 UTC Nick Barr <nicky@chuckie.co.uk>
` Re: Slow join using network address function
2004-02-24 17:10 UTC Steve Atkins <steve@blighty.com>
` Re: Slow join using network address function
2004-02-24 17:14 UTC Steve Atkins <steve@blighty.com>
` Re: Slow join using network address function
2004-02-25 06:28 UTC Steve Atkins <steve@blighty.com>
[10+ messages in thread]
Speed up a function?CREATE TABLE readings ( "when" TIMESTAMP DEFAULT timeofday()::timestamp NOT NULL PRIMARY KEY, "barometer" FLOAT DEFAULT NULL,
2004-02-25 05:10 UTC Robert Creager <Robert_Creager@LogicalChaos.org>
` Re: Speed up a function?CREATE TABLE readings ( "when" TIMESTAMP DEFAULT timeofday()::timestamp NOT NULL PRIMARY KEY, "barometer" FLOAT DEFAULT NULL,
2004-02-25 06:04 UTC Tom Lane <tgl@sss.pgh.pa.us>
[2+ messages in thread]
Column correlation drifts, index ignored again
2004-02-22 00:18 UTC John Siracusa <siracusa@mindspring.com>
` Re: Column correlation drifts, index ignored again
2004-02-22 19:05 UTC Josh Berkus <josh@agliodbs.com>
` Re: Column correlation drifts, index ignored again
2004-02-22 21:58 UTC John Siracusa <siracusa@mindspring.com>
` Re: Column correlation drifts, index ignored again
2004-02-22 22:06 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Column correlation drifts, index ignored again
2004-02-22 22:34 UTC John Siracusa <siracusa@mindspring.com>
` Re: Column correlation drifts, index ignored again
2004-02-22 23:40 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Column correlation drifts, index ignored again
2004-02-23 00:09 UTC John Siracusa <siracusa@mindspring.com>
` Re: Column correlation drifts, index ignored again
2004-02-23 00:17 UTC Josh Berkus <josh@agliodbs.com>
` Re: Column correlation drifts, index ignored again
2004-02-23 03:38 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Column correlation drifts, index ignored again
2004-02-24 03:56 UTC Kevin Brown <kevin@sysexperts.com>
` Re: Column correlation drifts, index ignored again
2004-02-24 16:59 UTC Josh Berkus <josh@agliodbs.com>
` Re: Column correlation drifts, index ignored again
2004-02-24 18:29 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Column correlation drifts, index ignored again
2004-02-24 20:14 UTC Kevin Brown <kevin@sysexperts.com>
` Re: Column correlation drifts, index ignored again
2004-02-24 20:54 UTC Ed L. <pgsql@bluepolka.net>
` Re: Column correlation drifts, index ignored again
2004-02-24 21:24 UTC Kevin Brown <kevin@sysexperts.com>
` Re: Column correlation drifts, index ignored again
2004-02-24 22:16 UTC Tom Lane <tgl@sss.pgh.pa.us>
[16+ messages in thread]
[PERFORMANCE] slow small delete on large table
2004-02-24 02:10 UTC Ed L. <pgsql@bluepolka.net>
` Re: [PERFORMANCE] slow small delete on large table
2004-02-24 02:34 UTC Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: [PERFORMANCE] slow small delete on large table
2004-02-24 03:00 UTC Bruno Wolff III <bruno@wolff.to>
` Re: [PERFORMANCE] slow small delete on large table
2004-02-24 03:48 UTC Christopher Browne <cbbrowne@acm.org>
` Re: [PERFORMANCE] slow small delete on large table
2004-02-24 05:23 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORMANCE] slow small delete on large table
2004-02-24 18:36 UTC Ed L. <pgsql@bluepolka.net>
` Re: [PERFORMANCE] slow small delete on large table
2004-02-24 19:12 UTC Christopher Browne <cbbrowne@acm.org>
[7+ messages in thread]
tsearch2 trigger alternative
2004-02-24 18:58 UTC Chris Gamache <cgg007@yahoo.com>
JOIN order, 15K, 15K, 7MM rows
2004-02-18 22:51 UTC Andrew Lazarus <drlaz@attglobal.net>
` Re: JOIN order, 15K, 15K, 7MM rows
2004-02-22 19:00 UTC Josh Berkus <josh@agliodbs.com>
` Re: JOIN order, 15K, 15K, 7MM rows
2004-02-23 20:00 UTC andrew@pillette.com
[3+ messages in thread]
conceptual method to create high performance query involving time
2004-02-21 21:12 UTC Don Bowman <don@sandvine.com>
Index called with Union but not with OR clause
2004-02-20 06:56 UTC V Chitra <vchitra@techbooks.com>
` Re: Index called with Union but not with OR clause
2004-02-20 20:11 UTC Bruno Wolff III <bruno@wolff.to>
[2+ messages in thread]
cacheable stored functions?
2004-02-20 15:35 UTC Bill Moran <wmoran@potentialtech.com>
` Re: cacheable stored functions?
2004-02-20 15:47 UTC Stephan Szabo <sszabo@megazone.bigpanda.com>
` Re: cacheable stored functions?
2004-02-20 15:59 UTC Tomasz Myrta <jasiek@klaster.net>
` Re: cacheable stored functions?
2004-02-20 16:01 UTC Richard Huxton <dev@archonet.com>
` Re: cacheable stored functions?
2004-02-20 16:48 UTC Bill Moran <wmoran@potentialtech.com>
[5+ 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