Postgres Pro
Downloads
Home   >   mailing lists

Help: how to speed up query after db server reboot - Mailing list pgsql-performance

From Wei Yan
Subject Help: how to speed up query after db server reboot
Date
Msg-id 14d06d70909011501x33081d81s75bd31e8a30b6316@mail.gmail.com
Whole thread Raw
Responses Re: Help: how to speed up query after db server reboot
List pgsql-performance
Tree view
Hi:

Looks like after postgres db server reboot, first query is very slow (10+mins). After the system cache built, query is pretty fast.
Now the question is how to speed up the first query slow issue?

Any pointers?

Thanks
wei

pgsql-performance by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: partition queries hitting all partitions even thoughcheck key is specified
Next
From: astro77
Date:
Subject: Slow select times on select with xpath