On Feb 11, 2004, at 7:23 AM, [EMAIL PROTECTED] 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: [EMAIL PROTECTED]
---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly