Hi Álvaro Herrera,
Please find the corresponding output:
*1).select name, setting, source, sourcefile, sourceline from pg_settings
where name like '%vacuum%'; *
-[ RECORD 1 ]
name | autovacuum
setting| on
source | configuration file
sourcefile
Please show the output of these queries in the relevant databases:
select name, setting, source, sourcefile, sourceline from pg_settings where
name like '%vacuum%';
select oid::regclass, reloptions from pg_class where reloptions is not null;
--
Álvaro Herrerahttps://www.2ndQuadr
On Wed, Jan 24, 2018 at 7:48 AM, Pavan Teja
wrote:
>
>
> Yes, but why doing vacuum freeze of a table is causing a rapid
> archiving??
> Any idea??
>
>
IIUC Freezing involves physically altering those pages that are not frozen
to make them frozen. Those changes are logged just like any (mo
On Jan 24, 2018 7:57 PM, "Claudio Freire" wrote:
On Wed, Jan 24, 2018 at 8:50 AM, pavan95
wrote:
> Hello all,
>
> One more interesting observation made by me.
>
> I have ran the below query(s) on production:
>
> SELECT
> relname,
> age(relfrozenxid) as xid_age,
> pg_size_pretty(pg
On Wed, Jan 24, 2018 at 8:50 AM, pavan95
wrote:
> Hello all,
>
> One more interesting observation made by me.
>
> I have ran the below query(s) on production:
>
> SELECT
> relname,
> age(relfrozenxid) as xid_age,
> pg_size_pretty(pg_table_size(oid)) as table_size
> FROM pg_class
> WHE
Hello all,
One more interesting observation made by me.
I have ran the below query(s) on production:
SELECT
relname,
age(relfrozenxid) as xid_age,
pg_size_pretty(pg_table_size(oid)) as table_size
FROM pg_class
WHERE relkind = 'r' and pg_table_size(oid) > 1073741824
ORDER BY age(re
Hello,
This email is structured in sections as follows:
1 - Estimating the size of pg_xlog depending on postgresql.conf parameters
2 - Cleaning up pg_xlog using a watchdog script
3 - Mailing list survey of related bugs
4 - Thoughts
We're using PostgreSQL 9.6.6 on a Ubuntu 16.04.3 LTS.
During som
Hi,
The following talk describes an issue with how Linux may handle memory
allocation for Postgres. The issue may cause many hundreds of megabytes
not being released in some cases.
PostgreSQL and RAM usage [Feb 27, 2017]
https://www.youtube.com/watch?v=EgQCxERi35A
see between minutes 33 and 3
