On 2013-07-02 14:02:22 +0200, Andres Freund wrote:
> Data loaded: load.sql.

Attached...

Greetings,

Andres Freund

-- 
 Andres Freund                     http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services
DROP TABLE IF EXISTS kv;
CREATE TABLE kv(
    id serial primary key,
    key text NOT NULL UNIQUE,
    data text NOT NULL
);
INSERT INTO kv(key, data)
SELECT 'key-'||g.i::text, 'abcdefg'
FROM generate_series(1, 100) g(i);

VACUUM (ANALYZE, VERBOSE, FREEZE) kv;
VACUUM (ANALYZE, VERBOSE) kv;
-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to