Wietse Venema put forth on 11/24/2010 7:20 AM: > Stan Hoeppner: > [ Charset ISO-8859-1 unsupported, converting... ] >> Wietse Venema put forth on 11/24/2010 6:18 AM: >> >>> That's 0.5 seconds to read the table once, and milliseconds to query it. >> >> Is it? I must be misreading this then. But it sure looks like each >> query is taking over half a second. >> >> Table has 67669 CIDRs: >> >> [r...@greer]/etc/postfix/cidr_files$ time postmap -q 1.1.1.1 cidr:dnswl >> >> real 0m0.618s >> user 0m0.464s >> sys 0m0.064s > > You measure the TIME TO COMPILE PLUS TIME TO QUERY. That is not at > all representative for how Postfix daemon processes use the table. > > To SEPARATE the ONE-TIME COMPILE cost from the INCREMENTAL QUERY cost, > > time postmap -q 1.2.3.4 cidr:dnswl > time postmap -q - cidr:dnswl < A-VERY-LARGE-FILE > > and deduct one from the other.
Ah, ok, so my test method isn't correct. I'm having trouble digesting: > time postmap -q - cidr:dnswl < A-VERY-LARGE-FILE Is A-VERY-LARGE-FILE to be a long list of IP addresses to query against the table? -- Stan
