PDA

View Full Version : Postgres 8.4- PATHETIC!!!!!!!!!!!!!!!!!!!



omaha
02-04-2010, 05:54 AM
I have a huuuuuge db that was with postgres 8.3, and a solid state drive. The initial import speed was 200 hands/sec, and thelast import speed was 170 hands/seconds. This had never been analysed

For some strange reason, i decided to uninstall hem and reinstall it, it installed postgres 8.4.

Initially, i got about 70 hands/seconds, which is woeful, and what i got with a cruddy hard disk

So, i used the tuning wizard, and Now, with a brand new db, I get about 100 hands/sec import

So, now i have two questions

WHy is 8.4 much worse than 8.3?

Is it possible to uninstall what i have, and put an old version back on?

fozzy71
02-05-2010, 12:39 AM
Our new combo installer uses 8.4 instead of 8.3. I am not sure why the performance would be that much worse, but I will forward it to my colleague that is more knowledgeable about hardware and SSDs.

If you want to reinstall the old version of postgresql that we distributed in the past:

*Please update to the latest beta - http://www.holdemmanager.com/downloads/HmBetaUpdate.exe

1) Uninstall PostgreSQL from the Windows Control Panel.
2) Start > Programs > Accessories > Command Prompt > Right-Click > Run As Administrator

net user postgres /delete
B) Reboot.
C) Download and unzip this package to a new folder and then run the 157Kb file named: postgresql-8.3.msi

http://www.holdemmanager.com/downloads/postgresql.zip

Patvs
02-08-2010, 05:35 PM
Which SSD?
With TRIM enabled?

SQL 8.3 vs 8.4 speeds should be the same. If they're not, a cause can be:
-different port (5432 vs 5433)
-Firewall/Antivirus/Defender program interfering with the SQL connection
-harddisk not defragged/trimmed
-different settings in the postgresql.conf file