Re: Initial queries of day slow

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*

In response to

Browse pgsql-general by date

  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