Re: Too slow to create new schema and their tables, functions, triggers.

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: PegoraroF10 <marcos(at)f10(dot)com(dot)br>, pgsql-general(at)postgresql(dot)org
Subject: Re: Too slow to create new schema and their tables, functions, triggers.
Date: 2019-07-24 19:05:41
Message-ID: 18481dfb-af39-b6a2-7b27-88563cab7134@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 7/24/19 11:33 AM, PegoraroF10 wrote:
> I did not have vacuumed or reindexed my database for last 30 days and that
> was my problem.

Autovacuum should be dealing with this.

Do you have it throttled in some manner?

> It works fine if I do a reindex database before adding that new schema.
> Well, I´ll try just reindexing system before adding a new schema to see if
> it works.
>
>
>
>
>
> --
> Sent from: https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
>
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Souvik Bhattacherjee 2019-07-24 19:22:31 Re: Running concurrent txns and measuring the timings in Postgres
Previous Message PegoraroF10 2019-07-24 18:33:48 Re: Too slow to create new schema and their tables, functions, triggers.