On Tue, Oct 14, 2008 at 5:08 PM, Rainer Mager <[EMAIL PROTECTED]> wrote:
> I have an interesting performance improvement need. As part of the automatic
> test suite we run in our development environment, we re-initialize our test
> database a number of times in order to ensure it is clean before ru
Rainer Mager wrote:
I have an interesting performance improvement need. As part of the
automatic test suite we run in our development environment, we
re-initialize our test database a number of times in order to ensure
it is clean before running a test. We currently do this by dropping
the p
I have an interesting performance improvement need. As part of the automatic
test suite we run in our development environment, we re-initialize our test
database a number of times in order to ensure it is clean before running a
test. We currently do this by dropping the public schema and then recre
>>> "Reuven M. Lerner" <[EMAIL PROTECTED]> wrote:
> Is there a superior backup strategy than pg_dump
> every 24 hours?
You should probably consider:
http://www.postgresql.org/docs/8.2/interactive/continuous-archiving.html
-Kevin
--
Sent via pgsql-performance mailing list (pgsql-performance
I'm running a medium-traffic Web site that has been running for a few
years, and which uses about four PostgreSQL databases on a regular
basis. I'm currently running 8.2, although I'm planning to upgrade to
8.3 in the coming week or two, in part because of the problems that I'm
having. The da
