David Fogarty <dfogarty(at)icsusa(dot)com> writes:
> It seems like whenever I restart my database server performance is quite bad until an Analyze has been performed. I expect this is due to the query planner needing new stats, but that leads me to three questions:
A simple restart shouldn't invalidate statistics. I'd lay some small
change on your actual problem being not that, but the need to
repopulate the server's buffers from disk files. If so, pg_prewarm
might help you.
regards, tom lane