Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgres 9.1.4 - high stats collector IO usage - Mailing list pgsql-performance

From David Barton
Subject Re: Postgres 9.1.4 - high stats collector IO usage
Date
Msg-id 50141D5A.2090302@oneit.com.au
Whole thread Raw
In response to Re: Postgres 9.1.4 - high stats collector IO usage  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-performance
Tree view
Thanks, Pavel.

I was a bit worried about trying this because of a comment elsewhere that the file was supposed to be permanent.  Tom's solution of increasing the vacuum delay has solved it for now.

Regards, David


On 28/07/12 15:07, Pavel Stehule wrote:
Hello

I had same problem with large numbers of tables - you can move
pg_stat_tmp to tmpfs filesystem - it was solution for us

Regards

Pavel

2012/7/28 David Barton <dave@oneit.com.au>:

Hi,

<snip>


-- 
David Barton - Managing Director
 1iT Pty Ltd "The Power of One" 
 Tel: (08) 9382 2296
 Direct: (08) 9200 4269
 Mob: 0404 863 671
 Fax: (08) 6210 1354
 Web: www.1it.com.au
 First Floor
 41 Oxford Close
 West Leederville, 6007 

		
	


	
	
Attachment

	
	

					

					





	

	pgsql-performance by date:
	
	

	
	

		
			

	        	

	       			Previous
	    		

	    		
	From:
	David Barton

	Date:
	



	Subject:
	Re: Postgres 9.1.4 - high stats collector IO usage
 

	    	

	    
	    
	    
			

	        	

	       			Next
	    		

	    		
	From:
	"Kevin Grittner"

	Date:
	



	Subject:
	Re: Linux memory zone reclaim