Re: [HACKERS] strange view performance

2011-05-01 Thread Tom Lane
Pavel Stehule writes: > I am solving a strange situation, where using a view is slower than > using same tables directly. > The view is defined as > CREATE VIEW v1 AS > SELECT * > FROM A >LEFT JOIN B >LEFT JOIN C >LEFT JOIN D > and query is

[HACKERS] strange view performance

2011-05-01 Thread Pavel Stehule
Hello I am solving a strange situation, where using a view is slower than using same tables directly. The view is defined as CREATE VIEW v1 AS SELECT * FROM A LEFT JOIN B LEFT JOIN C LEFT JOIN D and query is SELECT * FROM T