On Thursday 12 February 2004 19:32, Jason Tesser wrote: > Hi > > > Is there an index on: > > testclass.classid
> I created the indexes and it speed up a little. Still a little slower > than Access though. Which I think should not be. The testclass is a view > not A query so I cannot make an index there. But you can make one on the underlying table. > What is the best way to index this stuff? Should I make one index > (b-tree) > And add all fkeys and pkey from that table? You should apply indexes on columns where you need to discriminate amongst different values quickly. Anyway - what you need to do here is: 1. Run "VACUUM ANALYZE" 2. Run "EXPLAN ANALYZE SELECT tblroster.transcriptlink ..." and post the output here. Then we can see what query-plan PG is using. 3. Are you happy that your configuration is well tuned? See http://www.varlena.com/varlena/GeneralBits/Tidbits/index.php There is a performance tuning article and a breakdown of the config file there. -- Richard Huxton Archonet Ltd ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
