Received: from smtp.snet.net (smtp.snet.net [204.60.6.55]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f6CDx2a70737 for ; Thu, 12 Jul 2001 09:59:02 -0400 (EDT) (envelope-from wweng@kencast.com) Received: from pop.snet.net (pop.snet.net [204.60.6.9]) by smtp.snet.net (8.11.1/8.11.1/SNET-mx-1.4/D-1.10/O-1.7) with ESMTP id f6CDOqC11751 for ; Thu, 12 Jul 2001 09:24:52 -0400 (EDT) Received: from [192.168.1.83] (167.95.252.64.snet.net [64.252.95.167]) by pop.snet.net (8.11.1/8.11.1/SNET-pop-1.5/D-1.8/O-1.6) with ESMTP id f6CDOqr28360 for ; Thu, 12 Jul 2001 09:24:52 -0400 (EDT) Subject: shared memory size From: Wei Weng To: pgsql-sql@postgresql.org Content-Type: text/plain X-Mailer: Evolution/0.10 (Preview Release) Date: 12 Jul 2001 10:30:42 -0400 Message-Id: <994948253.2949.1.camel@Monet> Mime-Version: 1.0 X-Archive-Number: 200107/156 X-Sequence-Number: 3948 Will increasing kernel shared memory size (in linux by doing "echo 134217728 >/proc/sys/kernel/shmall; echo 134217728 >/proc/sys/kernel/shmmax) help with the speed of a complicated query with a large return set? (average 20000 or more entries in return) Thanks -- Wei Weng Network Software Engineer KenCast Inc.