pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
physical memory
6+ messages / 5 participants
[nested] [flat]

* physical memory
@ 2008-01-10 17:53  Antonio Corardi <antonio.corardi@gmail.com>
  0 siblings, 1 reply; 6+ messages in thread

From: Antonio Corardi @ 2008-01-10 17:53 UTC (permalink / raw)
  To: pgsql-admin

Hi all,
    I'm new here and my doubt is very basic. I'm wondering how to set 
the max amount of space(physical, not RAM) to be used by postgreSQL. 
Moreover, Is such amount limited to the hard disk in wich postgreSQL is 
installed or it scales  automatically to the others HD available? How 
can I manage it.
Thanks in advance.
Antonio



^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Fwd: physical memory
@ 2008-01-10 18:34  Rich <rhdyes@gmail.com>
  parent: Antonio Corardi <antonio.corardi@gmail.com>
  0 siblings, 1 reply; 6+ messages in thread

From: Rich @ 2008-01-10 18:34 UTC (permalink / raw)
  To: pgsql-admin

---------- Forwarded message ----------
From: Rich <rhdyes@gmail.com>
Date: Jan 10, 2008 1:32 PM
Subject: Re: [ADMIN] physical memory
To: Antonio Corardi <antonio.corardi@gmail.com>


There is probably no limit except the limitations of your hardware at
this time.  As far as it automatically incorporating other hard
drives, that is probably more of a function of your operating system.
Example if you put your tabelspace on a system where the filesystem
spans multiple drives, it will grow till you run out of space.  This I
would say is based on your filesystem design.


On Jan 10, 2008 12:53 PM, Antonio Corardi <antonio.corardi@gmail.com> wrote:
> Hi all,
>     I'm new here and my doubt is very basic. I'm wondering how to set
> the max amount of space(physical, not RAM) to be used by postgreSQL.
> Moreover, Is such amount limited to the hard disk in wich postgreSQL is
> installed or it scales  automatically to the others HD available? How
> can I manage it.
> Thanks in advance.
> Antonio
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>



^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: Fwd: physical memory
@ 2008-01-12 08:39  Antonio5556 <antonio.corardi@gmail.com>
  parent: Rich <rhdyes@gmail.com>
  0 siblings, 1 reply; 6+ messages in thread

From: Antonio5556 @ 2008-01-12 08:39 UTC (permalink / raw)
  To: pgsql-admin


My fear is that the tablespace is related to a specific directory of the OS;
and, in my best understanding on OS, the amount of memory of a directory is
bounded by the amount of memory of the related HD. Hence, when the amount of
memory related to such directory will run out of space it will not scale to
other HD. :rules:


Richmond Dyes-2 wrote:
> 
> ---------- Forwarded message ----------
> From: Rich <rhdyes@gmail.com>
> Date: Jan 10, 2008 1:32 PM
> Subject: Re: [ADMIN] physical memory
> To: Antonio Corardi <antonio.corardi@gmail.com>
> 
> ...
> Example if you put your tabelspace on a system where the filesystem
> spans multiple drives, it will grow till you run out of space.  This I
> would say is based on your filesystem design.
> 
> 
> ...
> 
> 

-- 
View this message in context: http://www.nabble.com/physical-memory-tp14739957p14770360.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.




^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: Fwd: physical memory
@ 2008-01-12 09:40  Tino Schwarze <postgresql@tisc.de>
  parent: Antonio5556 <antonio.corardi@gmail.com>
  0 siblings, 1 reply; 6+ messages in thread

From: Tino Schwarze @ 2008-01-12 09:40 UTC (permalink / raw)
  To: pgsql-admin

On Sat, Jan 12, 2008 at 12:39:52AM -0800, Antonio5556 wrote:

> My fear is that the tablespace is related to a specific directory of the OS;
> and, in my best understanding on OS, the amount of memory of a directory is
> bounded by the amount of memory of the related HD. Hence, when the amount of
> memory related to such directory will run out of space it will not scale to
> other HD. :rules:

That's what Logical Volume Management (LVM) is for - it allows you to
have a filesystem which spans multiple HDs (or RAIDs). So this is not an
issue of PostgreSQL but of the operating system.

Tino.

-- 
www.craniosacralzentrum.de
www.spiritualdesign-chemnitz.de

Tino Schwarze * Parkstraße 17h * 09120 Chemnitz



^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: Fwd: physical memory
@ 2008-01-13 01:35  Antonio5556 <antonio.corardi@gmail.com>
  parent: Tino Schwarze <postgresql@tisc.de>
  0 siblings, 1 reply; 6+ messages in thread

From: Antonio5556 @ 2008-01-13 01:35 UTC (permalink / raw)
  To: pgsql-admin


Thankyou
Mmaybe it is off topic but is LVM available in Windows (xp?)? Or have I to
buy a specific tool? Which one?
Thanks

-- 
View this message in context: http://www.nabble.com/physical-memory-tp14739957p14781197.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.




^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: Fwd: physical memory
@ 2008-01-13 01:50  Adam Tauno Williams <adamtaunowilliams@gmail.com>
  parent: Antonio5556 <antonio.corardi@gmail.com>
  0 siblings, 0 replies; 6+ messages in thread

From: Adam Tauno Williams @ 2008-01-13 01:50 UTC (permalink / raw)
  To: pgsql-admin

> Mmaybe it is off topic but is LVM available in Windows (xp?)? 

Yes.

> Or have I to buy a specific tool? Which one?

Just use the standard disk / volume management tools included under
Computer Management.

-- 
Adam Tauno Williams, Network & Systems Administrator
Consultant - http://www.whitemiceconsulting.com
Developer - http://www.opengroupware.org




^ permalink  raw  reply  [nested|flat] 6+ messages in thread


end of thread, other threads:[~2008-01-13 01:50 UTC | newest]

Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-01-10 17:53 physical memory Antonio Corardi <antonio.corardi@gmail.com>
2008-01-10 18:34 ` Rich <rhdyes@gmail.com>
2008-01-12 08:39   ` Antonio5556 <antonio.corardi@gmail.com>
2008-01-12 09:40     ` Tino Schwarze <postgresql@tisc.de>
2008-01-13 01:35       ` Antonio5556 <antonio.corardi@gmail.com>
2008-01-13 01:50         ` Adam Tauno Williams <adamtaunowilliams@gmail.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox