Hello,
I'm currently have to investigate some time to anyalyze how often the database
has to read data from disk compared to the number of cache(shared buffer)
accesses.
I got the following key figures for an example table:
a) pg_statio_user_indexes=>
-[ RECORD 12 ]+
buffers are set optimally (for example). Or if I need more RAM in the
> machine to run better etc..
>
> Thank you
> Sim
>
--
/===\
| Gerd König
| - Infrastruktur -
|
| TRANSPOREON GmbH
| Pfarrer-Weiss-Weg 12
| DE - 89077 Ulm
|
|
| Tel
ve tables with tens of millions of records if possible.
>
>
--
/=======\
| Gerd König
| - Infrastruktur -
|
| TRANSPOREON GmbH
| Pfarrer-Weiss-Weg 12
| DE - 89077 Ulm
|
|
| Tel: +49 [0]731 16906 16
| Fax: +49 [0]731 16906 9
Hello,
since 2 days ago we're facing an increased load on our database server
(opensuse10.3-64bit, PostgreSQL 8.3.5, 8GB Ram). This high load stays the whole
working day.
==
current situation:
==
#>top
top - 14:09:46 up 40 days, 8:08, 2 users, load average: 7.60,
Hello,
today I recognized an error while playing with pgpool-II 2.1 and
postgresql 8.3.5 (on 64bit linux).
I really don't know if the error is caused by pgpool or if it's
postgresql-related...?!?
There are up to 200 active connections in parallel and thereby sometimes
high load (with high write:r
you are talking about or is there another cybercluster I
> should be looking at.
>
> Also
>
>
> Is there an article or something that compares the different HA
> solutions for postgres? What are the differences between pgpool,
> pgcluster, cybercluster etc?
>
generate
> the sort of data and workload that you plan to have.
>
> Oh, and it's very easy to end up with data that tells you nothing
> useful. Make sure your tests are long enough, and that they're not too
> sensitive to minor ch
Hello,
Bristlecone is a tool from continuent and can be downloaded here:
http://bristlecone.continuent.org/HomePage
regards--GERD--
Abdul Rahman schrieb:
> Dear All,
>
> I searched a lot but failed to find any download link for Bristlecone. Kindly
> help me. Or let me know about any open sourc
Hello,
a few months ago we started using Postgres on Opensuse10.3-64bit.
We installed Postgres 8.3.1 with the (at that time) latest available rpm's.
But now Postgres' current version is 8.3.4 and I'm wondering why there
are no new rpm's for Opensuse ?!?!
The suse build service still offers me 8.3.
