-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:
- Seq Scan
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 JOIN using aliases
Neil Conway wrote:
Keith
-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 via a
cron job. In my ignorance I
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
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
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:
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