Lc_numeric = 'English_United States.1252'ĭefault_text_search_config = 'pg_catalog.english'Īny other information required, please let me know. Lc_monetary = 'English_United States.1252' Lc_messages = 'English_United States.1252' Shared_preload_libraries = '$libdir/plugins/plugin_debugger.dll' Here is information from the config files.Īnd postgresqlconf - I'm aware I've given some mammoth amount of buffers/memory to this config, just to test if it was the issue - showing uncommented lines only: I have also edited the postgre conf file to allow for more memory/buffers etc but I don't think this is the problem - what I am asking it to do is very simple - it shouldn't be intensive at all.Įdit: Please note the client and server are both running Windows. I've tried connecting remotely on 3 different networks now (including different routers) but the problem remains.Ĭonnecting remotely via another machine via the LAN is instant. What I do notice is on the router when the query is running that hardly any bandwidth is being used - but then again I wouldn't expect it to for a simple query but am not sure if this is the issue. I am able to telnet to the port 5432 on the VPS IP with no problems, and as I say the query does execute it just takes an extremely long time. I don't understand how MSSQL can query almost instantly yet PostgreSQL struggles so much. The database is a new database, containing hardly any data and I've ran vacuum/analyze etc all to no avail, I see no improvements.
#Postgresql pokertracker 4 software
I'm running their newest version of the software and the newest compatible version of PostgreSQL with their software.
The network communication between the two is almost instant, I am able to remotely connect fine with no lag whatsoever and am hosting several websites running MSSQL and all the queries run instantly, whether connected remotely or locally so it seems specific to PostgreSQL. The VPS is running 100MBPS and then computer I'm connecting to it from is on an 8MB line. While running it remotely, it takes about 1 minute and 30 seconds to run the query. Whilst connecting locally on the VPS, the query runs instantly. The query I am trying to execute is very small.
In the Database Management window the current PostgreSQL version is shown in the bottom right corner.
#Postgresql pokertracker 4 how to
I have done tons of research on 'remote postgresql slow' etc and am yet to find an answer so am hoping someone is able to help. How to check what PostgreSQL version PT4 is using The easiest way to check which PostgreSQL version PokerTracker 4 is using is by going to Database > Database Managementin the PT4 menu. I wanted this accessible from several different computers so decided to installed it on my VPS and after a few hiccups I managed to get it connecting without errors. PokerTracker logs all your hands and statistics whilst playing online poker. I have setup PostgreSQL on a VPS I own - the software that accesses the database is a program called PokerTracker.
0 kommentar(er)
