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

help / color / mirror / Atom feed
From: Jim C. Nasby <jnasby@pervasive.com>
To: Merlin Moncure <mmoncure@gmail.com>
Cc: soni de <soni.de@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Takes too long to fetch the data from database
Date: Fri, 21 Apr 2006 13:19:27 -0500
Message-ID: <20060421181927.GK49405@pervasive.com> (raw)
In-Reply-To: <b42b73150604210644x4f3857f3u9eecbcad8402351d@mail.gmail.com>
References: <9f2e40a90604100021n1cb694d0lb95f318f800f33ee@mail.gmail.com>
	<b42b73150604100845w553dcee6kde20e4b82770aab0@mail.gmail.com>
	<9f2e40a90604110004u787716c2s22bdf53fe349326@mail.gmail.com>
	<b42b73150604110613h2c63ea61oec8035c8e2f4ed98@mail.gmail.com>
	<9f2e40a90604192237i5d3e8f0dl1c8b19887bc34e22@mail.gmail.com>
	<b42b73150604200905h56a0d387xec8c80b4c8d3e901@mail.gmail.com>
	<9f2e40a90604202142x5adbe6f0r7a993f8319619cc7@mail.gmail.com>
	<b42b73150604210644x4f3857f3u9eecbcad8402351d@mail.gmail.com>

On Fri, Apr 21, 2006 at 09:44:25AM -0400, Merlin Moncure wrote:
> 2nd 50:
> select * from t where j >= j1 and (j > j1 or k > k1) order by j, k limit 50;
> 3 fields:
> select * from t where i >= i1 and (i > i1 or j >= j1) and (i > i1 or j
> > k1 or k > k1) order by i,j,k limit 50;

Note that in 8.2 you'll be able to do:

WHERE (i, j, k) >= (i1, j1, k1)
-- 
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461



view thread (17+ messages)  latest in thread

Message-ID: <20060421181927.GK49405@pervasive.com>
Permalink:  ../20060421181927.GK49405@pervasive.com/
Also on:    postgresql.org/message-id/20060421181927.GK49405@pervasive.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 using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: jnasby@pervasive.com, mmoncure@gmail.com, soni.de@gmail.com
  Subject: Re: Takes too long to fetch the data from database
  In-Reply-To: <20060421181927.GK49405@pervasive.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