-- -- PostgreSQL database dump -- SET client_encoding = 'SQL_ASCII'; SET check_function_bodies = false; SET client_min_messages = warning; SET search_path = public, pg_catalog; SET default_tablespace = ''; SET default_with_oids = false; -- -- Name: pgbench; Type: TABLE; Schema: public; Owner: darcy; Tablespace: -- CREATE TABLE pgbench ( id integer NOT NULL, version text NOT NULL, clients integer, scale integer, transactions integer, tpsc numeric(9,3), tps numeric(9,3), runnumber integer, date_run date DEFAULT (now())::date ); ALTER TABLE public.pgbench OWNER TO darcy; -- -- Name: id; Type: DEFAULT; Schema: public; Owner: darcy -- ALTER TABLE pgbench ALTER COLUMN id SET DEFAULT nextval('pgbench_id_seq'::regclass); -- -- Data for Name: pgbench; Type: TABLE DATA; Schema: public; Owner: darcy -- COPY pgbench (id, version, clients, scale, transactions, tpsc, tps, runnumber, date_run) FROM stdin; 5 PostgreSQL 8.2.0 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-3) 10 100 1000 5522.540 5601.158 1 2006-12-04 6 PostgreSQL 8.2.0 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-3) 10 100 1000 4384.115 4431.699 2 2006-12-04 7 PostgreSQL 8.2.0 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-3) 10 100 1000 4496.498 4552.909 3 2006-12-04 8 PostgreSQL 8.2.0 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-3) 10 100 1000 5340.260 5413.092 4 2006-12-04 9 PostgreSQL 8.2.0 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-3) 10 100 1000 4380.063 4440.089 5 2006-12-04 10 PostgreSQL 8.2.0 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-3) 20 100 1000 5657.952 5738.497 1 2006-12-04 11 PostgreSQL 8.2.0 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-3) 20 100 1000 5986.013 6086.305 2 2006-12-04 12 PostgreSQL 8.2.0 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-3) 20 100 1000 3469.906 3499.652 3 2006-12-04 13 PostgreSQL 8.2.0 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-3) 20 100 1000 5984.306 6079.253 4 2006-12-04 14 PostgreSQL 8.2.0 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-3) 20 100 1000 5883.563 5984.433 5 2006-12-04 15 PostgreSQL 8.2.0 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-3) 50 100 1000 4670.685 4724.722 1 2006-12-04 16 PostgreSQL 8.2.0 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-3) 50 100 1000 4731.611 4785.660 2 2006-12-04 17 PostgreSQL 8.2.0 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-3) 50 100 1000 3969.382 4008.236 3 2006-12-04 18 PostgreSQL 8.2.0 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-3) 50 100 1000 4605.248 4662.302 4 2006-12-04 19 PostgreSQL 8.2.0 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-3) 50 100 1000 3693.885 3728.222 5 2006-12-04 20 PostgreSQL 8.2.0 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-3) 100 100 1000 3514.032 3543.349 1 2006-12-04 21 PostgreSQL 8.2.0 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-3) 100 100 1000 3158.413 3182.467 2 2006-12-04 22 PostgreSQL 8.2.0 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-3) 100 100 1000 3484.719 3513.135 3 2006-12-04 23 PostgreSQL 8.2.0 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-3) 100 100 1000 3338.533 3366.148 4 2006-12-04 24 PostgreSQL 8.2.0 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-3) 100 100 1000 3458.674 3489.030 5 2006-12-04 25 PostgreSQL 8.2.0 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-3) 150 100 1000 3059.011 3081.097 1 2006-12-04 26 PostgreSQL 8.2.0 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-3) 150 100 1000 3180.324 3207.128 2 2006-12-04 27 PostgreSQL 8.2.0 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-3) 150 100 1000 2986.395 3011.737 3 2006-12-04 28 PostgreSQL 8.2.0 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-3) 150 100 1000 2990.945 3014.094 4 2006-12-04 29 PostgreSQL 8.2.0 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-3) 150 100 1000 3038.519 3063.418 5 2006-12-04 30 PostgreSQL 8.2.0 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-3) 200 100 1000 2805.022 2825.122 1 2006-12-04 31 PostgreSQL 8.2.0 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-3) 200 100 1000 2958.501 2982.133 2 2006-12-04 32 PostgreSQL 8.2.0 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-3) 200 100 1000 2793.070 2815.570 3 2006-12-04 33 PostgreSQL 8.2.0 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-3) 200 100 1000 2981.738 3003.032 4 2006-12-04 34 PostgreSQL 8.2.0 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-3) 200 100 1000 3098.988 3121.864 5 2006-12-04 35 PostgreSQL 8.2.0 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-3) 250 100 1000 2861.482 2881.317 1 2006-12-04 36 PostgreSQL 8.2.0 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-3) 250 100 1000 2258.989 2272.178 2 2006-12-04 37 PostgreSQL 8.2.0 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-3) 250 100 1000 2669.096 2688.527 3 2006-12-04 38 PostgreSQL 8.2.0 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-3) 250 100 1000 2222.920 2234.492 4 2006-12-04 39 PostgreSQL 8.2.0 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-3) 250 100 1000 2927.993 2949.032 5 2006-12-04 40 PostgreSQL 8.2.0 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-3) 300 100 1000 2727.572 2748.656 1 2006-12-04 41 PostgreSQL 8.2.0 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-3) 300 100 1000 2261.451 2273.742 2 2006-12-04 42 PostgreSQL 8.2.0 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-3) 300 100 1000 2596.148 2614.164 3 2006-12-04 43 PostgreSQL 8.2.0 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-3) 300 100 1000 2709.559 2727.240 4 2006-12-04 44 PostgreSQL 8.2.0 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-3) 300 100 1000 2357.433 2370.837 5 2006-12-04 45 PostgreSQL 8.1.5 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-3) 10 100 1000 3897.402 3932.588 1 2006-12-04 46 PostgreSQL 8.1.5 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-3) 10 100 1000 3961.171 4004.973 2 2006-12-04 47 PostgreSQL 8.1.5 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-3) 10 100 1000 3105.500 3126.207 3 2006-12-04 48 PostgreSQL 8.1.5 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-3) 10 100 1000 4238.468 4279.714 4 2006-12-04 49 PostgreSQL 8.1.5 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-3) 10 100 1000 4099.760 4135.933 5 2006-12-04 50 PostgreSQL 8.1.5 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-3) 20 100 1000 5247.999 5308.366 1 2006-12-04 51 PostgreSQL 8.1.5 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-3) 20 100 1000 5116.268 5188.510 2 2006-12-04 52 PostgreSQL 8.1.5 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-3) 20 100 1000 3874.662 3913.113 3 2006-12-04 53 PostgreSQL 8.1.5 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-3) 20 100 1000 5175.848 5244.577 4 2006-12-04 54 PostgreSQL 8.1.5 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-3) 20 100 1000 5224.381 5281.115 5 2006-12-04 55 PostgreSQL 8.1.5 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-3) 50 100 1000 3898.658 3934.636 1 2006-12-04 56 PostgreSQL 8.1.5 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-3) 50 100 1000 4007.384 4043.889 2 2006-12-04 57 PostgreSQL 8.1.5 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-3) 50 100 1000 3831.813 3869.245 3 2006-12-04 58 PostgreSQL 8.1.5 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-3) 50 100 1000 3996.817 4035.629 4 2006-12-04 59 PostgreSQL 8.1.5 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-3) 50 100 1000 3623.619 3654.940 5 2006-12-04 60 PostgreSQL 8.1.5 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-3) 100 100 1000 2989.610 3010.881 1 2006-12-04 61 PostgreSQL 8.1.5 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-3) 100 100 1000 3130.083 3153.568 2 2006-12-04 62 PostgreSQL 8.1.5 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-3) 100 100 1000 2965.082 2988.737 3 2006-12-04 63 PostgreSQL 8.1.5 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-3) 100 100 1000 3123.530 3144.792 4 2006-12-04 64 PostgreSQL 8.1.5 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-3) 100 100 1000 2980.102 3000.328 5 2006-12-04 65 PostgreSQL 8.1.5 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-3) 150 100 1000 2831.967 2850.268 1 2006-12-04 66 PostgreSQL 8.1.5 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-3) 150 100 1000 2549.424 2566.051 2 2006-12-04 67 PostgreSQL 8.1.5 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-3) 150 100 1000 2767.631 2784.579 3 2006-12-04 68 PostgreSQL 8.1.5 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-3) 150 100 1000 2655.783 2671.178 4 2006-12-04 69 PostgreSQL 8.1.5 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-3) 150 100 1000 2932.883 2952.722 5 2006-12-04 70 PostgreSQL 8.1.5 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-3) 200 100 1000 2401.764 2414.264 1 2006-12-04 71 PostgreSQL 8.1.5 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-3) 200 100 1000 2698.279 2714.711 2 2006-12-04 72 PostgreSQL 8.1.5 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-3) 200 100 1000 2019.523 2029.016 3 2006-12-04 73 PostgreSQL 8.1.5 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-3) 200 100 1000 2648.221 2663.721 4 2006-12-04 74 PostgreSQL 8.1.5 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-3) 200 100 1000 1970.013 1979.082 5 2006-12-04 75 PostgreSQL 8.1.5 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-3) 250 100 1000 2272.881 2285.110 1 2006-12-04 76 PostgreSQL 8.1.5 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-3) 250 100 1000 2596.028 2611.207 2 2006-12-04 77 PostgreSQL 8.1.5 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-3) 250 100 1000 2046.336 2055.643 3 2006-12-04 78 PostgreSQL 8.1.5 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-3) 250 100 1000 2640.572 2657.235 4 2006-12-04 79 PostgreSQL 8.1.5 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-3) 250 100 1000 2502.040 2515.651 5 2006-12-04 80 PostgreSQL 8.1.5 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-3) 300 100 1000 2231.739 2242.729 1 2006-12-04 81 PostgreSQL 8.1.5 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-3) 300 100 1000 2455.870 2470.903 2 2006-12-04 82 PostgreSQL 8.1.5 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-3) 300 100 1000 2529.325 2543.878 3 2006-12-04 83 PostgreSQL 8.1.5 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-3) 300 100 1000 2529.325 2543.878 4 2006-12-04 84 PostgreSQL 8.1.5 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-3) 300 100 1000 2174.762 2186.461 5 2006-12-04 \. -- -- Name: pgbench_pkey; Type: CONSTRAINT; Schema: public; Owner: darcy; Tablespace: -- ALTER TABLE ONLY pgbench ADD CONSTRAINT pgbench_pkey PRIMARY KEY (id); -- -- PostgreSQL database dump complete --