Re: psql is very slow

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.merta@gmail.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@mail.nih.gov> wrote:
> >>
> >>
> >>
> >>
> >> On 2/22/06 10:23 AM, "Michal Merta" <michal.merta@gmail.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