Help: how to speed up query after db server reboot

From: Wei Yan <weiyan1(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Help: how to speed up query after db server reboot
Date: 2009-09-01 22:01:41
Message-ID: 14d06d70909011501x33081d81s75bd31e8a30b6316@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Hrishikesh (हृषीकेश मेहेंदळे) 2009-09-01 22:11:50 Re: Performance issues with large amounts of time-series data
Previous Message Robert Schnabel 2009-09-01 12:33:10 Re: moving data between tables causes the db to overwhelm the system