Slow query: SELECT name FROM pg_timezone_names

This has consistently been my slowest query from day zero in development. I'm gradually preparing to switch to production, and I'm wondering if I should take care of this, and how. My game app uses a fixed time zone (Europe/Rome) and it has to use it because some aspects of the game depend strongly on it (daily challenges, and the definition of daily has to follow the date change in Italy). So, I cannot get rid of the timezone, but perhaps I could avoid causing the engine to query for it. Just to clarify: I don't launch that query directly, I guess it's implied by the way my tables and functions work. Thank you in advance for any hint or help.
No description
0 Replies
No replies yetBe the first to reply to this messageJoin

Did you find this page helpful?