Обсуждение: Postgres issues "Not enough storage is available to complete this operation" exception
Postgres issues "Not enough storage is available to complete this operation" exception
All,
I am running on a Windows XP machine, 4GB of RAM and over 26GB of free hard-disk an application that all it does is insert records into the Postgres 8.3 database. When the database is approx 17GB Postgres issues the “Not enough storage is available to complete this operation” and refuses to insert records. I normally shut down and restart the application and data collection continues normally until it reaches the 26GB and issues the same error: “Not enough storage is available to complete this operation.” I’m very puzzled to say the least. The Postgres configuration is attached. For some reason Postgres would no load if shared_buffers > 900MB.
I should say that my Windows is running with the /3GB flag.
Thanks in advance for any help you can offer.
Maria Cianci
Software Engineer
CAE USA Professional Services
CONSIM Group
3501 Quadrangle Blvd., Suite 271
Orlando, FL 32817
CAE: (407)745-2609
Privileged/Confidential Information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person) you may not use, copy, disclose or deliver this message to anyone. If you have received this message in error, kindly notify the sender by reply email or at the phone number listed above, and then delete this message.
Вложения
Re: Postgres issues "Not enough storage is available to complete this operation" exception
The topic for this message would be better suited for the pgsql-general or pgsql-admin mailing lists since the problem you've described doesn't relate to the ODBC driver. If you re-post your email to those mailing lists you will not doubt get more feed back. On Mon, Nov 16, 2009 at 8:26 AM, Maria Cianci <Maria.Cianci@cae.com> wrote: > I am running on a Windows XP machine, 4GB of RAM and over 26GB of free > hard-disk an application that all it does is insert records into the > Postgres 8.3 database. When the database is approx 17GB Postgres issues the > “Not enough storage is available to complete this operation” and refuses to > insert records. I normally shut down and restart the application and data > collection continues normally until it reaches the 26GB and issues the same > error: “Not enough storage is available to complete this operation.” I’m > very puzzled to say the least. The Postgres configuration is attached. For > some reason Postgres would no load if shared_buffers > 900MB. > > > > I should say that my Windows is running with the /3GB flag. > > > > Thanks in advance for any help you can offer. -- Regards, Richard Broersma Jr. Visit the Los Angeles PostgreSQL Users Group (LAPUG) http://pugs.postgresql.org/lapug