spec for dedicated PostgreSQL server

[Russelldust]

WhiteRider is pretty much correct on all points; it may not look like PostgreSQL is multithreaded but each process that splits off for each database connection should be running as its own thread as far as I understand it.

Sure they are running in separate threads (every process in Task Manager has at least one thread) but single-core CPUs are quite adept at running hundreds of threads! As I understand it, multiple cores will only give a noticeable benefit when 2+ processes/threads simultaneously do something CPU-intensive.

That's why I'm asking if this is ever likely to happen in the situation where just ONE user is connected to the dedicated PostgreSQL server.

Unless I'm making an incorrect assumption, it boils down to the question 'does PT ever ask PostgreSQL to do two things at once'?

[kraada]

I'm guessing you only ever tested with one database. If you have multiple databases running in the HUD at once, you should see multiple concurrent processes using CPU time on your server. And if you're running reports to analyze your play, and datamining as well, you most likely are going to want at least two databases (one for your play, one for datamined hands).

I think it's possible also that the import (if you're playing) is running in a separate thread than the HUD retrieval queries, but I'm not 100% certain on that.

[Russelldust]

Aha, that's exactly the sort of clarification I was looking for.

Thanks muchly.

[kraada]

You're welcome