Postgres Pro
Downloads
Home   >   mailing lists

Re: 4 way JOIN using aliases - Mailing list pgsql-performance

From Neil Conway
Subject Re: 4 way JOIN using aliases
Date
Msg-id 4259D8FA.9060307@samurai.com
Whole thread Raw
In response to 4 way JOIN using aliases  ("Keith Worthington" <keithw@narrowpathinc.com>)
Responses Re: 4 way JOIN using aliases
List pgsql-performance
Tree view 
Keith Worthington wrote:
>               ->  Seq Scan on tbl_current  (cost=0.00..1775.57 rows=76457
> width=31) (actual time=22.870..25.024 rows=605 loops=1)

This rowcount is way off -- have you run ANALYZE recently?

-Neil

pgsql-performance by date:

Previous
From: Josh Berkus
Date:
Subject: Re: 4 way JOIN using aliases
Next
From: Don Drake
Date:
Subject: Server crashing