Skip site navigation (1) Skip section navigation (2)

Re: slow database

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 (view raw or flat)
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


In response to

pgsql-performance by date

Next:From: Rod TaylorDate: 2004-02-11 14:49:26
Subject: Re: slow database
Previous:From: PC DrewDate: 2004-02-11 14:28:15
Subject: Re: slow database

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group