| 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:28:15 |
| Message-ID: | 874D01B5-5C9E-11D8-8191-000A95EA00C0@ibsncentral.com |
| Views: | Whole Thread | Raw Message | 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:
> #
> # 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(at)ibsncentral(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | PC Drew | 2004-02-11 14:44:42 | Re: slow database |
| Previous Message | Dennis Bjorklund | 2004-02-11 14:27:09 | Re: slow database |