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
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
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
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
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
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