Re: psql is very slow

From: Patrick Meylemans <Patrick(dot)Meylemans(at)wtcm(dot)be>
To: Sean Davis <sdavis2(at)mail(dot)nih(dot)gov>, Michal Merta <michal(dot)merta(at)gmail(dot)com>, PostgreSQL Novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: psql is very slow
Date: 2006-03-08 21:43:02
Message-ID: 6.0.1.1.0.20060308224220.01ac5ec0@server04.site04.wtcm.be
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Dear,

#vacuumdb -f -z dbname

Then test again, you will be surprized !

Kind Regards

Patrick

At 22:06 8/03/2006, Sean Davis wrote:
>Michal,
>
>I have no idea what is in the base directory. Perhaps some of the more
>experienced users on the list can enlighten us.
>
>What I meant about being specific was showing what it was that was slow and
>the commands that you were using to produce those results. The databases
>that we use are on the order of several Gb, so 100Mb isn't that big.
>
>One thing you should definitely consider doing is to upgrade to a newer
>version of postgresql.
>
>Sean
>
>On 3/8/06 10:10 AM, "Michal Merta" <michal(dot)merta(at)gmail(dot)com> wrote:
>
> > Hi Sean,
> > yes, you're right, i was thinking about postgresql.
> > But, now i can see somethink like:
> >
> > cztn base # du -sm /home/postgres/*
> > 1 /home/postgres/PG_VERSION
> > 2779 /home/postgres/base
> > 1 /home/postgres/global
> > 1 /home/postgres/pg_clog
> > 1 /home/postgres/pg_hba.conf
> > 1 /home/postgres/pg_ident.conf
> > 129 /home/postgres/pg_xlog
> > 1 /home/postgres/postgresql.conf
> > 21 /home/postgres/postgresql.log
> > 105 /home/postgres/postgresql.log.old
> > 1 /home/postgres/postmaster.opts
> > 1 /home/postgres/postmaster.pid
> > cztn base #
> >
> > Is this normal? Almost 3gigabytes in base directory?
> >
> > cztn base # ls /home/postgres/base
> > 1 16975 19932600 20370917
> > cztn base #
> >
> > Thanks,
> > Michal
> >
> > On 2/24/06, Sean Davis <sdavis2(at)mail(dot)nih(dot)gov> wrote:
> >>
> >>
> >>
> >>
> >> On 2/22/06 10:23 AM, "Michal Merta" <michal(dot)merta(at)gmail(dot)com> wrote:
> >>
> >>> I have a psql 7.3.4, apache 2.0.40, perl v5.8.0. Database is pretty
> >> big,
> >>> (dump is about 100Megs).
> >>> But all the operations are very, very slow.
> >>> Is any possibility to make postgresql more quick? (don't tell me to cut
> >> the
> >>> database :))
> >>
> >> I assume that by "psql" you mean postgresql?
> >>
> >> You'll probably have to be more specific about what you are doing, what
> >> your
> >> database is like and how it is used, what you want to change, and what
> >> kinds
> >> of time you are talking about.
> >>
> >> Sean
> >>
> >>
> >>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 2: Don't 'kill -9' the postmaster

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Michael Fuhr 2006-03-08 23:17:41 Re: Invalid Page Header
Previous Message Sean Davis 2006-03-08 21:06:13 Re: psql is very slow