You can suck the Pg table into a DBD::AnyData in-memory table and cache it. You can then use SQL to query or modify the cache without going back to Pg. Pair Networks (our kind host) uses this method for some of their sites. Dan Wright from Pair will be giving a talk on this at YAPC N.A. If you want to try it and have questions, let me know.