[ This has been written offline yesterday. Now I see that most of it
has already been covered. I send it anyway ... ]
On Tue, 24 Jun 2003 09:39:32 +0200, "Michael Mattox"
<[EMAIL PROTECTED]> wrote:
>Websites are monitored every 5 or 10 minutes (depends on client),
>there are 900 monitors which c
> > configure it properly and trial & error. I do think the
> documentation could
> > be enhanced a bit here, but I'm sure there are some users who don't make
>
> Do you have any specific thoughts about documentation? Areas of
> confusion? Was it difficult to find the information in question, or
> configure it properly and trial & error. I do think the documentation could
> be enhanced a bit here, but I'm sure there are some users who don't make
Do you have any specific thoughts about documentation? Areas of
confusion? Was it difficult to find the information in question, or was
it simp
Micheal,
> I changed the postgres.conf settings as suggested by several people. I've
> attached it to this email, please let me know if you see anything else I
> can tweak. top still says I have plenty of ram, so should I increase the
> buffers and/or effective_cache even more?
Effective cache,
I want to thank everyone for their help and post a status update. I've made
quite a bit of improvements. Here's what all I did:
I refactored my algorithm, instead of updating the timestamp, monitoring the
website, and then updating the status (two transactions), I wait and update
the timestamp a
"Shridhar Daithankar" <[EMAIL PROTECTED]> writes:
>> - Would a RAID setup make the disk faster? Because top rarely shows the
>> CPUs above 50%, I suspect maybe the disk is the bottleneck.
> Yes it is. You need to move WAL to a different disk.
For an update-intensive setup, putting WAL on its own
> Don't log your monitoring info directly into the database, log
> straight to one
> or more text-files and sync them every few seconds. Rotate the
> files once a
> minute (or whatever seems suitable). Then have a separate process
> that reads
> "old" files and processes them into the database.
>
>
On Tuesday 24 Jun 2003 8:39 am, Michael Mattox wrote:
> I'd like to get some feedback on my setup to see if I can optimize my
> database performance. My application has two separate applications:
>
> The first application connects to websites and records the statistics in
> the database. Websites
On 24 Jun 2003 at 12:10, Achilleus Mantzios wrote:
> On Tue, 24 Jun 2003, Shridhar Daithankar wrote:
> > With java runnning on same machine, I would not trust that machine for having
> > free RAM all the time, no matter how much RAM you have put into it.
>
> There are always the -Xmx, -Xss, -Xms
On Tue, 24 Jun 2003, Shridhar Daithankar wrote:
> On 24 Jun 2003 at 13:29, Shridhar Daithankar wrote:
> > > - I have at my disposal one other server which has 2 Xeons, 10,000 RPM SCSI
> > > drive. Would it make sense to put Postgres on it and leave my apps running
> > > on the more powerful 4 CPU
On 24 Jun 2003 at 13:29, Shridhar Daithankar wrote:
> > - I have at my disposal one other server which has 2 Xeons, 10,000 RPM SCSI
> > drive. Would it make sense to put Postgres on it and leave my apps running
> > on the more powerful 4 CPU server?
Argh.. Forgot it first time.
With java runnni
On 24 Jun 2003 at 9:39, Michael Mattox wrote:
> I'd like to get some feedback on my setup to see if I can optimize my
> database performance. My application has two separate applications:
>
> The first application connects to websites and records the statistics in the
> database. Websites are m
I'd like to get some feedback on my setup to see if I can optimize my
database performance. My application has two separate applications:
The first application connects to websites and records the statistics in the
database. Websites are monitored every 5 or 10 minutes (depends on client),
there
13 matches
Mail list logo
