Skip site navigation (1) Skip section navigation (2)

Re: query optimazation & starting postmaster with -B option

From: "Mitch Vincent" <mitch(at)venux(dot)net>
To: "sathya priya" <mscsathya(at)yahoo(dot)com>, <pgsql-sql(at)postgresql(dot)org>
Subject: Re: query optimazation & starting postmaster with -B option
Date: 2000-07-22 22:41:43
Message-ID: 008a01bff42e$028225e0$4100000a@doot (view raw or flat)
Thread:
Lists: pgsql-sql
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(at)yahoo(dot)com>
To: <pgsql-sql(at)postgresql(dot)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/
>


In response to

pgsql-sql by date

Next:From: Robert B. EasterDate: 2000-07-24 05:15:00
Subject: Is there any way to speed up PL/TCL functions?
Previous:From: Jan WieckDate: 2000-07-22 09:11:51
Subject: Re: create function - user permissions

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group