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
> 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
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
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
> >
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
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