From: Bruno Wolff III <bruno@wolff.to>
To: Madison Kelly <linux@alteeve.com>
To: pgsql-performance@postgresql.org, Tom Lane <tgl@sss.pgh.pa.us>
Subject: Re: Index ot being used
Date: Sun, 12 Jun 2005 22:13:17 -0500
Message-ID: <20050613031317.GA18988@wolff.to> (raw)
In-Reply-To: <20050613030001.GB17491@wolff.to>
References: <1825.216.209.137.1.1118419819.squirrel@mail.alteeve.com>
<20050610155535.GO8451@tobias.nordicbet.com>
<42AC42CB.8050703@alteeve.com>
<24636.1118591783@sss.pgh.pa.us>
<42ACBC95.9020404@alteeve.com>
<20050613030001.GB17491@wolff.to>
On Sun, Jun 12, 2005 at 22:00:01 -0500,
Bruno Wolff III <bruno@wolff.to> wrote:
> On Sun, Jun 12, 2005 at 18:52:05 -0400,
> Madison Kelly <linux@alteeve.com> wrote:
> >
> > After sending that email I kept plucking away and in the course of
> > doing so decided that I didn't need to return the 'file_type' column.
> > Other than that, it would see my query now matches what you two have
> > recommended in the 'ORDER BY...' front but I still can't get an index
> > search.
>
> No it doesn't. Even if you don't return file_type you still need it
> in the order by clause if you want postgres to consider using your
> index.
I didn't notice that you had changed the index. The reason this index
doesn't help is that you can't use it to select on records with the
desired file_type.
>
> Is there some reason you didn't actually try out our suggestion, but are
> now asking for more advice?
>
> >
> > Here is the latest query and the new index:
> >
> > tle-bu=> \d file_info_7_display_idx;
> > Index "public.file_info_7_display_idx"
> > Column | Type
> > -----------------+------
> > file_parent_dir | text
> > file_name | text
> > btree, for table "public.file_info_7"
> >
> > tle-bu=> EXPLAIN ANALYZE SELECT file_parent_dir, file_name, file_display
> > FROM file_info_7 WHERE file_type='d' ORDER BY file_parent_dir ASC,
> > file_name ASC;
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
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: bruno@wolff.to, linux@alteeve.com, tgl@sss.pgh.pa.us
Subject: Re: Index ot being used
In-Reply-To: <20050613031317.GA18988@wolff.to>
* 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