Project

Profile

Help

Task #1849

Investigate using postgres materialized views for content views

Added by semyers over 4 years ago. Updated 3 months ago.

Status:
CLOSED - WONTFIX
Priority:
Normal
Assignee:
-
Category:
-
Start date:
Due date:
% Done:

0%

Estimated time:
Platform Release:
Groomed:
No
Sprint Candidate:
No
Tags:
Pulp 2
Sprint:
Quarter:

Description

postgres provides a special view type known as a materialized view, which creates a query-based view table whose contents is generated at query time.

http://www.postgresql.org/docs/current/static/sql-creatematerializedview.html

Our current content "view" is comprised of symlinks on a filesystem that are exposed via apache. Using materialized views, it may be possible to forego creating these symlinks in favor of using a materialized view that correlates request paths to "real" content unit locations on the filesystem for delivery. Assuming it's performant (and it should be), this could help eliminate the need to serve files out of /var/www.

As an example, when a request comes in for /repos/repo_id/content_unit, it could go through normal authorization, and then a db query to this view is made to come up with the correct value for X-Sendfile to give back to apache for serving up the content.

Thanks to Nicholas Strugnell for the suggestion.

History

#1 Updated by semyers over 4 years ago

It should be noted that until we've got pulp running on postgres, this will be very difficult to investigate. :)

#2 Updated by bmbouter over 1 year ago

  • Status changed from NEW to CLOSED - WONTFIX

#3 Updated by bmbouter over 1 year ago

Pulp 2 is approaching maintenance mode, and this Pulp 2 ticket is not being actively worked on. As such, it is being closed as WONTFIX. Pulp 2 is still accepting contributions though, so if you want to contribute a fix for this ticket, please reopen or comment on it. If you don't have permissions to reopen this ticket, or you want to discuss an issue, please reach out via the developer mailing list.

#4 Updated by bmbouter over 1 year ago

  • Tags Pulp 2 added

Please register to edit this issue

Also available in: Atom PDF