PostgreSQL East 2008 Talk - Best Practices with PostgreSQL on Solaris

As Sun SPARC Enterprise T5140 is launched along with the Open Application Services solution which includes PostgreSQL, the talk I gave at PostgreSQL East 2008 on "Best Practices with PostgreSQL on Solaris" might be helpful for many new users.

 

If there are questions let me know.

 

Comments:

Can you elaborate on slide #27, "prstat -am / prstat -Jm". Since this is not an actual command you can type in the shell, how did you get the output you show? TIA.

Posted by Robert Treat on April 14, 2008 at 09:49 AM EDT #

Hi Robert,

The output on slide #27 is using
prstat -am
which shows microstate accounting information related to each top processes and also aggregations by userid. (My example used Solaris 10 8/07
Similarly if you are using resource controls based on project infrastructure (/etc/project) one can use
prstat -Jm
to get aggregation by project id instead of userid as in case of prstat -am

Posted by Jignesh Shah on April 14, 2008 at 10:37 AM EDT #

On the statement:

"Shared Bufferpool getting better in 8.2 worth to
increase it to 3GB (for 32-bit PostgreSQL) but still
not great to increase it more than 10GB (for 64-bit
PostgreSQL)"

Can you explain the "why"? Is it just a waste of memory or will it actually degrade performance? We're actually testing a x4150 with 32GB of memory and a 28GB shared buffer pool. We have yet to do any significant bench testing yet.

Thanks.

Posted by Damian on April 15, 2008 at 11:55 AM EDT #

Post a Comment:
Comments are closed for this entry.
About

Jignesh Shah is Principal Software Engineer in Application Integration Engineering, Oracle Corporation. AIE enables integration of ISV products including Oracle with Unified Storage Systems. You can also follow me on my blog http://jkshah.blogspot.com

Search

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