From: Charles A. Landemaine <landemaine@gmail.com>
To: pgsql-performance@postgresql.org
Subject: How to handle a large DB and simultaneous accesses?
Date: Tue, 10 Jan 2006 12:41:27 -0200
Message-ID: <e6575a30601100641s61317c63o@mail.gmail.com> (raw)
Hello,
I have to develop a companies search engine (looks like the Yellow
pages). We're using PostgreSQL at the company, and the initial DB is
2GB large, as it
has companies from the entire world, with a fair amount of information.
What reading do you suggest so that we can develop the search engine
core, in order that the result pages show up instantly, no matter the
heavy load and
the DB size. The DB is 2GB but should grow to up to 10GB in 2 years,
and there should be 250,000 unique visitors per month by the end of
the year.
Are there special techniques? Maybe there's a way to sort of cache
search results? We're using PHP5 + phpAccelerator.
Thanks,
--
Charles A. Landemaine.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: landemaine@gmail.com
Subject: Re: How to handle a large DB and simultaneous accesses?
In-Reply-To: <e6575a30601100641s61317c63o@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox