Hello,
I'm potentially having a strange performance problem. I have a BIG
table: ~100M, ~1KB rows. I do a SELECT count(*) from it (I know it will
be slow) and as I watch procinfo on my DB server I see a huge amount of
write activity. Thus,
1) Why does this statement generate any writes at all?
2) Is it possible to tweak something to make it avoid doing so?
3) Are my tools lying to me (i.e. procinfo is wrong)?
Thanks!
Oh, and our server configuration is:
Postgres 8.0.1, Linux 2.6, AMD64, 4GB RAM, and 3TB of storage (two RAID5
volumes striped together)
Logan Bowers