PostgreSQL tutorial (18): client commands (2), postgresql tutorial
VII. pg_dump:
Pg_dump is a tool used to back up PostgreSQL databases. It can even perform a full and consistent backup when the database is being used concurrently without blocking access to the database by other users. The dump format generated by this tool can be divided into two types: script a
Tutorial on installing and using the extension module on PostgreSQL, postgresql extension module
Installation Module
Note: My runtime environments are Ubuntu 10.04 and PostgreSQL 8.4.
First, install the postgresql-contrib package and restart the database server. Then, check the contrib directory to see if there are som
PostgreSQL tutorial (1): Detailed description of data tables and detailed description of postgresql
I. Table definition:
For any relational database, tables are the core and basic object units of data storage. Now let's start from here.1. Create a table:Copy codeThe Code is as follows:Create table products (Product_no integer,Name text,Price numeric);2. delete a table:Copy codeThe Code is as follows:Drop ta
PostgreSQL tutorial (14): database maintenance, postgresql tutorial
I. Disk Space Restoration:
In PostgreSQL, the data rows deleted or updated using the delete and update statements are not actually deleted, the physical address of the old data row sets the row status to deleted or expired. Therefore, when data in a data table changes frequently, the space occupi
PostgreSQL replication cluster overview, PostgreSQL replication Cluster
For pg replication, high availability, and load balancing clusters, write an overview for future reference.
Pg has the following various replication-Based Cluster solutions, most of which were used, and some were not sorted out at the time. There are also many cluster configuration documents on the Internet. After this document, find a
Mac installs PostgreSQL by default, so that PostgreSQL can be accessed remotelyMac default PostgreSQL directory storage path is /usr/local/var/postgres/ in this directory, modify two files, one is postgresql.conf, one is pg_ Hba.conf, and finally a reboot.Modify Postresql.conflisten_addresses = ' * ' # Modify the configuration here to allow link
Manual PostgreSQL database initialization tutorial in windows, initialize postgresql
Environment: win7 64 sp1PG: 9.3.5
1. Create the postgres user, and the password is also postgres:
net user postgres postgres /add
2. Create a data directory under the root directory of the database:
C:\Program Files\PostgreSQL\9.3>md data
3. Remove the administrator permission on
PostgreSQL tutorial (10): Performance Improvement tips and postgresql Performance Improvement
1. Use EXPLAIN:
PostgreSQL generates a query plan for each query, because selecting the correct query path has a critical impact on performance. PostgreSQL itself contains a scheduler for optimal planning. We can use the EXPLA
Postgresql C/C ++ API and postgresql sqlapi
1. postgresql learning uri recommendation
http://www.php100.com/manual/PostgreSQL8/ http://www.php100.com/manual/PostgreSQL8/reference.html http://www.yiibai.com/html/postgresql/
[Note tips byRuiy, distinguish uri/url, service/server,There has a certain truthChillax!]
Frie
2.4 Adjusting checkpoints and xlogSo far, this chapter has provided insight into how PostgreSQL writes data, in general, what Xlog is used for. Given this knowledge, we can now continue and learn what we can do to make our databases work more efficiently in both replication and single-server operations.2.4.1 Understanding CheckpointsIn this chapter, we have seen that it has been written to Xlog before the data can be elsewhere. The problem is that if
Since the introduction of the relational database model by edugatd in 1970, relational databases began to emerge. After more than 40 years of evolution, today's relational databases have a wide variety of features and are widely used. In the face of so many relational databases, how should we weigh and find a database system suitable for our own application scenarios? O.S. tezer recently published a blog post on DigitalOcean, comparing SQLite, MySQL, and Pos
Detailed description of the PostgreSQL Partition Table (partitioning) application instance, postgresql Partition Table
Preface
Vertical table sharding is required in the project, that is, data is split into n tables according to the time interval. PostgreSQL provides the partition table function. A partition table actually Splits a large logical table into severa
Label:2.2 Xlog and ReplicationIn this chapter, you have learned that the transaction log for PostgreSQL has made all changes to the database. The transaction log itself is packaged as an easy-to-use 16MB segment.The idea of using this change set to replicate data is not farfetched. In fact, this is a logical step in the development of each relational (or even non-relational) database system. Other parts of the book, you will see in many ways how the
Label:Brief introduction We can manage the PostgreSQL database through some graphical interface management programs, such as Pgadmin, to create new objects by visual or command line, delete and edit existing objects (such as directories, schemas, tables, etc.) and access them through JDBC or ODBC. Interface operation: To open a connection to a service, select the desired service in the tree, double-click it, or use the Connect on the Tools menu.In the
Describes the range type features and PostgreSQL features in postgresql.
A new feature of PostgreSQL 9.2 is the range type range types. With this name, you can easily guess the purpose of this type. It allows you to define a value range for a column of data.
This simple feature eliminates the need to define two fields to describe the start value and end value of
Detailed explanation of adding keywords in PostgreSQL syntax, detailed explanation of postgresql
Add keywords in PostgreSQL syntax
When PostgreSQL's background process Postgres receives the query statement, it first passes it to the query analysis module for lexical, syntax, and semantic analysis.
Add keywords in the parser Syntax Parsing module.
Introduction
PostgreSQL code analysis, query optimization, process_duplicate_ors, postgresql
PostgreSQL code analysis and query optimization.
/** Process_duplicate_ors * Given a list of exprs which are ORed together, try to apply * the inverse OR distributive law. ** Returns the resulting expression (cocould be an AND clause, an OR * clause, or maybe even a single subexpr
In the previous chapters, we have understood the various replication concepts. This is not just a theoretical overview of the things that will enhance your consciousness for the next thing to be introduced, but will also introduce you to a broad topic.In this chapter, we will be closer to the actual solution and understand how PostgreSQL works internally and what replication means. We'll see what the so-called transaction log (XLOG) does, and how it w
PostgreSQL tutorial (8): Index details, postgresql Index
I. Index type:
PostgreSQL provides multiple index types: B-Tree, Hash, GiST, and GIN. Because they use different algorithms, each index type has a suitable Query type, the create index Command creates a B-Tree INDEX.1. B-Tree:Copy codeThe Code is as follows:Create table test1 (Id integer,Content varchar);Cr
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.