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.
BR
Ingo Sander
Best Regards/mfG
Ingo Sander
=========================================================
Nokia Siemens Networks GmbH &Co. KG
NWS EP CP SVSS Platform Tech Support DE
St.-Martin-Str. 76
D-81541 München
(Tel.: +49-89-515938390
+ingo.sander@nsn.com
Nokia Siemens Networks GmbH & Co. KG
Sitz der Gesellschaft: München / Registered office: Munich
Registergericht: München / Commercial registry: Munich, HRA 88537
WEEE-Reg.-Nr.: DE 52984304
Persönlich haftende Gesellschafterin / General Partner: Nokia Siemens Networks Management GmbH
Geschäftsleitung / Board of Directors: Lydia Sommer, Olaf Horsthemke
Vorsitzender des Aufsichtsrats / Chairman of supervisory board: Herbert Merz
Sitz der Gesellschaft: München / Registered office: Munich
Registergericht: München / Commercial registry: Munich, HRB 163416