PostgreSQL Database size - Gambling and Poker Software Forum

Two Plus Two Forums Online Poker Sites & Marketplaces Poker Software General Software Discussion

PostgreSQL Database size

Post Reply Subscribe

...

11-05-2008 , 10:47 AM

Telmaa

centurion

Join Date: Apr 2008 Posts: 107

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

Quote

150% up to $2,000 Welcome Bonus on CoinPoker

Join the action now

Daily Rewards • Splash Pots • CoinRaces

11-05-2008 , 11:09 AM

corsakh

Carpal \'Tunnel

Join Date: Aug 2006 Posts: 12,140

Gigs. If you datamine, its not a couple

Quote

11-05-2008 , 11:19 AM

Telmaa

centurion

Join Date: Apr 2008 Posts: 107

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.

Quote

11-05-2008 , 11:21 AM

corsakh

Carpal \'Tunnel

Join Date: Aug 2006 Posts: 12,140

Just look at your postgres folder.

Quote

11-05-2008 , 12:41 PM

fozzy71

Carpal \'Tunnel

Join Date: Mar 2007 Posts: 38,222

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.

Quote

11-05-2008 , 03:50 PM

redlotus

journeyman

Join Date: Sep 2007 Posts: 375

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

Quote

11-05-2008 , 04:10 PM

Kraada

See our Commercial Software thread

Join Date: May 2005 Posts: 6,489

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

Quote

11-05-2008 , 05:59 PM

downrange

grinder

Join Date: Feb 2007 Posts: 445

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

Quote

150% up to $2,000 Welcome Bonus on CoinPoker

Join the action now

Daily Rewards • Splash Pots • CoinRaces

Post Reply Subscribe

...