Didn't find anyone asking about this already here or on stack overflow. I'm assuming that the default value of 4 is being used for random_page_cost (I created a new pg instance today with 2 cpu/13gb memory, 100gb of ssd). This might have just been overlooked but that's an awfully high number. Most of the time for more modern san's a number in the 1.5-2.0 is considered conservative. Also, how are are shared_buffers getting set? For this instance I created today it's set to have 128mb for shared buffers.
-- You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/48f70bbb-f1ef-4972-99f4-e8355348ffa0%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
No comments:
Post a Comment