| From: | Rod Taylor <rbt(at)rbt(dot)ca> |
|---|---|
| To: | rantunes(at)student(dot)dei(dot)uc(dot)pt |
| Cc: | Postgresql Performance <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Indices arent being used |
| Date: | 2003-09-25 23:46:41 |
| Message-ID: | 1064533600.27395.6.camel@jester |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
> Im running a Datawarehouse benchmark (APB-1) on PostgreSql. The objective is to
> choose which of the to main db (PostgreSQL, MySQL) is fastest. I've run into a
> small problem which I hope could be resolved here.
>
> I'm trying to speed up this query:
>
> select count(*) from actvars, prodlevel where
> actvars.product_level=prodlevel.code_level and
> prodlevel.division_level='OY3S5LAPALL6';
How about EXPLAIN ANALYZE output?
> ACTVARS is a fact table of aproximatly 16 million rows, PRODLEVEL has 20700
> rows. Both have btree indices.
> The database has been vacuumed and analyze has been executed.
The usual postgresql.conf adjustments have also been made?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Berkus | 2003-09-26 03:41:15 | Re: TPC-R benchmarks |
| Previous Message | rantunes | 2003-09-25 22:28:40 | Indices arent being used |