[PERFORM] Split select completes, single select doesn't and becomes IO bound!

2006-05-30 Thread Anthony Ransley
Can any one explain why the following query select f(q) from ( select * from times where '2006-03-01 00:00:00'<=q and q<'2006-03-08 00:00:00' order by q ) v; never completes, but splitting up the time span into single days does work. select f(q) from ( select * from times where '

Re: [PERFORM] Sun Fire T2000 and PostgreSQL 8.1.3

2006-04-05 Thread Anthony Ransley
Hi Juan Casero, I've found that serial query clients are best served by PostgreSQL running on fast single or dual core processors, ( such as the Athlon FX60 ) rather than expensive n-way systems. I was orginally using an 8-way Xeon computer for a similar serial throughput problem. and i wasn't