Yes, Here's the results table
name | setting | unit | category |
short_desc | ex
tra_desc | context | vartype | source | min_val |
max_val
---------------------------------+-----------+------+------------
+--------------
------------------------------------------------------------------------
----+---
---------+------------+---------+--------------------+-----------
+------------
autovacuum | on | | Autovacuum |
Starts the au
tovacuum
subprocess. |
| sighup | bool | configuration file | |
autovacuum_analyze_scale_factor | 0.1 | | Autovacuum |
Number of tup
le inserts, updates or deletes prior to analyze as a fraction of
reltuples. |
| sighup | real | configuration file | 0 | 100
autovacuum_analyze_threshold | 250 | | Autovacuum |
Minimum numbe
r of tuple inserts, updates or deletes prior to
analyze. |
| sighup | integer | configuration file | 0 |
2147483647
autovacuum_freeze_max_age | 200000000 | | Autovacuum | Age
at which
to autovacuum a table to prevent transaction ID
wraparound. |
| postmaster | integer | default | 100000000 |
2000000000
autovacuum_naptime | 30 | s | Autovacuum |
Time to sleep
between autovacuum runs, in
seconds. |
| sighup | integer | configuration file | 1 |
2147483647
autovacuum_vacuum_cost_delay | -1 | ms | Autovacuum |
Vacuum cost d
elay in milliseconds, for
autovacuum. |
| sighup | integer | configuration file | -1 | 1000
autovacuum_vacuum_cost_limit | -1 | | Autovacuum |
Vacuum cost a
mount available before napping, for
autovacuum. |
| sighup | integer | default | -1 |
10000
autovacuum_vacuum_scale_factor | 0.2 | | Autovacuum |
Number of tup
le updates or deletes prior to vacuum as a fraction of
reltuples. |
| sighup | real | configuration file | 0 | 100
autovacuum_vacuum_threshold | 500 | | Autovacuum |
Minimum numbe
r of tuple updates or deletes prior to
vacuum. |
| sighup | integer | configuration file | 0 |
2147483647
(9 rows)
Got lots more data with that command. ;-)
Carol Walter
On Apr 19, 2007, at 5:35 PM, Alvaro Herrera wrote:
Carol Walter wrote:
I'm not sure if we've done a reload. I'm in an academic environment
and our department is in a state of flux right now. I'm in the
process of trying to get up to speed on postgreSQL as fast as I can.
Here is the result set from that query.
select * from pg_settings where name = 'autovacuum';
Actually could you please try
select * from pg_settings where name like 'autovacuum%';
so that all the other settings show up as well?
--
Alvaro Herrera http://
www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
---------------------------(end of
broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
