|
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) |
- [GENERAL] SELECT count(*) Generating Lots of Write Activi... Logan Bowers
