Re: database performance and query performance question

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: "Shea,Dan [CIS]" <Dan(dot)Shea(at)ec(dot)gc(dot)ca>
Cc: "'pgsql-performance(at)postgresql(dot)org'" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: database performance and query performance question
Date: 2004-01-22 21:52:38
Message-ID: 200401221352.38351.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Dan,

Of course it took forever. You're retrieving 2.9 million rows!

> Index Scan using forecastelement_v_idx on forecastelement
> (cost=0.00..832139.81 rows=2523119 width=129) (actual time=0.519..467159.658
> rows=2940600 loops=1)

--
-Josh Berkus
Aglio Database Solutions
San Francisco

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Hannu Krosing 2004-01-22 23:38:37 Re: database performance and query performance question
Previous Message Shea,Dan [CIS] 2004-01-22 21:32:28 Re: database performance and query performance question