Hi all, I just wanted to share our experience with pmacct pushing netflow stuff to a Postgresql DB (9.2). By default the pmacct pgsql schemas use char(xxx) fields (for BGP stuff like AS, AS pathes, etc). After some readings, and some tests, it looks like replacing every char(xx) by text type makes queries really faster; maybe it just makes them use much less memory, claiming less workspace, avoiding to write anything to disk. Anyway, it's now quite faster like that (it appears that internally, char, varchar & text are stored the same way in pgsql, just padding char fields with whitespaces).
Just my 2 cents. regards, Olivier _______________________________________________ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists
