[ADMIN] Index Existence

2002-03-29 Thread Herb Blacker
Is there a shell script (or a call to a function) available to check the existence of an index before it is dropped? I'm reloading a set of tables, and I want to drop the index before the COPY, then recreate it. _ Herb Blacker Database Administrator ReCare, Inc. [

[ADMIN] Multi-threading

2002-03-13 Thread Herb Blacker
Will PG handle multi-threading if your box has multiple CPU's? If so, does it do this automatically...or do I need to set some parameter? Also, all my WAL stuff in postgresql.conf is commented...should I open it up, and if so, which lines? TIA, _ Herb Blacker Dat

[ADMIN] Checking Existence

2002-03-06 Thread Herb Blacker
Is there a shell script (or a call to a function) available to check the existence of an index before it is dropped? I'm reloading a set of tables, and I want to drop the index before the COPY, then recreate it. _ Herb Blacker Database Administrator ReCare, Inc. [