On Thu, Mar 15, 2012 at 6:43 AM, Aleksey Tsalolikhin
<atsaloli.tech@gmail.com> wrote:
Is there any way to consolidate the pages on the slave without taking
replication offline?
maybe CLUSTER?
filip@dev=> create table foobar (id serial primary key, load text);
CREATE TABLE
filip@dev=> insert into foobar(load)select md5(random()::text) from generate_series(1,100000);
INSERT 0 100000
filip@dev=> delete from foobar where id%4<>3; -- delete 75% of the table
DELETE 75000
filip@dev=> select pg_relation_size('foobar');
pg_relation_size
------------------
6832128
(1 row)
filip@dev=> CLUSTER foobar using foobar_pkey;
CLUSTER
filip@dev=> select pg_relation_size('foobar');
pg_relation_size
------------------
1712128
(1 row)
Of course events destined to this table will be queued by Slony while the table is locked.
Filip
