> -Original Message-
> From: Keith Worthington [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, April 12, 2005 1:14 PM
> To: Dave Held; PostgreSQL Perform
> Subject: Re: [PERFORM] 4 way JOIN using aliases
>
> > > I run vacuumdb with the analyze option every morning vi
On Tue, 12 Apr 2005 08:41:55 -0500, Dave Held wrote
> > -Original Message-
> > From: Keith Worthington [mailto:[EMAIL PROTECTED]
> > Sent: Monday, April 11, 2005 7:44 PM
> > To: Neil Conway
> > Cc: PostgreSQL Perform
> > Subject: Re: [PERFORM] 4 way JOI
> -Original Message-
> From: Keith Worthington [mailto:[EMAIL PROTECTED]
> Sent: Monday, April 11, 2005 7:44 PM
> To: Neil Conway
> Cc: PostgreSQL Perform
> Subject: Re: [PERFORM] 4 way JOIN using aliases
>
> Neil Conway wrote:
> > Keith Worthington wrote:
&
Neil Conway wrote:
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
---(end of broadcast)--
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
---(end of broadcast)---
TIP 4:
Keith,
> Thanks to all on the NOVICE list that gave me help I now have a query
> running that returns the results I am after. :-) Now of course I want it
> to run faster. Currently it clocks in at ~160ms. I have checked over the
> indexes and I belive that the tables are indexed properly. The
Hi All,
Thanks to all on the NOVICE list that gave me help I now have a query running
that returns the results I am after. :-) Now of course I want it to run
faster. Currently it clocks in at ~160ms. I have checked over the indexes
and I belive that the tables are indexed properly. The largest