Fran Fabrizio <[EMAIL PROTECTED]> writes:
> Seq Scan on status s (cost=0.00..9.04 rows=1 width=84)
>
> 010502.11:24:05.003 [3029] CommitTransactionCommand
>
> Which is incorrect because it should be using my index, shouldn't
> it? Here is how I created my index:
If a table is small (you ha
I'm sorry that I did not send the EXPLAIN results along with my original email,
I had no idea this command existed (I'm a first-week rookie with postgres!)
Also, I did not know about vacuum, and apparently, that was the culprit! After
vacuum'ing, times went from .433 sec/query to .001. Holy mol
