Re: [SQL] indexing for left join

[T E Schmitz]

Rod Taylor wrote:

Sequential despite the indices? Or is this because the tables of my test DB are virtually empty?

This is it. PostgreSQL changes strategies with data load. Performance
testing must be done on an approximation of the real data (both values
and size).

Thanks for your responses.

--


Regards,

Tarlika Elisabeth Schmitz


---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

              http://archives.postgresql.org