pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: PFC <lists@peufeu.com>
To: Andrus <kobruleht2@hot.ee>
To: pgsql-performance@postgresql.org
Subject: Re: analyzing intermediate query
Date: Tue, 02 Dec 2008 15:13:50 +0100
Message-ID: <op.uljghcfxcigqcu@soyouz> (raw)
In-Reply-To: <B52A6C218D2145378337CFDC89699D99@andrusnotebook>
References: <gh38cg$1544$1@news.hub.org>
	<op.uljfbad8cigqcu@soyouz>
	<B52A6C218D2145378337CFDC89699D99@andrusnotebook>


> My list can contain 1 .. 100000  records and table contains 3000000  
> records and is growing.

	Ah. No IN(), then ;)
	Temp table + ANALYZE seems your only option...

view thread (10+ messages)  latest in thread

Message-ID: <op.uljghcfxcigqcu@soyouz>
Permalink:  ../op.uljghcfxcigqcu@soyouz/
Also on:    postgresql.org/message-id/op.uljghcfxcigqcu@soyouz

copy link · copy postgr.es

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 using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: lists@peufeu.com, kobruleht2@hot.ee
  Subject: Re: analyzing intermediate query
  In-Reply-To: <op.uljghcfxcigqcu@soyouz>

* 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