From: | PC Drew <drewpc(at)ibsncentral(dot)com> |
---|---|
To: | alemon(at)tiago(dot)hazor(dot)com(dot)br |
Cc: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: slow database |
Date: | 2004-02-11 14:44:42 |
Message-ID: | D40408DB-5CA0-11D8-8191-000A95EA00C0@ibsncentral.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
On Feb 11, 2004, at 7:23 AM, alemon(at)tiago(dot)hazor(dot)com(dot)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(at)ibsncentral(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Rod Taylor | 2004-02-11 14:49:26 | Re: slow database |
Previous Message | PC Drew | 2004-02-11 14:28:15 | Re: slow database |