Hi Anthony, I will try that thank you very much for your help
Cheers Hany On Tue, Sep 13, 2011 at 2:49 PM, Anthony Presley <[email protected]>wrote: > 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 <[email protected]>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 <[email protected]> wrote: >> >>> On Sun, Sep 11, 2011 at 5:22 PM, Maciek Sakrejda >>> <[email protected]>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. >>> >>
