From: | Atri Sharma <atri(dot)jiit(at)gmail(dot)com> |
---|---|
To: | Rebecca Clarke <r(dot)clarke83(at)gmail(dot)com> |
Cc: | PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Initial queries of day slow |
Date: | 2014-04-07 09:41:27 |
Message-ID: | CAOeZVidDbpdpOqtZ2-+5c+R0gxxeEgxh58MJh=M=f+Lo_U5-sA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Mon, Apr 7, 2014 at 3:02 PM, Rebecca Clarke <r(dot)clarke83(at)gmail(dot)com> wrote:
> Hi all.
>
> I'm a bit stumped. At present I'm finding that queries to my database,
> that normally execute promptly, are taking a long time when they are
> executed first thing in the morning (after the database has been inactive
> for several hours). After the first execution, everything is back to
> normal.
>
> A while back I turned autovacuum off and now instead I run a daily cron at
> 3am that executes a script which does a VACUUM ANALYZE on each table.
>
> These are my details:
>
> Debian GNU/Linux 6.0
> Postgresql 9.1
> Memory 4GB
>
> shared_buffers = 1024MB
> work_mem = 16MB
> maintenance_work_mem = 128MB
> effective_cache_size = 2048MB
>
>
>
Could it be cold cache behaviour?
--
Regards,
Atri
*l'apprenant*
From | Date | Subject | |
---|---|---|---|
Next Message | Nithya Soman | 2014-04-07 09:46:18 | How do you find the row count for all your tables in Postgres? |
Previous Message | Rebecca Clarke | 2014-04-07 09:32:59 | Initial queries of day slow |