> 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
On Thu, Jul 12, 2012 at 8:23 PM, Stefan Schwarzer 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 incr
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
Try doing select * from pg_locks to see how many locks you have out.
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
ostgresql.org;
pgsql-performance@postgresql.org
Subject: Re: [GENERAL] ERROR: out of shared memory
"Sorin N. Ciolofan" <[EMAIL PROTECTED]> writes:
> It seems that the legacy application creates tables dynamically and the
> number of the created tables depends on the size of the in
l.org
Subject: Re: [GENERAL] ERROR: out of shared memory
"Sorin N. Ciolofan" <[EMAIL PROTECTED]> writes:
>I have to manage an application written in java which call another
module
> written in java which uses Postgre DBMS in a Linux environment. I'm new to
> Post
"Sorin N. Ciolofan" <[EMAIL PROTECTED]> writes:
> It seems that the legacy application creates tables dynamically and the
> number of the created tables depends on the size of the input of the
> application. For the specific input which generated that error I've
> estimated a number of created tabl
On 3/26/07, Tom Lane <[EMAIL PROTECTED]> wrote:
"Sorin N. Ciolofan" <[EMAIL PROTECTED]> writes:
>I have to manage an application written in java which call another module
> written in java which uses Postgre DBMS in a Linux environment. I'm new to
> Postgres. The problem is that for large amo
"Sorin N. Ciolofan" <[EMAIL PROTECTED]> writes:
>I have to manage an application written in java which call another module
> written in java which uses Postgre DBMS in a Linux environment. I'm new to
> Postgres. The problem is that for large amounts of data the application
> throws an:
> org.p
Hello!
I have to manage an application written in java which call another module
written in java which uses Postgre DBMS in a Linux environment. I'm new to
Postgres. The problem is that for large amounts of data the application
throws an:
org.postgresql.util.PSQLException: ERROR: ou
10 matches
Mail list logo
