Re: 7.3.2 : poor performance for me :-(

Well, I answer myself to my mprevious message !

It "seems" it's better with a 7.3.2 client.

If someone has a clue to optimize performance, thanks !

Our DB size id about 340 Mo

Largest table has 400K tuples.

We often have 3 or 4 updates in the same time on this tables, and selects in
the same time.

It runs on a P4 1.8G, with 1Go RAM, SCSI Disks

Postgres options are :

-B60564 -N255 -S131072

seqscan is off

Wal_buffers = 2048

We do a vaccum every 6 hours and a vaccum -f once or twice a week.

jean-arthur

On 18 Mar 2003 at 21:38, jeanarthur(at)eurovox(dot)fr wrote:

> hi !
>
> I used postgres 7.2 before on a server A.
>
> Accesses are made by another machine (B) via PHP
>
>
> Client on server B is from a 7.0 release.
>
> when it was a 7.2 on the DB machine, everything was ok.
>
> Now, with a 7.3.2, access are very slow (updates and select).
>
> Do you think it is possible it is because I use 7.0 libs with PHP on server B
> ??
>
> Thanks for your help !
>
>
> Jean-Arthur Silve
> EuroVox
> 4, Place Félix Eboué
> 75583 Paris Cedex 12
> T : +33 1 44670505
> F : +33 1 44670519
>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org

Jean-Arthur Silve
EuroVox
4, Place Félix Eboué
75583 Paris Cedex 12
T : +33 1 44670505
F : +33 1 44670519