[GENERAL] PG's suitability for high volume environment (many INSERTs and lots of aggregation reporting)

2009-01-28 Thread Phoenix Kiula
Hi. Further to my bafflement with the count(*) queries as described in this thread: http://archives.postgresql.org/pgsql-general/2009-01/msg00804.php It seems that whenever this question has come up, Postgresql comes up very short in terms of count(*) functions. The performance is always slow,

Re: [GENERAL] PG's suitability for high volume environment (many INSERTs and lots of aggregation reporting)

2009-01-28 Thread Gregory Stark
Phoenix Kiula phoenix.ki...@gmail.com writes: My question: with that kind of volume and the underlying aggregation functions (by product id, dates, possibly IP addresses or at least countries of origin..) will PG ever be a good choice? Well, only you're able to judge that for your own data