Re: Slow query plan used

From: "Wetzel, Juergen (Juergen)" <wetzel(at)avaya(dot)com>
To: Andreas Kretschmer <andreas(at)a-kretschmer(dot)de>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Slow query plan used
Date: 2017-05-31 11:27:35
Message-ID: B21CD5EA385190469D02AC8D9D60E61A640B65E1@AZ-FFEXMB02.global.avaya.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>> Only 130 rows out of the 30000 have ARCHIVED = 0

> in this case i would suggest a partial index:
> create index <indexname> on <tablename> (archived) where archived = 0;

Thanks, Andreas.

Sorry for the confusion about the table names.
The hint with the partial index sounds as it could solve the problem. I will test it.

Regards
Jürgen

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andreas Kretschmer 2017-05-31 12:52:07 Re: Slow query plan used
Previous Message Andreas Kretschmer 2017-05-31 07:46:35 Re: Slow query plan used