Does postgresql index update on inserting new row?
indexing, insert, postgresql-9.2
Solution
From the manual
Once an index is created, no further intervention is required: the system will update the index when the table is modified
Problem
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?