Re: [PERFORM] IP addresses, NetBlocks, and ASNs

e regarding the project, Steve. Thanks again! ------ Gary Warner Director of Research in Computer Forensics The University of Alabama at Birmingham Center for Information Assurance and Joint Forensics Research 205.422.2113 g...@cis.uab.edu --- - Or

[PERFORM] IP addresses, NetBlocks, and ASNs

that ... but I need a way to do "big aggregate queries" like "what were the most common ASNs in this whole log file?" or "how often does country XX occur in this log file?" -- Gary Warner Director of Research in Computer Forensics The Univers

[PERFORM] Seq Scan used instead of Index Scan

seem to beat the "combined query" index failure. The work-around has been to actually write code that makes the query for urlids, and then manually does the query into the table for message_ids, and then manually does the query for email.stuff. It's bad fast, but we can't figure out why 'the old way' quit working. Suggestions welcome! -- -- Gary Warner --- -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance

[PERFORM] "large" spam tables and performance: postgres memory parameters

ons within the web interface. The onsite researchers will bang the heck out of much larger datasets. (I'll let this thread run a bit, and then come back to ask questions about "vacuum analyze" and "partitioned tables" as a second and third round of questions.) -- --