Re: The need for clustered indexes to boost TPC-V performance - Mailing list pgsql-performance

On Thu, Jul 5, 2012 at 1:37 PM, Reza Taheri <rtaheri@vmware.com> wrote:

I provided more config details in an earlier email.

 

I hate to disagree, but unless I didn't get a message sent to the list

It looks like that might be the case. I got a message with Message-ID 66CE997FB523C04E9749452273184C6C137CB88CDD@exch-mbx-113.vmware.com sent at Thu, 5 Jul 2012 11:33:46 -0700 that contained the basic info, postgresql.conf, etc. Belated, but it was sent. I can't find this message in the archives and the copy I got came direct to me via cc, so I suspect our friendly mailing list system has silently held it for moderation due to size/attachment.


I'll reproduce the content below, followed by an inline copy of the postgresql.conf with only changed lines:

On 07/06/2012 02:33 AM, Reza Taheri wrote:

OK, some config details.

We are using:

 

·         Two blades of an HP BladeSystem c-Class c7000 with 2-socket Intel E5520 (Nehalem-EP) processors and 48GB of memory per blade

o   8 cores, 16 threads per blade

o   48GB of RAM per blade

·         Storage was an EMC VNX5700 with 14 SSDs fronting 32 15K RPM drives

·         The Tier B database VM was alone on a blade with 16 vCPUs, 40GB of memory, 4 virtual drives with various RAID levels

·         The driver and Tier A VMs were on the second blade

o   So we set PGHOST on the client system to point to the server

·         RHEL 6.1

·         PostgreSQL 8.4

·         unixODBC 2.3.2

 

We stuck with PGSQL 8.4 since it is the stock version shipped with RHEL 6. I am building a new, larger testbed, and will switch to PGSQL 9 with that.

 

postgresql.conf:

[craig@ayaki ~]$ egrep -v '(^\s*#)|(^\s*$)' /tmp/postgresql2.conf  | cut -d '#' -f 1
listen_addresses = '*'           
max_connections = 320           
shared_buffers = 28GB           
temp_buffers = 200MB           
work_mem = 10MB               
maintenance_work_mem = 10MB       
bgwriter_delay = 10ms           
bgwriter_lru_maxpages = 20       
wal_buffers = 16MB           
checkpoint_segments = 128       
checkpoint_timeout = 30min       
checkpoint_completion_target = 0.9   
default_statistics_target = 10000   
logging_collector = on           
log_directory = 'pg_log'       
log_filename = 'postgresql-%a.log'   
log_truncate_on_rotation = on       
log_rotation_age = 1d           
log_rotation_size = 0           
datestyle = 'iso, mdy'
lc_messages = 'en_US.UTF-8'           
lc_monetary = 'en_US.UTF-8'           
lc_numeric = 'en_US.UTF-8'           
lc_time = 'en_US.UTF-8'               
default_text_search_config = 'pg_catalog.english'