Re: [PERFORM] How to reduce writing on disk ? (90 gb on pgsql_tmp)

SQLSTATE[53100]: Disk full: 7 ERROR: could not write block 1099247 of temporary file Its looks like there is no room to write temporary file, try with limiting temporary file size by setting temp_file_limit GUC. -- View this message in context: http://postgresql.nabble.com/How-to-reduce-writ

Re: [PERFORM] Workaround for working_mem max value in windows?

>Anyone found a work around? Wouldn't it helpful, setting it in your session? set work_mem='2000MB'; set maintenance_work_mem='2000MB'; do rest of sql after . Regards, Amul Sul -- View this message in context: http://postgresql.1045698.n5.nabble.com/Workaround-for-working-mem-max-value

Re: [PERFORM] DBT5 execution failed due to undefined symbol: PQescapeLiteral

Hi Laurenz Albe , Thanks for reply. Your guess was correct :). It worked for me exporting LD_LIBRARY_PATH to postgres9.2 lib directory. Thanks again for your help. Regards, Amul Sul -- View this message in context: http://postgresql.1045698.n5.nabble.com/DBT5-execution-failed-due-to-unde