2011/11/14 Scott Ribe :
> On Nov 14, 2011, at 10:59 AM, Jean-Armel Luce wrote:
>
>> just for the value : rsync --checksum is the option to use to prevent
>> copying of identical files
>
> No, that's not what it's used for. It already avoids sending identical blocks
> by using checksums. --checksum
hello to all,
i am facing an issue concerning cancelled queries made on a hot standby
server. if we suppose that there are some tables that are never changed (no
inserts/updates/deletes) and that autovacuum is set to false for these
tables, what else could there be affecting these tables and conse
On Nov 15, 2011, at 3:02 AM, Cédric Villemain wrote:
> no, you are wrong.
> -c, --checksum
> "This changes the way rsync checks if the files have been changed and
> are in need of a transfer. Without this option, rsync uses a "quick
> check" that (by default) checks if each file's size and time of
2011/11/15 Scott Ribe :
> On Nov 15, 2011, at 3:02 AM, Cédric Villemain wrote:
>
>> no, you are wrong.
>> -c, --checksum
>> "This changes the way rsync checks if the files have been changed and
>> are in need of a transfer. Without this option, rsync uses a "quick
>> check" that (by default) checks
On Nov 15, 2011, at 8:30 AM, Cédric Villemain wrote:
> Seriously, I did. Is my post "just for the value : rsync --checksum is
> the option to use to prevent copying of **identical files**" incorrect
> ?
It's at least incomplete and somewhat misleading. But I guess you could say the
same about my
Sorry to be so long to answer :-(
2011/11/14 Scott Ribe
- How large is the db? By which I mean how much disk space does the
data directory occupy?
20 GB
- What's the bandwidth of the network connection to the distant slave?
during rsync, I see narly 125Mbits/sec
- What's the CPU &
Humm sorry, I did a mistake
2011/11/15 Jean-Armel Luce
> Sorry to be so long to answer :-(
>- How large is the db? By which I mean how much disk space does the
> data directory occupy?
> 100 GB
>
>
>
> 2011/11/14 Scott Ribe
>
> - How large is the db? By which I mean how much disk space
> This afternoon, I have again sent some updates requests, which were
> replicated to the sslaves.
> :
> - I am looking modification of modification dates and checksums of 2 tables
> among my 6000 tables :
> For each file, the checksum is the same on all the slaves, but different
> from the checks
On 11/15/2011 05:46 AM, MirrorX wrote:
i am facing an issue concerning cancelled queries made on a hot standby
server. if we suppose that there are some tables that are never changed (no
inserts/updates/deletes) and that autovacuum is set to false for these
tables, what else could there be affect
thanks a lot. the way it works is crystal clear to me now
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/cancelled-queries-on-standby-tp4994025p4995933.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
--
Sent via pgsql-admin mailing list (pgsql
10 matches
Mail list logo
