| From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
|---|---|
| To: | me nefcanto <sn(dot)1361(at)gmail(dot)com>, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
| Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Quesion about querying distributed databases |
| Date: | 2025-03-05 07:39:21 |
| Message-ID: | caf4e99941b3c83bb9eab91e33b144b826b68f79.camel@cybertec.at |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, 2025-03-05 at 10:12 +0330, me nefcanto wrote:
> Adrian Klaver, thank you for the link. I asked the AI to create a query for me using FDW.
>
> The problem here is that it collects all of the product_id values from the ItemCategories table [...]
>
> That's not scalable. Is there a workaround for this?
Without having scrutinized the case in detail: if your data are organized in an
entity-attribute-value design and distributed across three databases, you cannot
expect to end up with efficient queries.
Perhaps you can extract the data and load them into a reasonably organized
single database. Such an ETL process might make the task much easier.
Yours,
Laurenz Albe
| From | Date | Subject | |
|---|---|---|---|
| Next Message | me nefcanto | 2025-03-05 09:27:37 | Re: Quesion about querying distributed databases |
| Previous Message | me nefcanto | 2025-03-05 06:42:13 | Re: Quesion about querying distributed databases |