On Sep 20, 2010, at 2:12 PM, Dave Page wrote: On Mon, Sep 20, 2010 at 7:06 PM, Aram Fingal <fingal@xxxxxxxxxxxxxxxxxx> wrote:I'm using the OS X precompiled binary from EnterpriseDB and want to add the tablefunc contrib module. I haven't been able to find any documentation about how to do this or even whether modules can be added to this binary version. So that means something like: psql -d dbname -f /Library/PostgreSQL/8.4/share/postgresql/contrib/tablefunc.sql I suppose that it may be a good idea to export my databases and compile from source anyway. I see that Postgres is running as a 32-bit application while I have a 64-bit machine and OS (OS X, Snow Leopard.) I suppose that I will have to export and re-import the databases when I upgrade? That may be worth it but I'll do it later. I do have some some very intensive queries, which take a long time to run, but I gather (from Tom Lane's comment) that switching to 64-bit will only help if the query would benefit from utilizing large amounts of RAM (like more than 2GB?) A single query will still run on a single processor core. I do have 8GB RAM in the machine but my databases are just not that big. -Aram |
