Re: Creating a test database and table

I created 2 more tables with the same script just changing the table names
the results are:

movies1: Query OK, 0 rows affected (934 ms)
movies2: Query OK, 0 rows affected (110 ms)

> On Mon, Feb 9, 2009 at 7:23 AM, <kulmacet101@kulmacet.com> wrote:
>
>> All,
>>
>> I was creating a simple database for testing, as I created this table
>> here
>> is the response I got from the DB:
>>
>> NOTICE:  CREATE TABLE will create implicit sequence
>> "movies_movie_id_seq"
>> for serial column "movies.movie_id"
>> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
>> "movies_pkey" for table "movies"
>>
>>
>> Query OK, 0 rows affected (1.391 sec)
>>
>> Here is the script I ran:
>>
>> create table movies (
>>    movie_id    serial          not null,
>>    title       varchar(255)    not null,
>>    ranking     int,
>>
>>    primary key (movie_id)
>> );
>>
>> I am the only one accessing this server and DB. This table creation
>> seems
>> slow. The server is running on VMWare and has about 1GB of memory but
>> this
>> time for table creation seems slow. I am relatively new to Postgres and
>> was wondering if there is a setting or adjustment that can be done to
>> speed this up or is the time for this process about right. My thoughts
>> are
>> that an out of the box install should be sufficient but I think more
>> adjustment is required.
>>
>> Any thoughts or opinions appreciated.
>>
>
> Hi, Kulmacet.  If you create a second table, what is the time to do so for
> it?
>
> Sean
>