From: | Seref Arikan <serefarikan(at)kurumsalteknoloji(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | PG-General Mailing List <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: is there a relationship between indexes and temporary file creation? |
Date: | 2015-03-15 15:42:17 |
Message-ID: | CA+4Thdo5MM_hWDDC0BH1U+sdEg9a9Ak=g_UDNN4vgu-y5e8goQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Thanks Tom,
I'll give it a try, the whole setup is synthetic anyway, should not be too
much of a trouble
Best regards
Seref
On Sun, Mar 15, 2015 at 3:16 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Seref Arikan <serefarikan(at)kurumsalteknoloji(dot)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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2015-03-15 15:44:12 | Re: regclass and format('%I') |
Previous Message | Tom Lane | 2015-03-15 15:16:55 | Re: is there a relationship between indexes and temporary file creation? |