Re: Databases optimization

[Anthony Presley <anthony@xxxxxxxxxxxxxx>]

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@xxxxxxxxx> 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 <sisson.j@xxxxxxxxx> wrote:

On Sun, Sep 11, 2011 at 5:22 PM, Maciek Sakrejda <msakrejda@xxxxxxxxxxx> 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.