Re: [GENERAL] could not reattach to shared memory

Sorry, for the unfinished text, So, I run a long transaction with a lot of data, and after a while I got the messages: NOTICE: max_fsm_relations(1000) equals the number of relations checked HINT: You have at least 1000 relations. Consider increasing the configuration parameter

[GENERAL] could not reattach to shared memory

Hi there, I run a long transaction with a lot of data, and after a while I got the messages: -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] out of shared memory - find temporary tables

Hi there, I got out of shared memory error. Searching on postgresql forums, I found this it occurs probably because of intensive use of temporary tables in one transaction. I'm locking in pg_locks table, and I found some rows with the following modes: ShareLock, AccessExclusiveLock,

[GENERAL] repeated log $libdir/plugins/plugin_debugger.dll

Hi there, I have PostgreSQL 8.3.5, compiled by Visual C++ build 1400 installed on Windows XP. The log files contain the following repeated message: db=, user= LOG: loaded library $libdir/plugins/plugin_debugger.dll Unfortunately it fills a lot of my log file. Please tell me how to remove it

[GENERAL] remove log header

Hi there, On Windows, I run a script batch file with psql, and I get any log line with the following pattern: psql://path_file_name:4: NOTICE: log_message I'd like to remove the log header before NOTICE. What should I do ? Thanks, Sabin -- Sent via pgsql-general mailing list

Re: [GENERAL] COPY problem on -- strings

Is that the *first* error message you got? Yes it is. In fact I made a mistake in the first email, so instead: INSERT INTO A ( Col1, Col2 ) VALUES (2, '-- any text' ); please change with: INSERT INTO A ( Col1, Col2 ) VALUES (1, '-- any text' ); However I

[GENERAL] hidden errors calling a volatile function inside a stable function

Hi, I have PostgreSQL 8.2.4 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2 (mingw-special) on Windows OS , but I experienced the same problem on PostgreSQL 8.3.5, compiled by Visual C++ build 1400 too. I attach the demo database here, to be available to test according with the

Re: [GENERAL] COPY problem on -- strings

Sorry, my fault that I run the script in the query window of pgAdmin, not in the system console. I check it again in the system console and it works well. Thanks, Sabin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription:

[GENERAL] on error logs the whole multiline script

Hi, I have PostgreSQL 8.3.5, compiled by Visual C++ build 1400, and I found when I run a script and an error occurs, all the script content is logged. My previous postgres version PostgreSQL 8.2.4 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2 (mingw-special) logged just the function

[GENERAL] COPY problem on -- strings

Hi, I have PostgreSQL 8.3.5, compiled by Visual C++ build 1400 on Windows OS. I try to use the COPY command to optimize the backup/restore performance, but I found a problem. I reproduce it below. I create a database with a simple table: CREATE TABLE A ( Col1 integer NOT NULL, Col2

[GENERAL] statements of an unfinished transaction

Hi there, I'd like to find the sessions that provide unclosed transactions (i.e. marked as IDLE in transaction). Is any way to find the SQL statements that belong to such a transaction, or the transaction time start, or any other helpful data ? TIA, Sabin ---(end

Re: [GENERAL] memory optimization

So, what is better from the postgres memory point of view: to use temporary objects, or to use common variables ? A temp table might take *slightly* more room than variables... Can you suggest me other point of views to be taken into consideration in my case ? Code maintenance. I can't

[GENERAL] memory optimization

Hi there, I have a procedure which uses temporary objects (table and sequence). I tried to optimize it, using common variables (array and long varchar) instead. I didn't found any difference in performance, but I'd like to choose the best option from other points of view. One of them is the

[GENERAL] statistics on CRUD operations

Hi there, Is somewhere a system table providing statistic counters of CRUD operations against custom databases ? TIA, Sabin ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] statistics on CRUD operations

Simon Riggs [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] On Mon, 2007-06-18 at 12:35 +0300, Sabin Coanda wrote: Is somewhere a system table providing statistic counters of CRUD operations against custom databases ? pg_stat_user_tables http://www.postgresql.org/docs/8.2