[Qgis-developer] QGIS 2 becomes slow and freezes when editing and saving PostGIS layers

[Pedro Venâncio]

Hi,

I can now say that the slowness problem does not only affects PostGIS layers. It also happens to me with any kind of shapefiles (points, polylines and polygons).

It's an erratic behavior, does not have a regular pattern, and does not always happen. What seems to me is that only happens when I have labels in the project (not necessarily in the layer being edited).

Since, apparently, it is not a behavior that everyone can confirm, may be some plugin that is causing this behavior?

Thanks.

Best regards,
Pedro




----- Mensagem original -----
> DE: Pedro Venâncio 
> 
> Hi,
> 
> This happens to me with other layer types, these latter cases were with polygon 
> (multipolygon) layers.
> 
> 
> 
> 
> 
> ----- Mensagem original -----
>>  DE: Stott James 
>> 
>>  This happened to me in 1.8, but was never able to pin down why. QGIS would 
>>  become responsive again after a while, and the slow down when you tried to 
> save 
>>  the next edit.
>> 
>>  It was with point layers that I had the problem with. Not sure if it 
> affected 
>>  lines or polygons.
>> 
>>  Had to close down QGIS and open again.
>
>
>
----- Mensagem original -----
> DE: Régis Haubourg 
>
> Hi,
> I 've never seen that in 1.8, this is really related to new versions for
> sure. 
>
>
>
----- Mensagem original -----
> DE: Pedro Venâncio
>
> Hi Regis,
>
> Do you also think that this does not happen (at least as often) with QGIS 1.8?
>
>
> Best regards,
> Pedro
>
>
>
> ----- Mensagem original -----
>> DE: Régis Haubourg
>>
>> Confirmed for me yesterday! A commit process stays idle in database server.
> I
>> was blaming antivirus at start, but it seems related to the number of
> commit
>> done in an edit session..
>>
> 
>
>
>________________________________
> DE: Pedro Venâncio 
>
>
>Hi,
>
>In the recent times it has happened to me a strange thing, and I do not know what is the source, it may be that you have already identified something.
>
>When working with Postgis layers in QGIS, every time I "save" changes of an editing layer, I notice that the recording process is slower, until the moment when QGIS ends up freezing.
>
>Another situation where QGIS freezes very often, is when creating new fields/columns in the attribute table of PostGIS layers. I add new fields, but when I try to save them, QGIS freezes and PostgreSQL keep the UPDATE process of the table as IDLE. In some cases, after stopping the process, I see that the changes were saved and applied to the table, but I have to kill QGIS because it is frozen.
>
>This has happened to anyone? I really do not know if it is a QGIS problem, but the truth is that I do not remember this happening with QGIS 1.8, and now it happens to me very often.
>
>PostGIS (2.0.1 / PostgreSQL 9.1.10) is in a remote Linux machine, but on the same network. QGIS is version 2.0.1 on a Windows 7 machine.
>
>
>Thank you very much.
>
>Best regards,
>Pedro