Re: vacuum of empty table slows down as database table count grows

>
>
>> >
>> > 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(dot)consulting(at)comcast(dot)net
>> p: 312.241.7800
>>
>>
>> --
>> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-general
>>
>
>