from:"Nik"

[PERFORM] Large Table With Only a Few Rows

2006-02-28 Thread Nik

I have a table that has only a few records in it at the time, and they get deleted every few seconds and new records are inserted. Table never has more than 5-10 records in it. However, I noticed a deteriorating performance in deletes and inserts on it. So I performed vacuum analyze on it three ti

[PERFORM] Find how much memory is postgres using

2013-04-06 Thread Nik Tek

Hi, Could someone tell m how to measure postgres memory usage. Is there a pg_* view to measure? Thank you NikT

Re: [PERFORM] Find how much memory is postgres using

2013-04-09 Thread Nik Tek

ame like 'Maximum Workspace Memory (KB)%') * 100.0 / (select cntr_value from sys.dm_os_performance_counters where object_name like '%Memory Manager%' and counter_name like 'Target Server Memory (KB)%') as Ratio -- Oracle SELECT sum(bytes)/1024/1024

Re: [PERFORM] Find how much memory is postgres using

2013-04-09 Thread Nik Tek

M v$sysstat WHERE name = 'session pga memory') GROUP BY ROLLUP (nm); Sure, I will take up the task, will send you the script once it is ready, so you can bless it. :) Regards Nik On Tue, Apr 9, 2013 at 11:34 AM, hubert depesz lubaczewski < dep...@depesz.com> wrote: >