Re: Runtime dependency from size of a bytea field

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Tue, Oct 5, 2010 at 3:23 AM, Sander, Ingo (NSN - DE/Munich)
<ingo.sander@xxxxxxx> 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, part1, ) values ('%d', '%s');
>        ", i, entry);
>
> 1a) In a first measurement part is supported with a bytea area (entry) of
> 4000 bytes (4000 characters)
> 1b) In a second run part is supported with a bytea area (entry) of 5000
> bytes (5000 characters).
>
> Result: The runtime of case 1a) is ~ 3 sec, however for case 1b) the runtime
> is ~ 43 sec. Why here we have such a large difference in runtime.

Probably you are hitting toast threshold and running into compression.
 compression you can disable, but toast you cannot (short of
recompiling with higher blocksz).

merlin

-- 
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance



[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux