> 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
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?
In response to
pgsql-performance by date
|Next:||From: Josh Berkus||Date: 2003-09-26 03:41:15|
|Subject: Re: TPC-R benchmarks|
|Previous:||From: rantunes||Date: 2003-09-25 22:28:40|
|Subject: Indices arent being used|