Changing of the storage method ( alter table bytea_demo Alter part1 Set
storage EXTERNAL)
or the increasing of the BLOCK_SIZE (new compilation of the code with
--with-blocksize=32) change the behaviour.
Ingo Sander
-Original Message-
From: ext Craig Ringer [mailto:cr...@postnewspapers
On 10/06/2010 12:11 AM, Merlin Moncure wrote:
Probably you are hitting toast threshold and running into compression.
compression you can disable, but toast you cannot (short of
recompiling with higher blocksz).
For the OP's reference:
http://www.postgresql.org/docs/current/static/storage-to
On Tue, 2010-10-05 at 14:41 +0530, Nimesh Satam wrote:
> We have been trying to implement the streaming replication on one of
> our test servers. We have set archive_xlogs to on. But on the standby
> server, when we start the database we get error the following errors:
>
> LOG: shutting down
> L
On Tue, Oct 5, 2010 at 3:23 AM, Sander, Ingo (NSN - DE/Munich)
wrote:
> Hi,
>
> We have done the following test with PostgreSQL 9.0.
>
> create table bytea_demo ( index int, part1 bytea)");
>
> Then we have instantiated a loop (1000) with the following action:
>
> insert into bytea_demo ( index, p
I wasn't involved in this work but I do know a bit about it. Sadly, the
work on Postgres performance was cut down to under a page, complete
with the amazing offhand mention of "rewriting PostgreSQL's lock
manager". Here are a few more details...
The benchmarks in this paper are all about stressing
Hi All,
We have been trying to implement the streaming replication on one of our
test servers. We have set archive_xlogs to on. But on the standby server,
when we start the database we get error the following errors:
LOG: shutting down
LOG: database system is shut down
LOG: database system was
Hi,
We have done the following test with PostgreSQL 9.0.
create table bytea_demo ( index int, part1 bytea)");
Then we have instantiated a loop (1000) with the following action:
insert into bytea_demo ( index, part1, ) values ('%d', '%s');
", i, entry);
1a) In a first measurement part
