> > >> > >> > This is irrelevant of amount of data restored, i am seeing the same >> behavior with just schema restore, as well as with schema+data restores. >> > >> > If anyone is interested i may upload the schema data + my benchmarking >> script with collected whisper data from my test run (i've been plotting it >> in grafana via carbon) >> > >> > Is this a known issue? Can i do anything to improve performance here? >> > > we had 10K and more tables in one database - and we had lot of issues. > > I know so Tomas fixed some issues, but we need the stat files in tmpfs > > please, read this article https://blog.pgaddict.com/ > posts/the-two-kinds-of-stats-in-postgresql >
http://hacksoclock.blogspot.cz/2014/04/putting-statstempdirectory-on-ramdisk.html > > Regards > > Pavel > > > >> >> -- >> Jerry Sievers >> Postgres DBA/Development Consulting >> e: postgres.consult...@comcast.net >> p: 312.241.7800 >> >> >> -- >> Sent via pgsql-general mailing list (pgsql-general@postgresql.org) >> To make changes to your subscription: >> http://www.postgresql.org/mailpref/pgsql-general >> > >
