<html><head></head><body><div class="ydp4f1ab867yahoo-style-wrap" style="font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:13px;"><div dir="ltr" data-setdir="false">Hello,</div><div dir="ltr" data-setdir="false"> <span><span>I have a partitioned table in a PostgreSQL/PostGIS database with ~30 billion points. I would like to render a subset of this data in QGIS and run some analytics. <br></span></span></div><div dir="ltr" data-setdir="false"><span><span><br></span></span></div><div dir="ltr" data-setdir="false"><span><span>Normally, with a smaller dataset, I would simply navigate to the table I want via the "Browser" and add it to the map via a double click. Once the data is loaded, I can filter the data, run analysis, etc. However, in my case, this is impossible. <span>What I need is an option to filter the data before loading it into the map.</span><br></span></span></div><div dir="ltr" data-setdir="false"><span><span><br></span></span></div><div dir="ltr" data-setdir="false"><span><span>I looked at the Data Source Manager (<span>Layer -> Add Layer -> Add PostGIS Layers...) </span><span>but I don't see any filtering </span>options there and the app <span>hangs when I hit the "Connect" button.</span><br></span></span></div><div dir="ltr" data-setdir="false"><span><span><br></span></span></div><div dir="ltr" data-setdir="false"><span><span>Obviously, I can create views in the database to circumvent this issue but I don't want to create dozens of custom views. <br></span></span></div><div dir="ltr" data-setdir="false"><span><span><br></span></span></div><div dir="ltr" data-setdir="false"><span><span>Is there another way to create a layer from PostgreSQL/PostGIS using a filter-first strategy in QGIS? <br></span></span></div><div dir="ltr" data-setdir="false"><span><span><br></span></span></div><div dir="ltr" data-setdir="false"><span><span>Thanks in advance,</span></span></div><div dir="ltr" data-setdir="false"><span><span>Peter<br></span></span></div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false"><br></div></div></body></html>