| From: | Luca Ferrari <fluca1978(at)gmail(dot)com> |
|---|---|
| To: | PegoraroF10 <marcos(at)f10(dot)com(dot)br> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Too slow to create new schema and their tables, functions, triggers. |
| Date: | 2019-07-28 09:35:44 |
| Message-ID: | CAKoxK+4nfVhv9ZDv-i3EjC1euh5ba2NP+02Xx61xzHi2Vx3+Wg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, Jul 26, 2019 at 9:21 PM PegoraroF10 <marcos(at)f10(dot)com(dot)br> wrote:
> So, is it better to configure autovacuum properly to these tables or should
> I run vacuum periodically ?
> Obviously I´ll check our script too.
>
My guess would be that either you have disabled autovacuum on such
tables (I don't know if that is possible being system tables, but for
regular tables it is) or your script is running too frequently to let
autvacuum proceed on the sys tables. I would bet on the last one.
Seems to me you are also creating and deleting a lot of stuff to bloat
the catalog in such a way. Could it be your script is keeping a
trnsaction open (something like try in a loop)?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | farjad.farid | 2019-07-28 10:02:55 | RE: Hardware for writing/updating 12,000,000 rows per hour |
| Previous Message | Neil | 2019-07-28 00:32:59 | Re: Hardware for writing/updating 12,000,000 rows per hour |