[GENERAL] lo data type

2008-11-20 Thread John Zhang
Hi there, I am writing to seek your assistance on how to set up the lo data type for large objects. I am using postres 3.3. By default, the data type lo is not created by the installation, right? How to create one? Any input would be much appreciated. Thanks. John

[GENERAL] Fwd: Performance Tuning

2008-11-17 Thread John Zhang
Hi the list, I have a performance problem and would like to any input on how to make it perform as desired. In the DB, there are a few tables over 3 million records in postgis. When I do some operation on the tables, e.g. CREATE INDEX, it takes hours without results. I believe there must be someth