Re: Databases optimization

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(at)gmail(dot)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 <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.
>>
>