pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Joining 2 tables with 300 million rows
  2005-12-08 16:59 UTC  Amit V Shah <ashah@tagaudit.com>
` Re: Joining 2 tables with 300 million rows
  2005-12-08 18:47 UTC  Dmitri Bichko <dbichko@aveopharma.com>
` Re: Joining 2 tables with 300 million rows
  2005-12-08 22:01 UTC  Amit V Shah <ashah@tagaudit.com>
` Re: Joining 2 tables with 300 million rows
  2005-12-09 15:32 UTC  Jeff Trout <threshar@torgo.978.org>
` Re: Joining 2 tables with 300 million rows
  2005-12-12 22:34 UTC  Manfred Koizar <mkoi-pg@aon.at>
  [5+ messages in thread]

Very slow queries  - please help.
  2005-11-24 13:06 UTC  Bealach-na Bo <bealach_na_bo@hotmail.com>
` Re: Very slow queries - please help.
  2005-11-24 13:23 UTC  Claus Guttesen <kometen@gmail.com>
` Re: Very slow queries - please help.
  2005-11-24 14:36 UTC  Bealach-na Bo <bealach_na_bo@hotmail.com>
` Re: Very slow queries - please help.
  2005-11-24 15:03 UTC  Guillaume Smet <guillaume.smet@openwide.fr>
` Re: Very slow queries - please help.
  2005-11-24 15:15 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Very slow queries - please help
  2005-11-24 18:14 UTC  Bealach-na Bo <bealach_na_bo@hotmail.com>
` Very slow queries - please help
  2005-11-24 18:51 UTC  Bealach-na Bo <bealach_na_bo@hotmail.com>
` Re: Very slow queries - please help
  2005-12-04 06:40 UTC  Thomas F. O'Connell <tfo@sitening.com>
` Re: Very slow queries - please help
  2005-12-12 16:24 UTC  Bealach-na Bo <bealach_na_bo@hotmail.com>
  [9+ messages in thread]

7.4.7 vs. 8.1
  2005-12-12 08:54 UTC  Szabolcs BALLA <szballa@confinsystems.com>
` Re: 7.4.7 vs. 8.1
  2005-12-12 12:04 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
  [2+ messages in thread]

Is RAID10 the best choice?
  2005-12-10 11:34 UTC  Carlos Benkendorf <carlosbenkendorf@yahoo.com.br>
` Re: Is RAID10 the best choice?
  2005-12-12 04:45 UTC  Alex Turner <armtuk@gmail.com>
  [2+ messages in thread]

Join the same row
  2005-12-06 20:22 UTC  Edison Azzi <edisonazzi@terra.com.br>
` Re: Join the same row
  2005-12-07 09:27 UTC  Richard Huxton <dev@archonet.com>
` Re: Join the same row
  2005-12-07 18:45 UTC  Edison Azzi <edisonazzi@terra.com.br>
` Re: Join the same row
  2005-12-07 18:55 UTC  Richard Huxton <dev@archonet.com>
` Re: Join the same row
  2005-12-11 20:36 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [5+ messages in thread]

Bitmasks
  2005-12-10 17:12 UTC  Ivan Voras <ivoras@fer.hr>
` Re: Bitmasks
  2005-12-11 06:12 UTC  Greg Stark <gsstark@mit.edu>
  [2+ messages in thread]

Queries taking ages in PG 8.1, have been much faster in PG<=8.0
  2005-12-01 15:49 UTC  Markus Wollny <Markus.Wollny@computec.de>
` Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0
  2005-12-01 16:26 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0
  2005-12-01 16:30 UTC  Markus Wollny <Markus.Wollny@computec.de>
` Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0
  2005-12-01 16:34 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0
  2005-12-04 13:24 UTC  Markus Wollny <Markus.Wollny@computec.de>
` Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0
  2005-12-04 18:31 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0
  2005-12-05 10:28 UTC  Markus Wollny <Markus.Wollny@computec.de>
` Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0
  2005-12-05 14:32 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0
  2005-12-05 14:44 UTC  Markus Wollny <Markus.Wollny@computec.de>
` Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0
  2005-12-05 15:11 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0
  2005-12-05 15:40 UTC  Markus Wollny <Markus.Wollny@computec.de>
` Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0
  2005-12-05 15:45 UTC  Markus Wollny <Markus.Wollny@computec.de>
` Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0
  2005-12-10 17:14 UTC  Manfred Koizar <mkoi-pg@aon.at>
  [13+ messages in thread]

Clustered tables and seqscan disabled
  2005-12-10 15:29 UTC  Henrique Engelmann <henriqueengelmann@yahoo.com.br>
` Re: Clustered tables and seqscan disabled
  2005-12-10 16:53 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [2+ messages in thread]

