Tuesday Jun 30, 2009

Increase PostgreSQL Performance without Hardware change

Nowadays, most applications use a database in the back-end, particularly Web-based applications. The amount of time spent to process the database queries becomes a critical factor for the overall performance.

The BluePrints article “Optimizing PostgreSQL Application Performance with Solaris Dynamic Tracing” demonstrates, using multiple examples, how DTrace can be used to observe, analyse and fix PostgreSQL performance bottlenecks. The paper shows for example how to analyze and fix slow queries or optimize the buffer cache usage, all that live, without rebooting, recompiling, or even restarting the application. Download this paper and improve your database performance without changing the hardware.

Sun BluePrints articles are free whitepapers, written by engineers, for engineers. Don't miss out, stay up to date and join the Sun BluePrint Community on Facebook or subscribe to the Sun BluePrints Community RSS Feed.

Tuesday Jun 23, 2009

Building Optimized Configurations for MD Nastran

MD Nastran is a very high compute and I/O intensive application. Jobs can run for days and generate terabytes of data.  Any processing or I/O optimization will help running more jobs concurrently and for shorter periods of time. From storage (Internal? Network Attached? SAS? HDD? SSD?) to memory (how much per node? per job?), the Sun BluePrints article "Sun Business Ready HPC for MD Nastran" provides interesting suggestions to help designing optimized configurations and avoiding processor or I/O bottlenecks. Detailed configuration examples and performance test results are provided.

To stay up to date when new Sun BluePrints are published, join the Sun BluePrint Community on Facebook or subscribe to the Sun BluePrints Community RSS Feed.

About

PierreReynes

Search

Categories
Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today