Quesion about querying distributed databases - Mailing list pgsql-general

Hello

Consider this scenario:

• 3 servers, 3 databases, each on a separate server:
  • Products database: Contains the Products table (with over 100,000 records).
  • Taxonomy database: Contains the Categories and ItemCategories (EAV) tables.
  • Attributes database: Contains the Attributes and ItemAttributes (EAV) tables.

How do you find products based on the following criteria?

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")