Postgres Pro
Downloads
Home   >   mailing lists

Re: database performance and query performance question - Mailing list pgsql-performance

From Josh Berkus
Subject Re: database performance and query performance question
Date
Msg-id 200401221352.38351.josh@agliodbs.com
Whole thread Raw
In response to Re: database performance and query performance question  ("Shea,Dan [CIS]" <Dan.Shea@ec.gc.ca>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: "Shea,Dan [CIS]"
Date:
Subject: Re: database performance and query performance question
Next
From: Hannu Krosing
Date:
Subject: Re: database performance and query performance question