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 the

[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

[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

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

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 wrote: Hi, My application has high data intensive operations (high number of inserts

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

a specific table instead of whole database ? Thanks, Ramesh On Thu, Aug 16, 2012 at 10:09 AM, Scott Marlowe scott.marl...@gmail.comwrote: 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, J Ramesh Kumar rameshj1