---------- Forwarded message ---------- From: Joey K. <[EMAIL PROTECTED]> Date: Wed, Mar 26, 2008 at 9:42 AM Subject: Re: [GENERAL] Survey: renaming/removing script binaries (createdb, createuser...) To: Zdeněk Kotala <[EMAIL PROTECTED]>
Please let us know your meaning, > > thanks Zdenek Kotala > > > 1) What type of names do you prefer? > ------------------------------- > > a) old notation - createdb, createuser ... > b) new one with pg_ prefix - pg_createdb, pg_creteuser ... > c) new one with pg prefix - pgcreatedb, pgcreateuser ... > d) remove them - psql is the solution > e) remove them - pgadmin is the solution > [b] > > > 2) How often do you use these tools? > ----------------------------------- > > a) every day (e.g. in my cron) > b) one per week > c) one time > d) never > [a] In cron from commandline. in shell scripts > > 3) What name of initdb do you prefer? > ---------- -------------------------- > > a) initdb > b) pg_initdb > c) pg_init > d) pg_ctl -d <dir> init (replace initdb with pg_ctl new functionality) > e) What is initdb? My start/stop script does it automatically. > [c] > > 4) How do you perform VACUUM? > ----------------------------- > > a) vacuumdb - shell command > b) VACUUM - SQL command > c) autovacuum > d) What is vacuum? > [a], [b] and [c] Depending on the situation. For example ifcustomers complain, we manually do cia SQL. If this is a consistent problem, we usr cron for vacuumdb. If the database is not too loaded and supports autovacuum, we also have autovacuum enabled. We'd like to keep vacuumdb but maybe pg_vacuumdb? Hope this helps. Joey
