Mike Charnoky wrote: > Alvaro: The cluster suggestion probably won't help in my case since data > in the table should already be naturally ordered by date.
It's not helpful only for reordering, but also for getting rid of dead tuples. -- Alvaro Herrera http://www.flickr.com/photos/alvherre/ "Porque Kim no hacia nada, pero, eso sí, con extraordinario éxito" ("Kim", Kipling) /bin/bash: sigcommand: command not found ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
