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..
----- Original Message -----
From: "sathya priya" <mscsathya(at)yahoo(dot)com>
Sent: Saturday, July 22, 2000 4:34 AM
Subject: [SQL] query optimazation & starting postmaster with -B option
> 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
> 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!
In response to
pgsql-sql by date
|Next:||From: Robert B. Easter||Date: 2000-07-24 05:15:00|
|Subject: Is there any way to speed up PL/TCL functions?|
|Previous:||From: Jan Wieck||Date: 2000-07-22 09:11:51|
|Subject: Re: create function - user permissions|