yes i'm very sure. from what i observed, it has something to do with the concurrent query planing. if i disconnect other connections, the plan is very quick.
2015-08-11 22:42 GMT+08:00 Maxim Boguk <maxim.bo...@gmail.com>: > > > Check constraints: >> "article_729_cid_check" CHECK (cid = 729) >> > > > Used partition schema looks very simple and straightforward, and should > have no issues with 80 partitions. > Are you sure that you have only 80 partitions but not (lets say) 800? > Are every other partition of the article table use the same general idea > of partition check (cid=something)? > > > Maxim Boguk > Senior Postgresql DBA > http://www.postgresql-consulting.ru/ > <http://www.postgresql-consulting.com/> > > Phone RU: +7 910 405 4718 > Phone AU: +61 45 218 5678 > > LinkedIn: http://www.linkedin.com/pub/maksym-boguk/80/b99/b1b > Skype: maxim.boguk > Jabber: maxim.bo...@gmail.com > МойКруг: http://mboguk.moikrug.ru/ > > "People problems are solved with people. > If people cannot solve the problem, try technology. > People will then wish they'd listened at the first stage." > >
