On Mon, Nov 8, 2010 at 12:15 PM, Matthieu Huin <matthieu.huin@xxxxxxxxxx> wrote: > Greetings all, > > I am trying to optimize SELECT queries on a large table (10M rows and more) > by using temporary tables that are subsets of my main table, thus narrowing > the search space to a more manageable size. > Is it possible to transfer indices (or at least use the information from > existing indices) from the big table to its subset in a reasonable amount of > time ? Are you sure that the benefit of creating scratch tables is worth the overhead? Can you give explain/analyze of the query you are trying to optimize? merlin -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
