confusion

[thetruest]

I've briefly skimmed through the postgre faqs, and quick guides. I have postgre 8.2, and while dling pt3 noticed the version without, and I realized my postgre folder is over 3 gigs big. Why is it so big? I don't remember it being large at all when i got it, My c: drive is already running little low on space. If i get PT3 w/ 8.3 will that be added or installed on top of it? Can a PC have both 8.2 and 8.3 since PT2 doesn't fully support 8.3?

Why is 8.3 recommended for pt3 and what is the difference between that and 8.2?

[WhiteRider]

You *can* have both installed and running as long as they are configured to run on different ports.
Alternatively, you can just use 8.2 with PT3.
8.3 will give slightly better performance, but while you're still using PT2 and PT3 together, it will be simpler to just use 8.2.

[thetruest]

so why is my postgre folder so big?

[WhiteRider]

What have you done with postgres?
Have you got PT2 databases?
If you ran PT3 then it will have created a database for you, but unless you've imported hands into it it won't be very big.

[thetruest]

What have you done with postgres?
Have you got PT2 databases?
If you ran PT3 then it will have created a database for you, but unless you've imported hands into it it won't be very big.

that's the thing i can't remember doing anything to it. Does the size of my database affect taht? I have a few backups of my database on a totally different drive but that's it.

[WhiteRider]

If you've got backups of your databases, then you have databases, yes?
How many? Are these PT2 DBs? How big are they?

[thetruest]

If you've got backups of your databases, then you have databases, yes?
How many? Are these PT2 DBs? How big are they?

Sorry for being late to get back, forgot about this thread. I have only 1 big postgre db, and the original Access version with no hands in it. Last weekend i created a new postgre database with several thousand hands but thats it

I have several backups at differnt points for the main postgre database, none of them are under "maintain db names".

[kraada]

Try vacuuming your databases and see if that helps. If the databases aren't too large but have had data added and removed but haven't been vacuumed the space won't actually be freed up for general use.

[thetruest]

Try vacuuming your databases and see if that helps. If the databases aren't too large but have had data added and removed but haven't been vacuumed the space won't actually be freed up for general use.

what is vacuuming?

[kraada]

Vacuuming is a PostgreSQL function to recover used space from deleted rows. In PTv2, Utilities --> PostgreSQL Database Functions ... and run a Vacuum Full/Analyze and see if that recovers the space for you.