zzzeek / sqlalchemy_old / issues / #2510 - Remove unnecessary outer join in PG enums reflection query — Bitbucket

Issue #2510 resolved

Former user created an issue 2012-06-15

I missed this in ~~#2473~~: the query for enums also outer-joins pg_constraint without using any columns from it.

Removing this takes each table reflection from 1-2 seconds down to 160 ms in our production DB (which has a fairly unusual number of objects).

Patch attached.

Comments (5)

Former user Account Deleted
- attached ticket-2510-remove-unnecessary-join-in-enums-reflect-query.default.patch
Patch against default branch
- 2012-06-15T06:21:06+00:00
Former user Account Deleted
- attached ticket-2510-remove-unnecessary-join-in-enums-reflect-query.rel_0_7.patch
Patch against rel_0_7
- 2012-06-15T06:21:22+00:00
Mike Bayer repo owner
- changed milestone to 0.7.8
- 2012-06-15T09:47:35+00:00
Mike Bayer repo owner
- changed status to resolved
thanks for this !

2528595802a7900e1a61570d7228bd445b5b7f3f d84e3eb2842a23c39836d356479e05820a2b7808
- 2012-06-16T17:54:57+00:00
Mike Bayer repo owner
- removed milestone
Removing milestone: 0.7.8 (automated comment)
- 2014-02-23T18:14:56+00:00
Log in to comment

Assignee: Mike Bayer

Type: bug

Priority: major

Status: resolved

Component: postgres

Milestone: –

Votes: 0

Watchers: 0

Jira: the preferred issue tracker for Bitbucket. Join the team!