Then read with me. PostgreSQL source Code (ix)--executor (the--scan node (top) of the query execution module), this chapter ends the remaining seven scan nodes. T_SubqueryScanState, T_FunctionScanState, T_ValuesScanState, T_CteScanState,
Master-Slave Server IP:192.168.11.131 PostgreSQL Master192.168.11.132 PostgreSQL SlaveServer System version:# Cat/etc/redhat-releaseRed Hat Enterprise Linux Server Release 7.2 (MAIPO)PG Version:System default 9.21. Install software, configure
A. Description:To make the database read-only, PostgreSQL does not have a strictly read-only mode (such as temporary tables that are available in read-only transactions). You can set the session or the current transaction for subsequent logons to
There are two tables t1,t2, the table structure and the data are as follows:CREATE TABLE T1 ( ID int), CREATE TABLE T2 ( ID int, finished int), insert into T1 values (1); INSERT into T1 val UEs (2); INSERT into T1 values (3), insert into T1
PostgreSQL supports hstore to store data such as Key->value, which is in fact similar to array or JSON type. Efficient indexing is essential to the efficient use of this type of data. Let's take a look at the performance issues of two different
How to get the number of rows affected by the normal operation, PostgreSQL inside has a built-in variable diagnostics and Row_count can do this. First, the environment: Db:9.4beta3 Second, prepare: postgres=# CREATE TABLE test (id int); CREATE
Use the following three SQL statements to cancel a running query and terminate the connection(1) Isolate the active connection list and its process IDSELECT * from Pg_stat_activity;(2) Cancel the active query on the connectionSelect
CREATE AGGREGATE Rbitmap_union2 (rbitmap) ( sfunc = myfunction, stype = MyType, finalfunc = myfunction_final );When you write an aggregate function, the same function is called repeatedly for each row, and if the data to be processed is
Select EXISTS (select 1 from information_schema.schemata WHERE schema_name = ' Data_2014_shanxi ');Select EXISTS (select 1 from pg_namespace WHERE nspname = ' Data_2014_shanx ');Either way, the second one is more efficient.For detailed analysis, see:
After several years of renewal and industry recognition of the entity Framework. There are more and more databases that EF can support now. The PostgreSQL database can now use code first to create the database. Not much to say, the following
To back up the database:pg_dump-h localhost-u root demo02 >/home/arno/dumps/demo02.bakTo recover a database:psql-h localhost-u root-d Demo Backup table:pg_dump-h localhost-u root demo02-t books >/home/arno/dumps/books.bakRecovery table:psql-h
Reference http://www.php100.com/manual/PostgreSQL8/functions-matching.html likestring pattern [escape-character ]stringpattern [escape-character ] Each pattern defines a collection of strings. If the string is contained in a string collection
A database contains one or more naming modes. The schema also contains tables. The schema also contains other named objects, including data types, functions, and operators. The same object name can be used in different modes without causing
It took nearly two days to upload the space-based documents in batches. The original document was originally stored in the folder under the website directory as a file, and then stored in the bytea field of PostgreSQL. This field is equivalent to
-- Drop function top100cur (refcursor); Create Function top100cur (refcursor) returns refcursor as $ beginopen $1 for select * From person limit 100; return $1; end $ language plpgsql; ---------- test cursor ----------- select top100cur ('abc'); --
I. Basic installation
1. Download postgresql-8.3.3-2-binaries-no-installer.zip
2. Decompress sql-8.3.3-2-binaries-no-installer.zip to c :\
3. Detailed installation steps are as follows:
(Execute commands with Super User Permissions)
C: \> Cd
1. log ConfigurationThe system log and error log of postgresql are directly output by default and are not written to files. If you want to view these logs, modify PostgreSQL. conf as follows:
Log_destination = 'stderr'Logging_collector =
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service