On 04/26/2017 08:11 PM, Klaus P. Pieper wrote:
>
> Running PostgreSQL 9.6 on a Windows Server.
>
> Table âtâ is kind of a materialized view with > 100 columns and 2.24
> Mio rows. Queries are generated by an ORM framework â fairly difficult
> to modify.
>
> Vacuum analyze was carried out â no
Running PostgreSQL 9.6 on a Windows Server.
Table "t" is kind of a materialized view with > 100 columns and 2.24 Mio
rows. Queries are generated by an ORM framework - fairly difficult to
modify.
Vacuum analyze was carried out - no impact.
The framework generates queries like this: