Re: psql is very slow

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
>>
>>
>>