Re: 4 way JOIN using aliases

From: Neil Conway <neilc(at)samurai(dot)com>
To: KeithW(at)narrowpathinc(dot)com
Cc: PostgreSQL Perform <pgsql-performance(at)postgresql(dot)org>
Subject: Re: 4 way JOIN using aliases
Date: 2005-04-11 01:55:06
Message-ID: 4259D8FA.9060307@samurai.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Don Drake 2005-04-11 03:16:30 Server crashing
Previous Message Josh Berkus 2005-04-11 01:41:05 Re: 4 way JOIN using aliases