| From: | Andrew Sullivan <ajs(at)crankycanuck(dot)ca> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: index not being used. Why? |
| Date: | 2007-03-09 16:02:11 |
| Message-ID: | 20070309160211.GA24502@phlogiston.dyndns.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-sql |
On Fri, Mar 09, 2007 at 12:01:30PM -0300, Gerardo Herzig wrote:
> Hi all. I have this 2 relations
How big are they?
> -> Hash (cost=9.08..9.08 rows=408 width=55)
> -> Seq Scan on pages (cost=0.00..9.08 rows=408 width=55)
The planner thinks it will get 408 rows. How big a percentage of the
table is that?
Also, what does EXPLAIN ANALYSE say about this?
A
--
Andrew Sullivan | ajs(at)crankycanuck(dot)ca
If they don't do anything, we don't need their acronym.
--Josh Hamilton, on the US FEMA
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2007-03-09 16:27:56 | Re: Pg_dump and bytaA |
| Previous Message | Richard Huxton | 2007-03-09 15:59:48 | Re: index not being used. Why? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2007-03-09 16:29:26 | Re: index not being used. Why? |
| Previous Message | Richard Huxton | 2007-03-09 15:59:48 | Re: index not being used. Why? |