On Thu, Nov 29, 2007 at 03:32:59PM -0600, Campbell, Lance wrote: > How can I clear pg_stat views? I thought there was a command I could According to the manual, there's this: pg_stat_reset() I suggest you read the section of the manual about stats collection. A -- Andrew Sullivan Old sigs will return after re-constitution of blue smoke ---------------------------(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