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

Re: When are index scans used over seq scans?

From: Richard van den Berg <richard(dot)vandenberg(at)trust-factory(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-perform <pgsql-performance(at)postgresql(dot)org>
Subject: Re: When are index scans used over seq scans?
Date: 2005-04-22 09:04:17
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
Tom Lane wrote:
> Are the tables in question particularly wide (many columns)?

Yes they are. They both have 20 columns. If I cut down the duration
table to just 1 column of timestamps, the planner uses the index.

Interesting, so I could store just the timestamps in another table (view
doesn't help) to speed up this query.

I am using the debian package. How can I tell if profiling is enabled?

Thanks a lot,

Richard van den Berg, CISSP
Trust Factory B.V. |
Bazarstraat 44a    |
2518AK The Hague   |  Phone: +31 70 3620684
The Netherlands    |  Fax  : +31 70 3603009

In response to

pgsql-performance by date

Next:From: Andreas PflugDate: 2005-04-22 09:47:31
Subject: Re: Joel's Performance Issues WAS : Opteron vs Xeon
Previous:From: David RousselDate: 2005-04-22 08:44:05
Subject: Re: Index bloat problem?

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