How does a user know about techdocs.postgresql.org?
| От | Barry Lind |
|---|---|
| Тема | How does a user know about techdocs.postgresql.org? |
| Дата | |
| Msg-id | 3BB23C50.509@xythos.com обсуждение исходный текст |
| Ответ на | Re: postgresql.conf ("Mihai Gheorghiu" <tanethq@earthlink.net>) |
| Ответы |
Re: How does a user know about techdocs.postgresql.org?
Re: How does a user know about techdocs.postgresql.org? |
| Список | 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. >
В списке pgsql-general по дате отправления: