After a long battle with technology, [EMAIL PROTECTED] (Josh Berkus), an earthling,
wrote:
>> Other than the disks, I am curious what other people are using in
>> terms of the horsepower needed. The Quad server has been keeping
>> up, but we are expecting quite high loads in the near future, and I
Anjan,
> Other than the disks, I am curious what other people are using in terms
> of the horsepower needed. The Quad server has been keeping up, but we
> are expecting quite high loads in the near future, and I am not sure if
> just by having the disks on a high-end storage will do it.
Do a perf
Simon,
> Please set WAL_DEBUG to 1 so we can see a bit more info: thanks.
I'm pretty sure that WAL_DEBUG requires a compile-time option.
--
-Josh Berkus
Aglio Database Solutions
San Francisco
---(end of broadcast)---
TIP 6: Have you searched o
Hi,
nobody has an idea? :-(
-Ursprüngliche Nachricht-
Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von [EMAIL PROTECTED]
Gesendet: Freitag, 27. Februar 2004 17:53
An: [EMAIL PROTECTED]
Betreff: [PERFORM] Select-Insert-Query
Hi,
what is the most performant way to select f
"Simon Riggs" <[EMAIL PROTECTED]> writes:
> - why checkpoint interval of 300 secs causes them to happen every 10
> mins in quieter periods; is that an occaisional update occurring?
There is code in there to suppress a checkpoint if no WAL-loggable
activity has happened since the last checkpoint.
>Rob Fielding wrote:
> My focus today has been on WAL - I've not looked at WAL before. By
> increasing the settings thus :
>
> wal_buffers = 64 # need to determin WAL usage
> wal_files = 64 # range 0-64
> wal_sync_method = fsync # the default varies across platforms:
> wal_debug = 0
> All:
>
> We have a Quad-Intel XEON 2.0GHz (1MB cache), 12GB memory, running
RH9, PG 7.4.0. There's
> an internal U320, 10K RPM RAID-10 setup on 4 drives.
>
> We are expecting a pretty high load, a few thousands of 'concurrent'
users executing either
> select, insert, update, statments.
> Wha
Further update to my WAL experimentation. pg_xlog files have increased
to 81, and checking today up to 84. Currently nothing much going on with
the server save a background process running a select every 30 seconds
with almost no impact (according to IO from vmstats).
This in itself is a good s
Title: Message
All:
We have a
Quad-Intel XEON 2.0GHz (1MB cache), 12GB memory, running RH9, PG 7.4.0. There's
an internal U320, 10K RPM RAID-10 setup on 4 drives.
We are expecting
a pretty high load, a few thousands of 'concurrent' users executing
either select, insert, update, statments
On Thu, Feb 26, 2004 at 12:46:23PM +, teknokrat wrote:
> I've read about the place. Would using -O3 be an improvement?
In my experience, it's not only not an improvement, it sometimes
breaks the code. That's on 8, though, not 9.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
The plural of anecd
I noticed this passage too, but ...
Quoting from http://www.daemonnews.org/21/freebsd_vm.html :
*
When To Free a Page*
Since the VM system uses all available memory for disk caching, there
^
The VM system, as you can see from the article, is focused on paging and
11 matches
Mail list logo
