"Ow Mun Heng" <Ow.Mun.Heng@xxxxxxx> writes: > Have not changed anything in that area. Question is.. Do I need to? or > should I try out something just to see how it is? > (any) Recommendations would be good. Sorry, I don't have all the original plans. Can you post the explain analyze with and without enable_seqscan now that the stats are giving good predictions? -- Gregory Stark EnterpriseDB http://www.enterprisedb.com ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings