> RAM appears to be the bottleneck -- lots
> of swaps in and out.
> can we put the database indexes on a RAM disk?
Can you increase the RAM in the machine? I guess I should assume you're
maxed out.
Rick
[EMAIL PROTECTED] wrote on 07/29/2005 10:32:28 AM:
> All:
>
> We have a postgres 7.4 server
Tom Lane suggested a vacuum freeze (? or something like that) for archival
read only data. I got the impression the template databases are freeze
dried for freshness (good to the last bit?) That feature might help as
well in the transition from read-write to read-only.
Rick
Isn't there some way to trick PostgreSQL with a RAM disk, like for the WAL?
Rick
[EMAIL PROTECTED] wrote on 05/11/2005 02:31:55 PM:
> Why? Any specific reason that you are aware of ?
> Are there any writes done to the database when read only SQL
> statements are issued?
>
>
> -Original Messa
Are you just synching the schemas, or do you also need to synch the data?
Rick
John DeSoi
Note this (currently active) thread from the archives:
http://archives.postgresql.org/pgsql-general/2005-03/msg00025.php
Rick
Scott
I think Joel may be asking for a paid, dedicated consultant. Could be
wrong, but I know you folks are out there. --Rick
"Marc G. Fou
Hi Chris,
In the rotate_logs.sh I would replace the first sleep 150 with a call to
fuser (in a sleeping loop) to make sure there is no file access to the log
file. I don't understand the second sleep 150.
Rick
I do this using the following:
CREATE GROUP agroup;
ALTER GROUP agroup ADD USER auser;
CREATE TABLE atable ...;
GRANT ALL ON atable TO GROUP agroup;
If you grant permissions to some set of groups on all tables at schema
creation time, then you only need to alter the groups to add and remove
us
Did you turn on the "view system objects" thingy in pgadmin3? That's too
technical%| Okay, I just checked and it's Display->System Objects.
True. I can't imagine a modern server room, even running windows, that
doesn't have a gigabit or fiber backbone for the servers.
Rick
Andrew Sullivan
Depends on the NIC. If your running 100MBS Ether and put in 1GBS Ether or
fiber, it would make a difference.
Rick
Andrew Sullivan
11 matches
Mail list logo
