Jump to content

PostgreSQL on Windows - Terrible performance

DOWNEY
By DOWNEY
in Programs, Apps and Websites
 Share
Go to solution Solved by rockking1379,

how is disc io?

also i see the work memory is 100MB maybe try increasing that?

Posted

Performance is extremely bad. Every query is painfully slow.

Tried changing shared buffers size, no improvements. Postgres is using ~20MB of RAM.

Link to comment
Share on other sites
Link to post
Share on other sites
Posted
  • Author

Overall, it is still slower than MySQL and I don't think that I can do much, but disc io was a good point for one of databases. Thanks.

Link to comment
Share on other sites
Link to post
Share on other sites
Posted
15 minutes ago, DOWNEY said:

Overall, it is still slower than MySQL and I don't think that I can do much, but disc io was a good point for one of databases. Thanks.

Do you have it running on spinning disk or solid state? Is it possible you could setup a solid state cache?

Link to comment
Share on other sites
Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Go to topic listing Programs, Apps and Websites

×