Re: [PERFORM] Optimizing query

Sorry to forget to give the postgres version as 8.1 On Thu, Oct 7, 2010 at 2:12 PM, Srikanth K wrote: > Hi Can u Please let me know how can i optimize this query better. As i am > attaching u the Query, Schema and Explain Analyze Report. > > Plerase help me in optimizing this query

[PERFORM] What is the best way to optimize the query.

time=461.270..461.270 rows=304 loops=1)" " -> Seq Scan on cpntype t (cost=0.00..13.04 rows=304 width=4) (actual time=234.548..461.194 rows=304 loops=1)" " -> Sort (cost=62.33..64.83 rows

[PERFORM] What is the best way to optimize this query

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

Re: [PERFORM] Best practice to load a huge table from ORACLE to PG

But do we link oracle trigger to postgres trigger ? i mean : oracle trigger will take a note of what has been changed . but then how do we pass those changes to postgres trigger ? can u suggest any logic or algorithm ? Regards, Srikanth k Potluri +63 9177444783(philippines) On Sat 26

[PERFORM] bulk data loading

: Greenplum/Postgres Regards, Srikanth k Potluri +63 9177444783(philippines)