Open Side Menu Go to the Top

11-05-2008 , 10:47 AM
Hello,

Can anyone tell me how to know the exact size of a PostgreSQL database (either HEM and PT3 as i am using both depending on the site i play on...)

I've searched on pgAdmin III and could not find the disk space my databases are using (i am wondering if it's something like a couple of Megs or Gigs).

Thanks a lot for the info
PostgreSQL Database size Quote
PostgreSQL Database size
150% up to $2,000 Welcome Bonus on CoinPoker
Join the action now
Daily Rewards • Splash Pots • CoinRaces
PostgreSQL Database size
11-05-2008 , 11:09 AM
Gigs. If you datamine, its not a couple
PostgreSQL Database size Quote
11-05-2008 , 11:19 AM
that's what i think too but i wanna know how much EXACTLY... just to be able to make new databases once they get out of control size wise.
PostgreSQL Database size Quote
11-05-2008 , 11:21 AM
Just look at your postgres folder.
PostgreSQL Database size Quote
11-05-2008 , 12:41 PM
Quote:
Originally Posted by Telmaa
that's what i think too but i wanna know how much EXACTLY... just to be able to make new databases once they get out of control size wise.
This wont happen, unless you run out of HD space. You can have 10 - 20 million hands in a DB, and still get proper performance.
PostgreSQL Database size Quote
11-05-2008 , 03:50 PM
Click on the "Tables" icon for the database you are wondering about. Click the statistics tab on the right and you'll get a list of the sizes for all of the tables. Add them up and you have your answer.

-red
PostgreSQL Database size Quote
11-05-2008 , 04:10 PM
FWIW, I believe the PT3 rate is 5G/1M hands, roughly. (More for FR, less for 6M)

Either way it's a fairly reliable ballpark. And the biggest database I've heard of someone actively using runs about 55M hands. And no, that's not a typo
PostgreSQL Database size Quote
11-05-2008 , 05:59 PM
Quote:
Originally Posted by Telmaa
Hello,

Can anyone tell me how to know the exact size of a PostgreSQL database (either HEM and PT3 as i am using both depending on the site i play on...)
I don't use pgadmin but I think it can function as a front-end to psql and in psql this will list all dbs ordered by size

Code:
SELECT datname,pg_size_pretty(pg_database_size(oid)) FROM pg_database ORDER BY pg_database_size(oid) DESC;

this will list them in reverse alphabetical
Code:
 SELECT datname,pg_size_pretty(pg_database_size(oid)) FROM pg_database ORDER BY datname DESC;

you could google some of those terms and probably find other ways to list them
PostgreSQL Database size Quote
PostgreSQL Database size
150% up to $2,000 Welcome Bonus on CoinPoker
Join the action now
Daily Rewards • Splash Pots • CoinRaces
PostgreSQL Database size

      
m