Re: [PERFORM] very long updates very small tables

On 03/30/2011 06:54 PM, Kevin Grittner wrote: Lars Feistnerfeist...@uni-heidelberg.de wrote: On 03/29/2011 09:28 PM, Kevin Grittner wrote: Lars Feistnerfeist...@uni-heidelberg.de wrote: The log tells me that certain update statements take sometimes about 3-10 minutes. But we are talking

[PERFORM] Postgres Performance Tuning

Dear all, I have a Postgres database server with 16GB RAM. Our application runs by making connections to Postgres Server from different servers and selecting data from one table insert into remaining tables in a database. Below is the no. of connections output :- postgres=# select

Re: [PERFORM] Postgres Performance Tuning

max_connections = 700 shared_buffers = 4096MB temp_buffers = 16MB work_mem = 64MB maintenance_work_mem = 128MB wal_buffers = 32MB checkpoint_segments = 32 random_page_cost = 2.0 effective_cache_size = 4096MB First of all, there's no reason to increase wal_buffers above 32MB. AFAIK the

Re: [PERFORM] Postgres Performance Tuning

On Mon, Apr 4, 2011 at 3:40 AM, Adarsh Sharma adarsh.sha...@orkash.com wrote: Dear all, I have a Postgres database server with 16GB RAM. Our application runs by making connections to Postgres Server from different servers and selecting data from one table insert into remaining tables in a

Re: [PERFORM] Postgres Performance Tuning

Also you can try to take the help of pgtune before hand. pgfoundry.org/projects/*pgtune*/ On Mon, Apr 4, 2011 at 12:43 PM, Scott Marlowe scott.marl...@gmail.comwrote: On Mon, Apr 4, 2011 at 3:40 AM, Adarsh Sharma adarsh.sha...@orkash.com wrote: Dear all, I have a Postgres database

Re: [PERFORM] Postgres Performance Tuning

On Mon, Apr 4, 2011 at 4:43 AM, Scott Marlowe scott.marl...@gmail.com wrote: [root@s8-mysd-2 ~]# free              total       used       free     shared    buffers     cached Mem:      16299476   16202264      97212          0      58924   15231852 -/+ buffers/cache:     911488   15387988

Re: [PERFORM] Postgres Performance Tuning

Adarsh, What is the Size of Database? Best Regards, Raghavendra EnterpriseDB Corporation On Mon, Apr 4, 2011 at 4:24 PM, Scott Marlowe scott.marl...@gmail.comwrote: On Mon, Apr 4, 2011 at 4:43 AM, Scott Marlowe scott.marl...@gmail.com wrote: [root@s8-mysd-2 ~]# free total

Re: [PERFORM] Postgres Performance Tuning

On Mon, Apr 4, 2011 at 5:34 AM, Adarsh Sharma adarsh.sha...@orkash.com wrote: Mem:  16299476k total, 16198784k used,   100692k free,    73776k buffers Swap: 16787884k total,   148176k used, 16639708k free, 15585396k cached   PID USER  PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+ COMMAND  

Re: [PERFORM] Postgres Performance Tuning

Thanks Scott : My iostat package is not installed but have a look on below output: [root@s8-mysd-2 8.4SS]# vmstat 10 procs ---memory-- ---swap-- -io --system-- -cpu-- r b swpd free buff cache si sobibo incs us sy id wa st 1 0 147664

Re: [PERFORM] Postgres Performance Tuning

You got to have something to compare against. I would say, try to run some benchmarks (pgbench from contrib) and compare them against a known good instance of postgresql, if you have access in such a machine. That said, and forgive me if i sound a little explicit but if you dont know how to

Re: [PERFORM] Postgres Performance Tuning

On Mon, Apr 4, 2011 at 5:51 AM, Adarsh Sharma adarsh.sha...@orkash.com wrote: Thanks Scott : My iostat package is not installed but have a look on below output: [root@s8-mysd-2 8.4SS]# vmstat 10 procs ---memory-- ---swap-- -io --system-- -cpu--  r  b  

Re: [PERFORM] Postgres Performance Tuning

Thanks Scott : My iostat package is not installed but have a look on below output: [root@s8-mysd-2 8.4SS]# vmstat 10 procs ---memory-- ---swap-- -io --system-- -cpu-- r b swpd free buff cache si sobibo incs us sy id wa st 1 0

Re: [PERFORM] Postgres Performance Tuning

Thank U all, I know some things to work on after some work study on them , I will continue this discussion tomorrow . Best Regards, Adarsh Raghavendra wrote: Adarsh, [root@s8-mysd-2 8.4SS]# iostat -bash: iostat: command not found /usr/bin/iostat Our application runs

Re: [PERFORM] Postgres Performance Tuning

Adarsh, [root@s8-mysd-2 8.4SS]# iostat -bash: iostat: command not found /usr/bin/iostat Our application runs by making connections to Postgres Server from different servers and selecting data from one table insert into remaining tables in a database. When you are doing bulk inserts you

Re: [PERFORM] very long updates very small tables

Lars Feistner feist...@uni-heidelberg.de wrote: On 03/30/2011 06:54 PM, Kevin Grittner wrote: If you haven't already done so, you should probably turn on checkpoint logging to see if this corresponds to checkpoint activity. If it does, you can try cranking up how aggressive your background

Re: [PERFORM] Intel SSDs that may not suck

On 03/28/2011 04:21 PM, Greg Smith wrote: Today is the launch of Intel's 3rd generation SSD line, the 320 series. And they've finally produced a cheap consumer product that may be useful for databases, too! They've put 6 small capacitors onto the board and added logic to flush the write