Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Desperate: View not using indexes (very slow)
- From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- To: Jen Sale <js(at)slipt(dot)net>
- Cc: pgsql-performance(at)postgresql(dot)org
- Subject: Re: Desperate: View not using indexes (very slow)
- Date: Sun, 29 Jan 2006 22:50:58 -0500
Jen Sale <js(at)slipt(dot)net> writes: > can someone please tell me what we did wrong? Joins against union subqueries aren't handled very well at the moment. (As it happens, I'm working on that exact problem right now for 8.2, but that won't help you today.) The plan indicates that you are using UNION rather than UNION ALL, which is not helping any. Do you really need duplicate elimination in that view? regards, tom lane
- References:
- Desperate: View not using indexes (very slow)
- From: Jen Sale
- Desperate: View not using indexes (very slow)
- Prev by Date: Re: Huge Data sets, simple queries
- Next by Date: Re: Huge Data sets, simple queries
- Previous by thread: Desperate: View not using indexes (very slow)
- Next by thread: PostgreSQL Solaris packages now in beta
- Indexes: