This may be low hanging fruit but...
1) Get your WAL files onto their own disk. This is fairly easy to do and
has had very good payback for us.
2) Use pgmonitor to observe activity, identify long running queries, and
assess indexing opportunities.
3) Keep those daily vacuum/analyze going.
Hope
Exactly. My Informix background is showing. Is there a way to officially
get this put on a to do list? I'd be most appreciative of the value this adds.
Slightly off subject, is there a way to read from one cluster and insert
into a database in another cluster (local or remote)? I think I rea
check out "un remming" a line in postgresql.conf (clue... the line has to do
with tcp/ip and it has the word false, which should be changed to true)
By the way, don't think that if it runs as a windows service, you can't pass
command line parms to it.
- Original Message -
From: "Peter Ei
We do have /contrib/dblink in 7.3 that allows cross-db query access. We
don't have any pass-data-between-db's capability that I know of.
---
Naomi Walker wrote:
> Exactly. My Informix background is showing. Is there a way
