Shashank's Blog

Skip to content
  • General
  • Programming Language
    • Python
  • Database
    • SQL
    • MySQL
    • Postgresql
  • Web Framework
    • Django
  • Linux/Unix
    • Linux Commands
Search

postgresql

Dump only Data in PostgreSQL table backup

April 6, 2020 / Shashank vivek / Leave a comment

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

June 13, 2015June 20, 2015 / Shashank vivek / Leave a comment

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

November 16, 2014November 25, 2015 / Shashank vivek / Leave a comment

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

PostgreSQL Indexes

June 9, 2014November 16, 2014 / Shashank vivek / Leave a comment

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

Translate

Recent Posts

  • Using Surrogate Keys and unique_together in Django for Efficient Database Modeling April 4, 2023
  • Bose NC 700 HP Review – Noise cancellation headphone. July 11, 2022
  • Using Python to execute MySQL Insert and Update queries July 11, 2022
  • Setup Oracle in Ubuntu 20.04 July 5, 2022
  • Create a folder in Python of Current date format June 26, 2022

RSS Feed

  • RSS - Posts

Meta

  • Register
  • Log in
  • Entries feed
  • Comments feed
  • WordPress.com
Blog at WordPress.com.
  • Follow Following
    • Shashank's Blog
    • Already have a WordPress.com account? Log in now.
    • Shashank's Blog
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy