Seref Arikan <serefarikan@xxxxxxxxxxxxxxxxxxxxx> writes: > Another idea that popped into my head is to consider table partitioning. Am > I correct to assume that (inevitable) joins could benefit from partitions > when sub query criteria constraints results to a particular partition? That's too vague to answer really. My suspicion is that you'd still end up having to modify the queries, ie hand-factoring the joins, but maybe you wouldn't need to. You could experiment easily enough; just set up a toy database with not much data in it and see if you get plans that don't scan all the partitions. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
