In a (bad) PostgreSQL query, just a little to change (any (array[...)) to any (VALUES (...) ) will be able to reduce the query time from 20s to 0.2s. From the simplest learning to use EXPLAIN ANALYZE , to learn to use the Postgres community A lot of learning time input will have a hundredfold time to return.
using Postgres to monitor slow Postgres queries
Earli
Problem: Fatal error: User "Postgres" Ident authentication failed
Note: This is because there is no remote access configured and authentication method has not changed, only need to change the use of account password authentication.
Workaround: Locate pg_hba.conf (Find/-name pg_hba.conf), change the ident of method to MD5, and change the IP port to 0.0.0.0/0, or the desired IP address. After the modification is completed, the dire
Recently, I have been working on a project related to PostgreSQL database, documenting the knowledge that I have learned in this process. About PostgreSQL database online already have too many relevant introduction, in order to blog the system or first look at the Wikipedia on the PostgreSQL database introduction.PostgreSQL is a free object-relational database server (database management system), issued under a flexible bsd--style license. It provides a choice for users in addition to other open
SIGTERM
New connections are no longer allowed, but all active sessions are allowed to complete their work properly, and are closed only after all sessions have completed the task. This is smart off.
SIGINT
No new connections are allowed, send SIGTERM to all active servers (let them exit immediately), and wait for all child processes to exit and close the database. This is quick to close.
Sigquit
Causes Postgres to send sigquit t
Tags: res command src. SH name touch Shell strong imageThe first step: Connect to the Linux service via Xshell or other tools,Step Two: Create a script: Touch se.shStep three: Enter I to enter the following command on behalf of the start input:The script is as follows: (SQL statement can be any complex SQL, simple to write here)! /bin/shPsql-h 127.0.0.1-u postgres-w-D db_test >/root/zyy SELECT * from Test;EofScript parsing:-H represents the IP of the
"Peer Authentication" means that it ' s comparing your database username against your Linux username. It should work if your ' re logged in as postgres . You probably don ' t want md5 pg_hba to hits that rule in, as the postgres database user generally doesn ' t has a password.–The problem you has is, so if u dont define the Host, your system would decide.Explicit add "-H localhost", this would fix itPg_dum
Learn the PG start-up process today.The start command for pg./bin/postgres-d Path/to/data.1. Subject monitoring ProcessThe postmaster process enters an infinite loop, waiting for the client to request and provide the requested service. In an infinite loop, the postmaster process periodically checks for client service requests by invoking the operating system interface Select, if not, resumes the loop and, if there is one, creates a
Postgres is a very good open-source database. Good performance.
When it comes to databases, there's the topic of backup and import.
Backups are also broken down in a number of ways.
1. Full backup
This is the way most people use it to back up the entire database, including all database objects, such as user tables, system tables, indexes, views, and stored procedures. But it takes more time and space, so it's generally recommended to do a full backup
Postgres can not be directly accessed between different databases, such as database Test1 and test2, each database has a table of TableA; I am using the operating system Win8.1,postgres version 9.3.6; Access to Postgres using the PGADMINIII tool; Create a TableA in two databases (TEST1,TEST2) respectively; Test1 database creates TableA and inserts data: CREATE T
Php page access to IPVs database problems the local machine is equipped with php, apache, postgres database nbsp; I want to insert the data in the page from the browser php page to the local database, the code I wrote must be correct, but it means that the data cannot be inserted into the database (during the runtime, he only runs the code before the database code is connected, and then does not leave, and no error is reported, but the code is absolu
in the CREATESTMT structure, and then control whether or not to create a table or make an error message.Get the current user name as followsDatumcurrent_user (Pg_function_args) {pg_return_datum (DirectFunctionCall1 (Namein, Cstringgetdatum ( Getusernamefromid (GetUserId ()))));}This function is the intrinsic function of the PG, using the effect:postgres=# Select Current_User; Current_User--------------Postgres (1 row)In this way, you can complete the
S skills, Postgres skills
If you need to add indexes when the business volume is large, you need to use CONCURRENTLY. Otherwise, your database will easily break down.
For example
create index CONCURRENTLY idx_order_records_bank_statist_uid on order_records(statist_uid)
See
Http://www.postgresql.org/docs/9.1/static/sql-createindex.html
In a large business volume, if you want to execute some time-consuming database tasks, sometimes you will fin
Summary of Postgres operations in Ubuntu
1.Basic operation commands
After the installation is complete, PostgreSQL creates a database user account named Postgres by default. It is a super Administrator account like the root account of MySQL and the SA account of sqlserver, but unlike MySQL, postgreSQL also created a Unix account named S.
Like the master database of sqlserver, the default database o
This is a creation in
Article, where the information may have evolved or changed.
Github.com/lib/pq
PG is a pure go write driver of the Postgres database. The author gave us a little joke, the PQ will always be habitually written PG there is no ... The installation method is as follows:
go get github.com/lib/pq
Register
As mentioned earlier, driver needs to call Sql.register to register the Driver.driver type interface driver implementation by name. T
Today development found me, said their database connection is not up, may be too many connections, and then I log on to the server, and try to log into the database, is also an error:Psql:FATAL:sorry, too many clients alreadyIt is clear that the database connection is full. Then look at the database connection process:[Email protected] ~]$ Ps-ef |grep postgresPostgres 3406 18212 0 00:35? 00:01:00 postgres:denaliadmin region_na 172.16.60.16 (51976) idlePostgres 4221 18212 0 01:09? 00:00:03 postgr
PHP page access to postgres database issues
This machine is equipped with Php,apache,postgres database
I want to insert the data from the page into the native database from the browser PHP page, I write the code is certainly correct, but just can't insert the data into the library (run, he only run the code before the library code, and then do not go, and no error, but the code is absolutely correct, the fo
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.