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