Use below command to get only table data from a PostgreSQL table. It will not dump table create structure.
kill a running query in postgres
There are queries which takes more times to execute. Sometimes you need to stop the queries but you can't do it simply(Ctrl+c) because queries are coming from application. There are mainly two approaches to kill the query. You can find the process corresponding to the query & kill or you can find the procpid of … Continue reading kill a running query in postgres
Disable an index in postgres
If you have got one index on a table that you would like to temporarily disable you can do following steps. You can poke the system catalogue to disable an index: This means that the index won't be used for queries but will still be updated. It's one of the flags used for concurrent index … Continue reading Disable an index in postgres
There are many types of indexes in Postgres, as well as different ways to use them. In this article we give an overview of the types of indexes available, and explain different ways of using and maintaining the most common index type: B-Trees. An index is a way to efficiently retrieve a relatively small number … Continue reading PostgreSQL Indexes