Hm. Yes. Number of locks varies quite alot (10-600). Now what to
investigate
further? We do not use explicit locks in our functions. We use quite
simple
update/delete where key=something;
Some sample (select * from pg_locks order by pid) is below.
The sample doesn't show any lock
Alvaro,
Yes, and yes. Simply allocating more checkpoint segments (which can eat
a lot of disk space -- requirements are 16mb*(2 * segments +1) ) will
prevent this problem.
Hmm? I disagree -- it will only make things worse when the checkpoint
does occur.
Unless you allocate enough
My only comment is what is the layout of your data (just one table with
indexes?).
I found on my date with dozens of joins my view speed was not good for me to
use, so I made a flat file with no joins and it flies.
Joel Fradkin
Wazagua, Inc.
2520 Trailmate Dr
Sarasota, Florida 34243
Tel.