Initial queries of day slow
От | Rebecca Clarke |
---|---|
Тема | Initial queries of day slow |
Дата | |
Msg-id | CAMChtdfUqgQN+sb4mzsJYc+1istaQDijPZJq8D7+5EMcXz=6rA@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: Initial queries of day slow
Re: Initial queries of day slow Re: Initial queries of day slow |
Список | pgsql-general |
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
Would love peoples opinions on what the issue could be.
Thanks
В списке pgsql-general по дате отправления: