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: (view raw, whole thread or download thread mbox)
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, 

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:

PC Drew
Manager, Dominet

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-2017 The PostgreSQL Global Development Group