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.

0 Replies