pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedphysical memory
6+ messages / 5 participants
[nested] [flat]
* physical memory
@ 2008-01-10 17:53 Antonio Corardi <antonio.corardi@gmail.com>
2008-01-10 18:34 ` Fwd: physical memory Rich <rhdyes@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 17:53 physical memory Antonio Corardi <antonio.corardi@gmail.com>
@ 2008-01-10 18:34 ` Rich <rhdyes@gmail.com>
2008-01-12 08:39 ` Re: Fwd: physical memory Antonio5556 <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-10 17:53 physical memory Antonio Corardi <antonio.corardi@gmail.com>
2008-01-10 18:34 ` Fwd: physical memory Rich <rhdyes@gmail.com>
@ 2008-01-12 08:39 ` Antonio5556 <antonio.corardi@gmail.com>
2008-01-12 09:40 ` Re: Fwd: physical memory Tino Schwarze <postgresql@tisc.de>
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-10 17:53 physical memory Antonio Corardi <antonio.corardi@gmail.com>
2008-01-10 18:34 ` Fwd: physical memory Rich <rhdyes@gmail.com>
2008-01-12 08:39 ` Re: Fwd: physical memory Antonio5556 <antonio.corardi@gmail.com>
@ 2008-01-12 09:40 ` Tino Schwarze <postgresql@tisc.de>
2008-01-13 01:35 ` Re: Fwd: physical memory 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-10 17:53 physical memory Antonio Corardi <antonio.corardi@gmail.com>
2008-01-10 18:34 ` Fwd: physical memory Rich <rhdyes@gmail.com>
2008-01-12 08:39 ` Re: Fwd: physical memory Antonio5556 <antonio.corardi@gmail.com>
2008-01-12 09:40 ` Re: Fwd: physical memory Tino Schwarze <postgresql@tisc.de>
@ 2008-01-13 01:35 ` Antonio5556 <antonio.corardi@gmail.com>
2008-01-13 01:50 ` Re: Fwd: physical memory Adam Tauno Williams <adamtaunowilliams@gmail.com>
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-10 17:53 physical memory Antonio Corardi <antonio.corardi@gmail.com>
2008-01-10 18:34 ` Fwd: physical memory Rich <rhdyes@gmail.com>
2008-01-12 08:39 ` Re: Fwd: physical memory Antonio5556 <antonio.corardi@gmail.com>
2008-01-12 09:40 ` Re: Fwd: physical memory Tino Schwarze <postgresql@tisc.de>
2008-01-13 01:35 ` Re: Fwd: physical memory Antonio5556 <antonio.corardi@gmail.com>
@ 2008-01-13 01:50 ` Adam Tauno Williams <adamtaunowilliams@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