Обсуждение: Statistics
<p><font size="2">In the postgresql.conf file there is the option for statistics. Where are the statistics posted or recordedat?</font><br /><p><font size="2">Thank you,</font><p><font size="2">Ray Hunter</font><br /><font size="2">FirmwareEngineer</font><p><font size="2">ENTERASYS NETWORKS</font><p><font size="2">Internal: 53888</font><br/><font size="2">External: 801 887-9888</font><br /><font size="2">Email: rhunter@enterasys.com</font><br/><font size="2">www: www.enterasys.com</font><br />
Hunter, Ray wrote: > In the postgresql.conf file there is the option for statistics. Where are > the statistics posted or recorded at? They appear in system tables pg_stat*. -- 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, Pennsylvania19026
<p><font size="2">Is there some additional documentation of configuring the postgresql.conf file?</font><br /><br /><p><fontsize="2">Thank you,</font><p><font size="2">Ray Hunter</font><br /><font size="2">Firmware Engineer</font><p><fontsize="2">ENTERASYS NETWORKS</font><br /><p><font size="2">> -----Original Message-----</font><br/><font size="2">> From: Bruce Momjian [<a href="mailto:pgman@candle.pha.pa.us">mailto:pgman@candle.pha.pa.us</a>]</font><br /><font size="2">> Sent: Monday, April01, 2002 9:24 AM</font><br /><font size="2">> To: Hunter, Ray</font><br /><font size="2">> Cc: pgsql-sql@postgresql.org</font><br/><font size="2">> Subject: Re: [SQL] Statistics</font><br /><font size="2">> </font><br/><font size="2">> </font><br /><font size="2">> Hunter, Ray wrote:</font><br /><font size="2">> >In the postgresql.conf file there is the option for </font><br /><font size="2">> statistics. Where </font><br /><fontsize="2">> > are the statistics posted or recorded at?</font><br /><font size="2">> </font><br /><font size="2">>They appear in system tables pg_stat*.</font><br /><font size="2">> </font><br /><font size="2">> -- </font><br/><font size="2">> Bruce Momjian | <a href="http://candle.pha.pa.us" target="_blank">http://candle.pha.pa.us</a></font><br/><font size="2">> pgman@candle.pha.pa.us | (610)853-3000</font><br /><font size="2">> + If your life is a hard drive, | 830 Blythe Avenue</font><br /><fontsize="2">> + Christ can be your backup. | Drexel Hill, </font><br /><font size="2">> Pennsylvania19026</font><br /><font size="2">> </font>
chapter 3.4 "Runtime configuration" from the Administrator's Guide (http://www.ca.postgresql.org/users-lounge/docs/#7.2) describes the parameters in the postgresql.conf file
hth,
Marin
----
"...what you brought from your past, is of no use in your present. When
you must choose a new path, do not bring old experiences with you.
Those who strike out afresh, but who attempt to retain a little of the
old life, end up torn apart by their own memories. "
----- Original Message -----From: Hunter, RayTo: 'Bruce Momjian'Sent: Monday, April 01, 2002 19:25Subject: Re: [SQL] StatisticsIs there some additional documentation of configuring the postgresql.conf file?