Skip site navigation (1) Skip section navigation (2)

Re: Indices arent being used

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 (view raw or flat)
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?

In response to

pgsql-performance by date

Next:From: Josh BerkusDate: 2003-09-26 03:41:15
Subject: Re: TPC-R benchmarks
Previous:From: rantunesDate: 2003-09-25 22:28:40
Subject: Indices arent being used

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group