Received: from web1902.mail.yahoo.com (web1902.mail.yahoo.com [128.11.23.51]) by hub.org (8.10.1/8.10.1) with SMTP id e6M8VXh04562 for ; Sat, 22 Jul 2000 04:31:33 -0400 (EDT) Received: (qmail 16543 invoked by uid 60001); 22 Jul 2000 08:34:03 -0000 Message-ID: <20000722083403.16542.qmail@web1902.mail.yahoo.com> Received: from [203.199.224.251] by web1902.mail.yahoo.com; Sat, 22 Jul 2000 01:34:03 PDT Date: Sat, 22 Jul 2000 01:34:03 -0700 (PDT) From: sathya priya Subject: query optimazation & starting postmaster with -B option To: pgsql-sql@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Archive-Number: 200007/221 hai, Q 1 : Posgresql is running on Linux machine with 512MB ram. My question is When i start the postmaster with -B 3000 then there is no problem. If the start the postmaster with more than the 3000 then errors msg is popped out. How do I increase this buffer option morethan 3000 and what are things to be considered before doing this Q 2: postmaster with -N option. doc says 32 connection is default . I need more than that 32 connection. Before increase this connection to 100 what things (like memory,processor speed .. etc ) we have to take consideration. Q3 : If i increase the -B more than 3000 then will postgresql execute the query very fast thanks advance. kind regds. p. ashok kumar __________________________________________________ Do You Yahoo!? Get Yahoo! Mail – Free email you can access from anywhere! http://mail.yahoo.com/