If your tables are read-only (which it kind of sounds like), you could
abstract out the reload mechanism, use the current implementation for
the in-memory databases, and use a combination of watching the CSV
files (e.g., through inotify on Linux) and TRUNCATE / COPY in
PostgreSQL. I think how well this will work will really depend on what
you're doing with the system, but it could be worth a shot.
---
Maciek Sakrejda | System Architect | Truviso
1065 E. Hillsdale Blvd., Suite 215
Foster City, CA 94404
(650) 242-3500 Main
www.truviso.com
