pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedquery optimazation & starting postmaster with -B option
2+ messages / 2 participants
[nested] [flat]
* query optimazation & starting postmaster with -B option
@ 2000-07-22 08:34 sathya priya <mscsathya@yahoo.com>
2000-07-22 22:41 ` Re: query optimazation & starting postmaster with -B option Mitch Vincent <mitch@venux.net>
0 siblings, 1 reply; 2+ messages in thread
From: sathya priya @ 2000-07-22 08:34 UTC (permalink / raw)
To: pgsql-sql
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/
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: query optimazation & starting postmaster with -B option
2000-07-22 08:34 query optimazation & starting postmaster with -B option sathya priya <mscsathya@yahoo.com>
@ 2000-07-22 22:41 ` Mitch Vincent <mitch@venux.net>
0 siblings, 0 replies; 2+ messages in thread
From: Mitch Vincent @ 2000-07-22 22:41 UTC (permalink / raw)
To: sathya priya <mscsathya@yahoo.com>; 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@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/
>
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2000-07-22 22:41 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-07-22 08:34 query optimazation & starting postmaster with -B option sathya priya <mscsathya@yahoo.com>
2000-07-22 22:41 ` Mitch Vincent <mitch@venux.net>
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