I'm designing a system that will be doing over a million inserts/deletes
on a single table every hour. Rather than using a single table, it is
possible for me to partition the data into multiple tables if I wanted
to, which would be nice because I can just truncate them when I don't
need the
Hi all, I've run into an issue with a Pg 7.4.6 to 8.1.5 upgrade along
with hardware upgrade.
I moved the database from a 2x 3.0ghz Xeon (512kb w/HT) to a 2x Opteron
250. The database is in
memory on a tmpfs partition. (the application can rebuild the db during
total system failure)
When I fi
