Adam T. Gautier wrote:
> UPDATE subjects SET parent_id = 1 WHERE id = 2;
>
> I thought that the way to fix the problem was with an index so I created
> various indexes nothing helped. any input would be great.
Have you run
ANALYZE;
or
VACUUM ANALYZE;
?
What does
EXPLAIN ANALYZE UPDATE subjects SET parent_id = 1 WHERE id = 2;
say?
What indexes exactly have you created (definitions)?
Joe