Re: slow database - Mailing list pgsql-performance

From PC Drew
Subject Re: slow database
Date
Msg-id 874D01B5-5C9E-11D8-8191-000A95EA00C0@ibsncentral.com
Whole thread Raw
In response to slow database  (alemon@tiago.hazor.com.br)
List pgsql-performance
On Feb 11, 2004, at 7:23 AM, alemon@tiago.hazor.com.br wrote:

> #
> #       Optimizer Parameters
> #
> enable_seqscan = false
> enable_indexscan = false
> enable_tidscan = false
> enable_sort = false
> enable_nestloop = false
> enable_mergejoin = false
> enable_hashjoin = false
>

Why did you disable *every* type of query method?  Try commenting all
of these out or changing them to "true" instead of "false".

--
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


pgsql-performance by date:

Previous
From: Dennis Bjorklund
Date:
Subject: Re: slow database
Next
From: PC Drew
Date:
Subject: Re: slow database