[EMAIL PROTECTED] (D'Arcy J.M. Cain) writes:
> One thing I notice is that a single query can seem to block other queries,
> at least to some extent.
It's not supposed to, except with certain specific features (for
example, I don't think any of the index types other than btree allow
concurrent ins
Thus spake Tom Lane
> Tatsuo Ishii <[EMAIL PROTECTED]> writes:
> > I have tested PostgreSQL with 2-4 CPU linux boxes. In summary, 2 CPU
> > was a big win, but 4 was not. I'm not sure where the bottle neck is
> > though.
>
> Our not-very-good implementation of spin locking (using select() to
> wai
Tom Lane <[EMAIL PROTECTED]> wrote:
> Tatsuo Ishii <[EMAIL PROTECTED]> writes:
>> I have tested PostgreSQL with 2-4 CPU linux boxes. In summary, 2 CPU
>> was a big win, but 4 was not. I'm not sure where the bottle neck is
>> though.
> Our not-very-good implementation of spin locking (using select
Tatsuo Ishii <[EMAIL PROTECTED]> writes:
> I have tested PostgreSQL with 2-4 CPU linux boxes. In summary, 2 CPU
> was a big win, but 4 was not. I'm not sure where the bottle neck is
> though.
Our not-very-good implementation of spin locking (using select() to
wait) might have something to do with
> I am looking to beef up a PostgreSQL database by moving it to a Sun
> Enterprise or an Alpha ES-40 or some other multi-CPU platform. My
> questions are;
>
> - What suggestions do people have for a good PostgreSQL platform.
> - How well does PostgreSQLtake advantage of multiple CPUs?
I hav
On Thu, Mar 08, 2001 at 07:50:15AM -0500, D'Arcy J.M. Cain wrote:
> I am looking to beef up a PostgreSQL database by moving it to a Sun
> Enterprise or an Alpha ES-40 or some other multi-CPU platform. My
> questions are;
>
> - What suggestions do people have for a good PostgreSQL platform.
>
I am looking to beef up a PostgreSQL database by moving it to a Sun
Enterprise or an Alpha ES-40 or some other multi-CPU platform. My
questions are;
- What suggestions do people have for a good PostgreSQL platform.
- How well does PostgreSQLtake advantage of multiple CPUs?
Thanks.
--
D'Ar
