Re: [PERFORM] Autovacuum Issue

2011-11-22 Thread Raghavendra
On Wed, Nov 23, 2011 at 11:25 AM, J Ramesh Kumar wrote: > Hi, > > My application is performing 1600 inserts per second and 7 updates per > second. The updates occurred only in a small table which has only 6 integer > columns. The inserts occurred in all other daily tables. My application > creates

[PERFORM] Autovacuum Issue

2011-11-22 Thread J Ramesh Kumar
Hi, My application is performing 1600 inserts per second and 7 updates per second. The updates occurred only in a small table which has only 6 integer columns. The inserts occurred in all other daily tables. My application creates around 75 tables per day. No updates/deletes occurred in those 75 d

Re: [PERFORM] SSD options, small database, ZFS

2011-11-22 Thread Bruce Momjian
Amitabh Kant wrote: > > The whole memorys speed topic is also much more complicated than any > > simple explanation can cover. How many banks of RAM you can use > > effectively changes based on the number of CPUs and associated chipset too. > > Someone just sent me an explanation recently of why

Re: [PERFORM] SSD options, small database, ZFS

2011-11-22 Thread Bruce Momjian
Greg Smith wrote: > The whole memorys speed topic is also much more complicated than any > simple explanation can cover. How many banks of RAM you can use > effectively changes based on the number of CPUs and associated chipset > too. Someone just sent me an explanation recently of why I was s