x27;d know more about the setup.
hth,
Patric
Vitalii Tymchyshyn schrieb am 06.06.2012 14:25:
> Hello.
>
> Seen this already. It looks like cross join + sort. Badly configured ORM
> tools like Hibernate
> with multiple one-to-many relationships fetched with 'join' strat
I'm looking for something like UPDATE X set StoreY=(SELECT * FROM Y
WHERE pk=4) WHERE foreignID2Y = 4;
Is there a away to accomplish this straightforward in a single
statement without doing loops and stuff in a serverside procedure?
Thanks in advance
e
predicate for indices not
layed out for such a usage?
(PS: Don't want partition with method postgres offers..)
thanks in advance,
patric
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore you
60 gigabyte of diskspace. Now after a fresh import it only
has 5 gigabyte!
No wonder, I got IO problems with such a fragmentation.
For people not very familiar with postgres especially those coming
from mysql,
i'd recommend paying attention to this.
regard
Ok thanks.
iostat confirmed it's an IO bottleneck.
Will add some discs to the RAID unit.
Used 4 Raptor discs in Raid 10 until now.
best regards,
patric
Tom Lane wrote:
Patric de Waha <[EMAIL PROTECTED]> writes:
Postgres is running on a dedicated server P4 DualCore
any suggestions.
Patric
My Setup:
Debian Etch
PSQL: 8.1.4
WAL files are located on another disc than the dbase itself.
max_connections = 190
shared_buffers = 3
temp_buffers = 3000
work_mem = 4096
maintenance_work_mem = 16384
Hi,
I've dbase with about 80 relations.
On deleting a user, this cascades through all the tables.
This is very slow, for 20 users it takes 4 hours, with exclusive
access to the dbase.
No other users connected to the dbase.
Ok I know there will be somewhere a relation with a FK wi
