Re: Not a PG question: SCSI question

Hi

Just a little miss I think John did.
With PHP you dont have to start a new connection everytime.
You can use the good ole pg_pconnect. It is a persistant connection to
the server.
The server keeps a pool of connections open for fast access.

There has been some problems with this so I recommend PHP 4.0.5.
It is, among other things, a matter of issuing a rollback at the end of
the request on each page.

Best regards
Per-Olof Pettersson

>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<

On 2001-05-16, 03:06:36, njclark(at)ntsp(dot)nec(dot)co(dot)jp ("John Clark L. Naldoza")
wrote regarding Re: Not a PG question: SCSI question:

> Hi,

> Let me get this straight...;-)

> The IDE server is running Linux 2.0.36 with PHP and Apache.

> The SCSI server is running with PostgreSQL 7.0.3 ??

> And you're talking about speed in inserts?

> Try to use a kernel after 2.2.16 or the current 2.4.4 series, they
> handle memory management rather well.. You should also optimize your
> kernel depending upon your system's needs... like increasing the total
> number of process, the amount of memory one application can use.. The
> maximum number of files.. etc... Most of these are runtime tweaks found
> at the /proc/sys directory...;-)

> On the PostgreSQL side, you also need to optimize it a little bit...
> Kindly read the fine manual for this...;-)

> Apache and PHP... well, here's a sort of bottleneck in itself... You
> may need to increase your PHP (PHP4) scripts performance via Zend's
> Cache, Zend Optimizer, APC, and/or the PHP Smarty Template...

> You can also further increase performance if you have all your compiled
> PHP scripts under a RAM Disk System...;-)

> But one of the greatest bottlenecks that may not be so obvious... Is a
> rather simple one...;-) Each time you try to do an insert to your
> PostgreSQL database from your PHP application, you have to initialize a
> new connection...;-)

> I don't know how you accessed your server... Via psql? or from an
> application...;-) And how did you do you INSERTS? Did you use
> Transactions? Did you enable -F so that PostgreSQL doesn't write to
> your HDD often???

> Cheers,

> John Clark

> Jean-Arthur Silve wrote:
> >
> > Hi !
> >
> > I have 2 servers running apache, php and PG 7.0.3 running under Linux
> >
> > The first one uses IDE disks, and everything run fine and fast. (uses
linux
> > 2.0.36)
> >
> > The second one uses SCSI drives with a Adaptec adapter. (uses Linux
2.2.14)
> >
> > My problem is that acces to the DB on this server are very very slow (I
> > guess that it s particulary slow when i do INSERTs)
> > It s so slow that even the keyboard and the display slow down ! The HD
> > write or read a lot...
> > When I do a "ps" or "top", I don't see any process taking all the
ressources...
> >
> > So, I guess there is something whith the SCSI...
> >
> > Is anybody has a clue ??
> >
> > thanks !
> >
> > jean-arthur
> > PS : I did a vacuum analyze, and the table are not so big (max tuples are
> > 5000 )
> >

> --
> /) John Clark Naldoza y Lopez (\
> / ) Software Design Engineer II ( \
> _( (_ _ Web-Application Development _) )_
> (((\ \> /_> Cable Modem Network Management System <_\ </ /)))
> (\\\\ \_/ / NEC Telecom Software Phils., Inc. \ \_/ ////)
> \ / \ /
> \ _/ phone: (+63 32) 233-9142 loc. 3112 \_ /
> / / cellphone: (+63 919) 399-4742 \ \
> / / email: njclark(at)ntsp(dot)nec(dot)co(dot)jp \ \

> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly