Re: [PERFORM] Very poor read performance, query independent

2017-07-20 Thread Charles Nadeau
Mark, I received yesterday a second server having 16 drives bays. Just for a quick trial, I used 2 old 60GB SSD (a Kingston V300 and a ADATA SP900) to build a RAID0. To my surprise, my very pecky RAID controller (HP P410i) recognised them without a fuss (although as SATAII drives at 3Gb/s. A quick

Re: [PERFORM] CREATE EXTENSION postgis;

2017-07-20 Thread Florent Guillaume
Hi, Please use the proper list, your question is not appropriate for this list which is about PostgreSQL performance. Florent On Thu, Jul 20, 2017 at 11:05 AM, Daulat Ram wrote: > Hi team, > > > > Is this possible to create the postgis extension by *CREATE EXTENSION > postgis;* in PostgreSQL

[PERFORM] CREATE EXTENSION postgis;

2017-07-20 Thread Daulat Ram
Hi team, Is this possible to create the postgis extension by CREATE EXTENSION postgis; in PostgreSQL 9.1 As I know the template_postgis database is created by default during postgis installation to support the spatial objects. I am getting below the error messages while creating postgis exten