Tom,
You nailed it. The t1 table was using 9600 relpages versus 410 after the
vacuum full. The two databases are now showing similar execution plans and
times.
Thanks for your help. It is greatly appreciated.
Doug Eck
- Original Message
From: Tom Lane <[EMAIL PROTECTED]&
e
from
t1,
t2
where
t2.eff_dt = current_date
and t1.active = true
and t1.bn = t2.sn;
Thanks.
- Original Message
From: Tom Lane <[EMAIL PROTECTED]>
To: Doug Eck <[EMAIL PROTECTED]>
Cc: pgsql-performance@postgresql.org
Sent: Monday, September 29, 2008 11:42:01 AM
I have two identical databases that run the same query each morning. Starting
this morning, something caused the first db to start using a different
execution plan for the query, resulting in much worse performance. I've have
tried several things this morning, but I am currently stumped on wha
- Original Message
From: Merlin Moncure <[EMAIL PROTECTED]>
To: Doug Eck <[EMAIL PROTECTED]>
Cc: pgsql-performance@postgresql.org
Sent: Wednesday, May 14, 2008 3:38:23 PM
Subject: Re: [PERFORM] I/O on select count(*)
On Wed, May 14, 2008 at 4:09 PM, Doug Eck <[EMAIL PR
I have a large table (~ 2B rows) that contains an indexed timestamp column. I
am attempting to run a query to determine the number of rows for a given day
using something like "select count(*) from tbl1 where ts between '2008-05-12
00:00:00.000' and '2008-05-12 23:59:59.999'". Explain tells me
