That was exactly that one bug. Thanks a lot
вт, 14 марта 2017 г., 23:26 Jeff Janes :
> On Tue, Mar 14, 2017 at 5:09 AM, Антон Тарабрин
> wrote:
>
> Good day. It seems that we have some strange case of VACUUM malfunction
> and table bloating.
>
> PostgreSQL 9.5.3
>
>
omeone else will chime in ...
>
--
___
С наилучшими пожеланиями,
Антон Тарабрин
With best regards,
Anton Tarabrin
tivity where state<>'idle';
> select * from pg_stat_activity where state<>'idle' order by xact_start
> limit 1;
>
--
___
С наилучшими пожеланиями,
Антон Тарабрин
With best regards,
Anton Tarabrin
relname in
> ('__orders_y2017_m3_to_drop', '__orders_y2017_m2_to_drop');
> select * from pg_stat_database;
>
--
___
С наилучшими пожеланиями,
Антон Тарабрин
With best regards,
Anton Tarabrin
date patterns make it difficult to keep bloat down; we
> can see some rollbacks which I'm sure are part of your problem.
>
> You could try updating to the latest minor version of postgres as there
> are a few fixes to autovacuum in versions after 9.5.3, but I think
> analyzing your
n and again
--
___
С наилучшими пожеланиями,
Антон Тарабрин
With best regards,
Anton Tарабрин
Hello, google nothing for @ operator =(, what does this mean field1 <@ (
subquery ) ?
ps: sorry for my english
No. I'm Administrator.
About TEMP:
- %USERPROFILE%\AppData\Local\Temp (this is for current user)
- %SystemRoot%\TEMP (system var)
Im elso check disk free space - it's ok.
- Original Message -
From: "Raymond O'Donnell"
To: "tbazadaykin"
Cc:
Sent: Sunday, December 19, 2010 8:04 PM
S
