postgresql.conf

On Tuesday 25 September 2001 11:34 am, Mihai Gheorghiu wrote:

I installed PG from RPMs. postgresql.conf comes with all options commented
out.
What are the defaults? PG works anyway (Well... I know... -i etc.)
Thank you all.

All options commented out is the installation default of a from-source
install as well as the RPM install. The default values for the various
paramters are commented inside the file, IIRC.

Use tcpip_socket=true instead of -i....

I made the conscious decision to ship the default postgresql.conf -- what
optimizations should I make? I can't make generalized optimizations -- so I
ship the default file.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11

Thank you very much.
Actually, it was the optimization parameters that I was interested in. My db
works rather slow even in single user mode and I wondered if I had missed
some setup. BTW, is there a way to see what parameters are in effect?

-----Original Message-----
From: Lamar Owen <lamar.owen@wgcr.org>
To: Mihai Gheorghiu <tanethq@earthlink.net>; pgsql-general@postgresql.org
<pgsql-general@postgresql.org>
Date: Tuesday, September 25, 2001 8:30 PM
Subject: Re: [GENERAL] postgresql.conf

On Tuesday 25 September 2001 11:34 am, Mihai Gheorghiu wrote:

I installed PG from RPMs. postgresql.conf comes with all options

commented

out.
What are the defaults? PG works anyway (Well... I know... -i etc.)
Thank you all.

All options commented out is the installation default of a from-source
install as well as the RPM install. The default values for the various
paramters are commented inside the file, IIRC.

Use tcpip_socket=true instead of -i....

I made the conscious decision to ship the default postgresql.conf -- what
optimizations should I make? I can't make generalized optimizations -- so

I

On Wednesday 26 September 2001 09:29 am, Mihai Gheorghiu wrote:

Thank you very much.
Actually, it was the optimization parameters that I was interested in. My
db works rather slow even in single user mode and I wondered if I had
missed some setup.

See Bruce's Performance article, which is linked to from
techdocs.postgresql.org. But, the direct link is
http://candle.pha.pa.us/main/writings/pgsql/hw_performance/index.html

Even though it discusses hardware performance tuning, sizing the shared
buffer cache and the sort size is also discussed.

BTW, is there a way to see what parameters are in
effect?

See
http://www.postgresql.org/users-lounge/docs/7.1/admin/runtime-config.html for
the basics.

From a psql session you can show any runtime parameter that is set by using
the SQL 'SHOW' command. For instance, using SHOW tcpip_socket; from a psql
session I can get:
template1=# show tcpip_socket;
NOTICE: tcpip_socket is off
SHOW VARIABLE
template1=#

Or even:
template1=# show shared_buffers;
NOTICE: shared_buffers is 64
SHOW VARIABLE
template1=#

Use the listing in the administrator's guide (the link above) to see a
listing of the possible paramters, and then SHOW that parameter to see what
you want to see.

Although SHOW should have a way of listing ALL settings, IMHO.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11

This may sound like a strange question, but how does a postgres user
know of the existence of techdocs.postgresql.org? I would have assumed
that there would be a link off of the main web site under Users Corner
to this useful repository of information, but I can't find any such
link. Without such a link, how does a user find out that techdocs
exists? Other than posting an email and getting a response that says to
look there.

thanks,
--Barry

Lamar Owen wrote:

It *is* a little tough to stumble onto- it's the "Non-FAQ Documentation"
link from the User's Lounge. labeling it something like "3rd-party and
contributed DOCS" might help...

-Nick

On Wednesday 26 September 2001 04:36 pm, Barry Lind wrote:

This may sound like a strange question, but how does a postgres user
know of the existence of techdocs.postgresql.org? I would have assumed
that there would be a link off of the main web site under Users Corner
to this useful repository of information, but I can't find any such
link. Without such a link, how does a user find out that techdocs
exists? Other than posting an email and getting a response that says to
look there.

User Lounger -> Non-FAQ Documentation.

--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11

Use the listing in the administrator's guide (the link above) to see a
listing of the possible paramters, and then SHOW that parameter to see what
you want to see.

Although SHOW should have a way of listing ALL settings, IMHO.

Sure does, "SHOW ALL", new in 7.2.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

On Friday 28 September 2001 03:23 pm, Bruce Momjian wrote:

Although SHOW should have a way of listing ALL settings, IMHO.

Sure does, "SHOW ALL", new in 7.2.

It figures. Day late and a dollar short, that am I.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11