Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

Does postgresql index update on inserting new row?

Tags:

indexing

insert

postgresql-9.2

Sorry if this is a dumb question but do i need to reindex my table every time i insert rows, or does the new row get indexed when added?

like image 214
user2104778 Avatar asked Jul 07 '13 05:07

user2104778

1 Answers

From the manual

Once an index is created, no further intervention is required: the system will update the index when the table is modified

like image 195
a_horse_with_no_name Avatar answered Sep 24 '22 21:09

a_horse_with_no_name
Sign in to Comment

Related questions

Python: insert into list faster than O(N)?
ASP.net using a form to insert data into an sql server table
T-SQL: INSERT original value in OUTPUT clause
Implicit conversion from data type nvarchar to varbinary(max) is not allowed
SQL Server Insert Without INTO
Insert into create new table
oracle call stored procedure inside select
Transactions and sqlalchemy
ZF2 How to get last insert id value?
ExecuteNonQuery: Connection property has not been initialized.
php mysql insert into utf-8 [closed]
Java: How to insert CLOB into oracle database
How to insert special characters into a database?
std::inserter with set - insert to begin() or end()? [duplicate]
Bulk insert performance in MongoDB for large collections
STL map insertion efficiency: [] vs. insert
insert DEFAULT values
What are the differences between REPLACE, INSERT, UPDATE in MySql? [closed]
INSERT rows into multiple tables in a single query, selecting from an involved table
PostgreSQL: insert data into table from json

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!