I am experiencing an odd issue, i've noticed it on 9.3 , but i can
reproduce it on 9.6.
Basically, i have a database with a lot of schemas, but not that much data.
Each schema is maybe 2-4 GB in size, and often much less than that.
The database has ~300-500 schemas, each with ~100-300 tables. Gen
Thanks, i'll redo the benchmarks and report back how things look now.
2017-01-04 20:33 GMT+01:00 Pavel Stehule :
>
>>> >
>>> > 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
Well, unfortunately i am not seeing much difference. I shaved off maybe a
second of worst case run.
I guess i should just split the db into smaller ones, since tmpstats are
now per-db. Are there any other things i could try?
2017-01-05 8:18 GMT+01:00 marcin kowalski :
> Thanks, i'll
Hi list.
I'm migrating a bunch of old suse 9.3 systems with postgresql 8.2 databases
to opensuse 11.4 systems with 8.2 databases (the exact same version -
8.2.14). From there, the databases will be migrated to postgresql 9.x with
custom process.
Let's assume that 9.3 machine is machine A, and new
