Hi Tom,
I re-send this because my last email with attachment did not get
through.
It is a live production database, and I do not know what else happened
on Saturdays because I do not work on Saturdays. However, I can ask our
shift to find out what other queries will be in the PG next Saturday if
"Lee Wu" <[EMAIL PROTECTED]> writes:
> On the other hand, should not PG use fix number/amount
> of LOG files like Oracle even though there may be other activities at
> the same time?
No, it certainly should not. Anyone who's admin'd an Oracle
installation will tell you what a PITA it is that Orac
All of these recent threads about fastest hardware and "who's better than
who" has inspired me to create a new website:
http://www.dbtuning.org
I snipped a few bits from recent posts to get some pages started - hope
the innocent don't mind. It's a bit postgres biased at the moment, since
well,
Here is postgres log from 20:17:42 to 20:25:35.
I did NOT removing anything except hostname and table names.
Thanks,
name |setting
+---
australian_timezones | off
authenticat
People:
> All of these recent threads about fastest hardware and "who's better than
> who" has inspired me to create a new website:
>
> http://www.dbtuning.org
Well, time to plug my web site, too, I guess:
http://www.powerpostgresql.com
I've got a configuration primer up there, and the 8.0 Annot
"Lee Wu" <[EMAIL PROTECTED]> writes:
> Here is postgres log from 20:17:42 to 20:25:35.
> I did NOT removing anything except hostname and table names.
Hmm. That shows the checkpoint process (8213) in a tight loop removing
unwanted XLOG files. But apparently it is being starved for cycles ---
look
On Mon, 2005-01-10 at 11:31 -0700, Michael Fuhr wrote:
> On Mon, Jan 10, 2005 at 11:19:10AM -0600, Tad Marko wrote:
> ... earlier comments regarding schemas and privileges ...
Now I'm a bit closer to having things working, but I seem to be running
into another problem granting the privileges I wan
Hi all
Actually I have the Oracle Database. I am searching about others
Databases Soluctions.
I have a server with 2 processors (XEON 2.8) and 2Gb of RAM memory.
The size of my actual Database is 5Gb and the it has 300 simultaneous
access.
The postgreSQL provide a good performance to my applica
On Tue, Jan 11, 2005 at 14:26:15 -0600,
Tad Marko <[EMAIL PROTECTED]> wrote:
>
> I can
>
> GRANT ALL ON a_specific_table TO user
>
> but I can't figure out how to simply give some privilege to a user on
> all tables.
You can't do it with a single GRANT statement. You need to write a script
or
cat /etc/redhat-release
Red Hat Linux release 7.3 (Valhalla)
pg_xlog is on local disk while $PGDATA is on RAID 10.
Thanks,
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 11, 2005 1:00 PM
To: Lee Wu
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] V
Or, the best way is to use views and not grant any priviledges on the
table. The view must be created by the table owner and then grant
priviledges on that view to a user. You can then create more than one
view if you need, or else you can set up rules, triggers and procedures
to implement what
Sidnei,
In principle, yes, postgres can do quite well (we use 2 CPU boxes with 2 gigs
of RAM for most of our production servers), but a lot would depened on what
sort of use your database gets -- all read and bulk updates ? Or lots of
updates ? Are the queries complex ? etc., etc. How fast
Sidnei,
You'll find PostGreSql and Oracle to be kindred spirits. Similar, but
different at the same time. I find performance very good, although you'll
need to tweak the system memory parameters from the defaults and the
postgresql.conf file.
Dick Goulet
Senior Oracle DBA
Oracle Ce
On Tue, 2005-01-11 at 21:23 +, Bradley Kieser wrote:
> Or, the best way is to use views and not grant any priviledges on the
> table. The view must be created by the table owner and then grant
> priviledges on that view to a user. You can then create more than one
> view if you need, or else
Hello, I'm new to postgresql and I'm looking for some documents apart
from the standard documentation, I was a mysql user and as I can see
the user administration is very diferent from postgresql, the standar
documentation is too poor and does'nt explain everything, I read III.
Server Administratio
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
On Tue, Jan 11, 2005 at 02:53:45PM -0700, Hector Rosas wrote:
> Hello, I'm new to postgresql and I'm looking for some documents apart
> from the standard documentation, I was a mysql user and as I can see
> the user administration is very diferent from postgresql, the standar
> documentation is to
Is there a configuration setting that will relax the restriction of not
having psql touching template1 when I try to createdb?
Thanks,
Tad
--
Tad Marko <[EMAIL PROTECTED]>
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [E
On Tue, Jan 11, 2005 at 04:49:50PM -0700, Hector Rosas wrote:
> Well I came from a mysql environment where I give permision to certain
> user with some ip, identified by some password and other things. While
> reading the documentation, I didn't find anything about that, I read
> about that create
On Tue, Jan 11, 2005 at 07:11:13PM -0600, Tad Marko wrote:
> Is there a configuration setting that will relax the restriction of not
> having psql touching template1 when I try to createdb?
There should be little or no normal activity in template databases,
so better questions might be: Why is t
On Tue, Jan 11, 2005 at 15:49:32 -0600,
Tad Marko <[EMAIL PROTECTED]> wrote:
>
> In MySQL (the only DB I'm very familiar with), I can create a database,
> import tables, create a user, and then
>
> GRANT ALL ON dbname.* TO whateveruser
>
> and then whateveruser is essentially the super user on
21 matches
Mail list logo