Executing a shell command from a PG function
  2005-12-10 15:55 UTC  Yves Vindevogel <yves.vindevogel@implements.be>
` Re: Executing a shell command from a PG function
  2005-12-10 16:14 UTC  Jaime Casanova <systemguards@gmail.com>
` Re: Executing a shell command from a PG function
  2005-12-10 16:22 UTC  Michael Fuhr <mike@fuhr.org>
` Re: Executing a shell command from a PG function
  2005-12-10 16:53 UTC  Yves Vindevogel <yves.vindevogel@implements.be>
  [4+ messages in thread]

Disk tests for a new database server
  2005-12-08 12:12 UTC  Rory Campbell-Lange <rory@campbell-lange.net>
` Re: Disk tests for a new database server
  2005-12-08 15:06 UTC  Steve Poe <spoe@sfnet.cc>
` Re: Disk tests for a new database server
  2005-12-08 22:56 UTC  Rory Campbell-Lange <rory@campbell-lange.net>
  [3+ messages in thread]

slow COMMITs
  2005-12-08 17:10 UTC  Evgeny Gridasov <eugrid@fpm.kubsu.ru>

Performance degradation after successive UPDATE's
  2005-12-05 17:05 UTC  Assaf Yaari <assafy@mobixell.com>
` Re: Performance degradation after successive UPDATE's
  2005-12-05 20:36 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: Performance degradation after successive UPDATE's
  2005-12-06 09:08 UTC  Assaf Yaari <assafy@mobixell.com>
` Re: Performance degradation after successive UPDATE's
  2005-12-06 09:52 UTC  Pandurangan R S <pandurangan.r.s@gmail.com>
` Re: Performance degradation after successive UPDATE's
  2005-12-06 12:34 UTC  Jan Wieck <JanWieck@Yahoo.com>
` Re: Performance degradation after successive UPDATE's
  2005-12-06 20:44 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: Performance degradation after successive UPDATE's
  2005-12-07 12:14 UTC  Assaf Yaari <assafy@mobixell.com>
` Re: Performance degradation after successive UPDATE's
  2005-12-07 20:04 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: Performance degradation after successive UPDATE's
  2005-12-08 14:29 UTC  Assaf Yaari <assafy@mobixell.com>
  [9+ messages in thread]

view of view
  2005-12-08 02:47 UTC  Keith Worthington <KeithW@NarrowPathInc.com>
` Re: view of view
  2005-12-08 13:13 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: view of view
  2005-12-08 13:46 UTC  Rich Doughty <rich@opusvl.com>
  [3+ messages in thread]

LVM and Postgres
  2005-12-06 09:38 UTC  Rory Campbell-Lange <rory@campbell-lange.net>
` Re: LVM and Postgres
  2005-12-06 20:12 UTC  August Zajonc <augustz@augustz.com>
` Re: LVM and Postgres
  2005-12-06 21:36 UTC  Rory Campbell-Lange <rory@campbell-lange.net>
` Re: LVM and Postgres
  2005-12-07 00:25 UTC  Michael Stone <mstone+postgres@mathom.us>
` Re: LVM and Postgres
  2005-12-07 00:52 UTC  Alex Turner <armtuk@gmail.com>
` Re: LVM and Postgres
  2005-12-07 01:31 UTC  Michael Stone <mstone+postgres@mathom.us>
` Re: LVM and Postgres
  2005-12-07 04:14 UTC  Kevin Brown <kevin@sysexperts.com>
` Re: LVM and Postgres
  2005-12-08 11:28 UTC  Rory Campbell-Lange <rory@campbell-lange.net>
  [8+ messages in thread]

INSERTs becoming slower and slower
  2005-12-08 08:36 UTC  Nörder-Tuitje, Marcus <noerder-tuitje@technology.de>
` Re: INSERTs becoming slower and slower
  2005-12-08 08:44 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: INSERTs becoming slower and slower
  2005-12-08 10:59 UTC  Matteo Beccati <php@beccati.com>
  [3+ messages in thread]

First query is slow, subsequent queries fast
  2005-12-07 10:46 UTC  Stephan Vollmer <svollmer@gmx.de>
` Re: First query is slow, subsequent queries fast
  2005-12-07 10:55 UTC  Oleg Bartunov <oleg@sai.msu.su>
` Re: First query is slow, subsequent queries fast
  2005-12-07 18:33 UTC  Stephan Vollmer <svollmer@gmx.de>
  [3+ messages in thread]

TSearch2 vs. Apache Lucene
  2005-12-06 16:47 UTC  Joshua Kramer <josh@bitbuckets.com>
` Re: TSearch2 vs. Apache Lucene
  2005-12-06 16:59 UTC  Michael Riess <mlriess@gmx.de>
` Re: TSearch2 vs. Apache Lucene
  2005-12-06 17:00 UTC  Russell Garrett <russ@garrett.co.uk>
` Re: TSearch2 vs. Apache Lucene
  2005-12-06 17:14 UTC  Oleg Bartunov <oleg@sai.msu.su>
` Re: TSearch2 vs. Apache Lucene
  2005-12-06 17:27 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
` Re: TSearch2 vs. Apache Lucene
  2005-12-06 18:02 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: TSearch2 vs. Apache Lucene
  2005-12-06 18:28 UTC  Michael Riess <mlriess@gmx.de>
` Re: TSearch2 vs. Apache Lucene
  2005-12-06 18:32 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
` Re: TSearch2 vs. Apache Lucene
  2005-12-07 01:40 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: TSearch2 vs. Apache Lucene
  2005-12-07 07:56 UTC  Michael Riess <mlriess@gmx.de>
` Re: TSearch2 vs. Apache Lucene
  2005-12-07 08:20 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: TSearch2 vs. Apache Lucene
  2005-12-07 08:28 UTC  Michael Riess <mlriess@gmx.de>
  [12+ messages in thread]

Query Fails with error calloc - Cannot alocate memory
  2005-12-05 07:42 UTC  Howard Oblowitz <Howard.Oblowitz@lewisgroup.co.za>
` Re: Query Fails with error calloc - Cannot alocate memory
  2005-12-07 04:18 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: Query Fails with error calloc - Cannot alocate memory
  2005-12-07 06:31 UTC  Neil Conway <neilc@samurai.com>
  [3+ messages in thread]

table partitioning: effects of many sub-tables (was COPY too slow...)
  2005-12-07 03:06 UTC  Rick Schumeyer <rschumeyer@ieee.org>

two disks - best way to use them?
  2005-12-02 18:58 UTC  Rick Schumeyer <rschumeyer@ieee.org>
` Re: two disks - best way to use them?
  2005-12-02 20:05 UTC  Ron <rjpeace@earthlink.net>
` Re: two disks - best way to use them?
  2005-12-05 13:56 UTC  Olleg Samoylov <olleg_s@mail.ru>
` Re: two disks - best way to use them?
  2005-12-05 15:48 UTC  Thomas Harold <tgh@tgharold.com>
` Re: two disks - best way to use them?
  2005-12-05 16:15 UTC  David Lang <dlang@invendra.net>
` Re: two disks - best way to use them?
  2005-12-05 16:45 UTC  Thomas Harold <tgh@tgharold.com>
` Re: two disks - best way to use them?
  2005-12-06 03:54 UTC  David Lang <dlang@invendra.net>
` Re: two disks - best way to use them?
  2005-12-06 05:52 UTC  Thomas Harold <tgh@tgharold.com>
` Re: two disks - best way to use them?
  2005-12-06 08:12 UTC  Ron <rjpeace@earthlink.net>
` Re: two disks - best way to use them?
  2005-12-06 16:00 UTC  Thomas Harold <tgh@tgharold.com>
` Re: two disks - best way to use them?
  2005-12-06 21:57 UTC  David Lang <dlang@invendra.net>
  [11+ messages in thread]

Context switching and Xeon processors
  2005-12-06 21:01 UTC  Brandon Metcalf <bmetcalf@nortel.com>
` Re: Context switching and Xeon processors
  2005-12-06 21:36 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Context switching and Xeon processors
  2005-12-06 21:45 UTC  Brandon Metcalf <bmetcalf@nortel.com>
` Re: Context switching and Xeon processors
  2005-12-06 21:52 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
  [4+ messages in thread]

Missed index opportunity for outer join?
  2005-12-05 22:13 UTC  rm_pg@cheapcomplexdevices.com
` Re: Missed index opportunity for outer join?
  2005-12-05 22:38 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Missed index opportunity for outer join?
  2005-12-05 23:05 UTC  rm_pg@cheapcomplexdevices.com
` Re: Missed index opportunity for outer join?
  2005-12-06 16:57 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Missed index opportunity for outer join?
  2005-12-06 20:17 UTC  Ron Mayer <rm_pg@cheapcomplexdevices.com>
