> -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Clemens Eisserer > Sent: Wednesday, May 10, 2006 6:50 AM > To: pgsql-performance@postgresql.org > Subject: [PERFORM] Question about explain-command... > > What does the hash-lines mean, does that mean my query does not use > the indices at all? > Why are some table-names and some column-names surrounded by ' " '? > Are they threated as text-columns? > I have to admit that the tables are just filled with test-data so the > analyzer may take just a very simple way since almost no data is in... >
For small tables, it is faster to do a sequential scan than an index scan. You probably don't have enough test data to make the planner choose an index scan. I don't think the quotes really mean anything. They are just used as delimiters. The hash lines mean your tables are being joined by hash joins. You should read this page for more info: http://www.postgresql.org/docs/8.1/interactive/performance-tips.html ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
