| From: | Jeremy Smith <jeremy(at)musicsmith(dot)net> |
|---|---|
| To: | "Markhof, Ingolf" <ingolf(dot)markhof(at)de(dot)verizon(dot)com> |
| Cc: | pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Foreign table performance issue / PostgreSQK vs. ORACLE |
| Date: | 2021-01-30 11:28:06 |
| Message-ID: | CAM8SmLVioTeqR6GvhVpW3mtZ7eKUiNo+58qo9kbh7k0otdTNmQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
>
>
> Could there be some tuning option in PostgreSQL to make queries via
> foreign tables faster (e.g. I heard about option fetch_size)?
>
fetch_size can make a difference, but it won't change a query that takes
hours into a query that takes seconds. The default is likely too low,
though.
Have you analyzed the foreign table or set use_remote_estimate? With no
statistics, postgres may just be pulling the entire remote table.
As others have mentioned, it would be useful to see your query. There may
be obvious issues, such as functions in the predicate, but without the
query, we can only guess.
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ben Hoskings | 2021-01-30 14:07:31 | Occasional lengthy locking causing stalling on commit |
| Previous Message | 109 ktke | 2021-01-30 11:20:17 | Re: JIT on Windows with Postgres 12.1 |