Re: Optimizing query

From: Poul Møller Hansen <freebsd(at)pbnet(dot)dk>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Richard Huxton <dev(at)archonet(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Optimizing query
Date: 2005-08-15 14:54:13
Message-ID: 4300AC95.70204@pbnet.dk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>
> You're not there yet: you want what Richard said, namely
>

I realized that it wasn't optimal for all nodes, namely those with a lot
of rows.

So you are absolutely right, I followed the suggestion of Richard and it
works perfect.
Thank you all, I learned a lesson of indexes today...

Poul

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Magnus Hagander 2005-08-15 14:56:47 Re: Authenticating using Windows XP login
Previous Message Aly Dharshi 2005-08-15 14:53:41 Postgresql Books: Which one ?