# set client_min_messages = 'debug1';
# select count(*) over (order by four range between unbounded preceding and 2 preceding) from tenk1 limit 1;
DEBUG:  startup_tuples = 1
 count
-------
     0

# select count(*) over (order by four range between unbounded preceding and 2 following) from tenk1 limit 1;
DEBUG:  startup_tuples = 7500
 count
-------
  7500

# select count(*) over (order by four range between unbounded preceding and 2 following exclude current row) from tenk1 limit 1;
DEBUG:  startup_tuples = 7499
 count
-------
  7499

# select count(*) over (order by four range between unbounded preceding and 2 following exclude ties) from tenk1 limit 1;
DEBUG:  startup_tuples = 5001
 count
-------
  5001

# select count(*) over (order by four range between unbounded preceding and 20000 following exclude ties) from tenk1 limit 1;
DEBUG:  startup_tuples = 7501
 count
-------
  7501

# select count(*) over (order by four range between unbounded preceding and 20000 following exclude group) from tenk1 limit 1;
DEBUG:  startup_tuples = 7500
 count
-------
  7500

# select count(*) over (order by four range between unbounded preceding and 20000 following exclude current row) from tenk1 limit 1;
DEBUG:  startup_tuples = 9999
 count
-------
  9999

# select count(*) over (order by four range between unbounded preceding and 20000 following) from tenk1 limit 1;
DEBUG:  startup_tuples = 10000
 count
-------
 10000

# select count(*) over (order by four range between unbounded preceding and 0 following) from tenk1 limit 1;
DEBUG:  startup_tuples = 2500
 count
-------
  2500

# select count(*) over (order by four range between unbounded preceding and 0 following exclude ties) from tenk1 limit 1;
DEBUG:  startup_tuples = 1
 count
-------
     1

# select count(*) over (order by four range between unbounded preceding and 0 following exclude group) from tenk1 limit 1;
DEBUG:  startup_tuples = 1
 count
-------
     0

# select count(*) over (order by four range between unbounded preceding and 0 following exclude current row) from tenk1 limit 1;
DEBUG:  startup_tuples = 2499
 count
-------
  2499

# select count(*) over (order by four rows between unbounded preceding and 4000 following) from tenk1 limit 1;
DEBUG:  startup_tuples = 4001
 count
-------
  4001

# select count(*) over (order by four rows between unbounded preceding and 4000 following exclude group) from tenk1 limit 1;
DEBUG:  startup_tuples = 1501
 count
-------
  1501

# select count(*) over (order by four rows between unbounded preceding and 4000 following exclude ties) from tenk1 limit 1;
DEBUG:  startup_tuples = 1502
 count
-------
  1502