Received: from maia.hub.org (maia-5.hub.org [200.46.204.29])
	by mail.postgresql.org (Postfix) with ESMTP id 77593B5DBD6
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Thu,  3 Nov 2011 17:08:14 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024)
	with ESMTP id 00350-02
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Thu,  3 Nov 2011 20:08:07 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.8.0-rc2
Received: from mailout-de.gmx.net (mailout-de.gmx.net [213.165.64.22])
	by mail.postgresql.org (Postfix) with SMTP id 92DE9B5DBC0
	for <pgsql-performance@postgresql.org>;
	Thu,  3 Nov 2011 17:08:06 -0300 (ADT)
Received: (qmail invoked by alias); 03 Nov 2011 20:08:04 -0000
Received: from 194-166-52-16.adsl.highway.telekom.at (EHLO [10.192.17.32])
	[194.166.52.16]
	by mail.gmx.net (mp061) with SMTP; 03 Nov 2011 21:08:04 +0100
X-Authenticated: #5984785
X-Provags-ID: V01U2FsdGVkX19H10g5049HK5ETagHty7Eq9rysRxpNP/uJQvBuLl
	m1d1rV0qqX7HCO
Message-ID: <4EB2F49F.3080903@gmx.at>
Date: Thu, 03 Nov 2011 21:07:59 +0100
From: Mario Weilguni <roadrunner6@gmx.at>
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64;
	rv:7.0.1) Gecko/20110929 Thunderbird/7.0.1
MIME-Version: 1.0
To: pgsql-performance@postgresql.org
Subject: Re: Performance Problem with postgresql 9.03, 8GB RAM,Quadcore
	Processor Server--Need help!!!!!!!
References: 
 <CACBfhZPO1GJv4nVunPXGA2EZq923On-CBGtxyhtQYAaSMCuBEQ@mail.gmail.com>
	<CAF-3MvOjY17pVZXSWgYDB5dMy-B07KiVYexR4RRutxZyXeKjbA@mail.gmail.com>
	<CACBfhZNBwjB=3xQrvqy6ManJUaRyKEOoV8dMv7jJYPtXn9XFcQ@mail.gmail.com>
	<CACBfhZNr5qnMN0=8hp1Fb3hA8jwoEXnJAahua1JT5f5gXT9tuA@mail.gmail.com>
	<4EAFC29A.40509@engene.se> <24830.1320154980@sss.pgh.pa.us>
	<CACBfhZNoq_hjZyMnBTnrxR8rif31QvJ5dtdgQMdPwO0+x2AKpQ@mail.gmail.com>
	<4EB2ACEF.8090305@gmx.at>
	<65a8332e0128eda27f0345da80946dc6.squirrel@sq.gransy.com>
In-Reply-To: <65a8332e0128eda27f0345da80946dc6.squirrel@sq.gransy.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
X-Y-GMX-Trusted: 0
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.799 tagged_above=-10 required=5
	tests=BAYES_00=-1.9, FREEMAIL_ENVFROM_END_DIGIT=0.1, FREEMAIL_FROM=0.001,
	RCVD_IN_DNSWL_NONE=-0.0001
X-Spam-Level: 
X-Archive-Number: 201111/69
X-Sequence-Number: 45580

Am 03.11.2011 17:08, schrieb Tomas Vondra:
> On 3 Listopad 2011, 16:02, Mario Weilguni wrote:
> <snip>
> No doubt about that, querying tables using conditions on array columns is
> not the best direction in most cases, especially when those tables are
> huge.
>
> Still, the interesting part here is that the OP claims this worked just
> fine in the older version and after an upgrade the performance suddenly
> dropped. This could be caused by many things, and we're just guessing
> because we don't have any plans from the old version.
>
> Tomas
>
>

Not really, Mohamed always said he has 9.0.3, Marcus Engene wrote about 
problems after the migration from 8.x to 9.x. Or did I miss something here?

Regards,
Mario