Καλημέρα Κυριάκο
We have been running 9.3.4 as our test system for quite some years, and 9.3.10 on production for a month or so (little less than 1T size, WAL changes worth of 2-5GB/day, about 250K xations/day) we
never experienced any problems with data/pg_multixact.
In our 9.3.4 :
%
Hello,
Our pg_multixact directory keeps growing. I did a "vacuum freeze” which didn’t
help. I also did a "vacuum full” which didn’t help either.
We had this condition with 9.3.4 as well. When I upgraded our cluster to 9.4.5
(via plain sql dump and load) as expected the issue was resolved but
On Thu, Feb 11, 2016 at 7:52 AM, Kiriakos Georgiou
wrote:
> Hello,
>
> Our pg_multixact directory keeps growing. I did a "vacuum freeze” which
> didn’t help. I also did a "vacuum full” which didn’t help either.
> We had this condition with 9.3.4 as well. When I
Thomas Munro wrote:
> 4. You could look into whether all those multixacts with many member
> are really expected. (Large numbers of concurrent FK checks or
> explicit share locks on the same rows perhaps? A good proportion of
> this happened on one day this week I see.)
I think maybe this
On Thu, Feb 11, 2016 at 11:05 AM, Alvaro Herrera
wrote:
> Thomas Munro wrote:
>
>> 4. You could look into whether all those multixacts with many member
>> are really expected. (Large numbers of concurrent FK checks or
>> explicit share locks on the same rows perhaps?
El 17/09/14 10:51, Dev Kumkar escribió:
On Wed, Sep 17, 2014 at 6:53 PM, Andres Freund and...@2ndquadrant.com
mailto:and...@2ndquadrant.com wrote:
On 2014-09-17 17:46:05 +0530, Dev Kumkar wrote:
On one my machine the pg_multixact directory size has grown up
to 5 GB and
am
On Fri, Sep 19, 2014 at 7:14 PM, Emanuel Calvo
emanuel.ca...@2ndquadrant.com wrote:
Could it be related to some fixes on 9.3.5?:
- Fix wraparound handling for pg_multixact/members (Álvaro Herrera)
- Truncate pg_multixact during checkpoints, not during VACUUM (Álvaro
Herrera)
Currently
Hello,
On one my machine the pg_multixact directory size has grown up to 5 GB and
am not sure how to clean up this directory.
From the storage-file-layout this directory contains multitransaction
status data.
pg_multixactSubdirectory containing multitransaction status data (used for
shared row
On 2014-09-17 17:46:05 +0530, Dev Kumkar wrote:
On one my machine the pg_multixact directory size has grown up to 5 GB and
am not sure how to clean up this directory.
Which version of postgres are you using?
Greetings,
Andres Freund
--
Andres Freund
On Wed, Sep 17, 2014 at 6:53 PM, Andres Freund and...@2ndquadrant.com
wrote:
On 2014-09-17 17:46:05 +0530, Dev Kumkar wrote:
On one my machine the pg_multixact directory size has grown up to 5 GB
and
am not sure how to clean up this directory.
Which version of postgres are you using?
10 matches
Mail list logo