Re: *Regarding brin_index on required column of the table

[Andreas Kretschmer <andreas@xxxxxxxxxxxxxxx>]

Hi,


the problem is there:


Am 20.09.2018 um 11:48 schrieb Durgamahesh Manne:
>  Unique  (cost=5871873.64..6580630.73 rows=7400074 width=89) (actual 
> time=326397.551..389515.863 rows=3700000 loops=1)                     
>                             |
> |   ->  Sort  (cost=5871873.64..5973124.65 rows=40500405 width=89) 
> (actual time=326397.550..372470.846 rows=40500000 loops=1)            
>                                       |
> |         Sort Key: sub_head."vchSubmittersCode", rec."vchFileName", 
> rec."vchCusipFundIDSubFundID", rec."vchFundUnitPrice", 
> sub_head."vchValuationDate", rec."vchAdvisorLabel" |
> |         Sort Method: external merge  Disk: 3923224kB                 
>                                  |

Please check the execution time without DISTINCT.

Regards, Andreas
--

2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com