Postgres Pro
Downloads
Home   >   mailing lists

Re: Optimizing a VIEW - Mailing list pgsql-performance

From Rodrigo E. De León Plicet
Subject Re: Optimizing a VIEW
Date
Msg-id a55915760808161833j208dc08au2ffde26dd0005c6@mail.gmail.com
Whole thread Raw
In response to Re: Optimizing a VIEW  (Decibel! <decibel@decibel.org>)
List pgsql-performance
Tree view 
On Sat, Aug 16, 2008 at 2:19 PM, Decibel! <decibel@decibel.org> 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.

pgsql-performance by date:

Previous
From: david@lang.hm
Date:
Subject: Re: Filesystem benchmarking for pg 8.3.3 server
Next
From: "Rodrigo E. De León Plicet"
Date:
Subject: Re: Optimizing a VIEW