On Wed, Aug 29, 2007 at 11:15:21AM +0200, Vincenzo Romano wrote: > This loop is increadibly slow. Infact the friendly explain tells me > that:
Is it wrong? Have you have run with seq_scan disabled to see if an index scan is actually faster? If so, then perhaps your random+pagE_cost needs adjusting. Also, your query can't use an index anyway, for that you'd need an index on (f2,f3). Have a nice day, -- Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/ > From each according to his ability. To each according to his ability to > litigate.
signature.asc
Description: Digital signature