Postgres Pro
Downloads
Home   >   mailing lists

Re: Query improvement - Mailing list pgsql-performance

From Mark
Subject Re: Query improvement
Date
Msg-id 1304764792758-4378163.post@n5.nabble.com
Whole thread Raw
In response to Re: Query improvement  ("Marc Mamin" <M.Mamin@intershop.de>)
List pgsql-performance
Tree view 
Thanks for replies. Finally I have used UNION and JOINS, which helped. Mainly
the UNION helped a lot. Now the query takes 1sec max. Thanks a lot.

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Query-improvement-tp4362578p4378163.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.

pgsql-performance by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Postgres 9.0.4 + Hot Standby + FusionIO Drive + Performance => Query failed ERROR: catalog is missing 1 attribute(s) for relid 172226
Next
From: Thomas Hägi
Date:
Subject: indexes ignored when querying the master table