Re: FW: [GENERAL] Java Memory Issue while Loading Postgres library

-Original Message- From: Craig Ringer [mailto:cr...@postnewspapers.com.au] Sent: Friday, April 30, 2010 12:01 PM To: Arya, Ashish Cc: pgsql-general@postgresql.org; Bhattacharya, A Subject: Re: FW: [GENERAL] Java Memory Issue while Loading Postgres library Hi Did you eventually figure o

Re: FW: [GENERAL] Java Memory Issue while Loading Postgres library

-Original Message- From: Craig Ringer [mailto:cr...@postnewspapers.com.au] Sent: Thursday, April 29, 2010 6:02 PM To: Bhattacharya, A Cc: pgsql-general@postgresql.org Subject: Re: FW: [GENERAL] Java Memory Issue while Loading Postgres library On 29/04/2010 7:34 PM, a.bhattacha...@sungard.

FW: [GENERAL] Java Memory Issue while Loading Postgres library

Dear All Experts, We have a java exe making a call to a postgres function. This postgres function internally makes a call to a dll (which is written using Postgres extended C). Now the issue is that, when we make a call to this dll, it consumes a lot of memory and this memory is getting cons

[GENERAL] Java Memory Issue while Loading Postgres library

Dear All Experts, We have a java exe making a call to a postgres function. This postgres function internally makes a call to a dll (which is written using Postgres extended C). Now the issue is that, when we make a call to this dll, it consumes a lot of memory and this memory is getting cons

Re: [GENERAL] PostgreSQL Performance issue

I am curious to know how much of your delay is due to PostgreSQL and how much to your Java batch program. If you comment out the call to the database function, so that you are reading your input file but not doing anything with the data, how long does your batch program take to run? RobR -

Re: [GENERAL] PostgreSQL Performance issue

Thanks a lot for your help. However I am new to Postgres database therefore it would be nice if you can let me know how to set autocommit off. I know from psql client issuing "\set Autocommit Off" would set it off but unfortunately it doesn't set it off. Many thanks for your help.

[GENERAL] PostgreSQL Performance issue

Dear All Experts, I am using in PostgreSQL 8.3.5 database on windows 64 bit OS. However, I have a batch program written in Java which processes the data and populates them into tables in Postgres database. I have 622,000 number of records but it is taking almost 4 and half hours to load th

[GENERAL] SET AUTOCOMMIT OFF

Hi All, I am new to Postgresql and I need to turn off the AUTO COMMIT in PostgreSQL 8.3.Can anyone guide me how to do it as SET AUTOCOMMIT = off; does not seem to be supported any more in PostgreSQL 8.3. Many thanks for help!

[GENERAL] Setting global parameter in Postgres 8.3

Hi All, Is there any way we can set the global parameter in Postgres 8.3? As I have a sql script which need to accept some parameter at run time. For example I have sql script for creating tablespaces called "create_tablespace.sql" Inside the sql script I have the following statements

[GENERAL] Too many postgres.exe

Hi All, I have my application UI in Java and which is communicating with Postgresql database. However whenever my application is running I could see there are too many postgres.exe are created even though the application is not doing anything in database. In general the observation is tha

[GENERAL] Postgres.exe Process taking too much memory and CPU usage - making the system extremely slow.

Hi All. I have a program which import some 6000-1 records in Postgres database. However the import of data is successful but the postgres.exe almost takes up entire memory and CPU. I could see in the process list there are lot of postgres.exe are running and one of the postgres.exe has

[GENERAL] Auto Vacuum Daemon

Hello All, I am using Postgres 8.3.5 on windows and was using manually VACCUM and ANALYZE commands in my scripts but now I have turned on the AutoVaccum daemon by changing the postgresql conf file. Is it fine to do that or should we manually perform vacuum and analyze. Will it automaticall

[GENERAL] WARNING: worker took too long to start; cancelled on VACCUM ANALYZE

Hi All, I am facing the below error when executing "VACCUM ANALYZE" on the several tables and also the entire PostgreSQL database hanging up and not responding. WARNING: worker took too long to start; cancelled I have disabled my AV and I have the modified the below parameters in my postgresq

[GENERAL] Error on VACCUM ANALYZE

Hi All, I am facing the below error when executing "VACCUM ANALYZE" on the several tables and also the entire PostgreSQL database hanging up and not responding. WARNING: worker took too long to start; cancelled I am using PostgreSQL 8.3.5 on windows 32 bit machine. Any help would be h

[GENERAL] Error in Loading DLL using Postgres function

Hi All, I am trying to load a dll using the Postgres function but whenever I am calling it is giving me the below error message. I am using Win32 machine and compiled and created the dll using MSVC2005. ERROR: could not load library "C:/Program Files/PostgreSQL/8.3/lib/watchlist.dll": This

[GENERAL] PostgreSQL for 64 Bit Windows Version

Hello All, Can anybody help me on downloading 64 bit version of PostgreSQL for Windows environment? Do PostgreSQL for windows version supports 64 bit version? Many thanks

[GENERAL] PostgreSQL function can not load dll library.

Hi All, I am creating a dll using MSVC 2005 and trying to call the dll from my Postgres function but unfortunately PostgreSQL is throwing an error message saying: ERROR: could not load library "C:/Program Files/PostgreSQL/8.3/lib/watchlist.dll": The specified module could not be found. SQL

[GENERAL] Problem calling C function in PostgreSQL

Hi, I am new to PostgreSQL and could anyone please suggest me any windows based C compiler which will successfully create a dll on windows and which can be callable by PostgreSQL. I am facing a problem with the below code compiled and created dll in MSVC 2005. __

[GENERAL] Incompatible library : Missing Magic Block

Hi, I am trying to code Postgres external C function in windows XP and am using Postgres 8.3 version. However I have included all the required things in the code to run (Please find below the example code which I am compiling using MSVC and generating the dll) __

[GENERAL] FW: Incompatible library : Missing Magic Block

One more thing to add here...I am using the Postgres 8.3.7 headers to compile my program and have added PG_MODULE_MAGIC but still error is persisting. From: Bhattacharya, A Sent: Thursday, October 22, 2009 10:46 AM To: 'pgsql-general@postgresql.org' Subj

[GENERAL] Incompatible library : Missing Magic Block

Hi, I am trying to write a C function (using Postgres external methods) in windows XP and am using Postgres 8.3.7 version and creating a dll using Microsoft Visual Studio 2005. However I have included all the required headers and PG_MODULE_MAGIC in my code. (Please find below the example code