From: | Andres Freund <andres(at)anarazel(dot)de> |
---|---|
To: | Dmitriy Sarafannikov <d(dot)sarafannikov(at)bk(dot)ru> |
Cc: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, PostgreSQL Bugs <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Re: Too many files in pg_replslot folder |
Date: | 2016-03-17 23:21:37 |
Message-ID: | 20160317232137.wdg726cwsea5tmwd@alap3.anarazel.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Hi,
On 2016-03-16 14:06:35 +0300, Dmitriy Sarafannikov wrote:
> Sorry, autovacuum not involved in this.
> I took several xids from this files and found them in WAL with pg_xlogdump:
> rmgr: Heap len (rec/tot): 67/ 99, tx: 2918822231, lsn:
> 4983/D8FF8388, prev 4983/D8FF8338, bkp: 0000, desc: insert: rel
> 1663/16428/133587958; tid 5737/114
> rmgr: Btree len (rec/tot): 34/ 66, tx: 2918822231, lsn:
> 4983/D8FF83F0, prev 4983/D8FF8388, bkp: 0000, desc: insert: rel
> 1663/16428/133587964; tid 6560/2
> rmgr: Btree len (rec/tot): 50/ 82, tx: 2918822231, lsn:
> 4983/D8FF8438, prev 4983/D8FF83F0, bkp: 0000, desc: insert: rel
> 1663/16428/133926198; tid 27418/14
> rmgr: Btree len (rec/tot): 50/ 82, tx: 2918822231, lsn:
> 4983/D8FF8490, prev 4983/D8FF8438, bkp: 0000, desc: insert: rel
> 1663/16428/148286684; tid 14048/2
>
> i noticed that they are points to table, that filled by trigger functions
> with upsert.
Hm, interesting. I wonder, could you try this with a source checkout of
9.4? There's some fixes in the upcoming minor release that might be
related. If not, I'll look into it.
- Andres
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2016-03-17 23:21:41 | Re: BUG #14024: problem in Creating pivot table |
Previous Message | John R Pierce | 2016-03-17 23:18:52 | Re: BUG #14026: Problem to convert number to real |