On Mon, 8 Sep 2003, Vasilis Ventirozos wrote: > This is a simple statement that i run > > core_netfon=# EXPLAIN select spcode,count(*) from callticket group by spcode;
Well, yeah. Whatever you do, a complete seqscan and count is going to take a long time, in the order of hours rather than days I would expect. However, you may want to ensure that all tuning in postgresql.conf is correct, as it may not be using all possible resources. That will probably only make a small difference. -- Sam Barnett-Cormack Software Developer | Student of Physics & Maths UK Mirror Service (http://www.mirror.ac.uk) | Lancaster University ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster