> if the master overwrite the wal BEFORE they are sent to the standby via
> replication, does the standby *automatically* start looking in WAL
> archive destination?
> Or this step have to be made by hand?
I understand it works this way: normally, the replica tries to stream
from master. If it i
vacuumdb 15.3
database instance: 9.6.24
I manually analyzed 71 tables this morning at 10:42. (All those with
"rp20_y2021" in the relname.)
Three of the 71 tables were not analyzed. Why would that be?
(Five were not vacuumed, but I accept that some other process might have
blocked them.)
vac
On 12/13/23 15:49, Sean Flaherty wrote:
More information needed:
2) An example of reported size for the 14.? and 15.5 cases.
Since upgrading from 14.8 to 15.5, the jsonb data that was previously
written in 14.8 is reporting a smaller size than the same hourly data
written after the upgr
More information needed:
1) Table definition.
\d "DataRecords"
Partitioned table "public.DataRecords"
Column |Type | Collation | Nullable |
Default
+-+---+--+-
filename | character
On 12/13/23 14:07, Sean Flaherty wrote:
Hello,
We are seeing an increase in the reported storage size of our jsonb
columns (using pg_column_size) since upgrading to Postgres 15.5 from
version 14. The increase in size is enough to push us over the size
threshold and more of our data to get wr
Hello,
We are seeing an increase in the reported storage size of our jsonb columns
(using pg_column_size) since upgrading to Postgres 15.5 from version 14.
The increase in size is enough to push us over the size threshold and more
of our data to get written to the TOAST table.
I can't find any in
On 12/13/23 06:42, Igniris Valdivia Baez wrote:
Hello,
How is saved to xls files? --- using pentaho there is a tool there to
output data in different formats in this case xls
Defined reviewed, on particular is the data changed? ---Yes, some
descriptions are changed
How is transferred from xls to
Igniris Valdivia Baez wrote:
> 3. After the revision the data is loaded to the destiny database and
> here is were I believe the issue is, because the data is reviewed in
> Windows and somehow Pentaho is not understanding correctly the
> interaction between both operating systems.
On Wind
Hello,
How is saved to xls files? --- using pentaho there is a tool there to
output data in different formats in this case xls
Defined reviewed, on particular is the data changed? ---Yes, some
descriptions are changed
How is transferred from xls to to the database? --- Using pentaho
there is a tool
Hi,
we have a doubt interpreting documentation. We have a 9.6
installation master+stand-by in streaming replication.
Master database
is in archive mode and WAL archive destination (NFS) is mounted in both
master and stand-by servers.
The question is regarding this part of
documentation:
(https:
10 matches
Mail list logo
