Re: [GENERAL] bgwriter and pg_locks

On Wed, Sep 12, 2012 at 8:27 PM, Ben Chobot wrote: > In an attempt to get a hackfix for > http://pgfoundry.org/tracker/index.php?func=detail&aid=1011203&group_id=1000411&atid=1376, > I'm wonder if it's true that, when looking at pg_locks, the only pid which > will have virtualxid = '1/1' and vi

[GENERAL] bgwriter and pg_locks

In an attempt to get a hackfix for http://pgfoundry.org/tracker/index.php?func=detail&aid=1011203&group_id=1000411&atid=1376, I'm wonder if it's true that, when looking at pg_locks, the only pid which will have virtualxid = '1/1' and virtualtransaction = '-1/0' will be the bgwriter. That seems

[GENERAL] Bgwriter and pg_stat_bgwriter.buffers_clean aspects

Hello. I am trying to tune PostgreSQL write parameters to make writing operation fast on a heavy-loaded database (a lot of inserts/updates). After resetting the pg_stat_bgwriter statistics (I do it by deleting global/pgstat.stat file and restarting PostgreSQL) I monitor the following: # select *

[GENERAL] Bgwriter and pg_stat_bgwriter.buffers_clean aspects

Hello. I am trying to tune PostgreSQL write parameters to make writing operation fast on a heavy-loaded database (a lot of inserts/updates). After resetting the pg_stat_bgwriter statistics (I do it by deleting global/pgstat.stat file and restarting PostgreSQL) I monitor the following: # select *

Re: [GENERAL] Bgwriter--- BufferSync() and StrategyStatsDump()

Himanshu Baweja <[EMAIL PROTECTED]> writes: > this would greatly help ppl in determining the > appropriate value of bgwriter parameters it would > require a simple patch to written which will add two > else statements in StrategyDirtyBufferList() and > returning a struct instead of int... > als

[GENERAL] Bgwriter--- BufferSync() and StrategyStatsDump()

wht StrategyStatsDump prints is ARC clean buffers at LRU of T1 and T2 now lets say i have a dirty buffer at position 31st from LRU and the next one is at 3500th... in cases like this... t1_clean and t2_clean are of no use a better option would be to have a function like StrategyDirtyBuffe

[GENERAL] bgwriter

I understand that the bgwriter code will not be changed until 8.1 (I'm referring to this issue: ). After reading through the thread, it's my impression that there exists some performance problem with the current method of using a