From: | Srikanth Kata <srikanth(at)inventum(dot)net> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Subject: | What is the best way to optimize this query |
Date: | 2010-07-01 05:19:14 |
Message-ID: | 29041515.post@talk.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Please tell me What is the best way to optimize this query
select
s.*,a.actid,a.phone,d.domid,d.domname,d.domno,a.actno,a.actname,p.descr
as svcdescr from vwsubsmin s inner join packages p on s.svcno=p.pkgno inner
join
account a on a.actno=s.actno inner join ssgdom d on a.domno=d.domno inner
join (select subsno from
getexpiringsubs($1,cast($2 as integer),cast($3 as double precision), $4) as
(subsno int,expirydt timestamp without time zone,balcpt double precision))
as e on s.subsno=e.subsno where s.status <=15 and d.domno=$5 order by
d.domname,s.expirydt,a.actname
--
View this message in context: http://old.nabble.com/What-is-the-best-way-to-optimize-this-query-tp29041515p29041515.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.
From | Date | Subject | |
---|---|---|---|
Next Message | Rajesh Kumar Mallah | 2010-07-01 09:41:10 | how to (temporarily) disable/minimize benefits of disk block cache or postgresql shared buffer |
Previous Message | Bruce Momjian | 2010-07-01 00:42:55 | Re: Analysis Function |