create table UPD_TST (
  ID      integer not null,
  STR80   varchar(80) not null,
  FDATE   date not null,
  STR2000 varchar(2000)
);

alter table UPD_TST
  add constraint PK_UPD_TST
      primary key  ( ID, STR80, FDATE );

while i <= 6 * 1000 * 1000

create table TEST (
    ID        integer not null,
    STR_80    varchar(80) not null,
    DAT       date not null,
    STR_2000  varchar(2000)
);

execute block
as
  declare variable ID integer;
begin
  ID = 0;
  while ( ID < 100000000 ) do
  begin
    ID = :ID + 1;
    insert into TEST (
        ID,
        STR_80,
        DAT,
        STR_2000 )
    values ( :ID,
             'STR_80( ' || lpad( :ID, 9, '0' ) || ' )',
             current_date,
             'STR_2000( ' || current_date || ' ) - STR_80( ' || lpad( :ID, 9, '0' ) || ' )' );
  end
end;

DO
$$DECLARE 
  ID integer;
BEGIN
  ID = 0;
  WHILE ( ID < 100000000 ) LOOP
    ID = ID + 1;
    insert into TEST (
        ID,
        STR_80,
        DAT,
        STR_2000 )
    values (
        ID,
        'STR_80( ' || lpad( cast( ID as varchar(9) ), 9, '0' ) || ' )',
        current_date,
        'STR_2000( ' || current_date || ' ) - STR_80( ' || lpad( cast( ID as varchar(9) ), 9, '0' ) || ' )' );
  END LOOP;
END$$;

-- FB - 6 мин 38 сек
-- PG - 2 мин 51 сек
alter table TEST
  add constraint PK_TEST
      primary key (ID,STR_80,DAT);

-- FB - 7.72 сек
-- PG - 2.42 сек
select count(*)
  from TEST
 where ID between 1 and 10000000;

-- FB - 7.69 сек
-- PG - 2.11 сек
select count(*)
  from TEST
 where ID between 45000001 and 55000000;

-- FB - 7.67 сек
-- PG - 2.45 сек
select count(*)
  from TEST
 where ID between 99000001 and 100000000;

-- FB - 27.94 сек
select first(100000) skip(20000000) *
  from TEST
 where ID > 0
 order by ID, STR_80, DAT;

-- PG - 3.53 сек
select *
  from TEST
 where ID > 0
 order by ID, STR_80, DAT
limit(100000) offset(20000000);

-- FB - 26.18 сек
select first(100000) skip(20000000) *
  from TEST
 where ID > 30000000
 order by ID, STR_80, DAT;

-- PG - 32.14 сек
select *
  from TEST
 where ID > 30000000
 order by ID, STR_80, DAT
limit(100000) offset(20000000);

-- FB - 25.26 сек
select first(100000) skip(20000000) *
  from TEST
 where ID > 79000000
 order by ID, STR_80, DAT;

-- PG - 13.76 сек
select *
  from TEST
 where ID > 79000000
 order by ID, STR_80, DAT
limit(100000) offset(20000000);

-- FB - 2 мин 43 сек
-- PG - 3 мин 53 сек
update TEST
   set STR_2000 = STR_2000 || STR_2000
 where ID between 45000001 and 55000000;