Changes
Jump to navigation
Jump to search
Working with PostgreSQL (view source)
Revision as of 14:43, 22 February 2011
, 14:43, 22 February 2011no edit summary
There is a [http://www.postgresql.org/docs/7.3/static/reference-client.html list of commands/client applications], with links to documentation, which is useful.
You will almost surely want to 'performance tune' your postgresql database, as the default settings are near useless. In particular edit postgresql.conf (which is in the data directory of your install) to change:
shared_buffers = 512MB #Use about 10-15% of available RAM
effective_cache_size = 2GB #Use a large chunk of available RAM
Then restart the server:
pg_ctl restart
Create a user using pgAdmin or the createuser command:
