Re: Odd query result

From: Maximilian Tyrtania <maximilian(dot)tyrtania(at)contactking(dot)de>
To: Sergey Konoplev <gray(dot)ru(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Odd query result
Date: 2012-08-27 09:53:17
Message-ID: 72CCC486-8E30-4695-9A3A-7263993B15E5@contactking.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> On Mon, Aug 27, 2012 at 12:55 PM, Maximilian Tyrtania
> <lists(at)contactking(dot)de> wrote:
>> What might be up there?
>
> It might be a broken index issue. Please show the EXPLAIN for these queries.

It was. I had an index like this:

CREATE INDEX idx_firmen_iskunde_index
ON firmen
USING btree
(f_firmen_iskunde(firmen.*));

Dropping and recreating it fixed it.

Thanks a lot,

Maximilian Tyrtania
http://www.contactking.de

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Maximilian Tyrtania 2012-08-27 09:56:46 Re: Odd query result
Previous Message Sergey Konoplev 2012-08-27 09:39:45 Re: Odd query result