pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedWhich one is faster: one way reading ="single pass reading"
2005-03-16 11:15 UTC Rosny <sehatrosny@hotmail.com>
Slow loads when indexes added.
2005-03-15 15:23 UTC Stef <svb@ucs.co.za>
` Re: Slow loads when indexes added.
2005-03-16 07:59 UTC Stef <svb@ucs.co.za>
[2+ messages in thread]
interesting benchmarks PG/Firebird Linux/Windows fsync/nofsync
2005-03-15 13:44 UTC Chris Mair <list@1006.org>
` Re: interesting benchmarks PG/Firebird Linux/Windows fsync/nofsync
2005-03-15 13:52 UTC Magnus Hagander <mha@sollentuna.net>
` Re: interesting benchmarks PG/Firebird Linux/Windows fsync/nofsync
2005-03-15 13:55 UTC Bruce Momjian <pgman@candle.pha.pa.us>
` Re: interesting benchmarks PG/Firebird Linux/Windows fsync/nofsync
2005-03-16 01:44 UTC Qingqing Zhou <zhouqq@cs.toronto.edu>
[4+ messages in thread]
Re: Changing the random_page_cost default (was: cpu_tuple_cost)
2005-03-15 12:35 UTC Greg Sabino Mullane <greg@turnstep.com>
` Re: Changing the random_page_cost default (was: cpu_tuple_cost)
2005-03-15 13:31 UTC Jeff Hoffmann <jeff@propertykey.com>
` Re: Changing the random_page_cost default (was: cpu_tuple_cost)
2005-03-15 15:22 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Changing the random_page_cost default (was:
2005-03-15 22:44 UTC Mark Kirkwood <markir@paradise.net.nz>
` Re: Changing the random_page_cost default (was: cpu_tuple_cost)
2005-03-16 01:03 UTC Greg Sabino Mullane <greg@turnstep.com>
[5+ messages in thread]
Avoiding tuple construction/deconstruction during joining
2005-03-14 17:24 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Avoiding tuple construction/deconstruction during joining
2005-03-14 19:11 UTC Miroslav ulc <miroslav.sulc@startnet.cz>
` Re: Avoiding tuple construction/deconstruction during joining
2005-03-14 19:22 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Avoiding tuple construction/deconstruction during joining
2005-03-14 19:31 UTC Miroslav ulc <miroslav.sulc@startnet.cz>
` Re: [PERFORM] Avoiding tuple construction/deconstruction during joining
2005-03-15 17:17 UTC PFC <lists@boutiquenumerique.com>
` Re: [PERFORM] Avoiding tuple construction/deconstruction during joining
2005-03-15 19:53 UTC PFC <lists@boutiquenumerique.com>
[6+ messages in thread]
Effect of Stripe Size (was Postgres on RAID5)
2005-03-15 16:17 UTC Ruth Ivimey-Cook <Ruth.Ivimey-Cook@ivimey.org>
How to read query plan
2005-03-13 15:32 UTC Miroslav Šulc <miroslav.sulc@startnet.cz>
` Re: How to read query plan
2005-03-13 16:24 UTC John Arbash Meinel <john@arbash-meinel.com>
` Re: How to read query plan
2005-03-13 16:51 UTC Ragnar Hafstað <gnari@simnet.is>
` Re: How to read query plan
2005-03-13 17:10 UTC Miroslav Šulc <miroslav.sulc@startnet.cz>
` Re: How to read query plan
2005-03-13 17:23 UTC Miroslav Šulc <miroslav.sulc@startnet.cz>
` Re: How to read query plan
2005-03-13 17:30 UTC John Arbash Meinel <john@arbash-meinel.com>
` Re: How to read query plan
2005-03-13 17:50 UTC John Arbash Meinel <john@arbash-meinel.com>
` Re: How to read query plan
2005-03-13 18:10 UTC Miroslav Šulc <miroslav.sulc@startnet.cz>
` Re: How to read query plan
2005-03-13 19:07 UTC Miroslav Šulc <miroslav.sulc@startnet.cz>
` Re: How to read query plan
2005-03-13 19:15 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: How to read query plan
2005-03-13 19:26 UTC John Arbash Meinel <john@arbash-meinel.com>
` Re: How to read query plan
2005-03-13 19:43 UTC Miroslav ulc <miroslav.sulc@startnet.cz>
` Re: How to read query plan
2005-03-13 19:51 UTC Miroslav Šulc <miroslav.sulc@startnet.cz>
` Re: How to read query plan
2005-03-13 19:54 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: How to read query plan
2005-03-13 20:03 UTC Miroslav ulc <miroslav.sulc@startnet.cz>
` Re: How to read query plan
2005-03-13 20:26 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] How to read query plan
2005-03-14 00:08 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] How to read query plan
2005-03-14 05:00 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] How to read query plan
2005-03-14 08:43 UTC Miroslav ulc <miroslav.sulc@startnet.cz>
` Re: [PERFORM] How to read query plan
2005-03-14 08:44 UTC Miroslav ulc <miroslav.sulc@startnet.cz>
` Re: How to read query plan
2005-03-14 08:58 UTC Miroslav Šulc <miroslav.sulc@startnet.cz>
` Re: How to read query plan
2005-03-14 09:02 UTC Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: How to read query plan
2005-03-14 09:08 UTC PFC <lists@boutiquenumerique.com>
` Re: How to read query plan
2005-03-14 09:09 UTC Miroslav Šulc <miroslav.sulc@startnet.cz>
` Re: How to read query plan
2005-03-14 09:17 UTC Miroslav Šulc <miroslav.sulc@startnet.cz>
` Re: How to read query plan
2005-03-14 14:05 UTC Harald Fuchs <use_reply_to@protecting.net>
` Re: [PERFORM] How to read query plan
2005-03-14 15:03 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] How to read query plan
2005-03-14 15:04 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] How to read query plan
2005-03-14 15:21 UTC Miroslav ulc <miroslav.sulc@startnet.cz>
` Re: How to read query plan
2005-03-14 15:27 UTC Miroslav Šulc <miroslav.sulc@startnet.cz>
` Re: [PERFORM] How to read query plan
2005-03-14 15:54 UTC John Arbash Meinel <john@arbash-meinel.com>
` Re: How to read query plan
2005-03-14 15:58 UTC Greg Stark <gsstark@mit.edu>
` Re: How to read query plan
2005-03-14 16:23 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: How to read query plan
2005-03-14 16:33 UTC Miroslav ulc <miroslav.sulc@startnet.cz>
` Re: How to read query plan
2005-03-14 16:36 UTC John Arbash Meinel <john@arbash-meinel.com>
` Re: How to read query plan
2005-03-14 17:03 UTC Kaloyan Iliev Iliev <news1@faith.digsys.bg>
` Re: How to read query plan
2005-03-14 17:07 UTC Miroslav Šulc <miroslav.sulc@startnet.cz>
[37+ messages in thread]
Bad Performance[2]
2005-03-14 16:47 UTC Gaetano Mendola <mendola@bigfoot.com>
adding 'limit' leads to very slow query
2005-03-07 23:39 UTC Michael McFarland <sidlonDoesntLikeSpam@yahoo.com>
` Re: adding 'limit' leads to very slow query
2005-03-08 04:46 UTC John A Meinel <john@arbash-meinel.com>
` Re: adding 'limit' leads to very slow query
2005-03-08 07:03 UTC Stephan Szabo <sszabo@megazone.bigpanda.com>
` Re: adding 'limit' leads to very slow query
2005-03-09 16:00 UTC Michael McFarland <sidlonDoesntLikeSpam@yahoo.com>
` Re: adding 'limit' leads to very slow query
2005-03-14 14:50 UTC Stephan Szabo <sszabo@megazone.bigpanda.com>
[5+ messages in thread]
Questions about 2 databases.
2005-03-11 18:54 UTC jelle <jellej@pacbell.net>
` Re: Questions about 2 databases.
2005-03-11 20:33 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Questions about 2 databases.
2005-03-11 20:51 UTC Richard_D_Levine@raytheon.com
` Re: Questions about 2 databases.
2005-03-11 21:43 UTC jelle <jellej@pacbell.net>
` Re: Questions about 2 databases.
2005-03-12 02:15 UTC PFC <lists@boutiquenumerique.com>
` Re: Questions about 2 databases.
2005-03-14 10:43 UTC Mirko Zeibig <mirko-individual@zeibig.net>
[6+ messages in thread]
Performance Tuning
2005-02-09 20:01 UTC Chris Kratz <chris.kratz@vistashare.com>
` Re: Performance Tuning
2005-02-09 20:27 UTC Rod Taylor <rbt@sitesell.com>
` Re: Performance Tuning
2005-02-09 20:38 UTC John Arbash Meinel <john@arbash-meinel.com>
` Re: Performance Tuning
2005-02-09 20:59 UTC Greg Stark <gsstark@mit.edu>
` Re: Performance Tuning
2005-02-09 21:25 UTC Chris Kratz <chris.kratz@vistashare.com>
` Re: Performance Tuning
2005-02-09 22:08 UTC Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: Performance Tuning
2005-02-09 22:15 UTC Chris Kratz <chris.kratz@vistashare.com>
` Re: Performance Tuning
2005-02-09 22:17 UTC Chris Kratz <chris.kratz@vistashare.com>
` Re: Performance Tuning
2005-02-09 22:30 UTC Chris Kratz <chris.kratz@vistashare.com>
` Re: Performance Tuning
2005-02-09 23:58 UTC PFC <lists@boutiquenumerique.com>
` Re: Performance Tuning
2005-02-10 01:27 UTC Mike Rylander <mrylander@gmail.com>
` Re: Performance Tuning
2005-02-10 03:09 UTC Christopher Browne <cbbrowne@acm.org>
` Re: Performance Tuning
2005-02-10 03:38 UTC PFC <lists@boutiquenumerique.com>
` Performance tuning
2005-03-11 15:40 UTC Jacques Caron <jc@directinfos.com>
` Re: Performance tuning
2005-03-14 09:41 UTC Richard Huxton <dev@archonet.com>
[15+ messages in thread]
Re: Postgres on RAID5 (possible sync blocking read type
2005-03-14 07:44 UTC David Greaves <david@dgreaves.com>
Index use and slow queries
2005-03-13 05:40 UTC Tom Pfeifer <tpfeifer@tela.com>
` Re: Index use and slow queries
2005-03-13 06:07 UTC Russell Smith <mr-russ@pws.com.au>
` Re: Index use and slow queries
2005-03-13 06:26 UTC Tom Lane <tgl@sss.pgh.pa.us>
[3+ messages in thread]
What is the number of rows in explain?
2005-03-11 13:45 UTC Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
` Re: What is the number of rows in explain?
2005-03-11 14:43 UTC John A Meinel <john@arbash-meinel.com>
[2+ messages in thread]
Re: [GENERAL] more execution time
2005-03-11 13:05 UTC Richard Huxton <dev@archonet.com>
Statistics not working??
2005-03-11 11:53 UTC Hugo Ferreira <bytter@gmail.com>
` Re: Statistics not working??
2005-03-11 12:03 UTC Oleg Bartunov <oleg@sai.msu.su>
[2+ messages in thread]
What's better: Raid 0 or disk for seperate pg_xlog
2005-03-10 07:44 UTC Karim Nassar <Karim.Nassar@acm.org>
` Re: What's better: Raid 0 or disk for seperate pg_xlog
2005-03-10 14:14 UTC David Brown <time@bigpond.net.au>
` Re: What's better: Raid 0 or disk for seperate pg_xlog
2005-03-10 15:26 UTC John A Meinel <john@arbash-meinel.com>
` Re: What's better: Raid 0 or disk for seperate pg_xlog
2005-03-10 16:41 UTC Mario Weilguni <mweilguni@sime.com>
` Re: What's better: Raid 0 or disk for seperate pg_xlog
2005-03-10 19:50 UTC Karim Nassar <Karim.Nassar@acm.org>
` Re: What's better: Raid 0 or disk for seperate pg_xlog
2005-03-10 19:56 UTC John Arbash Meinel <john@arbash-meinel.com>
` Re: What's better: Raid 0 or disk for seperate pg_xlog
2005-03-11 08:05 UTC Richard Huxton <dev@archonet.com>
[7+ messages in thread]
Multi-line requests in COPY ... FROM STDIN
2005-03-10 05:29 UTC Mischa <mischa.Sandberg@telus.net>
Help trying to tune query that executes 40x slower than in SqlServer
2005-03-07 17:01 UTC Hugo Ferreira <bytter@gmail.com>
` Re: Help trying to tune query that executes 40x slower than in SqlServer
2005-03-07 17:28 UTC Josh Berkus <josh@agliodbs.com>
` Re: Help trying to tune query that executes 40x slower than in SqlServer
2005-03-07 17:45 UTC Hugo Ferreira <bytter@gmail.com>
` Re: Help trying to tune query that executes 40x slower than in SqlServer
2005-03-07 18:02 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Help trying to tune query that executes 40x slower than in SqlServer
2005-03-09 12:08 UTC Hugo Ferreira <bytter@gmail.com>
` Re: Help trying to tune query that executes 40x slower than in SqlServer
2005-03-09 22:08 UTC Russell Smith <mr-russ@pws.com.au>
` Re: Help trying to tune query that executes 40x slower
2005-03-10 02:09 UTC Jim Johannsen <jjsa@gvtc.com>
[7+ messages in thread]
How to speed up tsearch2 indexing
2005-03-09 17:25 UTC Werner Bohl <WernerBohl@infutor.com>
` Re: How to speed up tsearch2 indexing
2005-03-09 17:41 UTC Oleg Bartunov <oleg@sai.msu.su>
` Re: How to speed up tsearch2 indexing
2005-03-09 20:21 UTC Werner Bohl <WernerBohl@infutor.com>
` Re: How to speed up tsearch2 indexing
2005-03-09 20:27 UTC Oleg Bartunov <oleg@sai.msu.su>
[4+ messages in thread]
vacuum full, why multiple times ?
2005-03-09 01:02 UTC Gaetano Mendola <mendola@bigfoot.com>
` Re: vacuum full, why multiple times ?
2005-03-09 02:15 UTC Michael Fuhr <mike@fuhr.org>
` Re: vacuum full, why multiple times ?
2005-03-09 11:27 UTC Gaetano Mendola <mendola@bigfoot.com>
` Re: vacuum full, why multiple times ?
2005-03-09 12:30 UTC Richard Huxton <dev@archonet.com>
` Re: vacuum full, why multiple times ?
2005-03-09 14:30 UTC Gaetano Mendola <mendola@bigfoot.com>
` Re: vacuum full, why multiple times ?
2005-03-09 15:16 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: vacuum full, why multiple times ?
2005-03-09 16:17 UTC Gaetano Mendola <mendola@bigfoot.com>
[7+ messages in thread]
pl/pgsql faster than raw SQL?
2005-03-08 12:20 UTC Markus Bertheau ☭ <twanger@bluetwanger.de>
` Re: pl/pgsql faster than raw SQL?
2005-03-08 12:48 UTC Richard Huxton <dev@archonet.com>
` Re: pl/pgsql faster than raw SQL?
2005-03-08 15:10 UTC John A Meinel <john@arbash-meinel.com>
` Re: pl/pgsql faster than raw SQL?
2005-03-09 00:54 UTC Gaetano Mendola <mendola@bigfoot.com>
` Re: pl/pgsql faster than raw SQL?
2005-03-09 01:27 UTC John A Meinel <john@arbash-meinel.com>
` Re: pl/pgsql faster than raw SQL?
2005-03-09 11:20 UTC Gaetano Mendola <mendola@bigfoot.com>
[6+ messages in thread]
Why would writes to pgsql_tmp bottleneck at 1mb/s?
2005-03-08 20:18 UTC Josh Berkus <josh@agliodbs.com>
` Re: Why would writes to pgsql_tmp bottleneck at 1mb/s?
2005-03-09 00:17 UTC Josh Berkus <josh@agliodbs.com>
` Re: Why would writes to pgsql_tmp bottleneck at 1mb/s?
2005-03-09 00:44 UTC Josh Berkus <josh@agliodbs.com>
` Re: Why would writes to pgsql_tmp bottleneck at 1mb/s?
2005-03-09 01:13 UTC Aaron Birkland <birkie@gmail.com>
` Re: Why would writes to pgsql_tmp bottleneck at 1mb/s?
2005-03-09 04:27 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Why would writes to pgsql_tmp bottleneck at 1mb/s?
2005-03-09 04:37 UTC Josh Berkus <josh@agliodbs.com>
` Re: Why would writes to pgsql_tmp bottleneck at 1mb/s?
2005-03-09 04:37 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Why would writes to pgsql_tmp bottleneck at 1mb/s?
2005-03-09 07:00 UTC Josh Berkus <josh@agliodbs.com>
[8+ messages in thread]
64bit Opteron multi drive raid. Help with best config settings
2005-03-09 03:07 UTC David B <davidb999@gmail.com>
` Re: 64bit Opteron multi drive raid. Help with best config
2005-03-09 03:53 UTC Karim Nassar <Karim.Nassar@acm.org>
[2+ messages in thread]
Tuning, configuration for 7.3.5 on a Sun E4500
2005-03-07 14:46 UTC tsarevich@gmail.com
` Re: Tuning, configuration for 7.3.5 on a Sun E4500
2005-03-07 17:31 UTC Josh Berkus <josh@agliodbs.com>
` Re: Tuning, configuration for 7.3.5 on a Sun E4500
2005-03-08 07:47 UTC tsarevich@gmail.com
` Re: Tuning, configuration for 7.3.5 on a Sun E4500
2005-03-08 17:10 UTC Josh Berkus <josh@agliodbs.com>
[4+ 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