* whitespace=space-before-tab,trailing-space

*.[chly] whitespace=space-before-tab,trailing-space,indent-with-non-tab,tabwidth=4

*.pl whitespace=space-before-tab,trailing-space,tabwidth=4

*.po whitespace=space-before-tab,trailing-space,tab-in-indent,-blank-at-eof

*.x[ms]l whitespace=space-before-tab,trailing-space,tab-in-indent

*.out -whitespace

src/interfaces/ecpg/test/expected/* -whitespace

src/interfaces/libpq/test/expected.out whitespace=-blank-at-eof

configure -whitespace

ppport.h -whitespace

src/backend/regex/COPYRIGHT -whitespace

src/backend/snowball/libstemmer/*.c -whitespace

src/backend/utils/mb/Unicode/*-std.txt -whitespace

src/include/snowball/libstemmer/* -whitespace

</programlisting>

<screen>

-----------+-------+--------+-----------------------

develop | 11 | 5200 | 5020.0000000000000000

develop | 7 | 4200 | 5020.0000000000000000

</programlisting>

<screen>

-----------+-------+--------+------

develop | 8 | 6000 | 1

develop | 10 | 5200 | 2

</programlisting>

<screen>

--------+-------

5200 | 47100

5000 | 47100

</programlisting>

<screen>

--------+-------

3500 | 3500

3900 | 7400

<filename>backup_label</filename> in the root directory of the backup. The

third field should be written to a file named

<filename>tablespace_map</filename> unless the field is empty. These files are

modification, which may require opening the file in binary mode.

</para>

</listitem>

A sequential scan over this large table takes a long time:

<programlisting>

=# EXPLAIN ANALYZE SELECT * FROM tbloom WHERE i2 = 898732 AND i5 = 123451;

-------------------------------------------------------------------&zwsp;-----------------------------------

Seq Scan on tbloom (cost=0.00..2137.14 rows=3 width=24) (actual time=16.971..16.971 rows=0 loops=1)

Filter: ((i2 = 898732) AND (i5 = 123451))

3976 kB

(1 row)

=# EXPLAIN ANALYZE SELECT * FROM tbloom WHERE i2 = 898732 AND i5 = 123451;

-------------------------------------------------------------------&zwsp;-----------------------------------

Seq Scan on tbloom (cost=0.00..2137.00 rows=2 width=24) (actual time=12.805..12.805 rows=0 loops=1)

Filter: ((i2 = 898732) AND (i5 = 123451))

1584 kB

(1 row)

=# EXPLAIN ANALYZE SELECT * FROM tbloom WHERE i2 = 898732 AND i5 = 123451;

-------------------------------------------------------------------&zwsp;--------------------------------------------------

Bitmap Heap Scan on tbloom (cost=1792.00..1799.69 rows=2 width=24) (actual time=0.388..0.388 rows=0 loops=1)

Recheck Cond: ((i2 = 898732) AND (i5 = 123451))

=# CREATE INDEX btreeidx6 ON tbloom (i6);

CREATE INDEX

=# EXPLAIN ANALYZE SELECT * FROM tbloom WHERE i2 = 898732 AND i5 = 123451;

-------------------------------------------------------------------&zwsp;--------------------------------------------------------

Bitmap Heap Scan on tbloom (cost=24.34..32.03 rows=2 width=24) (actual time=0.028..0.029 rows=0 loops=1)

Recheck Cond: ((i5 = 123451) AND (i2 = 898732))

<screen>

$ <userinput>psql -l</userinput>

List of databases

-----------+----------+-----------+-------------+-------------+-------------------------------------

template0 | hlinnaka | UTF8 | fi_FI.UTF8 | fi_FI.UTF8 | {=c/hlinnaka,hlinnaka=CTc/hlinnaka}

template1 | hlinnaka | UTF8 | fi_FI.UTF8 | fi_FI.UTF8 | {=c/hlinnaka,hlinnaka=CTc/hlinnaka}

(7 rows)

);

INSERT INTO person VALUES ('Moe', 'happy');

SELECT * FROM person WHERE current_mood = 'happy';

------+--------------

Moe | happy

(1 row)

INSERT INTO person VALUES ('Larry', 'sad');

INSERT INTO person VALUES ('Curly', 'ok');

SELECT * FROM person WHERE current_mood > 'sad';

-------+--------------

Moe | happy

Curly | ok

(2 rows)

SELECT * FROM person WHERE current_mood > 'sad' ORDER BY current_mood;

-------+--------------

Curly | ok

Moe | happy

SELECT name

FROM person

WHERE current_mood = (SELECT MIN(current_mood) FROM person);

-------

Larry

(1 row)

<programlisting>

SELECT person.name, holidays.num_weeks FROM person, holidays

WHERE person.current_mood::text = holidays.happiness::text;

------+-----------

Moe | 4

(1 row)

<programlisting>

SELECT macaddr8_set7bit('08:00:2b:01:02:03');

<computeroutput>

-------------------------

0a:00:2b:ff:fe:01:02:03

(1 row)

<programlisting>

SELECT $$the lexeme ' ' contains spaces$$::tsvector;

-------------------------------------------

' ' 'contains' 'lexeme' 'spaces' 'the'

</programlisting>

<programlisting>

SELECT $$the lexeme 'Joe''s' contains a quote$$::tsvector;

------------------------------------------------

'Joe''s' 'a' 'contains' 'lexeme' 'quote' 'the'

</programlisting>

<programlisting>

SELECT 'a:1A fat:2B,4C cat:5D'::tsvector;

----------------------------

'a':1A 'cat':5 'fat':2B,4C

</programlisting>

<programlisting>

SELECT 'The Fat Rats'::tsvector;

--------------------

'Fat' 'Rats' 'The'

</programlisting>

<programlisting>

SELECT to_tsvector('english', 'The Fat Rats');

-----------------

'fat':2 'rat':3

</programlisting>

<programlisting>

SELECT 'fat &amp; rat'::tsquery;

---------------

'fat' &amp; 'rat'

SELECT 'fat &amp; (rat | cat)'::tsquery;

---------------------------

'fat' &amp; ( 'rat' | 'cat' )

SELECT 'fat &amp; rat &amp; ! cat'::tsquery;

------------------------

'fat' &amp; 'rat' &amp; !'cat'

</programlisting>

to specify prefix matching:

<programlisting>

SELECT 'super:*'::tsquery;

-----------

'super':*

</programlisting>

<programlisting>

SELECT to_tsquery('Fat:ab &amp; Cats');

------------------

'fat':AB &amp; 'cat'

</programlisting>

\set ORIGINAL_USER :USER

\c - regress_dblink_user

SELECT dblink_connect('myconn', 'fdtest');

----------------

OK

(1 row)

SELECT * FROM dblink('myconn', 'SELECT * FROM foo') AS t(a int, b text, c text[]);

----+---+---------------

0 | a | {a0,b0,c0}

1 | b | {a1,b1,c1}

<screen>

SELECT dblink_exec('LISTEN virtual');

-------------

LISTEN

(1 row)

<programlisting>

=&gt; SELECT current_user;

--------------

admin

(1 row)

=&gt; select inet_client_addr();

------------------

127.0.0.1

(1 row)

requested in the original <command>TRUNCATE</command> command,

respectively.

</para>

<para>

If <literal>restart_seqs</literal> is <literal>true</literal>,

the original <command>TRUNCATE</command> command requested the