Re: in memory views

[Thomas Vatter <thomas.vatter@xxxxxxxxxxxxxxxxxxxx>]

Scott Marlowe wrote:

On Wed, 2006-05-10 at 04:55, Thomas Vatter wrote:
  

Tino Wildenhain wrote:

    

Thomas Vatter schrieb:

      

is there a possibility for creating views or temp tables in memory to 
avoid disk io when user makes select operations?
        

No need. The data will be available in OS and database caches if
they are really required often. If not, tune up the caches and
do a regular "pre select".

Regards
Tino


      

hmm, I am selecting a resultset with 1300 rows joined from 12 tables. 
with jdbc I am waiting 40 seconds until the first row appears. The 
following rows appear really fast but the 40 seconds are a problem.
    

Are you selecting the whole set at once?  Or are you placing it into a
cursor?

What happens if you do this by declaring it as a cursor and then
fetching the first row?

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org


  

I do executeQuery(), for the resultSet I do next() and return one row, but wait, I have to review the logic in this area, I can tell you tomorrow

regards
tom