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 <kleptog@xxxxxxxxx> http://svana.org/kleptog/ > From each according to his ability. To each according to his ability to litigate.
Attachment:
signature.asc
Description: Digital signature