Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Core team statement on replication in PostgreSQL
- From: Greg Smith <gsmith(at)gregsmith(dot)com>
- To: Gurjeet Singh <singh(dot)gurjeet(at)gmail(dot)com>
- Cc: "Andreas 'ads' Scherbaum" <adsmail(at)wars-nicht(dot)de>, pgsql-hackers(at)postgresql(dot)org
- Subject: Re: Core team statement on replication in PostgreSQL
- Date: Fri, 30 May 2008 18:11:20 -0400 (EDT)
- Message-id: <Pine(dot)GSO(dot)4(dot)64(dot)0805301809050(dot)9617(at)westnet(dot)com>
On Sat, 31 May 2008, Gurjeet Singh wrote:
Not if you use pg_clearxlogtailThis means we need to modify pg_standby to not check for filesize when reading XLogs.
No, the idea is that you run the segments through pg_clearxlogtail | gzip, which then compresses lightly used segments massively because all the unused bytes are 0. File comes out the same size at the other side, but you didn't ship a full 16MB if there was only a few KB used.
-- * Greg Smith gsmith(at)gregsmith(dot)com http://www.gregsmith.com Baltimore, MD
- Follow-Ups:
- Re: Core team statement on replication in PostgreSQL
- From: Gurjeet Singh
- Re: Core team statement on replication in PostgreSQL
- References:
- Re: Core team statement on replication in PostgreSQL
- From: Bruce Momjian
- Re: Core team statement on replication in PostgreSQL
- From: Tom Lane
- Re: Core team statement on replication in PostgreSQL
- From: Greg Smith
- Re: Core team statement on replication in PostgreSQL
- From: Josh Berkus
- Re: Core team statement on replication in PostgreSQL
- From: Andrew Dunstan
- Re: Core team statement on replication in PostgreSQL
- From: Andreas 'ads' Scherbaum
- Re: Core team statement on replication in PostgreSQL
- From: Greg Smith
- Re: Core team statement on replication in PostgreSQL
- From: Gurjeet Singh
- Re: Core team statement on replication in PostgreSQL
- Prev by Date: Re: Core team statement on replication in PostgreSQL
- Next by Date: Re: Core team statement on replication in PostgreSQL
- Previous by thread: Re: Core team statement on replication in PostgreSQL
- Next by thread: Re: Core team statement on replication in PostgreSQL
- Indexes: