Re: postgresql having trouble under load

On Fri, 2003-10-17 at 05:18, Greg Reeves wrote:

> Hi There,
>
> I am new to postgresql and we are thinking of migrating from MS-SQL to
> postgresql, but I am having trouble getting postgresql to keep up with the
> load.
>

Hmm, the website seems to be loading pretty slow as it is.

> I am using it to serve about 10000 images/hour (16/sec), so I am making that
> many connections to determine which image to serve each time.
>

Not to make wild assumptions, but that seems quite exaggerated. Are
those live images or something? It looks like you could really use some
caching. The key point in building a large
and high traffic website with dynamic content is caching. You can't
possibly need to get 16
images per second from the database, you're not an on-line surgery room.

> It seems to build up a lot of connections and then dissallow non-super
> users. My sysadmin has set the connection limit to above 1000.
>
> I am using php 4.3 on red hat 8 and postgresql 7.3.
>
> I explicitly use pg_close at the end of my PHP scripts, but it doesn't seem
> to have much impact.
>
> Is there anything I should be doing in a high load situation. I have just
> set up postgresql with default settings.
>

Read the configuration and tuning docs. They're not like exotic and
uber-geek-only, but common
sense stuff.

> Thanks in advance,
> Greg
>
> There are 10 kinds of people:
> ones that get binary, and ones that don't.
>
>
>
> This e-mail message (and any attachments) may contain information that is
> confidential to SportOdds Systems Pty Ltd and it's fully owned subsidiary,
> SuperOdds UK Ltd. If you are not the intended recipient you cannot print,
> retransmit, store, distribute or copy the message or attachments. In such a
> case, please notify the sender by return e-mail immediately and erase all
> copies of the message and attachments.You should only re-transmit or
> distribute this email or attachments if you are authorised to do so.
> Opinions, conclusions and other information in this message and attachments
> that do not relate to the official business of SportOdds (and/or SuperOdds)
> are neither given nor endorsed by it. SportOdds (and/or SuperOdds) has
> implemented anti-virus software, and whilst all care is taken, it is the
> recipient's responsibility to ensure that any attachments are scanned for
> viruses prior to use.
>
> ---------------------------(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

--
Radu-Adrian Popescu
CSA, DBA, Developer
Aldratech Ltd.
+40213212243