Re: [ADMIN] Memory exhausted in AllocSetAlloc

2004-09-11 Thread Tom Lane
"C. Bensend" <[EMAIL PROTECTED]> writes: >I understand what happened, but not exactly why - this machine is > running with over 300M of RAM unused. Bumping this value down to 16M > works fine. But why does it hit a memory exhausted error at 64M? Maybe it's exceeding a ulimit setting? You mi

[ADMIN] Memory exhausted in AllocSetAlloc

2004-09-11 Thread C. Bensend
Hey folks, I'm running 7.3.5 on an OpenBSD 3.5-STABLE machine, with 512M of RAM. I'm running VACUUM ANALYZE every hour, with a VACUUM FULL once per night before backups. I'm trying to speed up the VACCUMs, so I tried bumping up vacuum_mem in postgresql.conf from the default to 64M. This r

Re: [ADMIN] Binding Parameters

2004-09-11 Thread Postgres User
Do you mean PREPARE / EXECUTE? /* [EMAIL PROTECTED]:5432/ahammond =# */ \d foo ~ Table "public.foo" ~ Column | Type | Modifiers - +-+-- ~ foo_id | integer | not null default nextval('foo_id_seq'::

Re: [ADMIN] Binding Parameters

2004-09-11 Thread Andrew Hammond
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Postgres User wrote: | I'm new to PostgreSQL, and am wondering for BindSQL is intergrated in | Postgres or in the future for version 8. | | Example: | | SELECT * FROM sample_table WHERE computer = :1; | | Any pointers will help. Do you mean PREPARE / EX