Steve <[EMAIL PROTECTED]> wrote:
>
> Someone please please help me!!!! :-(
[snip]
Relax, Steve. The people helping-out on PostgreSQL mailing lists are
in 24 timezones, have real jobs (for which they actually get paid), are
all volunteers (for which they don't get paid), may be going to school,
take vacations, sleep, etc.
It may take some time, maybe hours, or even days, depending on a
variety of factors, for somebody to address your question(s). And
that's assuming somebody knows, has the time, and will take an
interest.
I'm no expert in pgsql performance, but I suspect you'd be better-off
with UW-SCSI drives in a RAID array, than doing things like trying to
put different bits on different drives. There are reams of other
questions, such as: Do you "vacuum analyze" regularly? Do you have
sufficient sort memory?
It may be that your question(s) would be more appropriately directed to
the performance mailing list, rather than general.
You might also help yourself by spending some time searching/browsing
the performance, admin and general mailing lists archives for past
discussions of issues similar to yours.
Jim
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
