Re: SELECT performance problem on a join

From: Patrice Espié <patrice(dot)espie(at)free(dot)fr>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Re: SELECT performance problem on a join
Date: 2001-05-02 08:08:51
Message-ID: 010401c0d2df$20c0a550$0400a8c0@univlyon2.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

>> > 2) Have you 'VACUUM ANALYZE t_test' and 'VACUUM ANALYZE doc' yet?
>> >Try #2, it should help you quite a bit.
>> I jsut did it : it said : VACUUM. Nothing else. This doesn't help me,
realy
>> ! ;)
>Have you tried your query since you VACUUM'ed?
>It helps a lot more than you would think.

Done. The problem has disapeared !!
Any explanation ?

Thank's a lot
Patrice

Browse pgsql-novice by date

  From Date Subject
Next Message suhail sarwar 2001-05-02 11:44:59 Passing values from an applet to a main method for JDBC
Previous Message Albert REINER 2001-05-01 19:07:06 pl/pgSQL: locale and ~ '[a-z]'