Your message was dropped into my Spam lable :S
2011/3/30 Strange, John W john.w.stra...@jpmchase.com:
Just some information on our setup:
- HP DL585 G6
- 4 x AMD Opteron 8435 (24 cores)
- 256GB RAM
- 2 FusionIO 640GB PCI-SSD (RAID0)
- dual 10GB ethernet.
- we have several tables that we
Jeremy,
Does table_revision have a unique index on id? Also, I doubt these two indexes
ever get used:
CREATE INDEX idx_crs_action_expired_created
ON table_version.bde_crs_action_revision
USING btree
(_revision_expired, _revision_created);
CREATE INDEX idx_crs_action_expired_key
ON
But you are using stdin for COPY! The best way is use files.
I've never heard this before, and I don't see how reading from files
could possibly help. Can you clarify?
---
Maciek Sakrejda | System Architect | Truviso
1065 E. Hillsdale Blvd., Suite 215
Foster City, CA 94404
(650) 242-3500 Main
On Sat, Mar 5, 2011 at 7:34 PM, marcin mank marcin.m...@gmail.com wrote:
Is this fast enough on a slave:
with deltas as (select * from get_delta_table(...)),
p95 as(select round(count(volume_id) * 0.95) as p95v from deltas)
select
(select in_rate from deltas, p95 where
in_rate_order =
Hi Bob,
The table_version.revision (revision is the same) table has a primary key
on id because of the PK revision_pkey. Actually at the moment there are only
two rows in the table table_version.revision!
Thanks for the tips about the indexes. I'm still in the development and tuning
process,