[Tobias Brox - Tue at 02:10:04PM +0200] > Did you try "analyze" as well? It's weird it's using seq scan, since > you have a primary key it's supposed to have an index ... though 500 > rows is little. > > I just checked up our own production database, takes 0.08 ms to fetch a > row by ID from one of our tables containing 176k with rows. Oh, the gid is not primary key. I guess I should also apologize for adding noise here :-) Make an index here! :-)
