pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Mitch Vincent <mitch@venux.net>
To: sathya priya <mscsathya@yahoo.com>
To: pgsql-sql@postgresql.org
Subject: Re: query optimazation & starting postmaster with -B option
Date: Sat, 22 Jul 2000 18:41:43 -0400
Message-ID: <008a01bff42e$028225e0$4100000a@doot> (raw)
References: <20000722083403.16542.qmail@web1902.mail.yahoo.com>

As I've found through countless trial and error and many emails to this
list, performance is mostly in how you structure queries and how you use the
backend (indexes, proper VACUUMing etc etc)..

Increasing the size passed as -S and -B options will help -- there is
probably much more that can be done if you can get specific with us about
your tables and what queries you're having trouble with..

Good luck!!

-Mitch

----- Original Message -----
From: "sathya priya" <mscsathya@yahoo.com>
To: <pgsql-sql@postgresql.org>
Sent: Saturday, July 22, 2000 4:34 AM
Subject: [SQL] query optimazation & starting postmaster with -B option


> 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/
>




view thread (2+ messages)

Message-ID: <008a01bff42e$028225e0$4100000a@doot>
Permalink:  ../008a01bff42e$028225e0$4100000a@doot/
Also on:    postgresql.org/message-id/008a01bff42e$028225e0$4100000a@doot

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: mitch@venux.net, mscsathya@yahoo.com
  Subject: Re: query optimazation & starting postmaster with -B option
  In-Reply-To: <008a01bff42e$028225e0$4100000a@doot>
  References: <20000722083403.16542.qmail@web1902.mail.yahoo.com> <008a01bff42e$028225e0$4100000a@doot>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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