Hi,
I have a primary server (9.1), which does wal archiving like this:
wal_level = hot_standby
archive_mode = on
archive_command = 'test ! -f /home/autobackup/wal/%f && cp %p
/home/autobackup/wal/%f'
then I have a warm standby with this configuration in recovery.conf:
restore_command = 'c
Hi,
I need a little help with a deadlock.
when I execute this (end of the mail) function in parallel sometimes a deadlock
happens.
This function does implement a insert or update functionality.
The error is:
"DETAIL: Process 29464 waits for ShareLock on transaction 1293098; blocked by
proces
Hi,
some days ago I removed all foreign keys from the database to speed up
an import.
Now I tried to create the keys again but it says:
ALTER TABLE ONLY xxx ADD CONSTRAINT y FOREIGN KEY (zz)
REFERENCES aaa(bb) ON UPDATE CASCADE;
ERROR: constraint "yyy" for
Hi,
I consider buying one of these Intel SSDs for my Database (MLC).
I have a few questions regarding this, maybe some of you already have
some experience with that.
- which files should not be put onto the SSD (pg_clog ? pg_xlog ? ) to
reduce wear (which may be an issue with the MLC varia
description below, but I don't completely understand the
difference.
I want to plot a realtime graph: "tuples read from buffers or disk"
is it both combined ?
Thanks
Sebastian
Am 15.12.2008 um 04:28 schrieb Gregory Stark:
Sebastian Böhm writes:
one question:
what actually
Hi,
one question:
what actually is tup_returned and tup_fetched ?
read from disc before scans and before aggregate ?
thanks
sebastian
Hi,
I have a table with a lot of columns (text and integer).
It currently has 3Mio Rows.
Updating a column in all rows (integer) takes endless (days).
The column I update is not indexed.
How can I tune postgres to do this much more quickly?
VMstat looks like this:
r b swpd free buff
