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

Slow response of PostgreSQL
  2004-02-17 06:24 UTC  Saleem Burhani Baloch <peseek@khi.wol.net.pk>
` Re: Slow response of PostgreSQL
  2004-02-17 06:59 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: Slow response of PostgreSQL
  2004-02-17 07:42 UTC  Stephan Szabo <sszabo@megazone.bigpanda.com>
` Re: Slow response of PostgreSQL
  2004-02-17 07:45 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Slow response of PostgreSQL
  2004-02-17 10:39 UTC  Saleem Burhani Baloch <peseek@khi.wol.net.pk>
` Re: Slow response of PostgreSQL
  2004-02-17 11:00 UTC  Shridhar Daithankar <shridhar@frodo.hserus.net>
` Re: Slow response of PostgreSQL
  2004-02-17 13:02 UTC  Bill Moran <wmoran@potentialtech.com>
` Re: Slow response of PostgreSQL
  2004-02-17 15:02 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Slow response of PostgreSQL
  2004-02-17 17:15 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Re: Slow response of PostgreSQL
  2004-02-18 01:50 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: Slow response of PostgreSQL
  2004-02-18 01:50 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Re: Slow response of PostgreSQL
  2004-02-18 02:21 UTC  Bill Moran <wmoran@potentialtech.com>
` Re: Slow response of PostgreSQL
  2004-02-18 04:52 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: Slow response of PostgreSQL
  2004-02-19 09:01 UTC  Saleem Burhani Baloch <peseek@khi.wol.net.pk>
` Re: Slow response of PostgreSQL
  2004-02-19 09:26 UTC  Shridhar Daithankar <shridhar@frodo.hserus.net>
` Re: Slow response of PostgreSQL
  2004-02-19 13:52 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: Slow response of PostgreSQL
  2004-02-19 20:46 UTC  Hannu Krosing <hannu@tm.ee>
` Re: Slow response of PostgreSQL
  2004-02-20 14:34 UTC  Neil Conway <neilc@samurai.com>
  [18+ messages in thread]

Forcing filter/join order?
  2004-02-19 00:10 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Forcing filter/join order?
  2004-02-19 00:30 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Forcing filter/join order?
  2004-02-19 00:31 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Forcing filter/join order?
  2004-02-19 00:40 UTC  Peter Darley <pdarley@kinesis-cem.com>
` Re: Forcing filter/join order?
  2004-02-19 00:56 UTC  Stephan Szabo <sszabo@megazone.bigpanda.com>
` Re: Forcing filter/join order?
  2004-02-19 01:18 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Forcing filter/join order?
  2004-02-19 03:14 UTC  Stephan Szabo <sszabo@megazone.bigpanda.com>
` Re: Forcing filter/join order?
  2004-02-19 04:26 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Forcing filter/join order?
  2004-02-19 04:49 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Forcing filter/join order?
  2004-02-19 05:08 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Forcing filter/join order?
  2004-02-19 17:39 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Forcing filter/join order?
  2004-02-19 21:17 UTC  Josh Berkus <josh@agliodbs.com>
  [12+ messages in thread]

Optimizer difference using function index between 7.3 and 7.4
  2004-02-18 15:24 UTC  Jeff Boes <jboes@nexcerpt.com>
` Re: Optimizer difference using function index between 7.3 and 7.4
  2004-02-18 16:55 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Optimizer difference using function index between 7.3 and 7.4
  2004-02-19 20:58 UTC  Simon Riggs <simon@2ndquadrant.com>
  [3+ messages in thread]

Tables on multiple disk drives
  2004-02-17 12:54 UTC  Konstantin Tokar <lists2@tokar.ru>
` Re: Tables on multiple disk drives
  2004-02-17 14:56 UTC  Richard Huxton <dev@archonet.com>
` Re: Tables on multiple disk drives
  2004-02-17 17:18 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Re: Tables on multiple disk drives
  2004-02-17 17:35 UTC  Craig Thomas <craiger@osdl.org>
` Re: Tables on multiple disk drives
  2004-02-17 17:53 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Re: Tables on multiple disk drives
  2004-02-17 18:16 UTC  Craig Thomas <craiger@osdl.org>
` Re: Tables on multiple disk drives
  2004-02-17 18:23 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Re: Tables on multiple disk drives
  2004-02-17 22:31 UTC  Christopher Browne <cbbrowne@acm.org>
` Re: Tables on multiple disk drives
  2004-02-19 04:56 UTC  Josh Berkus <josh@agliodbs.com>
  [9+ messages in thread]

UPDATE with subquery too slow
  2004-02-17 12:38 UTC  Eric Jain <Eric.Jain@isb-sib.ch>
` Re: UPDATE with subquery too slow
  2004-02-17 12:49 UTC  Leeuw van der, Tim <tim.leeuwvander@nl.unisys.com>
` Re: UPDATE with subquery too slow
  2004-02-18 06:52 UTC  Kevin Brown <kevin@sysexperts.com>
