From: Scott Marlowe <smarlowe@g2switchworks.com>
To: Thomas Vatter <thomas.vatter@network-inventory.de>
Cc: Tino Wildenhain <tino@wildenhain.de>
Cc: pgsql-performance@postgresql.org
Subject: Re: in memory views
Date: Wed, 10 May 2006 10:11:57 -0500
Message-ID: <1147273917.9755.22.camel@state.g2switchworks.com> (raw)
In-Reply-To: <4461B899.4030502@network-inventory.de>
References: <4461AFFF.7060200@network-inventory.de>
<4461B3DE.6030700@wildenhain.de>
<4461B899.4030502@network-inventory.de>
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?
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: smarlowe@g2switchworks.com, thomas.vatter@network-inventory.de, tino@wildenhain.de
Subject: Re: in memory views
In-Reply-To: <1147273917.9755.22.camel@state.g2switchworks.com>
* 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