[GENERAL] autovacuum log?

Hello, when I put the autovacuum on, where can I check what it does? Is there any log-file? Regards Michaela

[GENERAL] max_connections (postgresql.conf)

Hello, we are using SCO OpenServer6 and Postgresql 8.1.4. We increased the parameter max_connections in the postgresql.conf to 300. In Section 16.4.1 of the dokumentation we try to find out how to adjust depending parameters. But we can't figure it out. What would be reasonable values for the

Re: [GENERAL] WARNING: some databases have not been vacuumed in 1953945422 transactions

1.074.758.205 2 db2 1.074.728.832 3 template1 1.074.728.720 4 template0 1.978.965.587 Regards Michaela - Original Message - From: "Albe Laurenz" <[EMAIL PROTECTED]> To: "MG *EXTERN*" <[EMAIL PROTECTED]> Cc: Sent: Monday, February 19, 20

Re: [GENERAL] pg_dump: [tar archiver] write error appending to tar archive

Where do I find the man page. Regards Michaela - Original Message - From: "Tom Lane" <[EMAIL PROTECTED]> To: "MG" <[EMAIL PROTECTED]> Sent: Tuesday, February 13, 2007 3:46 PM Subject: Re: [GENERAL] pg_dump: [tar archiver] write error appending

Re: [GENERAL] WARNING: some databases have not been vacuumed in 1953945422 transactions

Hello Tom, thanks for your answer. But I don't understand why there are changes of the databases template1 and template0 at all? I thought they are only templates. Regards Michaela - Original Message - From: "Tom Lane" <[EMAIL PROTECTED]> To: "MG"

[GENERAL] WARNING: some databases have not been vacuumed in 1953945422 transactions

Hello, we are using PostgreSQL 8.0.3 and have two databases in one cluster. db1 and db2. Each night a shell script is being executed. vacuumdb --analyze -U cmduser db1 vacuumdb --analyze -U cmduser db2 The last weeks the following warnings are given out: WARNING: some databases have not been v

[GENERAL] pg_dump: [tar archiver] write error appending to tar archive

Hello, we have a shell-script, which executes the pg_dump once a day. This script ran already for about 6 months successfully. Now we got the following error: pg_dump: [tar archiver] write error appending to tar archive (wrote 28186, attempted 32767) There is enough space on the hard disk. A

[GENERAL] RAID + PostgreSQL?

Hello,   we are using PostgreSQL 8.0.3 together with RAID on OpenServer 6.   When we do a big SELECT-query the whole maschine becomes very very very slowly or stands. The maschine has 3 GB RAM, so we suppose it`s the RAID.   Has anyone some experience with RAID + PostgreSQL?   Where does Postgr

Fw: [GENERAL] Performance UPDATE/INSERT

ance UPDATE/INSERT am 11.04.2006, um 11:32:55 +0200 mailte MG folgendes: I can`t use COPY for INSERTs, because I have to manipulate each record indiviuell. But the problem is the UPDATEs test=# \timing Timing is on. test=# update mira set y = 123; UPDATE 15 Time: 1874.894 ms 150 00

Re: [GENERAL] Performance UPDATE/INSERT

pril 11, 2006 11:30 AM Subject: Re: [GENERAL] Performance UPDATE/INSERT Hi, On Tuesday 11 April 2006 11:08, MG wrote: | I have about 100 000 records, which need about 30 minutes to write them | with single INSERTs into PostgreSQL. If I go through these 100 000 records | and make an UPDATE on

Re: [GENERAL] Performance UPDATE/INSERT

rformance UPDATE/INSERT am 11.04.2006, um 11:08:57 +0200 mailte MG folgendes: Hello, I have about 100 000 records, which need about 30 minutes to write them with single INSERTs into PostgreSQL. You should better use the COPY - command for bulk inserts. This is faster. HTH, Andreas -- An

[GENERAL] Performance UPDATE/INSERT

Hello,   I have about 100 000 records, which need about 30 minutes to write them with single INSERTs into PostgreSQL. If I go through these 100 000 records and make an UPDATE on each record, it takes 1 hour.   Can anyone tell me, about his experience of the performance of INSERT and UPDATE.  

[GENERAL] actual SQL statement

Hello,   can I find out, what SQL statement the PostgreSQL-server is executing?   Thanks Michaela    

[GENERAL] LIMIT + OFFSET

Hello,   I want to show an overview where you can place 16 data sets. I use the sql-statement SELECT F1,F2 FROM testtable limit 16 offset 0   To show different pages I vary the value for offset.   But if I want to stay on a special data set, I have the problem to find the right value for offset

[GENERAL] Sequence Manipulation Functions

Hello,   I use PostgreSQL 8.0.3.   I want to get the information of the last value of a sequence.   The function 'currval' only gives the value back, if before a nextval is executed. Return the value most recently obtained by nextval for this sequence in the current session. (An error is repo

[GENERAL] Re: Error: 'cache lookup failed' w/trigger

Meanwhile, I've found the source of my problem myself. When I drop a function and re-create it (this is what phpPgAdmin does when "modifying" a function), I also have to drop and re-create the corresponding trigger. Again one of these 'gotchas' for beginners... mg schri

[GENERAL] Error: 'cache lookup failed' w/trigger

Hello, I'm new to Postgresql and just tried to write my very first pgsql trigger procedure. So please forgive me if this is a stupid question. This is what I did: 1. using bash as user postgres (my db superuser) on my RH6.2 linux box: bash$ export PGLIB=/usr/lib/pgsql bash$ createlang plpgsql my