Postgres Pro
Downloads
Home   >   mailing lists

Re: Query improvement - Mailing list pgsql-performance

From Mark
Subject Re: Query improvement
Date
Msg-id 1304764622535-4378157.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 reply both UNION and JOINS 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-tp4362578p4378157.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.

pgsql-performance by date:

Previous
From: Thomas Hägi
Date:
Subject: indexes ignored when querying the master table
Next
From: Mark
Date:
Subject: Re: Query improvement