Обсуждение: Databases optimization
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
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 he spent much time on running virtualized (which certainly could affect things). Then if you have *specific* hardware or query questions, this list is a great resource. [1]: http://www.2ndquadrant.com/books/postgresql-9-0-high-performance/ --- Maciek Sakrejda | System Architect | Truviso 1065 E. Hillsdale Blvd., Suite 215 Foster City, CA 94404 (650) 242-3500 Main www.truviso.com
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 <msakrejda@truviso.com> wrote:
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 he spent much time on running
virtualized (which certainly could affect things). Then if you have
*specific* hardware or query questions, this list is a great resource.
[1]: http://www.2ndquadrant.com/books/postgresql-9-0-high-performance/
---
Maciek Sakrejda | System Architect | Truviso
1065 E. Hillsdale Blvd., Suite 215
Foster City, CA 94404
(650) 242-3500 Main
www.truviso.com
On Sun, Sep 11, 2011 at 5:22 PM, Maciek Sakrejda <msakrejda@truviso.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.
(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.
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
On Mon, Sep 12, 2011 at 2:46 PM, J Sisson <sisson.j@gmail.com> wrote:
On Sun, Sep 11, 2011 at 5:22 PM, Maciek Sakrejda <msakrejda@truviso.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.
You may want to try pgreplay ... we've tried it for a similar scenario, and so far, it's pretty promising.
--
Anthony Presley
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@gmail.com> wrote:
I have a production PostGres v8.2 database on luinx and a test PostGres V9.0 database on a test linux serverI 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.2My 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 comparisonsThanks guysOn Mon, Sep 12, 2011 at 2:46 PM, J Sisson <sisson.j@gmail.com> wrote:On Sun, Sep 11, 2011 at 5:22 PM, Maciek Sakrejda <msakrejda@truviso.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.
Hi Anthony,
Cheers
Hany
On Tue, Sep 13, 2011 at 2:49 PM, Anthony Presley <anthony@resolution.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 PresleyOn Mon, Sep 12, 2011 at 6:28 PM, Hany ABOU-GHOURY <hghoury@gmail.com> wrote:I have a production PostGres v8.2 database on luinx and a test PostGres V9.0 database on a test linux serverI 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.2My 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 comparisonsThanks guysOn Mon, Sep 12, 2011 at 2:46 PM, J Sisson <sisson.j@gmail.com> wrote:On Sun, Sep 11, 2011 at 5:22 PM, Maciek Sakrejda <msakrejda@truviso.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.