Alex Hochberger wrote:
Does anyone have any white papers or basic guides for a large RAM server?
We are consolidating two databases to enable better data-mining that
currently run on a 4 GB and 2 GB machine. The data issues on the 4 GB
machine are numerous, things like "create index" fail and update queries
fail from out of memory issues.
Problem Usage: we have a 20GB table with 120m rows that we are
splitting into some sub-tables. Generally, we do large data pulls from
here, 1 million - 4 million records at a time, stored in a new table for
export. These queries are problematic because we are unable to index
the database for the queries that we run because we get out of memory
errors.
Would it not make sense to find out why you are getting these errors first?
It's not normal to get "out of memory" when rebuilding an index.
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
