Re: [PERFORM] High Disk write and space taken by PostgreSQL

here any way to vacuum a specific table instead of whole database ? Thanks, Ramesh On Thu, Aug 16, 2012 at 10:09 AM, Scott Marlowe wrote: > Please use plain text on the list, some folks don't have mail readers > that can handle html easily. > > On Wed, Aug 15, 2012 at 10:30 PM,

Re: [PERFORM] High Disk write and space taken by PostgreSQL

ry quickly. Do you have anything deleting the rows afterwards? I have > no experience with databases past 50M rows, so my questions are just so you > can line up the right info for when the real experts get online :-) > > Regards, David > > > On 16/08/12 11:23, J Ramesh Kumar

[PERFORM] High Disk write and space taken by PostgreSQL

Hi, My application has high data intensive operations (high number of inserts 1500 per sec.). I switched my application from MySQL to PostgreSQL. When I take performance comparison report between mysql and pgsql, I found that, there are huge difference in disk writes and disk space taken. Below st

[PERFORM] Autovacuum Issue

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] ORDER BY and LIMIT not propagated on inherited

Hi all I have got lot of information from ur group. Now i want to relieve from this group. I kindly request all of you. Plz unsubcribe me. Thankz a lot Ramesh  On 9/3/05, Matteo Beccati <[EMAIL PROTECTED]> wrote: Simon Riggs wrote:> Returning to Matteo's original query, what we are saying is that t