Ok, can someone explain to me why this first query might run faster than the second?
select src,dst,count(dst) from data; select src,dst,count(*) from data; I've always used the second form. If the first is faster, I need to know. Thanx, Mike Diehl, Network Monitoring Tool Devl. Sandia National Laboratories. (505) 284-3137 [EMAIL PROTECTED] > -----Original Message----- > From: Haller Christoph [mailto:[EMAIL PROTECTED]] > Sent: September 18, 2001 7:18 AM > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > Subject: Re: [SQL] Out of free buffers... HELP! > > > As long as there are no nulls allowed in column 'dst' the > select src,dst,count(dst) from ... > should retrieve the same result. > Try it. It should run faster anyway. > Maybe there are other ways to word your query, but without > more knowledge about your table structure and intentions > I can't tell you what. > Alternatively, you may want to report your error to the > [HACKERS] mailing list - there you might even find more > detailed support. > Regards, Christoph > > > > Hi all. > > > > I sent this once before, but didn't see it appear on the > list... So here we > > go again... > > > > I have a large query that I'm trying to run, but it never > finishes. I > > get an error message and it quits. > > > > I'm doing: > > > > psql ids -c 'select src,dst,count(*) from brick* where src_port=135 > > group by src,dst' > /tmp/135.dat > > > > and I get: > > > > ERROR: out of free buffers: time to abort ! > > > > Any ideas on how to get this query to run? > > > > Thanx, > > Mike Diehl. > > > > > > ---------------------------(end of > broadcast)--------------------------- > > TIP 1: subscribe and unsubscribe commands go to > [EMAIL PROTECTED] > > > > > ---------------------------(end of > broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to > [EMAIL PROTECTED]) > ---------------------------(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
