public inbox for [email protected]
help / color / mirror / Atom feedAllocated size of DB?
3+ messages / 3 participants
[nested] [flat]
* Allocated size of DB?
@ 2022-10-17 16:48 Ron Watkins <[email protected]>
2022-10-17 16:51 ` Re: Allocated size of DB? Keith Fiske <[email protected]>
2022-10-18 02:48 ` Re: Allocated size of DB? Laurenz Albe <[email protected]>
0 siblings, 2 replies; 3+ messages in thread
From: Ron Watkins @ 2022-10-17 16:48 UTC (permalink / raw)
To: [email protected]
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Allocated size of DB?
2022-10-17 16:48 Allocated size of DB? Ron Watkins <[email protected]>
@ 2022-10-17 16:51 ` Keith Fiske <[email protected]>
1 sibling, 0 replies; 3+ messages in thread
From: Keith Fiske @ 2022-10-17 16:51 UTC (permalink / raw)
To: Ron Watkins <[email protected]>; +Cc: [email protected]
On Mon, Oct 17, 2022 at 12:48 PM Ron Watkins <[email protected]> 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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Allocated size of DB?
2022-10-17 16:48 Allocated size of DB? Ron Watkins <[email protected]>
@ 2022-10-18 02:48 ` Laurenz Albe <[email protected]>
1 sibling, 0 replies; 3+ messages in thread
From: Laurenz Albe @ 2022-10-18 02:48 UTC (permalink / raw)
To: Ron Watkins <[email protected]>; [email protected]
On Mon, 2022-10-17 at 09:48 -0700, Ron Watkins 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?
The available size would be the size of the file system that contains the data directory.
You cannot query that size from the database; you have to ask the operating system.
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2022-10-18 02:48 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2022-10-17 16:48 Allocated size of DB? Ron Watkins <[email protected]>
2022-10-17 16:51 ` Keith Fiske <[email protected]>
2022-10-18 02:48 ` Laurenz Albe <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox