Re: Large # of rows in query extremely slow, not using

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Stephen Crowley <stephen(dot)crowley(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Large # of rows in query extremely slow, not using
Date: 2004-09-17 17:40:18
Message-ID: 200409171040.18830.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Stephen,

> " -> Seq Scan on island_history (cost=0.00..417867.13 rows=292274
> width=83) (actual time=346759.000..346759.000 rows=10 loops=1)"

Take a look at your row comparisons. When was the last time you ran ANALYZE?

--
Josh Berkus
Aglio Database Solutions
San Francisco

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Mischa Sandberg 2004-09-17 19:23:08 Tryint to match Solaris-Oracle performance with directio?
Previous Message Simon Riggs 2004-09-17 07:39:10 Re: Data Warehouse Reevaluation - MySQL vs Postgres --