Re: [ADMIN] Allowing TCP/IP connections

2001-12-31 Thread Tony Reina
Marc <[EMAIL PROTECTED]> wrote in message news:<[EMAIL PROTECTED]>... > In the postgres configuration file, which options do I have to enable to > allow TCP/IP connections: > > # > # Connection Parameters > # > #tcpip_socket = false > #ssl = false > > #max_connections = 32 # 1-1024 > > #

[ADMIN] VACUUM question, OID range

2001-12-31 Thread Bob Smith, Hammett & Edison, Inc.
I have a db which has many tables that are mirrors of data from an outside source. I download text export files and do weekly updates of the entire tables using TRUNCATE and COPY. Is there any benefit to a VACUUM ANALYZE immediately afterwards? There are a number of indices on these tables. D