[kjelle(at)bingon(dot)no - Tue at 08:33:58PM +0200]
> I use FreeBSD 4.11 with PostGreSQL 7.3.8.
> database=> explain select date_trunc('hour', time),count(*) as total from
> test where p1=53 and time > now() - interval '24 hours' group by
> date_trunc order by date_trunc ;
I haven't looked through all your email yet, but this phenomena have been up
at the list a couple of times. Try replacing "now() - interval '24 hours'"
with a fixed time stamp, and see if it helps.
pg7 will plan the query without knowledge of what "now() - interval '24
hours'" will compute to. This should be fixed in pg8.
Tobias Brox, +86-13521622905
Nordicbet, IT dept
In response to
pgsql-performance by date
|Next:||From: Tom Lane||Date: 2005-06-28 06:18:44|
|Subject: Re: How are text columns stored? |
|Previous:||From: Tom Lane||Date: 2005-06-28 05:53:26|
|Subject: Re: perl garbage collector |