From: | Kwan Lai Sum <KwanLaiSum(at)hkex(dot)com(dot)hk> |
---|---|
To: | "'mykarz(at)miyabara(dot)com'" <mykarz(at)miyabara(dot)com>, pgsql-general(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org, pgsql-novice(at)postgresql(dot)org |
Subject: | syslog.conf |
Date: | 2001-02-02 03:24:13 |
Message-ID: | E5DC0E26B2C2D41181F700508BAD31E726E469@SMTP0101 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-general pgsql-novice |
Hello all
How do I set up (config) the syslog.conf in red hat 7.0 so that I can
capture the log of other machine ?? Is there any additional works needed to
do ??
Thanks
Sum
> -----Original Message-----
> From: Michael Miyabara-McCaskey [SMTP:mykarz(at)miyabara(dot)com]
> Sent: Wednesday, January 31, 2001 12:17 PM
> To: pgsql-general(at)postgresql(dot)org; pgsql-admin(at)postgresql(dot)org;
> pgsql-novice(at)postgresql(dot)org
> Subject: [ADMIN] Queries against multi-million record tables.
>
> Hello all,
>
> I am in the midst of taking a development DB into production, but the
> performance has not been very good so far.
>
> The DB is a decision based system, that currently has queries against
> tables
> with up to 20million records (3GB table sizes), and at this point about a
> 25GB DB in total. {Later down the road up to 60million records and a DB of
> up to 150GB is planned).
>
> As I understand it, Oracle has some product called "parallel query" which
> splits the table queried into 10 pieces and then does each one across as
> many CPUs as possible, then puts it all back together again.
>
> So my question is... based upon the messages I have read here, it does not
> appear that PostgreSQL makes use of multiple CPUs, but only hands the next
> query off to the next processor based upon operating system rules.
>
> Therefore, what are some good ways to handle such large amounts of
> information using PostgreSQL?
>
> Michael Miyabara-McCaskey
> Email: mykarz(at)miyabara(dot)com
> Web: http://www.miyabara.com/mykarz/
> Mobile: +1 408 504 9014
From | Date | Subject | |
---|---|---|---|
Next Message | Leland V. Lammert | 2001-02-02 04:33:54 | Dumb Question |
Previous Message | Andreas Pronakis | 2001-02-01 12:54:31 | PostgreSQL 7.0.3 vacuum and insert problems |
From | Date | Subject | |
---|---|---|---|
Next Message | Per-Olof Petterson | 2001-02-02 03:50:50 | Re: Foreign Keys |
Previous Message | Stephan Szabo | 2001-02-02 01:50:39 | Re: sintax??? |
From | Date | Subject | |
---|---|---|---|
Next Message | Francisco Reyes | 2001-02-02 05:07:24 | Re: explain plan |
Previous Message | Robert B. Easter | 2001-02-01 18:49:48 | Re: how to deteck empty tables in outer joins |