CREATE TEMP TABLE IF NOT EXISTS positiontemporarytable (pos_instrument_id integer, pos_code varchar(40));BEGIN TRANSACTION ISOLATION LEVEL SERIALIZABLE;prepare pos_insert (integer, varchar(40)) as insert into "positiontemporarytable" values($1, $2);execute pos_insert ('76','27958');execute pos_insert ('71','9406:58');
......
<about 8000 same 'executes' commands>
execute pos_insert ('74','19406:58');
COMMIT;
pgbench -l -t 8192 -C -f /db/postgres/report_test.sql db_test
for i in {1..8192}do echo $i psql -f /db/postgres/report_test.sql db_testdone
3. They are not WAL-logged.
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных
