Re: [Qgis-user] Incredibly slow attribute view/access from postgresv3.16

2021-10-06 Thread Richard McDonnell
...@opw.ie Email Disclaimer: https://www.gov.ie/en/organisation-information/439daf-email-disclaimer/ From: Qgis-user On Behalf Of Andrew Hughes Sent: 06 October 2021 08:22 To: Bernhard Ströbl Cc: QGIS User Subject: Re: [Qgis-user] Incredibly slow attribute view/access from postgresv3.16 Thanks

Re: [Qgis-user] Incredibly slow attribute view/access from postgresv3.16

2021-10-06 Thread Andrew Hughes
Thanks Bernhard, I'm afraid we are quite well indexed. I'd also expect slow performance on the map rendering if that were the problem. Unless of course there is some client side data caching from postgres that I am not aware of? Thank you & Cheers, Andrew On Wed, 6 Oct 2021 at 16:26, Bernhard S

Re: [Qgis-user] Incredibly slow attribute view/access from postgresv3.16

2021-10-05 Thread Bernhard Ströbl
Hi, just a few ideas: Do you have a spatial index on the table? I have no clue how QGIS handles the attribute table (loading all datasets in the first place and then select or else) maybe editing this many features is better done directly on the DB? Bernhard Am 05.10.2021 um 23:51 schrieb And