On Feb 11, 2004, at 7:23 AM, alemon@tiago.hazor.com.br wrote:
>
>
> my data base is very slow. The machine is a processor Xeon 2GB with
> 256 MB of RAM DDR. My archive of configuration is this:
>
After looking through the configuration some more, I would definitely
recommend getting rid of your current postgresql.conf file and
replacing it with the default. You have some very very odd settings,
namely:
This is dangerous, but maybe you need it:
fsync = false
You've essentially disabled the optimizer:
enable_seqscan = false
enable_indexscan = false
enable_tidscan = false
enable_sort = false
enable_nestloop = false
enable_mergejoin = false
enable_hashjoin = false
WOAH, this is huge:
random_page_cost = 1000000000
Take a look at this page which goes through each option in the
configuration file:
http://www.varlena.com/varlena/GeneralBits/Tidbits/annotated_conf_e.html
--
PC Drew
Manager, Dominet
IBSN
1600 Broadway, Suite 400
Denver, CO 80202
Phone: 303-984-4727 x107
Cell: 720-841-4543
Fax: 303-984-4730
Email: drewpc@ibsncentral.com