` Re: Missed index opportunity for outer join?
  2005-12-06 20:33 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Missed index opportunity for outer join?
  2005-12-06 21:15 UTC  Ron Mayer <rm_pg@cheapcomplexdevices.com>
` Re: Missed index opportunity for outer join?
  2005-12-06 21:24 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Missed index opportunity for outer join?
  2005-12-06 21:42 UTC  Ron Mayer <rm_pg@cheapcomplexdevices.com>
  [9+ messages in thread]

Can this query go faster???
  2005-12-06 09:43 UTC  Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
` Re: Can this query go faster???
  2005-12-06 09:51 UTC  Michael Riess <mlriess@gmx.de>
` Re: Can this query go faster???
  2005-12-06 09:52 UTC  Csaba Nagy <nagy@ecircle-ag.com>
` Re: Can this query go faster???
  2005-12-06 09:54 UTC  Markus Wollny <Markus.Wollny@computec.de>
` Re: Can this query go faster???
  2005-12-06 10:21 UTC  Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
` Re: Can this query go faster???
  2005-12-06 10:32 UTC  Tino Wildenhain <tino@wildenhain.de>
` Re: Can this query go faster???
  2005-12-06 11:21 UTC  Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
` Re: Can this query go faster???
  2005-12-06 11:36 UTC  Tino Wildenhain <tino@wildenhain.de>
` Re: Can this query go faster???
  2005-12-06 12:20 UTC  Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
` Re: Can this query go faster???
  2005-12-06 12:30 UTC  Tino Wildenhain <tino@wildenhain.de>
` Re: Can this query go faster???
  2005-12-06 12:32 UTC  Csaba Nagy <nagy@ecircle-ag.com>
` Re: Can this query go faster???
  2005-12-06 13:41 UTC  Ron <rjpeace@earthlink.net>
` Re: Can this query go faster???
  2005-12-06 13:58 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: Can this query go faster???
  2005-12-06 20:50 UTC  Bruno Wolff III <bruno@wolff.to>
  [14+ messages in thread]

8.1 count(*) distinct: IndexScan/SeqScan
  2005-11-23 22:14 UTC  Pailloncy Jean-Gerard <jg@rilk.com>
` Re: 8.1 count(*) distinct: IndexScan/SeqScan
  2005-11-24 03:14 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: 8.1 count(*) distinct: IndexScan/SeqScan
  2005-11-24 05:20 UTC  andrew@pillette.com
` Re: 8.1 count(*) distinct: IndexScan/SeqScan
  2005-11-24 11:54 UTC  Pailloncy Jean-Gerard <jg@rilk.com>
` Re: 8.1 count(*) distinct: IndexScan/SeqScan
  2005-11-24 11:54 UTC  Pailloncy Jean-Gerard <jg@rilk.com>
` Re: 8.1 count(*) distinct: IndexScan/SeqScan
  2005-11-24 23:34 UTC  Pailloncy Jean-Gerard <jg@rilk.com>
` Re: 8.1 count(*) distinct: IndexScan/SeqScan
  2005-11-25 02:37 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: 8.1 count(*) distinct: IndexScan/SeqScan
  2005-11-25 03:15 UTC  Kyle Cordes <kyle@kylecordes.com>
` Re: 8.1 count(*) distinct: IndexScan/SeqScan
  2005-11-25 11:40 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: 8.1 count(*) distinct: IndexScan/SeqScan
  2005-11-25 12:32 UTC  Alvaro Herrera <alvherre@commandprompt.com>
` Re: 8.1 count(*) distinct: IndexScan/SeqScan
  2005-11-25 14:47 UTC  Pailloncy Jean-Gerard <jg@rilk.com>
` Re: 8.1 count(*) distinct: IndexScan/SeqScan
  2005-12-06 16:19 UTC  Pailloncy Jean-Gerard <jg@rilk.com>
  [12+ messages in thread]

BLCKSZ
  2005-12-05 13:47 UTC  Olleg Samoylov <olleg_s@mail.ru>
` Re: BLCKSZ
  2005-12-05 15:02 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: BLCKSZ
  2005-12-05 21:32 UTC  Olleg <olleg_s@mail.ru>
` Re: BLCKSZ
  2005-12-06 00:07 UTC  Alvaro Herrera <alvherre@commandprompt.com>
` Re: BLCKSZ
  2005-12-06 01:21 UTC  Ron <rjpeace@earthlink.net>
` Re: BLCKSZ
  2005-12-06 05:51 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: BLCKSZ
  2005-12-06 10:40 UTC  Olleg <olleg_s@mail.ru>
` Re: BLCKSZ
  2005-12-06 10:59 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: BLCKSZ
  2005-12-06 11:39 UTC  David Lang <dlang@invendra.net>
  [9+ 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