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@eurovox.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