| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | me nefcanto <sn(dot)1361(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Quesion about querying distributed databases |
| Date: | 2025-03-05 04:42:08 |
| Message-ID: | fd47b28c-8f6b-4bfb-a393-160c5c3de8c0@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 3/4/25 20:40, me nefcanto wrote:
> Hello
>
> Consider this scenario:
>
> * 3 servers, 3 databases, each on a separate server:
> o *Products database*: Contains the *Products* table (with over
> 100,000 records).
> o *Taxonomy database*: Contains the *Categories* and
> *ItemCategories (EAV)* tables.
> o *Attributes database*: Contains the *Attributes* and
> *ItemAttributes (EAV)* tables.
>
> How do you find products based on the following criteria?
https://www.postgresql.org/docs/current/postgres-fdw.html
>
> 1. A search in the title (e.g., "awesome shirts").
> 2. Selected categories (e.g., "casual" and "sports").
> 3. Selected attributes (e.g., "color: blue" and "size: large")
>
>
> Regards
> Saeed
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | me nefcanto | 2025-03-05 06:42:13 | Re: Quesion about querying distributed databases |
| Previous Message | me nefcanto | 2025-03-05 04:40:09 | Quesion about querying distributed databases |