From: | raghu ram <raghuchennuru(at)gmail(dot)com> |
---|---|
To: | Stefan Schwarzer <stefan(dot)schwarzer(at)unep(dot)org> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: ERROR: out of shared memory - But the table is empty |
Date: | 2012-07-13 05:23:04 |
Message-ID: | CALnrrJQpWs0-vSYrurRGrXowVTei3BbxEqbG6FsLLQ_+ovz89g@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Thu, Jul 12, 2012 at 8:23 PM, Stefan Schwarzer <stefan(dot)schwarzer(at)unep(dot)org
> wrote:
> Hi there,
>
> not being an expert for Postgres…. I have a Postgis table with the
> countries of the world. Now, I would like to drop it. I got the error
> message:
>
> ERROR: out of shared memory
> HINT: You might need to increase max_locks_per_transaction.
>
> and thought that it would be easier to drop first all rows, and then drop
> the empty table.
>
> But it seems that it has a problem with dropping the index:
>
> DROP INDEX gis.countries_uid;
>
> actually generates that error message.
>
> So, do I need to dig now into the postgres config file? It seems strange
> to me that Postgres has a problem deleting an empty table, though.
>
>
The shared lock table has room for max_locks_per_transaction *
max_connections entries,so as soon as it exceeds,you will get this error
message. For fixing this issue,please set max_locks_per_transaction
to (tables in database)/max_connections.
Thanks & Regards,
Raghu Ram
EnterpriseDB Corporation
Blog:http://raghurc.blogspot.in/
From | Date | Subject | |
---|---|---|---|
Next Message | Craig Ringer | 2012-07-13 05:51:18 | hstore for audit logging: Finding differences between two hstore values |
Previous Message | Toby Corkindale | 2012-07-13 01:46:54 | Re: Bug? Prepared queries continue to use search_path from their preparation time |