Andreas Hartmann wrote:
Dear PostgreSQL community,
first some info about our application:
- Online course directory for a University
- Amount of data: complete dump is 27 MB
- Semester is part of primary key in each table
- Data for approx. 10 semesters stored in the DB
- Read-only access from web application (JDBC)
Our client has asked us if the performance of the application could be
improved by moving the data from previous years to a separate "archive"
application.
If you had 27GB of data maybe, but you've only got 27MB - that's
presumably all sitting in memory.
What in particular is slow?
--
Richard Huxton
Archonet Ltd
