Thank you for your very quick response Chester. I guess I should clarify something. Knoppix is a version of linux that runs entirely in memory. I need as smallest footprint as possible.
Currently the datase is roughly 80 Megs. About half of the size is stored in pg_xlog directory. I managed to figure out that those files are transaction log files? How can I delete them safely? (after creatation the database will pretty much be read-only - any changes will be in memory only). Are there any other tricks I can use to get the size down? Please keep in mind that I work with a fairly new database - I'm always recreating it from a dump so only the initial inserts are in there, no changes or deletions. Vacuuming helps a bit, but nowhere near as much as I would hope. Greg Greg __________________________________ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
