[PERFORM] Query problem

Hi , I am working to migrate a oracle application to pg. I am using pg 7.3.3 on Dual PIII, 2 GB RAM,linux RedHat 7.3. One of my selects is working much slower as in oracle. In this example I am using not many rows in tables. For all the joins I have indexes. All IDS or IDS_xxx are name. Pls if i

Re: RE : [PERFORM] Query problem

Hi Bruno, I think I have tunet it. Pg is working for most of my selects, but I have problem with this one. regards, ivan Bruno BAGUETTE wrote: > Hello, > > > One of my selects is working much slower as in oracle. > > In this example I am using not many rows in tables. > > For all the joins I hav

[PERFORM] bad join performance

Hi , I am using pg 7.3.3 on RH 7.3, dual Athlon 1 GB RAM. I have 2 tables a_acc and a_vid_doc (all PK are int). sizes: select count(IDS) from a_acc; count - 1006772 select count(IDS) from a_vid_doc; count --- 25 I have problem with the join ot this tables. I tryed this exa

[PERFORM] bad join preformance

Hi , I am using pg 7.3.3 on RH 7.3, dual Athlon 1 GB RAM. I have 2 tables a_acc and a_vid_doc (all PK are int). sizes: select count(IDS) from a_acc; count - 1006772 select count(IDS) from a_vid_doc; count --- 25 I have problem with the join ot this tables. I tryed this exa

Re: [PERFORM] bad join performance

Hi tom, sorry for my bad. My production server is 7.3.7, but the development is 7.3.1 and I ran the tests on 7.3.1. It is courios that on 7.3.1 the query is not constantly bad. >From time to time it is running well. regards, ivan. Tom Lane wrote: > pginfo <[EMAIL PROTECTED]> writ

Re: [PERFORM] bad join performance

Ok, thanks for the help and best regards. ivan. Tom Lane wrote: > pginfo <[EMAIL PROTECTED]> writes: > > sorry for my bad. > > My production server is 7.3.7, but the development is 7.3.1 and I ran the > > tests on 7.3.1. > > > It is courios that on 7.3.1 the q