On Mon, Apr 7, 2014 at 3:02 PM, Rebecca Clarke <r.clark...@gmail.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*