From: | Barry Lind <barry(at)xythos(dot)com> |
---|---|
To: | Lamar Owen <lamar(dot)owen(at)wgcr(dot)org> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | How does a user know about techdocs.postgresql.org? |
Date: | 2001-09-26 20:36:32 |
Message-ID: | 3BB23C50.509@xythos.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
>
From | Date | Subject | |
---|---|---|---|
Next Message | Nick Fankhauser | 2001-09-26 21:33:59 | Re: How does a user know about techdocs.postgresql.org? |
Previous Message | Murray Hobbs | 2001-09-26 20:30:49 | Multibyte design issue |