Re: [PERFORM] seqscan on UNION'ed views

2013-02-27 Thread Tom Lane
Dmitry Karasik writes: > I need to have a sort of a time machine, where select statements on tables > could be easily replaced to select statements on tables as they were some > time in the past, > including all related table. To do so, I used views (see in the script) that > UNION > both curre

[PERFORM] seqscan on UNION'ed views

2013-02-27 Thread Dmitry Karasik
Dear all, I have a problem with seqscan I hope you might help me with. Attached is the simple script that reproduces a database and results, which I have tested both on 9.0.4 and 9.3-devel with identical results. I need to have a sort of a time machine, where select statements on tables could be