Seref Arikan <serefari...@kurumsalteknoloji.com> 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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
