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