Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 09F98650224 for ; Sat, 16 Aug 2008 22:33:11 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 12315-07 for ; Sat, 16 Aug 2008 22:33:02 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from rv-out-0506.google.com (rv-out-0506.google.com [209.85.198.233]) by postgresql.org (Postfix) with ESMTP id E84E964FD3E for ; Sat, 16 Aug 2008 22:33:07 -0300 (ADT) Received: by rv-out-0506.google.com with SMTP id b25so2445344rvf.43 for ; Sat, 16 Aug 2008 18:33:06 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:in-reply-to:mime-version:content-type :content-transfer-encoding:content-disposition:references; bh=iqN9HEJczBqZDmYar2/gpueD5lqRHcOuhZKyt0jzXno=; b=v42m37PUXLWJEnhxp+4+LM2fi9Ga6f2kPWIlgYK62468/uUwqnBJcYF2NGaCYjnwRD dOaBgl6LYzZX8/8XtBT5FNcvkOfiyFuf3eenIMvrebxdXmfwBUBCVm7+0VXDnpIFBmx1 WjGZCI/vSlt3VEKakJM18yyW+IB9se5o/8ONk= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:in-reply-to:mime-version :content-type:content-transfer-encoding:content-disposition :references; b=BuJii4XcoqkBs6cMDmXSnDvfFljHfiAyQ8H1lUSLVY4pdBB48LBXnd/bZVTXZ2ELT7 8LaX/QGRttruK3NuwZRVKCntLVZ6g3UT9a4BBQCT214jIRm2LoRHuNaD6FlTIAa8A+IE ie7L5p1DZ48cj+TNW1hulGymRp5sVI1iCbpNw= Received: by 10.141.74.18 with SMTP id b18mr2398253rvl.80.1218936786383; Sat, 16 Aug 2008 18:33:06 -0700 (PDT) Received: by 10.141.177.18 with HTTP; Sat, 16 Aug 2008 18:33:06 -0700 (PDT) Message-ID: Date: Sat, 16 Aug 2008 20:33:06 -0500 From: "=?UTF-8?Q?Rodrigo_E._De_Le=C3=B3n_Plicet?=" To: pgsql-performance@postgresql.org Subject: Re: Optimizing a VIEW In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <48A5CCA4.2040206@alteeve.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200808/181 X-Sequence-Number: 31062 On Sat, Aug 16, 2008 at 2:19 PM, Decibel! wrote: > You need to trim down your EAV table. Egads! I'd say completely get rid of this beast and redesign it according to valid relational concepts. This post pretty much explains the whole issue with EAV: http://groups.google.com/group/microsoft.public.sqlserver.programming/browse_thread/thread/df5bb99b3eaadfa9/6a160e5027ce3a80?lnk=st&q=eav#6a160e5027ce3a80 EAV is evil. Period.