Re: Databases optimization

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 <anthony(at)resolution(dot)com>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 <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.
>>>
>>