On 09/10/2011 11:43 AM, Thom Brown wrote:
On 10 September 2011 17:40, Andy Colson<a...@squeakycode.net> wrote:
I'm playing with 9.2devel, and I can fill my logs with:
WARNING: pgstat waiting for 5001623 usec (494 loops), file timestamp
368986878169601 target timestamp 368986897680812 last errno 0
WARNING: pgstat waiting for 5011780 usec (495 loops), file timestamp
368986878169601 target timestamp 368986897680812 last errno 0
WARNING: pgstat waiting for 5021947 usec (496 loops), file timestamp
368986878169601 target timestamp 368986897680812 last errno 0
WARNING: pgstat waiting for 5032115 usec (497 loops), file timestamp
368986878169601 target timestamp 368986897680812 last errno 0
WARNING: pgstat waiting for 5042254 usec (498 loops), file timestamp
368986878169601 target timestamp 368986897680812 last errno 0
WARNING: pgstat waiting for 5052400 usec (499 loops), file timestamp
368986878169601 target timestamp 368986897680812 last errno 0
I see its from here:
http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=79b2ee20c8a041a85dd230c4e787bef22edae57b
So I was wondering if there is anything I can help with? Not sure if you
need a reproducible case, or something you'd like me to try?
I've had exactly the same sort of messages, pages of them. But wasn't
quite sure what I needed to recreate it.
Just hammer a table with updates. I used:
pgbench -i -s 75
then:
pgbench -f bank1.sql -s 75 -c 5 -T 9999
-- bank1.sql
\set nbranches :scale
\set naccounts 100000 * :scale
\setrandom a 1 :naccounts
\setrandom b 1 :naccounts
\setrandom c 1 :naccounts
begin;
update pgbench_accounts set abalance = abalance + 1 where aid = :a;
update pgbench_accounts set abalance = abalance + 1 where aid = :b;
update pgbench_accounts set abalance = abalance + 1 where aid = :c;
\sleep 30 ms
end;
This is on a desktop box, single sata drive, postgresql.conf:
checkpoint_segments = 12
shared_buffers = 100MB
work_mem = 5MB
-Andy
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
