From: | Sean Davis <sdavis2(at)mail(dot)nih(dot)gov> |
---|---|
To: | kulmacet101(at)kulmacet(dot)com |
Cc: | pgsql <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Creating a test database and table |
Date: | 2009-02-09 13:01:23 |
Message-ID: | 264855a00902090501y3b0077f7v896c39ec308952af@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On Mon, Feb 9, 2009 at 7:47 AM, <kulmacet101(at)kulmacet(dot)com> wrote:
> 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)
>
>
So, Postgresql has read some information into cache.
As Ries points out, running under VMWare will probably not be as fast as
running on a native system.
Sean
>
> > On Mon, Feb 9, 2009 at 7:23 AM, <kulmacet101(at)kulmacet(dot)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
> >
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | salmonix | 2009-02-09 13:06:19 | Exporting tables/views |
Previous Message | ries van Twisk | 2009-02-09 12:51:23 | Re: Creating a test database and table |