Problem/Motivation

Currently the schema creates columns for all the fields even if they aren't used for filtering.

Steps to reproduce

1. Create a search api backend with multiple fields.
2. Check the database schema has created columns for all the extra fields.

Proposed resolution

It should only create columns for fields with the Filterable attributes indexing option.

Remaining tasks

Provide MR

Issue fork ai_vdb_provider_postgres-3547625

Command icon Show commands

Start within a Git clone of the project using the version control instructions.

Or, if you do not have SSH keys set up on git.drupalcode.org:

About issue forks

Comments

codebymikey created an issue. See original summary.

codebymikey opened merge request !10

codebymikey’s picture

codebymikey commented
Status: Active » Needs review
codebymikey’s picture

codebymikey commented
Issue summary: View changes
m4olivei’s picture

m4olivei
he/him
Primary language English
Location Grimsby, ON
commented
Related issues: +#3576852: Reduce schema bloat: don't create columns for non-attribute fields; normalize entity-level attributes

Duplicate of #3576852: Reduce schema bloat: don't create columns for non-attribute fields; normalize entity-level attributes, not sure which to move forward with perhaps the authors could collaborate on a single patch?