Re: [GENERAL] optimal memory

2010-08-03 Thread Scott Marlowe
On Tue, Aug 3, 2010 at 6:27 AM, Sim Zacks wrote: > >> So, about how big is your db?  How many users are likely to be running >> queries at once?  How big of a chunk of data are those users likely to >> each need for sorts etc? >> > The database is 400MB (using du on the base folder), I have 10 act

Re: [GENERAL] optimal memory

2010-08-03 Thread Sim Zacks
> So, about how big is your db? How many users are likely to be running > queries at once? How big of a chunk of data are those users likely to > each need for sorts etc? > The database is 400MB (using du on the base folder), I have 10 active users who run queries and functions that generally

Re: [GENERAL] optimal memory

2010-08-03 Thread Scott Marlowe
2010/8/3 Sim Zacks : > Is there a way to tell what the optimal memory is for a specific > postgresql instance? > > I am configuring Xen virtual machines and I don't want to give it more > then it needs. > > Would looking at the swap be an indication? As soon as it starts to use > swap, that means I

Re: [GENERAL] optimal memory

2010-08-03 Thread A. Kretschmer
In response to Sim Zacks : > > > On 03-Aug-2010 11:18 AM, A. Kretschmer wrote: > > In response to Sim Zacks : > > > >> Is there a way to tell what the optimal memory is for a specific > >> postgresql instance? > >> > >> I am configuring Xen virtual machines and I don't want to give it more > >

Re: [GENERAL] optimal memory

2010-08-03 Thread A. Kretschmer
In response to Sim Zacks : > Is there a way to tell what the optimal memory is for a specific > postgresql instance? > > I am configuring Xen virtual machines and I don't want to give it more > then it needs. > > Would looking at the swap be an indication? As soon as it starts to use > swap, that

[GENERAL] optimal memory

2010-08-03 Thread Sim Zacks
Is there a way to tell what the optimal memory is for a specific postgresql instance? I am configuring Xen virtual machines and I don't want to give it more then it needs. Would looking at the swap be an indication? As soon as it starts to use swap, that means I need more, but until that point, I