Hello,
when I put the autovacuum on, where can I check what it does? Is there any
log-file?
Regards
Michaela
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
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 to tar
archive
MG [EMAIL PROTECTED] writes
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: pgsql-general@postgresql.org
Sent: Monday, February 19, 2007 9:41 AM
Subject
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 [EMAIL PROTECTED]
Cc: pgsql-general
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
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.
Hello,
we are using PostgreSQL 8.0.3 together with RAID on OpenServer 6.
When we do abig SELECT-query the whole maschine becomes very very
very slowly or stands.
The maschine has 3 GB RAM, so wesuppose it`s the RAID.
Has anyone some experience with RAID + PostgreSQL?
Where does PostgreSQL
Hello,
I have about 100 000 records, which need about 30 minutes to write them
with singleINSERTs 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] Performance 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
: Tuesday, April 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
/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 000 Records
Hello,
can I find out, what SQL statement the PostgreSQL-server is
executing?
Thanks
Michaela
Hello,
I want to show an overview where you can place 16 data sets.
I use the sql-statement
SELECTF1,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.
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
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
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 schrieb:
Hello,
17 matches
Mail list logo