Re: Databases optimization

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(dot)j(at)gmail(dot)com> wrote:

> On Sun, Sep 11, 2011 at 5:22 PM, Maciek Sakrejda <msakrejda(at)truviso(dot)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.
>
>