pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Rusty Conover <rconover@infogears.com>
To: Ulrich <ulrich.mierendorff@gmx.net>
Cc: pgsql-performance@postgresql.org
Subject: Re: Subquery WHERE IN or WHERE EXISTS faster?
Date: Mon, 30 Jun 2008 01:44:45 -0600
Message-ID: <B68AFD89-4213-4912-8108-8C41913F45CB@infogears.com> (raw)
In-Reply-To: <48688B44.6070407@gmx.net>
References: <48665741.2060900@gmx.net>
	<29009.1214668423@sss.pgh.pa.us>
	<4866B624.1090906@gmx.net>
	<B7AEEA21-79C7-481D-BB7B-899002CC2174@infogears.com>
	<48688B44.6070407@gmx.net>


On Jun 30, 2008, at 1:29 AM, Ulrich wrote:

> I think it will be fast, because the "IN set", which is the result  
> of "SELECT processorid FROM users_processors WHERE userid=4040", is  
> limited to a maximum of ~500 processors which is not very big.  
> Increasing Postgres' RAM would be difficult for me, because I am  
> only running a very small server with 256MB RAM and the webserver  
> also likes to use some RAM.
>
> Does Postgre cache the HASH-Table for later use? For example when  
> the user reloads the website.
>

No the hash table only lives as long as the query is being executed.   
If you're looking for generic caching, I'd suggest memcached may be  
able to fill your needs.

Cheers,

Rusty
--
Rusty Conover
InfoGears Inc.
http://www.infogears.com









view thread (13+ messages)  latest in thread

Message-ID: <B68AFD89-4213-4912-8108-8C41913F45CB@infogears.com>
Permalink:  ../B68AFD89-4213-4912-8108-8C41913F45CB@infogears.com/
Also on:    postgresql.org/message-id/B68AFD89-4213-4912-8108-8C41913F45CB@infogears.com

 · 

reply

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-performance@postgresql.org
  Cc: rconover@infogears.com, ulrich.mierendorff@gmx.net
  Subject: Re: Subquery WHERE IN or WHERE EXISTS faster?
  In-Reply-To: <B68AFD89-4213-4912-8108-8C41913F45CB@infogears.com>
  References: <48665741.2060900@gmx.net> <29009.1214668423@sss.pgh.pa.us> <4866B624.1090906@gmx.net> <B7AEEA21-79C7-481D-BB7B-899002CC2174@infogears.com> <48688B44.6070407@gmx.net> <B68AFD89-4213-4912-8108-8C41913F45CB@infogears.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