[Qgis-user] Primary key and spatial index

[chris hermansen]

Rikesh and list,

On Thu, Feb 15, 2024, 18:40 Rikesh Lad via QGIS-User <
qgis-user at lists.osgeo.org> wrote:

> Hello,
>
> Please see attached. Does anyone know how to add a primary key and spatial
> index to a large layer without the software crashing?
>
> [image: image.png]
>


Here is some reference info about adding a primary key to a PostgreSQL table

https://www.postgresqltutorial.com/postgresql-tutorial/postgresql-primary-key/#:~:text=To%20add%20a%20primary%20key%20to%20an%20existing%20table%2C%20you,to%20the%20primary%20key%20constraint
.

>
>
Here is some reference info that explains how to add a spatial index

https://postgis.net/workshops/postgis-intro/indexing.html

>
Both require the use of a PostgreSQL client for example "psql".

>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20240215/fcbd4a11/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 32290 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20240215/fcbd4a11/attachment-0001.png>