Stop postgres writing to pgstat.tmp :: how disable / to verify that postgres statistics are correctly disabled

Поиск
Список
Период
Сортировка
От Ceriel Jacobs
Тема Stop postgres writing to pgstat.tmp :: how disable / to verify that postgres statistics are correctly disabled
Дата
Msg-id D4A27036-87C0-466C-B157-9E2F0042F61B@gmail.com
обсуждение исходный текст
Список pgsql-admin
In the search to speed up the slow generate_tiles.py script (~ 37
tiles per minute) that connects with a postgresql 8.3.5 database on
Mac OS X 10.5.6 installed via macports, I found out with 'iofileb.d' &
'iofile.d' that much disk i/o was used by writing to /global/pgstat.tmp.

Now I disabled statistics (I think) by changing /opt/local/var/db/
postgresql83/defaultdb/postgresql.conf while the postgres daemon was
being stopped:
#track_activities = on
track_activities = off
#track_counts = on
track_counts = off
#update_process_title = on
update_process_title = off

After (re)starting postgres daemon, there is a major speed improvement
(> 575 tiles / minute), but still some statistics writing is being done:
$ sudo iofileb.d
Password:
Tracing... Hit Ctrl-C to end.
^C
   PID CMD              KB FILE
   100 perl              4 ??/webmin/miniserv.pid #webmin
  1030 Python            4 ??/33481/21874.png
  1030 Python            4 ??/33481/21876.png
  1030 Python            4 ??/33481/21878.png
  1030 Python            4 ??/33481/21879.png
  1030 Python            4 ??/33481/21880.png
  1030 Python            4 ??/33481/21881.png
  1030 Python            4 ??/33481/21882.png
  1030 Python            4 ??/33481/21883.png
  1030 Python            4 ??/33481/21884.png
  1030 Python            4 ??/33481/21885.png
  1030 Python            4 ??/33481/21886.png
  1030 Python            4 ??/33481/21887.png
  1030 Python            4 ??/33481/21888.png
  1030 Python            4 ??/33481/21889.png
  1030 Python            4 ??/33481/21890.png
  1030 Python            4 ??/33481/21891.png
  1030 Python            4 ??/33481/21892.png
  1030 Python            4 ??/33481/21893.png
  1030 Python            4 ??/33481/21894.png
  1030 Python            4 ??/33481/21895.png
  1030 Python            4 ??/33481/21896.png
  1030 Python            4 ??/33481/21897.png
  1030 Python            4 ??/33481/21898.png
  1030 Python            4 ??/33481/21899.png
  1030 Python            4 ??/33481/21900.png
  1030 Python            4 ??/33481/21901.png
  1030 Python            4 ??/33481/21902.png
  1030 Python            8 ??/33481/21875.png
  1030 Python            8 ??/33481/21877.png
  1025 postgres        168 ??/global/pgstat.tmp

= 124KB for images versus 168KB for postgres in this (short) period of
time.

Questions:
1. How  can I verify that I edited the correct postgresql.conf file,
in other words how can I verify which postgresql.conf file is used by
MacPorts daemon?

I would say by checking the process tree, and check which data
directory is specified:
   103     postgres     /opt/local/lib/postgresql83/bin/postgres -D /opt/
local/var/db/postgresql83/defaultdb
      105     postgres     postgres: writer process
      106     postgres     postgres: wal writer process
      107     postgres     postgres: autovacuum launcher process
      108     postgres     postgres: stats collector process
      259     postgres     postgres: postgres gis [local] idle

2. Is it correct to think that when disabling statistics in
postgresql.conf, no pgstat.tmp should be written to, or are more
actions required?

3. Or should I restart the server machine before these 'disabling
statistics' changes become effective in postgres server?

~Ceriel


В списке pgsql-admin по дате отправления:

Предыдущее
От: John Lister
Дата:
Сообщение: Re: database corruption help
Следующее
От: Roger Ging
Дата:
Сообщение: Vacuum wait time problem