From: Thomas Vatter <thomas.vatter@network-inventory.de>
To: Scott Marlowe <smarlowe@g2switchworks.com>
Cc: Tino Wildenhain <tino@wildenhain.de>
Cc: pgsql-performance@postgresql.org
Subject: Re: in memory views
Date: Wed, 10 May 2006 17:41:01 +0200
Message-ID: <4462098D.2010500@network-inventory.de> (raw)
In-Reply-To: <1147273917.9755.22.camel@state.g2switchworks.com>
References: <4461AFFF.7060200@network-inventory.de>
<4461B3DE.6030700@wildenhain.de>
<4461B899.4030502@network-inventory.de>
<1147273917.9755.22.camel@state.g2switchworks.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: thomas.vatter@network-inventory.de, smarlowe@g2switchworks.com, tino@wildenhain.de
Subject: Re: in memory views
In-Reply-To: <4462098D.2010500@network-inventory.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox