You may want to try pgreplay ... we've tried it for a similar scenario, and so far, it's pretty promising.
I do wish it was able to be loaded from a pgfouine formatted log file, or from another db ... but that's OK.
-- Anthony Presley
On Mon, Sep 12, 2011 at 6:28 PM, Hany ABOU-GHOURY <hghoury@gmail.com> wrote:
I have a production PostGres v8.2 database on luinx and a test PostGres V9.0 database on a test linux server
I am going to do migration but do not want to do that before making sure the performance of the new test Postgres 9.0 database performance is as good as the current production Postgres 8.2
My question is:
Is there a script that I can run on Postgres V8.2 and PostGres 9.0 that allows me test performance and make comparisons
performance guidelines, I recommend Greg Smith's "PostgreSQL 9.0 High Performance" [1] (disclaimer: I used to work with Greg and got a free copy)
I'll second that. "PostgreSQL 9.0 High Performance" is an excellent resource (I recommend it even for non-PostgreSQL admins because it goes so in-depth on Linux tuning) so whether you get it for free or not, it's worth the time it takes to read and absorb the info.
I've never run PostgreSQL virtualized, but I can say that if it's anything like running SQL Server virtualized, it's not a terribly good idea.