PostgreSQL 8.3 Documentationthat corresponds to your organization’s subnet. Assume a table like this: CREATE TABLE access_log ( url varchar, client_ip inet, ... ); To create a partial index that suits our example, use a command such 168.100.255’); A typical query that can use this index would be: SELECT * FROM access_log WHERE url = ’/index.html’ AND client_ip = inet ’212.78.10.32’; A query that cannot use this index is: SELECT http:// url URL example.com/stuff/index.html host Host example.com url_path URL path /stuff/index.html, in the context of a URL file File or path name /usr/local/foo.txt, if not within a URL 283 Chapter0 码力 | 2143 页 | 4.58 MB | 1 年前3
 PostgreSQL 8.3 Documentationthat corresponds to your organization’s subnet. Assume a table like this: CREATE TABLE access_log ( url varchar, client_ip inet, ... ); To create a partial index that suits our example, use a command such 168.100.255’); A typical query that can use this index would be: SELECT * FROM access_log WHERE url = ’/index.html’ AND client_ip = inet ’212.78.10.32’; A query that cannot use this index is: 246 Chapter http:// url URL example.com/stuff/index.html host Host example.com url_path URL path /stuff/index.html, in the context of a URL file File or path name /usr/local/foo.txt, if not within a URL 267 Chapter0 码力 | 2015 页 | 4.54 MB | 1 年前3
 PostgreSQL 8.4 Documentationthat corresponds to your organization’s subnet. Assume a table like this: CREATE TABLE access_log ( url varchar, client_ip inet, ... ); To create a partial index that suits our example, use a command such query that can use this index would be: SELECT * 269 Chapter 11. Indexes FROM access_log WHERE url = ’/index.html’ AND client_ip = inet ’212.78.10.32’; A query that cannot use this index is: SELECT http:// url URL example.com/stuff/index.html host Host example.com url_path URL path /stuff/index.html, in the context of a URL file File or path name /usr/local/foo.txt, if not within a URL sfloat0 码力 | 2224 页 | 5.05 MB | 1 年前3
 PostgreSQL 8.4 Documentationthat corresponds to your organization’s subnet. Assume a table like this: CREATE TABLE access_log ( url varchar, client_ip inet, ... ); To create a partial index that suits our example, use a command such 168.100.255’); A typical query that can use this index would be: SELECT * FROM access_log WHERE url = ’/index.html’ AND client_ip = inet ’212.78.10.32’; A query that cannot use this index is: SELECT http:// url URL example.com/stuff/index.html host Host example.com url_path URL path /stuff/index.html, in the context of a URL file File or path name /usr/local/foo.txt, if not within a URL sfloat0 码力 | 2371 页 | 5.09 MB | 1 年前3
 PostgreSQL 9.0 Documentationthat corresponds to your organization’s subnet. Assume a table like this: CREATE TABLE access_log ( url varchar, client_ip inet, ... ); To create a partial index that suits our example, use a command such 168.100.255’); A typical query that can use this index would be: SELECT * FROM access_log WHERE url = ’/index.html’ AND client_ip = inet ’212.78.10.32’; A query that cannot use this index is: SELECT http:// url URL example.com/stuff/index.html host Host example.com url_path URL path /stuff/index.html, in the context of a URL file File or path name /usr/local/foo.txt, if not within a URL sfloat0 码力 | 2561 页 | 5.55 MB | 1 年前3
 PostgreSQL 9.4 Documentationorganization’s subnet. Assume a table like this: 355 Chapter 11. Indexes CREATE TABLE access_log ( url varchar, client_ip inet, ... ); To create a partial index that suits our example, use a command such 168.100.255’); A typical query that can use this index would be: SELECT * FROM access_log WHERE url = ’/index.html’ AND client_ip = inet ’212.78.10.32’; A query that cannot use this index is: SELECT http:// url URL example.com/stuff/index.html host Host example.com url_path URL path /stuff/index.html, in the context of a URL file File or path name /usr/local/foo.txt, if not within a URL sfloat0 码力 | 2603 页 | 6.05 MB | 1 年前3
 PostgreSQL 9.0 Documentationthat corresponds to your organization’s subnet. Assume a table like this: CREATE TABLE access_log ( url varchar, client_ip inet, ... ); To create a partial index that suits our example, use a command such 168.100.255’); A typical query that can use this index would be: SELECT * FROM access_log WHERE url = ’/index.html’ AND client_ip = inet ’212.78.10.32’; A query that cannot use this index is: SELECT http:// url URL example.com/stuff/index.html host Host example.com url_path URL path /stuff/index.html, in the context of a URL file File or path name /usr/local/foo.txt, if not within a URL sfloat0 码力 | 2401 页 | 5.50 MB | 1 年前3
 PostgreSQL 9.4.26 Documentation
that corresponds to your organization’s subnet. Assume a table like this: CREATE TABLE access_log ( url varchar, client_ip inet, ... ); To create a partial index that suits our example, use a command such 168.100.255’); A typical query that can use this index would be: SELECT * FROM access_log WHERE url = ’/index.html’ AND client_ip = inet ’212.78.10.32’; A query that cannot use this index is: SELECT http:// url URL example.com/stuff/index.html host Host example.com url_path URL path /stuff/index.html, in the context of a URL file File or path name /usr/local/foo.txt, if not within a URL sfloat0 码力 | 2452 页 | 5.99 MB | 1 年前3
 PostgreSQL 9.5.25 Documentation
that corresponds to your organization’s subnet. Assume a table like this: CREATE TABLE access_log ( url varchar, client_ip inet, ... ); To create a partial index that suits our example, use a command such 168.100.255’); A typical query that can use this index would be: SELECT * FROM access_log WHERE url = ’/index.html’ AND client_ip = inet ’212.78.10.32’; A query that cannot use this index is: SELECT http:// url URL example.com/stuff/index.html host Host example.com url_path URL path /stuff/index.html, in the context of a URL file File or path name /usr/local/foo.txt, if not within a URL sfloat0 码力 | 2558 页 | 6.27 MB | 1 年前3
 PostgreSQL 9.5 Documentationthat corresponds to your organization’s subnet. Assume a table like this: CREATE TABLE access_log ( url varchar, client_ip inet, ... ); To create a partial index that suits our example, use a command such 168.100.255’); A typical query that can use this index would be: SELECT * FROM access_log WHERE url = ’/index.html’ AND client_ip = inet ’212.78.10.32’; A query that cannot use this index is: SELECT http:// url URL example.com/stuff/index.html host Host example.com url_path URL path /stuff/index.html, in the context of a URL file File or path name /usr/local/foo.txt, if not within a URL sfloat0 码力 | 2714 页 | 6.33 MB | 1 年前3
共 41 条
- 1
 - 2
 - 3
 - 4
 - 5
 













