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 <hgho...@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 > > > > Thanks guys > > > > On Mon, Sep 12, 2011 at 2:46 PM, J Sisson <sisso...@gmail.com> wrote: > >> On Sun, Sep 11, 2011 at 5:22 PM, Maciek Sakrejda >> <msakre...@truviso.com>wrote: >> >>> 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. >> >
