Re: [PERFORM] Databases optimization

2011-09-12 Thread Hany ABOU-GHOURY
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 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 pgfoui

Re: [PERFORM] Databases optimization

2011-09-12 Thread Anthony Presley
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 wrote:

Re: [PERFORM] Databases optimization

2011-09-12 Thread Hany ABOU-GHOURY
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

Re: [PERFORM] Databases optimization

2011-09-11 Thread J Sisson
On Sun, Sep 11, 2011 at 5:22 PM, Maciek Sakrejda 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 recom

Re: [PERFORM] Databases optimization

2011-09-11 Thread Hany ABOU-GHOURY
Thanks Maciek. I really do not know where to start or how to explain my question I am newbie to Postgres. I will try to get more information from the development team and SA's Cheers Hany On Mon, Sep 12, 2011 at 10:22 AM, Maciek Sakrejda wrote: > I doubt you'll get much useful feedback because

Re: [PERFORM] Databases optimization

2011-09-11 Thread Maciek Sakrejda
I doubt you'll get much useful feedback because your question is too broad for a mailing list answer. If you're looking for basic 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), although I don't think

[PERFORM] Databases optimization

2011-09-11 Thread Hany ABOU-GHOURY
Hi, I have a database cluster running PostgreSQL 8.2 and I have **new Linux virtualized database environment running PostgreSQL 9.0 My question is how to ensure that database schemas are always performing and scalable and databases optimized and entirely migrated Thanks in advance! Hany