ShareChiWai
  • Blog
  • Menu Venue
  • Event
  • Sharing
  • References
    • 🎉 Easily create your own simple yet highly customizable blog
    • 🧠 Sharpen your thinking with a second brain
    • 📈 Communicate your results effectively with the best data visualizations
    • 👩🏼‍🏫 Teach academic courses
    • ✅ Manage your projects
    • Welcome to Hugo Blox Builder, the website builder for Hugo
  • Projects
    • Pandas
    • PyTorch
    • scikit-learn
  • Blog
    • Vercel ReactJs 404 Page Not Found
    • Hugo Blox Note - Hugo Blox筆記
    • How to extract query string from NextJs
    • Ngrok Alternative Cloudflare Tunnel - Ngrok 同 Cloudflare Tunnel 介紹
    • How to check all table size in postgresql - 在PostgreSQL 如何查詢資料庫所有Table的大小
    • How to check the size of table in postgresql - 在PostgreSQL 如何查詢資料庫Table大小
    • How to check the size of database in postgresql - 在PostgreSQL 如何查詢資料庫大小
    • How to set environment variable globally on Linux - 在Linux 上如何設定環境變數
    • How to check if your website has Enforcing HTTP Strict Transport Security
    • How to install PostgreSQL Client psql on AWS VM - 在AWS VM 上如何安裝 PostgreSQL Client
    • How to remove docker image with tag none
    • S3 buckets should require requests to use Secure Socket Layer
    • Git credential-manager-core is not a git command
    • AWS S3 Bucket Security config - Block public access
    • Docker compose rebuild image
    • Docker daemon conflict unable to remove repository reference (must force)
    • How to shut down windows 11 properly - 在Win 11 上如何真關機
    • How to install psql PostgreSQL Client Tools on Windows / 如何在Windows 上安裝 PSQL
    • Cannot find my Azure Subscription
    • Runtime.HandlerNotFound index.handler is undefined or not exported
    • vitest.config.js
    • Codecov upload coverage report without GitHub Action
    • VS Code Markdown auto format issue
    • ESLint Auto Fix via CLI
    • NextJs - How to change port
    • NodeJs - SyntaxError Cannot use import statement outside a module
    • Git Ignore new change after initial commit
    • SF Express Tracking - 順豐速運運單追蹤
    • PostgresSQL database maintenance script
    • XRound VERSA connection issue (FIX) - XRound VERSA耳機成日斷線問題解決方法
    • GoDaddy Discount Code for renew domain - GoDaddy 優惠碼
    • docker-compose up with specific file
    • SonarQube - max virtual memory areas vm.max_map_count [65530] is too low, increase to at least [262144]
    • Run SonarQube in Docker - docker-compose
    • PostgresSQL Get number of connection connected to server
    • PostgresSQL database import database backup from command
    • PostgresSQL database backup with Insert Statement
    • Postgresql - rebuild database index
    • Prisma Output SQL query
    • You are running `create-react-app` 5.0.0, which is behind the latest release (5.0.1)
    • Google 粵語輸入法 download - Android - Google Cantonese Input
    • Create React Native without Expo
    • How to create database from azure flexible server
    • Microsoft for Startups - Azure Credit Balance and Usage
    • Deploy NodeJs express site to Azure App Service
    • Enable spell check on Chrome
    • Enable spell check on Chrome
    • Prisma deploy database without Shadow
    • Set environment variables on bash
    • Enable spell check on Chrome - 在Google Chrome 上啟用 spell checker
    • Setup Prettier
    • Setup ESLint
    • Vaccination Lucky Draw Hong Kong - 香港疫苗抽獎
    • How to get/check javascript execution time
    • BUPA Hong Kong Hotline - Customer Service
    • apt-get update - public key is not available
    • How to install wifite on Raspbian - 如何在 Raspbian / ubuntu 上安裝 wifite
    • RaspberryPi unzip file via 7Zip
    • upload copy file via ssh
    • RaspberryPi how to unzip unrar
    • 'python' no such file or directory
    • How to resume SSH session - Ubuntu / RaspberryPi
    • add-apt-repository: command not found
    • git rewrite commit author
    • How to run reactjs in different port
    • Ubuntu remote desktop from windows 10
    • SQL Server Management Studio (SSMS) shortcut to view Table Defination (sp_help)
    • Create-React-App test without watch mode
    • ReactJs set base path -
    • Where Event Log files store on Windows - Event Log 檔案在那裡
    • ASP.Net MVC client-side validation
    • How to untrack committed file - 如果在git 上 untrack committed file
    • How to untrack committed file - 如果在git 上 untrack committed file
    • .gitignore include a file from excluded folder
    • ReferenceError: regeneratorRuntime is not defined jest nodejs
    • How to check battery health on Windows - 如果在Windows 上檢查電池健康度.
    • Manifest: found icon with no valid size.
    • Upgrade ReactJS - module build failed - Cannot find module 'js-levenshtein'
    • redux - uncaught TypeError: Cannot read property 'apply' of undefined(…)
    • FFmpeg - 十分好用可以轉換Audio / video既 program
    • FFmpeg convert resize video - 使用FFmpeg 來轉換視訊格式
    • Git change capitalization of filename - Git 更改檔案名大小字
    • Use Google Translate with Google Sheet - 在Google Sheet 上使用Google Translate
    • git Create branch via Command
    • TSQL Variable Scope fun finding
    • Git Your branch have diverged and have 1 and 1 different commits each, respectively
    • Windows reset subsystem - Ubuntu
    • Ubuntu install WPScan
    • JS format JSON
    • Useful Heroku command
    • XSD restriction for either specific string or number (mixture type)
    • Visual Studio Useful Shortcut
    • Choco check if package already installed / outated
    • Firebase ReactJs routing issue - Page not found
    • How to get distinct values from an array of objects in JavaScript
    • How to set Environment Variable on NodeJS
    • Git undo local commit
    • failed to extract shortcode: template for shortcode "alert" not found
    • ESLint couldnt find the plugin (when install dependencies using yarn)
    • Clear node-modules
    • Git Error Unlink of File failed. Should I try again?
    • Update WordPress Inside Docker Container Required FTP Access
    • VSCode config trim trailing space when saving file
    • Linux updated folder and subfolder's ownership
    • C# Distinct List of Object
    • EF Core with MySQL Specified key was too long; max key length is 3072 bytes
    • Git Check which branch contain specific commit
    • Visual Studio CodeLens show no Reference
    • Git Include Ignored files
    • Note: Nginx Docker sample
    • Code-Playground
    • WPScan Docker Sample - WPScan Docker 示範
    • Screen Recording via PowerPoint (Free Feature) - 使用 PowerPoint進行 屏幕錄製
    • Free Software for Student - 免費軟體 (學生篇)
    • Useful SQL command to reduce the size of the database
    • Different Git User credential Con on same machine - 在同一個電腦上使用不同的Git 使用者
    • Git refusing to merge unrelated histories
    • VS Code disable minimap - 如何在Visual Studio Code 上 Disable Minimap 這個 extension
    • Csharp - Remove last comma - C# 如何移除最後一個符號 (分號)?
    • How to use && (bash) in powershell to run multiple command
    • ASP.Net Core Enable Development Error
    • LetsEncrypt Renew - Lets Encrypt SSL 更新
    • OnePlus 5 Windows Driver Download
    • OnePlus 5 Release - Early Access - OnePlus5 提早購買Code
    • ASP.net Core SPA Single Page Application Template Generator with angular, aurelia, knockout, react
    • Git note - How to checkout specific commit - Git 如何checkout 之前的Commit / Changeset
    • dotnet watch does not refresh content for AspNetCore.SpaTemplates React / Angular
    • Enable dotnet watch - on asp.net core
    • ASP.Net Core App can NOW be deploy to Azure - (Azure web app)
    • RaspberryPi install NodeJs 6.x / 7.x - 如何在RaspberryPi 安裝 NodeJs
    • Chocolatey Update All Package -Chocolatey更新所有Package
    • Windows Azure Region Location - Microsoft Azure 終於開始使用Windows/ Azure Microsoft Azure 了
    • .Net Post XML via HTTPS Notes 1 [Convert XSD to .Net Class]
    • Convert Date to Month Name in .Net
    • Cannot open CHM file in Windows XP/Vista- Navigation to the Webpage has been cancelled.
    • 開啟 CHM 說明檔 問題 (XP/VISTA) - 已取消瀏覽該網頁
    • Win2008 SP1 download
    • Fatal error: Call to undefined function curl_init() 問題
    • ASP.Net GridView RowCommand did not get trigger
    • MegaUpload -This service is temporarily not available from your service area
    • PHP Session Problem
    • Remote Desktop in WinXP Home Edition
    • Windows Server 2008 and Windows VIsta Service Pack 2 Download
    • InLink Checker in SilverLight
    • BackLink Checker in Silverlight
    • 7個步驟便可以在電腦上擁有屬於自己手寫字形
    • Trend Micro HouseCall on Vista/ Free online scan for antivirus
    • Jquery's Notes
    • Crystal report XI Service Packs 5 solve the PDF font size get reduced/smaller issue
    • WordWrap on Crystal Report?
    • TSQL Get Number of Decimal Place (on a field)
    • Deselect an Item on SilverLight
    • SAP Business One 2007 System Requirement
    • CodeIgniter does not work — CodeIgniter 不能 顯示 $name入面的內容
    • PHP Framework CodeIgniter- 一個挺好用的 PHP Framework
  • Event 活動
    • 救狗之家 x 頌缽療癒 2024-03-08 Singing Bowl x HKDR
  • Menu Venue
    • MOM LiveHouse Menu - Fortress Hill
    • 順景車仔麵 Menu
  • Publications
    • An example preprint / working paper
    • An example journal article
    • An example conference paper
  • Sharing
    • Hong Kong Unscaffolding with Bamboo shoot timelapse - 香港拆棚(築棚)
    • Hong Kong Scaffolding with Bamboo shoot timelapse - 香港搭棚(築棚)
    • Tai Kwun Lightshow 2022 InnerGlow timelapse - 大館燈光展2022 綻放大館
    • Bee super slow motion - 蜜蜂超慢動作採蜜
    • #大館 外邊遊 #insta360 #ai移動延時
  • Teaching
    • Learn JavaScript
    • Learn Python

Postgresql - rebuild database index

2022-06-27 · 1 min read

如何在 postgresql 上rebuild database index

REINDEX DATABASE "database-name";

Hope you find it useful

Last updated on 2024-02-17
Postgresql Database Maintenancce
Chi Yau
Authors
Chi Yau
App Dev
← PostgresSQL database backup with Insert Statement 2022-07-02
Prisma Output SQL query 2022-06-27 →

© 2025 Sharechiwai. This work is licensed under CC BY NC ND 4.0

Published with Hugo Blox Builder — the free, open source website builder that empowers creators.