Hello 2010/8/30 Andreas Kretschmer <akretschmer@xxxxxxxxxxxxx>: > Gerhard Wiesinger <lists@xxxxxxxxxxxxx> wrote: > >> I know that the data model is key/value pairs but it worked well in 8.3. >> I need this flexibility. >> >> Any ideas? > > If i understand the query correctly it's a pivot-table, right? > no - it's just EAV table on very large data :( Regards Pavel Stehule > If yes, and if i where you, i would try to rewrite this query, to > something like: > > select > timestamp, > sum (case when keyid = 1 then value else 0 end) as Raumsolltemperatur, > ... > from > log > group by > timestamp; > > > Assuming you can read a german text: > http://www.pg-forum.de/h-ufig-gestellte-fragen-faq/4067-faq-zeilen-zu-spalten.html > > > > Andreas > -- > Really, I'm not out to destroy Microsoft. That will just be a completely > unintentional side effect. (Linus Torvalds) > "If I was god, I would recompile penguin with --enable-fly." (unknown) > Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889° > > -- > Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-performance > -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
