Re: psql is slow and it does not take much resources

It is inserts.

I create the inserts myself with a Python programmed I hace created to
migrate MySQL databases to PostgreSQL (by th way if someone wants
it...)

Thanks.

Javier.



On 5/3/06, Larry Rosenman <lrosenman@pervasive.com> wrote:
> Javier de la Torre wrote:
> > Hi all,
> >
> > I've been searching around for an answer to this, but I coulnd't find
> > anything. So here we go.
> >
> > I am running PostgreSQL 8.1.3 on Red Hat on an Intel server with 2GB
> > of RAM and lot of free HD space.
> >
> > I have a very large dump file, more then 4GB, to recreate a database.
> > When I run:
> >
> > psql -Uuser -q -dmydatabase <mydump.sql &
> >
> > It works, but is slow, it inserts about 1.000 record in 10 seconds.
> > But the curious thing is that if I check the resources of the server
> > it seems that psql is not using them much. "top" says that postgres is
> > using around 2% of the processor and psql around 1% so that server is
> > only 3% used. "top" also says that more or less 48% idle and
> > 50%waiting...
> >
> > In the other hand the memory seems to be very high...
> >
> > What could be the problem? Is that the server is just slow reading
> > from the file? It has a 300GB SCSI drive.
> >
> > Is there any way to make this work faster? I would like to recreate
> > the db at least once a month, but this taked too much time...
> >
> > Thanks in advance for any advice.
> >
> > Javier.
> >
> How is the MyDump created?  is it inserts? Or copy's?
>
>
>
> --
> Larry Rosenman
> Database Support Engineer
>
> PERVASIVE SOFTWARE. INC.
> 12365B RIATA TRACE PKWY
> 3015
> AUSTIN TX  78727-6531
>
> Tel: 512.231.6173
> Fax: 512.231.6597
> Email: Larry.Rosenman@pervasive.com
> Web: www.pervasive.com
>