` Re: UPDATE with subquery too slow
  2004-02-18 19:11 UTC  Eric Jain <Eric.Jain@isb-sib.ch>
  [4+ messages in thread]

long running query running too long
  2004-02-17 17:06 UTC  Todd Fulton <pongo@jah.net>
` Re: long running query running too long
  2004-02-17 20:05 UTC  PC Drew <drewpc@ibsncentral.com>
` Re: long running query running too long
  2004-02-17 20:41 UTC  Todd Fulton <pongo@jah.net>
` Re: long running query running too long
  2004-02-17 23:17 UTC  PC Drew <drewpc@ibsncentral.com>
` Re: long running query running too long
  2004-02-17 23:55 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [5+ messages in thread]

RAID or manual split?
  2004-02-17 21:53 UTC  Mike Glover <mpg4@duluoz.net>
` Re: RAID or manual split?
  2004-02-17 22:17 UTC  Rod Taylor <rbt@rbt.ca>
` Re: RAID or manual split?
  2004-02-17 22:34 UTC  matt@ymogen.net
  [3+ messages in thread]

Disappointing performance in db migrated from MS SQL Server
  2004-02-12 18:29 UTC  Leon Out <leon-lists@comvision.com>
` Re: Disappointing performance in db migrated from MS SQL Server
  2004-02-12 18:43 UTC  PC Drew <drewpc@ibsncentral.com>
` Re: Disappointing performance in db migrated from MS SQL
  2004-02-12 19:03 UTC  Gavin M. Roy <gmr@ehpg.net>
` Re: Disappointing performance in db migrated from MS SQL Server
  2004-02-12 19:05 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
` Re: Disappointing performance in db migrated from MS SQL
  2004-02-12 19:15 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Re: Disappointing performance in db migrated from MS SQL Server
  2004-02-12 20:26 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Disappointing performance in db migrated from MS SQL Server
  2004-02-12 22:19 UTC  Chris Ruprecht <chris@ruprecht.org>
` Re: Disappointing performance in db migrated from MS SQL Server
  2004-02-13 12:38 UTC  Andrew Sullivan <ajs@crankycanuck.ca>
` Re: Disappointing performance in db migrated from MS SQL Server
  2004-02-13 20:56 UTC  Leon Out <leon-lists@comvision.com>
` Re: Disappointing performance in db migrated from MS SQL
  2004-02-13 22:00 UTC  matt@ymogen.net
` Re: Disappointing performance in db migrated from MS SQL Server
  2004-02-13 22:01 UTC  Vivek Khera <khera@kcilink.com>
` Re: Disappointing performance in db migrated from MS SQL Server
  2004-02-13 22:03 UTC  Vivek Khera <khera@kcilink.com>
` Re: Disappointing performance in db migrated from MS SQL
  2004-02-17 15:17 UTC  scott.marlowe <scott.marlowe@ihs.com>
  [13+ messages in thread]

very large db performance question
  2003-11-26 20:22 UTC  LIANHE SHAO <lshao2@jhmi.edu>
` Re: very large db performance question
  2003-11-26 22:03 UTC  Neil Conway <neilc@samurai.com>
` Re: very large db performance question
  2003-11-26 22:46 UTC  LIANHE SHAO <lshao2@jhmi.edu>
` Re: very large db performance question
  2003-11-27 01:03 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: very large db performance question
  2003-11-27 08:42 UTC  Thierry Missimilly <THIERRY.MISSIMILLY@BULL.NET>
` Re: very large db performance question
  2004-02-17 10:36 UTC  Eric Jain <Eric.Jain@isb-sib.ch>
  [6+ messages in thread]

optimization ideas for frequent, large(ish) updates in frequently accessed DB?
  2004-02-13 00:58 UTC  Marinos J. Yannikos <mjy@geizhals.at>
` Re: optimization ideas for frequent, large(ish) updates in frequently accessed DB?
  2004-02-13 06:28 UTC  Josh Berkus <josh@agliodbs.com>
` Re: optimization ideas for frequent, large(ish) updates in frequently accessed DB?
  2004-02-13 09:26 UTC  Manfred Koizar <mkoi-pg@aon.at>
` Re: optimization ideas for frequent, large(ish) updates in frequently accessed DB?
  2004-02-13 15:21 UTC  Manfred Koizar <mkoi-pg@aon.at>
` Re: optimization ideas for frequent, large(ish) updates in frequently accessed DB?
  2004-02-13 16:47 UTC  Manfred Koizar <mkoi-pg@aon.at>
` Re: optimization ideas for frequent, large(ish) updates
  2004-02-15 02:02 UTC  Marinos J. Yannikos <mjy@geizhals.at>
` Re: optimization ideas for frequent, large(ish) updates
  2004-02-15 04:51 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: optimization ideas for frequent, large(ish) updates
  2004-02-15 17:20 UTC  Jeff Trout <jeff@jefftrout.com>
` Re: optimization ideas for frequent, large(ish) updates
  2004-02-16 02:53 UTC  Marinos J. Yannikos <mjy@geizhals.at>
` Re: optimization ideas for frequent, large(ish) updates
  2004-02-16 03:28 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [10+ messages in thread]

slow GIST index creation
  2004-02-14 03:39 UTC  Rajesh Kumar Mallah <mallah@trade-india.com>


[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