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:
> 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.
>