Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id B39AF7FB732 for ; Wed, 4 Jul 2012 07:36:06 -0300 (ADT) Received: from mail-bk0-f46.google.com ([209.85.214.46]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SmMwH-0002Oa-BT for pgsql-performance@postgresql.org; Wed, 04 Jul 2012 10:36:05 +0000 Received: by bkwj10 with SMTP id j10so2480187bkw.19 for ; Wed, 04 Jul 2012 03:35:52 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=message-id:date:from:user-agent:mime-version:cc:subject:references :in-reply-to:content-type:content-transfer-encoding; bh=nPwzZmukkG0Hy9LXsZxkIBrrtn6+BBvhyfK6c1KVI+Q=; b=VFeVNOHC7ksnXqYiNGQzuKIxWUZD3UO1JFAf32Ld7vPQQH7dXn1v3Ips1y96afNjad EadBeWLGQ8NJn3CmTfRcjkBpem8P+WwPg54ic+h5FZe9JY6Kbd5O4AADKvpmu/YAU25s bm/KEoBV/x79x7XNjHfMaCIg/k7EKAqiPOi+iR1yOaObWjJ+d9gIQ83BufzAhWZskl3B IVzt+F6UL6DvE8vB3FVCfTBIdd6FINR32Vms4Av1VsWqhu3koi3A8ILLJm5LMgkSAhyf GHChqUbaIU4L/rCOKGcAMeoWwyBUphOuG/627IQaRlwt/TqdVhFQLKK/ZslpjHwiZ3To PuBQ== Received: by 10.204.148.83 with SMTP id o19mr11266156bkv.96.1341398152228; Wed, 04 Jul 2012 03:35:52 -0700 (PDT) Received: from athlon.ww1.0pc.eu (237.Red-88-28-127.staticIP.rima-tde.net. [88.28.127.237]) by mx.google.com with ESMTPS id u8sm18710665bks.0.2012.07.04.03.35.49 (version=SSLv3 cipher=OTHER); Wed, 04 Jul 2012 03:35:51 -0700 (PDT) Message-ID: <4FF41C83.6040206@gmail.com> Date: Wed, 04 Jul 2012 12:35:47 +0200 From: PV User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:13.0) Gecko/20120605 Thunderbird/13.0 MIME-Version: 1.0 CC: pgsql-performance@postgresql.org Subject: Re: static virtual columns as result? References: <4FF2B1020200002500048D3F@gw.wicourts.gov> In-Reply-To: <4FF2B1020200002500048D3F@gw.wicourts.gov> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -1.4 (-) X-Archive-Number: 201207/15 X-Sequence-Number: 47196 SOLVED: 1) Try remove old functions tsearch, ltree,..., "old" database format 2) Vacuum or rebuild database One could solve the problem. Regards