Re: [PERFORM] Query improvement

Thanks a lot for reply. Finally I have used UNION, but thanks for your help. -- View this message in context: http://postgresql.1045698.n5.nabble.com/Query-improvement-tp4362578p4378160.html Sent from the PostgreSQL - performance mailing list archive at Nabble.com. -- Sent via pgsql-performance

Re: [PERFORM] Query improvement

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 a

[PERFORM] indexes ignored when querying the master table

i have around 25mio records of data distributed yearly over 9 child tables (data.logs_20xx) that inherit from the master table data.logs. the tables are partitioned using the field "re_timestamp", which has btree indexes defined on all tables. the query "SELECT * FROM data.logs ORDER BY re_tim

Re: [PERFORM] Query improvement

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 - performan

Re: [PERFORM] Postgres 9.0.4 + Hot Standby + FusionIO Drive + Performance => Query failed ERROR: catalog is missing 1 attribute(s) for relid 172226

On Tue, May 3, 2011 at 10:02 AM, Sethu Prasad wrote: > I tried with the PostgreSQL 9.0.4 + Hot Standby and running the database > from Fusion IO Drive to understand the PG Performance. > > While doing so I got the "Query failed ERROR: catalog is missing 1 > attribute(s) for relid 172226". Any ide