Does postgresql index update on inserting new row?

insert indexing postgresql-9.2
user2104778 picture user2104778 · Jul 7, 2013 · Viewed 10k times · Source

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?

Answer

a_horse_with_no_name picture a_horse_with_no_name · Jul 7, 2013

From the manual

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

Related questions

Inserting multiple rows in a single SQL query?

I have multiple set of data to insert at once, say 4 rows. My table has three columns: Person, Id and Office. INSERT INTO MyTable VALUES ("John", 123, "Lloyds Office"); INSERT INTO MyTable VALUES ("Jane", 124, "Lloyds Office"); INSERT INTO MyTable VALUES ("Billy", 125, "…

Read More
"INSERT IGNORE" vs "INSERT ... ON DUPLICATE KEY UPDATE"

While executing an INSERT statement with many rows, I want to skip duplicate entries that would otherwise cause failure. After some research, my options appear to be the use of either: ON DUPLICATE KEY UPDATE which implies an unnecessary update …

Read More
Insert multiple rows WITHOUT repeating the "INSERT INTO ..." part of the statement?

I know I've done this before years ago, but I can't remember the syntax, and I can't find it anywhere due to pulling up tons of help docs and articles about "bulk imports". Here's what I want to do, but …

Read More