On Sun, 2004-08-29 at 15:38, Scott Marlowe wrote: > On Sun, 2004-08-29 at 15:12, Greg Stark wrote: > > "Scott Marlowe" <[EMAIL PROTECTED]> writes: > > > > > Also, count(*) is likely to always generate a seq scan due to the way > > > aggregates are implemented currently in pgsql. you might want to try: > > > > Huh? I'm curious to know what you're talking about here. > > This has been discussed ad infinitum on the lists in the past. And > explained by better minds than mine, but I'll give it a go. > > PostgreSQL has a "generic" aggregate method. Imagine instead doing a > select count(id1+id2-id3) from table where ...
that should be avg(id1+id2-id3)... doh ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match