ceph/src/arrow/dev/benchmarking/ddl/1_07_table_public_benchmark_type.sql

   1 /*
   2   Licensed to the Apache Software Foundation (ASF) under one
   3   or more contributor license agreements.  See the NOTICE file
   4   distributed with this work for additional information
   5   regarding copyright ownership.  The ASF licenses this file
   6   to you under the Apache License, Version 2.0 (the
   7   "License"); you may not use this file except in compliance
   8   with the License.  You may obtain a copy of the License at
   9
  10     http://www.apache.org/licenses/LICENSE-2.0
  11
  12   Unless required by applicable law or agreed to in writing,
  13   software distributed under the License is distributed on an
  14   "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
  15   KIND, either express or implied.  See the License for the
  16   specific language governing permissions and limitations
  17   under the License.
  18 */
  19
  20
  21 -- BENCHMARK_TYPE
  22 CREATE TABLE IF NOT EXISTS public.benchmark_type
  23 (
  24   benchmark_type_id SERIAL PRIMARY KEY
  25   , benchmark_type citext NOT NULL UNIQUE
  26   , lessisbetter boolean NOT NULL
  27 );
  28 COMMENT ON TABLE public.benchmark_type
  29   IS 'The type of benchmark. For example "time", "mem", "peakmem", "track"';
  30 COMMENT ON COLUMN public.benchmark_type.benchmark_type
  31   IS 'The type of units, so ''time'' for seconds, miliseconds, or '
  32      '''mem'' for kilobytes, megabytes.';
  33 COMMENT ON COLUMN public.benchmark_type.lessisbetter
  34   IS 'True if a smaller benchmark value is better.';
  35
  36 -- CONSTRAINTS
  37 ALTER TABLE public.benchmark_type
  38   ADD CONSTRAINT benchmark_type_check_benchmark_type_char_length
  39   CHECK (char_length(benchmark_type) < 63);