pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedSURVEY: who is running postgresql on 8 or more CPUs?
2005-05-31 13:16 UTC Dirk Lutzebäck <lutzeb@aeccom.com>
` Re: SURVEY: who is running postgresql on 8 or more CPUs?
2005-06-02 08:28 UTC Dirk Lutzebäck <lutzeb@aeccom.com>
` Re: SURVEY: who is running postgresql on 8 or more CPUs?
2005-06-02 12:12 UTC Dawid Kuroczko <qnex42@gmail.com>
` Re: SURVEY: who is running postgresql on 8 or more CPUs?
2005-06-02 12:28 UTC Dirk Lutzebäck <lutzeb@aeccom.com>
` Re: SURVEY: who is running postgresql on 8 or more CPUs?
2005-06-02 15:57 UTC ohp@pyrenet.fr
[5+ messages in thread]
Specific query performance problem help requested - postgresql 7.4
2005-05-26 15:36 UTC Brad Might <bmight@storediq.com>
` Specific query performance problem help requested - postgresql 7.4
2005-05-26 17:55 UTC Brad Might <bmight@storediq.com>
` Re: Specific query performance problem help requested - postgresql 7.4
2005-05-26 18:31 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Specific query performance problem help requested - postgresql 7.4
2005-05-26 18:41 UTC Brad Might <bmight@storediq.com>
` Re: Specific query performance problem help requested - postgresql 7.4
2005-06-02 15:03 UTC Brad Might <bmight@storediq.com>
[5+ messages in thread]
Moving pg_xlog
2005-06-01 15:31 UTC Keith Worthington <keithw@narrowpathinc.com>
` Re: Moving pg_xlog
2005-06-01 16:19 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Moving pg_xlog
2005-06-01 20:11 UTC Keith Worthington <keithw@narrowpathinc.com>
` Re: Moving pg_xlog
2005-06-01 20:30 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Moving pg_xlog
2005-06-01 20:31 UTC Brad Nicholson <bnichols@ca.afilias.info>
` Re: Moving pg_xlog
2005-06-01 21:27 UTC John A Meinel <john@arbash-meinel.com>
` Re: Moving pg_xlog
2005-06-02 06:06 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Moving pg_xlog
2005-06-02 07:02 UTC Himanshu Baweja <himanshubaweja@yahoo.com>
` Re: Moving pg_xlog
2005-06-02 14:23 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Moving pg_xlog
2005-06-02 14:47 UTC Himanshu Baweja <himanshubaweja@yahoo.com>
[10+ messages in thread]
postgresql-8.0.1 performance tuning
2005-05-27 13:41 UTC Martin Fandel <martin.fandel@alphyra-evs.de>
` Re: postgresql-8.0.1 performance tuning
2005-05-31 18:46 UTC John A Meinel <john@arbash-meinel.com>
` Re: postgresql-8.0.1 performance tuning
2005-06-01 05:30 UTC Cosimo Streppone <cosimo@streppone.it>
` Re: postgresql-8.0.1 performance tuning
2005-06-01 06:33 UTC Mark Kirkwood <markir@paradise.net.nz>
` Re: postgresql-8.0.1 performance tuning
2005-06-01 06:44 UTC Cosimo Streppone <cosimo@streppone.it>
` Re: postgresql-8.0.1 performance tuning
2005-06-01 07:22 UTC Mark Kirkwood <markir@paradise.net.nz>
` Re: postgresql-8.0.1 performance tuning
2005-06-01 08:50 UTC Martin Fandel <martin.fandel@alphyra-evs.de>
` Re: postgresql-8.0.1 performance tuning
2005-06-01 09:57 UTC Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: postgresql-8.0.1 performance tuning
2005-06-01 10:22 UTC Cosimo Streppone <cosimo@streppone.it>
` Re: postgresql-8.0.1 performance tuning
2005-06-01 10:26 UTC Martin Fandel <martin.fandel@alphyra-evs.de>
` Re: postgresql-8.0.1 performance tuning
2005-06-02 12:50 UTC Martin Fandel <martin.fandel@alphyra-evs.de>
` Re: postgresql-8.0.1 performance tuning
2005-06-02 13:10 UTC Martin Fandel <martin.fandel@alphyra-evs.de>
` Re: postgresql-8.0.1 performance tuning
2005-06-02 13:12 UTC Martin Fandel <martin.fandel@alphyra-evs.de>
[13+ messages in thread]
'Fastest' PC's are slowest in the house
2005-05-31 17:02 UTC Justin Davis <justin.davis@rapidsys.net>
` Re: 'Fastest' PC's are slowest in the house
2005-06-02 06:32 UTC Grega Bremec <gregab@p0f.net>
[2+ messages in thread]
TIP 9: the planner will ignore... & datatypes
2005-06-01 09:45 UTC Marc Mamin <m.mamin@gmx.net>
` Re: TIP 9: the planner will ignore... & datatypes
2005-06-01 13:40 UTC Alvaro Herrera <alvherre@surnet.cl>
[2+ messages in thread]
slow queries, possibly disk io
2005-05-26 20:24 UTC Josh Close <narshe@gmail.com>
` Re: slow queries, possibly disk io
2005-05-26 21:14 UTC John Arbash Meinel <john@arbash-meinel.com>
` Re: slow queries, possibly disk io
2005-05-26 21:23 UTC Dawid Kuroczko <qnex42@gmail.com>
` Re: slow queries, possibly disk io
2005-05-27 01:29 UTC Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: slow queries, possibly disk io
2005-05-27 12:52 UTC Josh Close <narshe@gmail.com>
` slow queries, possibly disk io
2005-05-27 13:04 UTC Josh Close <narshe@gmail.com>
` Re: slow queries, possibly disk io
2005-05-27 13:05 UTC Josh Close <narshe@gmail.com>
` Re: slow queries, possibly disk io
2005-05-27 14:29 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: slow queries, possibly disk io
2005-05-27 14:54 UTC Josh Close <narshe@gmail.com>
` Re: slow queries, possibly disk io
2005-05-27 15:00 UTC Josh Close <narshe@gmail.com>
` Re: slow queries, possibly disk io
2005-05-30 22:16 UTC Rudi Starcevic <tech@wildcash.com>
` Re: slow queries, possibly disk io
2005-05-31 13:17 UTC Josh Close <narshe@gmail.com>
` Re: slow queries, possibly disk io
2005-05-31 14:33 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: slow queries, possibly disk io
2005-05-31 16:36 UTC Josh Close <narshe@gmail.com>
` Re: slow queries, possibly disk io
2005-05-31 18:18 UTC Manfred Koizar <mkoi-pg@aon.at>
` Re: slow queries, possibly disk io
2005-06-01 09:06 UTC Simon Riggs <simon@2ndquadrant.com>
[16+ messages in thread]
very large table
2005-05-31 09:37 UTC Praveen Raja <praveen.raja@netlight.se>
` Re: very large table
2005-05-31 14:06 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: very large table
2005-06-01 08:57 UTC Simon Riggs <simon@2ndquadrant.com>
[3+ messages in thread]
Index on a NULL-value
2005-05-31 03:02 UTC Tobias Brox <tobias@nordicbet.com>
` Re: Index on a NULL-value
2005-05-31 03:16 UTC Bruno Wolff III <bruno@wolff.to>
` Re: Index on a NULL-value
2005-05-31 03:21 UTC Tobias Brox <tobias@nordicbet.com>
` Re: Index on a NULL-value
2005-05-31 03:31 UTC Tobias Brox <tobias@nordicbet.com>
` Re: Index on a NULL-value
2005-05-31 03:36 UTC Bruno Wolff III <bruno@wolff.to>
` Re: Index on a NULL-value
2005-05-31 03:45 UTC Tobias Brox <tobias@nordicbet.com>
` Re: Index on a NULL-value
2005-05-31 04:08 UTC Bruno Wolff III <bruno@wolff.to>
` Re: Index on a NULL-value
2005-05-31 04:18 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Index on a NULL-value
2005-05-31 04:21 UTC Greg Stark <gsstark@mit.edu>
` Re: Index on a NULL-value
2005-05-31 05:12 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Index on a NULL-value
2005-05-31 05:59 UTC Tobias Brox <tobias@nordicbet.com>
` Re: Index on a NULL-value
2005-06-01 05:42 UTC Tobias Brox <tobias@nordicbet.com>
[12+ messages in thread]
Major flood of mail to lists ...
2005-05-31 17:45 UTC Marc G. Fournier <scrappy@postgresql.org>
poor performance involving a small table
2005-05-26 14:57 UTC Colton A Smith <smith@cs.utk.edu>
` Re: poor performance involving a small table
2005-05-30 22:00 UTC Bricklen Anderson <BAnderson@PresiNET.com>
` Re: poor performance involving a small table
2005-05-31 01:52 UTC Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: poor performance involving a small table
2005-05-31 02:31 UTC andrew@pillette.com
[4+ messages in thread]
Drop / 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]
[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