"Csaba Nagy" <nagy@xxxxxxxxxxxxxx> writes: > On Fri, 2007-09-21 at 09:03 +0100, Gregory Stark wrote: >> >> Mem: 32945280k total, 32871832k used, 73448k free, 247432k buffers >> >> Swap: 1951888k total, 42308k used, 1909580k free, 30294300k cached >> > >> It seems to imply Linux is paging out sysV shared memory. In fact some of >> Heikki's tests here showed that Linux would do precisely that. > > But then why is it not reporting that in the "Swap: used" section ? It > only reports 42308k used swap. Hm, good point. The other possibility is that Postgres just hasn't even touched a large part of its shared buffers. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com ---------------------------(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
