Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: smiley2211
- Order by date
-
Poor VIEW performance
My query is SIMPLE SELECT: select 1 from people_consent LIMIT 1; VIEWS: CREATE OR REPLACE VIEW temp_consent AS SELECT p.id, max(en.enrolled_at) AS daterecorded, a.answer FROM people p, enrollments en, encounters ec, encounters_questions_answers eqa, questions_answers qa, answers a...- smiley2211
- Post #3
- Forum: PostgreSQL Inc.: PostgreSQL
-
Poor VIEW performance
Hello all, I am NEW to Postgresql and I have a VIEW that is performing HORRIBLY...I have vacuumed the database and rebuild indexes...when I try to run EXPLAIN ANALYZE the results never come back...I did run an EXPLAIN and received results...this view I am told use to take 1 minute now it's...- smiley2211
- Thread
- Replies: 4
- Forum: PostgreSQL Inc.: PostgreSQL
