public inbox for [email protected]help / color / mirror / Atom feed
Allocated size of DB? 3+ messages / 3 participants [nested] [flat]
* Allocated size of DB? @ 2022-10-17 16:48 Ron Watkins <[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:51 Keith Fiske <[email protected]> parent: Ron Watkins <[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-18 02:48 Laurenz Albe <[email protected]> parent: Ron Watkins <[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