MIME-Version: 1.0
References: 
 <CAPdrarobvEJjubL_0UOn9f4BmuhSPzX_Tn3PWoT+je8pRp6_HQ@mail.gmail.com>
In-Reply-To: 
 <CAPdrarobvEJjubL_0UOn9f4BmuhSPzX_Tn3PWoT+je8pRp6_HQ@mail.gmail.com>
From: Keith Fiske <keith.fiske@crunchydata.com>
Date: Mon, 17 Oct 2022 12:51:49 -0400
Message-ID: 
 <CAODZiv7J7Fz-XtrTkssaXWbtLhhKKEvwN=ZWvfgZ6dMov4ZUAA@mail.gmail.com>
Subject: Re: Allocated size of DB?
To: Ron Watkins <rwatki@gmail.com>
Cc: pgsql-novice@lists.postgresql.org
Content-Type: multipart/alternative; boundary="0000000000003d09de05eb3dcc00"
Archived-At: 
 <https://www.postgresql.org/message-id/CAODZiv7J7Fz-XtrTkssaXWbtLhhKKEvwN%3DZWvfgZ6dMov4ZUAA%40mail.gmail.com>
Precedence: bulk

--0000000000003d09de05eb3dcc00
Content-Type: text/plain; charset="UTF-8"

On Mon, Oct 17, 2022 at 12:48 PM Ron Watkins <rwatki@gmail.com> wrote:

> I have a request to supply business owner with both the available size of
> DB as well as the used size of the DB. I have been able to locate the used
> size, but I don't see any way to query the available size (used + unused
> space). How can I find that in PSQL?
>
> --
> Ron Watkins, K7DOG
> 602.743.5272
>


There is no unused space in PostgreSQL like this. It will use all the
available space on disk that you give it. It is not like Oracle where you
can reserve segment sizes.

So for this, you'd just monitor your available space on disk for the
filesystem that PostgreSQL is using.

-- 
Keith Fiske
Senior Database Engineer
Crunchy Data - http://crunchydata.com

--0000000000003d09de05eb3dcc00
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><br></div><br><div class=3D"gmail_quote">=
<div dir=3D"ltr" class=3D"gmail_attr">On Mon, Oct 17, 2022 at 12:48 PM Ron =
Watkins &lt;<a href=3D"mailto:rwatki@gmail.com">rwatki@gmail.com</a>&gt; wr=
ote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px=
 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D=
"ltr">I have a request to supply business owner with both the available siz=
e of DB as well as the used size of the DB. I have been able to locate the =
used size, but I don&#39;t see any way to query the available size (used=C2=
=A0+ unused space). How can I find that in PSQL?<br clear=3D"all"><div><br>=
</div>-- <br><div dir=3D"ltr"><div dir=3D"ltr"><div>Ron Watkins, K7DOG<br>6=
02.743.5272</div></div></div></div>
</blockquote></div><br clear=3D"all"><div><br></div><div>There is no unused=
 space in PostgreSQL like this. It will use all the available space on disk=
 that you give it. It is not like Oracle where you can reserve segment size=
s.</div><div><br></div><div>So for this, you&#39;d just monitor your availa=
ble space=C2=A0on disk for the filesystem that PostgreSQL is using.</div><d=
iv><br></div>-- <br><div dir=3D"ltr" class=3D"gmail_signature"><div dir=3D"=
ltr"><div><div dir=3D"ltr">Keith Fiske<br>Senior Database Engineer<br>Crunc=
hy Data - <a href=3D"http://crunchydata.com" target=3D"_blank">http://crunc=
hydata.com</a></div></div></div></div></div>

--0000000000003d09de05eb3dcc00--