[Postgres-xc-developers] IO PGXC

[Arni S. <Arn...@md...>]

Users,

I have 20 nodes sitting on a disk arrays, with multiple LUNs. when I issue queries - `select count(1) from table` for example, I am experiencing heavy writes and heavy reads. I expected the reads but not the writes and it has really thrown a wrench in the caching. My first assumption would be the log files, do you have any other ideas what could be causing all these writes with a select?

Arni Sumarlidason | Software Engineer, Information Technology
MDA | 820 West Diamond Ave | Gaithersburg, MD | USA
O: 240-833-8200 D: 240-833-8318 M: 256-393-2803
arn...@md...<mailto:arn...@md...>| http://www.mdaus.com<http://www.mdaus.com/>