[PERFORM] High Planning Time

2016-01-21 Thread Phil S
I am running Postgresql on a Windows Server 2008 server. I have noticed that queries have very high planning times now and then. Planning times go down for the same query immediately after the query runs the first time, but then go up again after if the query is not re-run for 5 minutes or so. I a

Re: [PERFORM] insert performance

2016-01-21 Thread Jinhua Luo
Hi, There is another problem. When the autovacuum recycles the old pages, the ReadBuffer_common() would do mdread() instead of mdextend(). The read is synchronous, while the write could be mostly asynchronous, so the frequent read is much worse than write version. Any help? Please. Regards, Jinh