Re: [GENERAL] vacuum of empty table slows down as database tablecount grows - Mailing list pgsql-general

From Pavel Stehule
Subject Re: [GENERAL] vacuum of empty table slows down as database tablecount grows
Date
Msg-id CAFj8pRBT5Wj_vpdufSigNhS5B-yPPwnKtmQ+ipXGoQkFWvYT=w@mail.gmail.com
Whole thread Raw
In response to Re: [GENERAL] vacuum of empty table slows down as database tablecount grows  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: [GENERAL] vacuum of empty table slows down as database tablecount grows
List pgsql-general

>
> 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 


 

Regards

Pavel

>

--
Jerry Sievers
Postgres DBA/Development Consulting
e: postgres.consulting@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


pgsql-general by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: [GENERAL] vacuum of empty table slows down as database tablecount grows
Next
From: Kisung Kim
Date:
Subject: Re: [GENERAL] Performance degradation when using auto_explain