Re: Slow access with PG 7.0

* Jean-Arthur Silve <jeanarthur@eurovox.fr> [001206 01:10] wrote:
> Hello,
>
> I have a problem :
> it seems that when a script access to a db for a SELECT (or table i don't
> really know), postgres locks the db or table and other scripts cannot
> access to this DB concurrently.
> So it's very very slow when this script (a PHP4 script) is called by
> several users...
> it's so slow that even keyboard is slow !
>
> My tables are not so large (about 500 records)
>
> I don't use "Begin" and "Commit"
>
> PG Version is 7.0, with SCSI HD with Adaptec 2940U2W card , on PIII 500 .
>
> I used to utilize these same scripts on another server with postgres 6.4
> (on Celeron 300), and there was no such problem, it was really faster !!

1) when was the last time you ran "vacuum verbose analyze <tablename>" ?
2) do you have indecies on this table?
3) have you tried this: pg_exec($dbh, "set enable seqscan off;"); (*)
4) how can you expect help without going into a bit more detail about
   how your table is set up and what the actuall query is?

(*) not sure on the syntax for that one, check the manual.

--
-Alfred Perlstein - [bright@wintelcom.net|alfred@freebsd.org]
"I have the heart of a child; I keep it in a jar on my desk."