from:"Christophe Combet \[PBIL\/IBCP\/CNRS\]"

[GENERAL] Postgresql 7.4.3/8.2.4 out of memory

2007-06-07 Thread Christophe Combet [PBIL/IBCP/CNRS]

Dear all, With the below transaction we got an out of memory error. BEGIN; ANALYZE referenceAuthorLnkTemp; INSERT INTO referenceAuthor (author) SELECT DISTINCT ON (author) author FROM referenceAuthorLnkTemp; ANALYZE referenceAuthor; UPDATE referenceAuthorLnkTemp SET

[GENERAL] Postgresql 7.4.3/8.2.4 out of memory

2007-06-06 Thread Christophe Combet PBIL/IBCP/CNRS

Dear all, With the below transaction we got an out of memory error. BEGIN; ANALYZE referenceAuthorLnkTemp; INSERT INTO referenceAuthor (author) SELECT DISTINCT ON (author) author FROM referenceAuthorLnkTemp; ANALYZE referenceAuthor; UPDATE referenceAuthorLnkTemp SET