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

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



---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings