pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedDrop / create indexes and vacuumdb
2005-05-30 22:06 UTC Yves Vindevogel <yves.vindevogel@implements.be>
Postgresql and xeon.
2005-05-30 13:43 UTC Eric Lauzon <eric.lauzon@abovesecurity.com>
` Re: Postgresql and xeon.
2005-05-30 16:19 UTC Josh Berkus <josh@agliodbs.com>
` Re: Postgresql and xeon.
2005-05-30 16:54 UTC Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Postgresql and xeon.
2005-05-30 17:02 UTC Eric Lauzon <eric.lauzon@abovesecurity.com>
` Re: Postgresql and xeon.
2005-05-30 17:15 UTC Tom Lane <tgl@sss.pgh.pa.us>
[5+ messages in thread]
sequential scan performance
2005-05-29 13:27 UTC Michael Engelhart <mengelhart@mac.com>
` Re: sequential scan performance
2005-05-29 13:47 UTC Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: sequential scan performance
2005-05-29 14:43 UTC Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: sequential scan performance
2005-05-29 19:44 UTC Oleg Bartunov <oleg@sai.msu.su>
` Re: sequential scan performance
2005-05-30 16:33 UTC Michael Engelhart <mengelhart@mac.com>
` Re: sequential scan performance
2005-05-30 16:53 UTC Steve Atkins <steve@blighty.com>
[6+ messages in thread]
Index not used on join with inherited tables
2005-05-30 15:54 UTC Sebastian Böck <sebastianboeck@freenet.de>
` Re: Index not used on join with inherited tables
2005-05-30 16:21 UTC Josh Berkus <josh@agliodbs.com>
` Re: Index not used on join with inherited tables
2005-05-30 16:36 UTC Sebastian Böck <sebastianboeck@freenet.de>
[3+ messages in thread]
OID vs overall system performances on high load databases.
2005-05-27 17:05 UTC Eric Lauzon <eric.lauzon@abovesecurity.com>
` Re: OID vs overall system performances on high load
2005-05-28 05:08 UTC Andrew McMillan <andrew@catalyst.net.nz>
` Re: OID vs overall system performances on high load
2005-05-28 17:36 UTC PFC <lists@boutiquenumerique.com>
` OID vs overall system performances on high load
2005-05-29 20:17 UTC Eric Lauzon <eric.lauzon@abovesecurity.com>
` Re: OID vs overall system performances on high load
2005-05-29 21:46 UTC Andrew McMillan <andrew@catalyst.net.nz>
` Re: OID vs overall system performances on high load
2005-05-29 21:47 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: OID vs overall system performances on high load
2005-05-30 04:02 UTC Neil Conway <neilc@samurai.com>
[7+ messages in thread]
Redundant indexes?
2005-05-27 21:28 UTC Jeffrey Tenny <jeffrey.tenny@comcast.net>
` Re: Redundant indexes?
2005-05-28 00:09 UTC Tom Lane <tgl@sss.pgh.pa.us>
[2+ messages in thread]
Re: [PERFORM] "Hash index" vs. "b-tree index" (PostgreSQL
2005-05-09 15:34 UTC Neil Conway <neilc@samurai.com>
` Re: [PERFORM] "Hash index" vs. "b-tree index" (PostgreSQL
2005-05-09 16:34 UTC Jim C. Nasby <decibel@decibel.org>
` Re: [PERFORM] "Hash index" vs. "b-tree index" (PostgreSQL
2005-05-09 16:38 UTC Neil Conway <neilc@samurai.com>
` Re: [PERFORM] "Hash index" vs. "b-tree index" (PostgreSQL
2005-05-09 16:51 UTC Jim C. Nasby <decibel@decibel.org>
` Re: [PERFORM] "Hash index" vs. "b-tree index" (PostgreSQL
2005-05-10 00:14 UTC Neil Conway <neilc@samurai.com>
` Re: [PERFORM] "Hash index" vs. "b-tree index" (PostgreSQL
2005-05-10 02:20 UTC Bruce Momjian <pgman@candle.pha.pa.us>
` Re: [PERFORM] "Hash index" vs. "b-tree index" (PostgreSQL
2005-05-10 04:10 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] "Hash index" vs. "b-tree index" (PostgreSQL
2005-05-10 04:25 UTC Neil Conway <neilc@samurai.com>
` Re: [PERFORM] "Hash index" vs. "b-tree index" (PostgreSQL
2005-05-10 04:54 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] "Hash index" vs. "b-tree index" (PostgreSQL
2005-05-10 05:29 UTC Neil Conway <neilc@samurai.com>
` Re: [PERFORM] "Hash index" vs. "b-tree index" (PostgreSQL
2005-05-10 06:12 UTC Greg Stark <gsstark@mit.edu>
` Re: [PERFORM] "Hash index" vs. "b-tree index" (PostgreSQL
2005-05-10 13:53 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] "Hash index" vs. "b-tree index" (PostgreSQL
2005-05-10 15:32 UTC Jim C. Nasby <decibel@decibel.org>
` Re: [PERFORM] "Hash index" vs. "b-tree index" (PostgreSQL
2005-05-10 15:39 UTC Jim C. Nasby <decibel@decibel.org>
` Re: [PERFORM] "Hash index" vs. "b-tree index" (PostgreSQL
2005-05-10 15:49 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] "Hash index" vs. "b-tree index" (PostgreSQL
2005-05-10 17:26 UTC Jim C. Nasby <decibel@decibel.org>
` Re: [PERFORM] "Hash index" vs. "b-tree index" (PostgreSQL
2005-05-10 17:35 UTC Greg Stark <gsstark@mit.edu>
` Re: [PERFORM] "Hash index" vs. "b-tree index" (PostgreSQL
2005-05-10 18:07 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [GENERAL] "Hash index" vs. "b-tree index" (PostgreSQL
2005-05-10 18:12 UTC Mischa Sandberg <mischa.sandberg@telus.net>
` Re: [PERFORM] "Hash index" vs. "b-tree index" (PostgreSQL
2005-05-10 19:50 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] "Hash index" vs. "b-tree index" (PostgreSQL
2005-05-10 21:35 UTC Mischa Sandberg <mischa.sandberg@telus.net>
` Re: [PERFORM] "Hash index" vs. "b-tree index" (PostgreSQL
2005-05-10 22:46 UTC Mark Lewis <mark.lewis@mir3.com>
` Re: [PERFORM] "Hash index" vs. "b-tree index" (PostgreSQL
2005-05-10 22:56 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] "Hash index" vs. "b-tree index" (PostgreSQL
2005-05-10 23:24 UTC Mischa Sandberg <mischa.sandberg@telus.net>
` Re: [PERFORM] "Hash index" vs. "b-tree index" (PostgreSQL
2005-05-10 23:56 UTC Greg Stark <gsstark@mit.edu>
` Re: [PERFORM] "Hash index" vs. "b-tree index" (PostgreSQL
2005-05-11 00:14 UTC Mischa Sandberg <mischa.sandberg@telus.net>
` Re: [PERFORM] "Hash index" vs. "b-tree index" (PostgreSQL
2005-05-11 01:51 UTC Bruce Momjian <pgman@candle.pha.pa.us>
` Re: [PERFORM] "Hash index" vs. "b-tree index" (PostgreSQL
2005-05-11 02:02 UTC Mischa Sandberg <mischa.sandberg@telus.net>
` Re: [PERFORM] "Hash index" vs. "b-tree index" (PostgreSQL
2005-05-11 02:03 UTC Bruce Momjian <pgman@candle.pha.pa.us>
` Re: [PERFORM] "Hash index" vs. "b-tree index" (PostgreSQL
2005-05-11 02:05 UTC Mischa Sandberg <mischa.sandberg@telus.net>
` Re: [PERFORM] "Hash index" vs. "b-tree index" (PostgreSQL
2005-05-11 02:14 UTC Neil Conway <neilc@samurai.com>
` Re: [PERFORM] "Hash index" vs. "b-tree index" (PostgreSQL
2005-05-11 02:17 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] "Hash index" vs. "b-tree index" (PostgreSQL
2005-05-11 13:57 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] "Hash index" vs. "b-tree index" (PostgreSQL
2005-05-11 13:59 UTC Greg Stark <gsstark@mit.edu>
` Re: [PERFORM] "Hash index" vs. "b-tree index" (PostgreSQL
2005-05-11 14:14 UTC Neil Conway <neilc@samurai.com>
` Re: [PERFORM] "Hash index" vs. "b-tree index" (PostgreSQL
2005-05-27 22:07 UTC Bruce Momjian <pgman@candle.pha.pa.us>
[36+ messages in thread]
Optimising queries involving unions
2005-05-26 15:22 UTC Sam Mason <sam@samason.me.uk>
` Re: Optimising queries involving unions
2005-05-26 16:53 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Optimising queries involving unions
2005-05-26 17:42 UTC Sam Mason <sam@samason.me.uk>
` Re: Optimising queries involving unions
2005-05-26 18:02 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Optimising queries involving unions
2005-05-27 07:40 UTC Marc Mamin <m.mamin@gmx.net>
[5+ messages in thread]
Re: [PORTS] Which library has these symbols? -- Eureka
2005-05-25 18:06 UTC Mohan, Ross <RMohan@arbinet.com>
` Re: Which library has these symbols? -- Eureka
2005-05-25 21:30 UTC Christopher Browne <cbbrowne@acm.org>
` Re: [PORTS] Which library has these symbols? -- Eureka
2005-05-26 01:40 UTC Christopher Kings-Lynne <chriskl@familyhealth.com.au>
[3+ messages in thread]
Inner join on two OR conditions dont use index
2005-05-25 20:12 UTC Jocelyn Turcotte <turcotte.j@gmail.com>
` Re: Inner join on two OR conditions dont use index
2005-05-25 20:18 UTC John A Meinel <john@arbash-meinel.com>
` Re: Inner join on two OR conditions dont use index
2005-05-25 21:22 UTC Jocelyn Turcotte <turcotte.j@gmail.com>
` Re: Inner join on two OR conditions dont use index
2005-05-25 21:43 UTC Tom Lane <tgl@sss.pgh.pa.us>
[4+ messages in thread]
test - pls delete and ignore
2005-05-25 20:36 UTC Mohan, Ross <RMohan@arbinet.com>
Can anyone explain this: duplicate dbs.
2005-05-25 02:07 UTC SpaceBallOne <space_ball_one@hotmail.com>
` Re: Can anyone explain this: duplicate dbs.
2005-05-25 02:21 UTC Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: Can anyone explain this: duplicate dbs.
2005-05-25 02:22 UTC Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: Can anyone explain this: duplicate dbs.
2005-05-25 02:39 UTC John A Meinel <john@arbash-meinel.com>
` Re: Can anyone explain this: duplicate dbs.
2005-05-25 02:53 UTC SpaceBallOne <space_ball_one@hotmail.com>
` Re: Can anyone explain this: duplicate dbs.
2005-05-25 03:00 UTC John A Meinel <john@arbash-meinel.com>
` Re: Can anyone explain this: duplicate dbs.
2005-05-25 03:00 UTC Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: Can anyone explain this: duplicate dbs.
2005-05-25 03:01 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Can anyone explain this: duplicate dbs.
2005-05-25 03:02 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Can anyone explain this: duplicate dbs.
2005-05-25 03:32 UTC Bruno Wolff III <bruno@wolff.to>
[10+ messages in thread]
seqential vs random io
2005-05-23 20:58 UTC David Parker <dparker@tazznetworks.com>
` Re: seqential vs random io
2005-05-23 22:23 UTC John A Meinel <john@arbash-meinel.com>
` Re: seqential vs random io
2005-05-23 22:32 UTC Josh Berkus <josh@agliodbs.com>
` Re: seqential vs random io
2005-05-23 22:35 UTC Anjan Dave <adave@vantage.com>
[4+ messages in thread]
Fwd: Index on table when using DESC clause
2005-05-23 17:41 UTC Yves Vindevogel <yves.vindevogel@implements.be>
` Re: Fwd: Index on table when using DESC clause
2005-05-23 18:03 UTC Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Fwd: Index on table when using DESC clause
2005-05-23 19:02 UTC Yves Vindevogel <yves.vindevogel@implements.be>
` Re: Fwd: Index on table when using DESC clause
2005-05-23 19:46 UTC Oleg Bartunov <oleg@sai.msu.su>
` Re: Fwd: Index on table when using DESC clause
2005-05-23 20:27 UTC Andrew Lazarus <andrew@pillette.com>
` Re: Fwd: Index on table when using DESC clause
2005-05-23 21:18 UTC Yves Vindevogel <yves.vindevogel@implements.be>
[6+ messages in thread]
Tuning planner cost estimates
2005-05-18 00:22 UTC Jim C. Nasby <decibel@decibel.org>
` Re: Tuning planner cost estimates
2005-05-19 16:31 UTC Josh Berkus <josh@agliodbs.com>
` Re: Tuning planner cost estimates
2005-05-19 17:16 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Tuning planner cost estimates
2005-05-19 17:21 UTC Josh Berkus <josh@agliodbs.com>
` Re: Tuning planner cost estimates
2005-05-20 20:20 UTC Jim C. Nasby <decibel@decibel.org>
` Re: Tuning planner cost estimates
2005-05-20 20:47 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Tuning planner cost estimates
2005-05-20 22:23 UTC Josh Berkus <josh@agliodbs.com>
` Re: Tuning planner cost estimates
2005-05-20 22:40 UTC Jim C. Nasby <decibel@decibel.org>
` Re: Tuning planner cost estimates
2005-05-20 22:49 UTC Jim C. Nasby <decibel@decibel.org>
` Re: Tuning planner cost estimates
2005-05-20 23:06 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Tuning planner cost estimates
2005-05-23 20:46 UTC Simon Riggs <simon@2ndquadrant.com>
[11+ messages in thread]
Optimizing for writes. Data integrity not critical
2005-05-19 22:21 UTC Steve Bergman <steve@rueb.com>
` Re: Optimizing for writes. Data integrity not critical
2005-05-19 22:27 UTC Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Optimizing for writes. Data integrity not critical
2005-05-19 23:45 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Optimizing for writes. Data integrity not critical
2005-05-20 01:45 UTC Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: Optimizing for writes. Data integrity not critical
2005-05-21 15:16 UTC Alex Stapleton <alexs@advfn.com>
` Re: Optimizing for writes. Data integrity not critical
2005-05-21 17:27 UTC Alex Stapleton <alexs@advfn.com>
[6+ messages in thread]
Error when try installing pgbench ?
2005-05-15 09:37 UTC Andre Nas <blesets@yahoo.com.au>
` Re: [pgsql-benchmarks] Error when try installing pgbench ?
2005-05-18 19:08 UTC Vivek Khera <vivek@khera.org>
` Re: Error when try installing pgbench ?
2005-05-21 07:42 UTC Tomaz Borstnar <tomaz.borstnar@over.net>
[3+ messages in thread]
cant seem to post the explain
2005-05-20 19:58 UTC Joel Fradkin <jfradkin@wazagua.com>
performance on a querry with many group by's any way to speed it up?
2005-05-20 19:47 UTC Joel Fradkin <jfradkin@wazagua.com>
Which is better, correlated subqueries or joins?
2005-05-19 21:50 UTC Jeffrey Tenny <jeffrey.tenny@comcast.net>
` Re: Which is better, correlated subqueries or joins?
2005-05-19 21:53 UTC Joshua D. Drake <jd@commandprompt.com>
[2+ messages in thread]
PostgreSQL strugling during high load
2005-05-13 12:52 UTC Mindaugas Riauba <mind@bi.lt>
` Re: PostgreSQL strugling during high load
2005-05-13 13:00 UTC Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: PostgreSQL strugling during high load
2005-05-13 13:42 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: PostgreSQL strugling during high load
2005-05-13 14:10 UTC Mindaugas Riauba <mind@bi.lt>
` Re: PostgreSQL strugling during high load
2005-05-13 14:12 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: PostgreSQL strugling during high load
2005-05-13 14:45 UTC Mindaugas Riauba <mind@bi.lt>
` Re: PostgreSQL strugling during high load
2005-05-13 15:23 UTC Cosimo Streppone <cosimo@streppone.it>
` Re: PostgreSQL strugling during high load
2005-05-13 15:41 UTC Mindaugas Riauba <mind@bi.lt>
` Re: PostgreSQL strugling during high load
2005-05-13 16:12 UTC Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: PostgreSQL strugling during high load
2005-05-13 16:42 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: PostgreSQL strugling during high load
2005-05-13 17:33 UTC Mischa Sandberg <mischa.sandberg@telus.net>
` Re: PostgreSQL strugling during high load
2005-05-16 02:26 UTC Matthew T. O'Connor <matthew@zeut.net>
` Re: PostgreSQL strugling during high load
2005-05-16 02:45 UTC Thomas F. O'Connell <tfo@sitening.com>
` Re: PostgreSQL strugling during high load
2005-05-16 10:05 UTC Mindaugas Riauba <mind@bi.lt>
` Re: PostgreSQL strugling during high load
2005-05-19 16:54 UTC Donald Courtney <Donald.Courtney@Sun.COM>
` Re: PostgreSQL strugling during high load
2005-05-19 18:12 UTC Anjan Dave <adave@vantage.com>
` Re: PostgreSQL strugling during high load
2005-05-19 18:29 UTC Donald Courtney <Donald.Courtney@Sun.COM>
` Re: PostgreSQL strugling during high load
2005-05-19 19:43 UTC Vivek Khera <vivek@khera.org>
` Re: PostgreSQL strugling during high load
2005-05-19 19:57 UTC Josh Berkus <josh@agliodbs.com>
` Re: PostgreSQL strugling during high load
2005-05-19 20:10 UTC Steve Poe <spoe@sfnet.cc>
` Re: PostgreSQL strugling during high load
2005-05-19 20:19 UTC Anjan Dave <adave@vantage.com>
[21+ messages in thread]
where+orderby+limit not (always) using appropriate index?
2005-05-18 14:30 UTC Szűcs Gábor <surrano@gmail.com>
` Re: where+orderby+limit not (always) using appropriate index?
2005-05-18 15:06 UTC PFC <lists@boutiquenumerique.com>
` Re: where+orderby+limit not (always) using appropriate index?
2005-05-18 15:14 UTC Tom Lane <tgl@sss.pgh.pa.us>
[3+ messages in thread]
Re: Is there any other way to do this?
2005-05-17 22:57 UTC Steinar H. Gunderson <sgunderson@bigfoot.com>
` Is there any other way to do this?
2005-05-17 22:58 UTC Wei Weng <wweng@kencast.com>
` Re: Is there any other way to do this?
2005-05-18 02:12 UTC Christopher Kings-Lynne <chriskl@familyhealth.com.au>
[3+ messages in thread]
Trigger performance problem
2005-05-16 13:06 UTC Manuel Wenger <manuel.wenger@ticinocom.com>
` Re: Trigger performance problem
2005-05-17 17:47 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Trigger performance problem
2005-05-17 17:53 UTC lists@boutiquenumerique.com
[3+ messages in thread]
checkpoint segments
2005-05-16 00:22 UTC David Parker <dparker@tazznetworks.com>
` Re: checkpoint segments
2005-05-16 03:26 UTC Josh Berkus <josh@agliodbs.com>
` Re: checkpoint segments
2005-05-16 04:34 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: checkpoint segments
2005-05-16 04:39 UTC Alvaro Herrera <alvherre@surnet.cl>
` Re: checkpoint segments
2005-05-16 04:40 UTC Alvaro Herrera <alvherre@surnet.cl>
` Re: checkpoint segments
2005-05-16 16:17 UTC Josh Berkus <josh@agliodbs.com>
[6+ 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