On Sun, 2007-12-16 at 16:11 -0800, Joshua D. Drake wrote:
> On Sun, 16 Dec 2007 17:55:55 -0600
> "Scott Marlowe" <scott.marlowe@xxxxxxxxx> wrote:
>
> > On Dec 14, 2007 1:33 AM, Ow Mun Heng <Ow.Mun.Heng@xxxxxxx> wrote:
> > > I kept looking at the io columns and didn't even think of the swap
> > > partition. It's true that it's moving quite erratically but I won't
> > > say that it's really thrashing.
> > >
> > > total used free shared buffers
> > > cached Mem: 503 498 4 0
> > > 3 287 -/+ buffers/cache: 207 295
> > > Swap: 2527 328 2199
> > >
> > > (YEP, I know I'm RAM starved on this machine)
> >
> > Good lord, my laptop has more memory than that. :)
>
> My phone has more memory than that :P
What can I say :-p
budgets are tight
---------------------------(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
