File: test_shm_mq.sql

package info (click to toggle)
postgresql-9.4 9.4.18-0%2Bdeb8u1
  • links: PTS, VCS
  • area: main
  • in suites: jessie
  • size: 121,624 kB
  • sloc: ansic: 672,040; sql: 55,424; yacc: 28,505; perl: 10,067; lex: 6,757; sh: 5,199; makefile: 4,103; asm: 65; sed: 15; python: 12
file content (12 lines) | stat: -rw-r--r-- 702 bytes parent folder | download | duplicates (13) 
1
2
3
4
5
6
7
8
9
10
11
12
 
CREATE EXTENSION test_shm_mq;

--
-- These tests don't produce any interesting output.  We're checking that
-- the operations complete without crashing or hanging and that none of their
-- internal sanity tests fail.
--
SELECT test_shm_mq(1024, '', 2000, 1);
SELECT test_shm_mq(1024, 'a', 2001, 1);
SELECT test_shm_mq(32768, (select string_agg(chr(32+(random()*95)::int), '') from generate_series(1,(100+900*random())::int)), 10000, 1);
SELECT test_shm_mq(100, (select string_agg(chr(32+(random()*95)::int), '') from generate_series(1,(100+200*random())::int)), 10000, 1);
SELECT test_shm_mq_pipelined(16384, (select string_agg(chr(32+(random()*95)::int), '') from generate_series(1,270000)), 200, 3);