Re: [PERFORM] Mapping a database completly into Memory

Daniel, > > I just wondered if there is a possibility to map my database running > > on a linux system completly into memory and to only use disk > > accesses for writes. > > That happens for free, if you have enough RAM. The kernel will use > spare RAM to hold copies of every disk block it's eve

Re: [PERFORM] Mapping a database completly into Memory

Daniel Migowski <[EMAIL PROTECTED]> writes: > I just wondered if there is a possibility to map my database running > on a linux system completly into memory and to only use disk > accesses for writes. That happens for free, if you have enough RAM. The kernel will use spare RAM to hold copies of e

Re: [PERFORM] Query problem

Try re-arranging your join structure: , A_CARS O JOIN A_CH_CAR CHT ON (CHT.IDS=O.IDS) left outer join A_SLUJITELI SLU ON(O.IDS_SLUJITEL=SLU.IDS) left outer join A_AUTOVOZ AWT ON(O.IDS_AUTOVOZ=AWT.IDS) left outer join A_COMBOPT CB ON(O.IDS_COMBOPT=CB.IDS) left outer

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

RE : [PERFORM] Query problem

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 have indexes. > All IDS or IDS_xxx are name. > > Pls if it is possible poit me how to fix this problem. > > I send the query and the explai analyze. > I hav

[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

[PERFORM] Mapping a database completly into Memory

Hallo pgsql-performance, I just wondered if there is a possibility to map my database running on a linux system completly into memory and to only use disk accesses for writes. I got a nice machine around with 2 gigs of ram, and my database at the moment uses about 30MB on the disks. Or does Post

[PERFORM] Mapping Database completly into memory

Hallo pgsql-performance, I just wondered if there is a possibility to map my database running on a linux system completly into memory and to only use disk accesses for writes. I got a nice machine around with 2 gigs of ram, and my database at the moment uses about 30MB on the disks. Or does Post