Tom,
We can give you access to the machine Tom. We need to know what sort of
access you require. Since I don't have the ability to correspond with
you via email due to the earthlink filter you have on could you send me
another email address privately or a phone number or smoke signal so we
c
Tom,
As you can see I had to reduce the number of arguments in the IN clause
to even get the explain.
explain update f_commerce_impressions set servlet_key = 60 where
servlet_key in (68,69,70,71,87,90,94);
Sean Shanny <[EMAIL PROTECTED]> writes:
> There are no FK's or triggers on this or any of the tables in our
> warehouse schema. Also I should have mentioned that this update will
> produce 0 rows as these values do not exist in this table.
Hm, that makes no sense at all ...
> Here is output fr
Tom,
There are no FK's or triggers on this or any of the tables in our
warehouse schema. Also I should have mentioned that this update will
produce 0 rows as these values do not exist in this table. We have a
dimension table named d_servlet that holds servlet names and id's.
This table is
Sean Shanny <[EMAIL PROTECTED]> writes:
> update f_commerce_impressions set servlet_key = 60 where servlet_key in
> (68,69,70,71,87,90,94,91,98,105,106);
> ERROR: out of memory
How many rows will this try to update? Do you have any triggers or
foreign keys in this table? I'm wondering if the l
To all,
The facts:
PostgreSQL 7.4.0 running on BSD 5.1 on Dell 2650 with 4GB RAM, 5 SCSI
drives in hardware RAID 0 configuration. Database size with indexes is
currently 122GB. Schema for the table in question is at the end of this
email. The DB has been vacuumed full and analyzed. Between
