[EMAIL PROTECTED] - 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 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly