X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 379F232A400 for ; Wed, 6 Oct 2004 18:28:07 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 83506-10 for ; Wed, 6 Oct 2004 17:28:01 +0000 (GMT) Received: from fe08.axelero.hu (fe08.axelero.hu [195.228.240.96]) by svr1.postgresql.org (Postfix) with ESMTP id 1798632A3FB for ; Wed, 6 Oct 2004 18:27:59 +0100 (BST) Received: from fe08 (localhost-02 [127.0.2.1]) by fe08.axelero.hu (8.12.11/8.12.11) with SMTP id i96HQxcf092268 for ; Wed, 6 Oct 2004 19:26:59 +0200 (CEST) Received: from fe08.axelero.hu [127.0.2.1] via SMTP gateway by fe08 [195.228.240.96]; id A068691C51D at Wed, 06 Oct 2004 19:26:59 +0200 Received: from fejleszt4 (121-248-182-81.adsl-fixip.axelero.hu [81.182.248.121]) by fe08.axelero.hu (8.12.11/8.12.11) with SMTP id i96HQw2i092255 for ; Wed, 6 Oct 2004 19:26:58 +0200 (CEST) Message-ID: <019301c4abc9$ef251ea0$0403a8c0@fejleszt4> From: =?iso-8859-1?Q?SZUCS_G=E1bor?= To: References: <4162CA14.6080206@lulu.com> <200410050947.36174.josh@agliodbs.com> <41630D50.3020308@lulu.com> <200410051538.51664.josh@agliodbs.com> <4164131A.6080601@lulu.com> Subject: Re: Excessive context switching on SMP Xeons Date: Wed, 6 Oct 2004 19:28:45 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1437 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 X-RAVMilter-Version: 8.4.3(snapshot 20030217) (fe08.axelero.hu) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200410/62 X-Sequence-Number: 8538 Hmmm... I may be mistaken (I think last time I read about optimization params was in 7.3 docs), but doesn't RPC < 1 mean that random read is faster than sequential read? In your case, do you really think reading randomly is 4x faster than reading sequentially? Doesn't seem to make sense, even with a zillion-disk array. Theoretically. Also not sure, but sort_mem and vacuum_mem seem to be too small to me. G. %----------------------- cut here -----------------------% \end ----- Original Message ----- From: "Bill Montgomery" Sent: Wednesday, October 06, 2004 5:45 PM > Some relevant parameters: > shared_buffers = 16384 > sort_mem = 2048 > vacuum_mem = 16384 > max_fsm_pages = 200000 > max_fsm_relations = 10000 > fsync = true > wal_sync_method = fsync > wal_buffers = 32 > checkpoint_segments = 6 > effective_cache_size = 262144 > random_page_cost = 0.25