[ADMIN] change database ownership

2002-05-30 Thread Laurette Cisneros
How do you change the owner of an existing database? Thanks, -- Laurette Cisneros The Database Group (510) 420-3137 NextBus Information Systems, Inc. www.nextbus.com Where's mybus? ---(end of broadcast)--- TIP 6: Have you searched our list a

Re: [ADMIN] strange inefficiency in shared memory handling

2002-05-30 Thread Radoslaw Stachowiak
*** Tom Lane <[EMAIL PROTECTED]> [Thursday, 30.May.2002, 18:04 -0400]: > > of course this memory removal of cached index blocks is caused by normal > > queries and their memory (buffer) requirements, but certainly algorithm > > which chose which buffer to remove is a very ineffective on index bloc

Re: [ADMIN] strange inefficiency in shared memory handling

2002-05-30 Thread Tom Lane
Radoslaw Stachowiak <[EMAIL PROTECTED]> writes: > of course this memory removal of cached index blocks is caused by normal > queries and their memory (buffer) requirements, but certainly algorithm > which chose which buffer to remove is a very ineffective on index blocks. > looks to me that it pr

[ADMIN] strange inefficiency in shared memory handling

2002-05-30 Thread Radoslaw Stachowiak
hello, i have medium sized database ( about 1mln records) served by p2-300 with 64M ram and ide disk. after upgrading to 7.2 version i started to use pg_stat_* tables to optimize performance, and noticed very strange thing. looks like that shared_buffers (which during these tests i tweaked from

Re: [ADMIN] databases and RAID ...

2002-05-30 Thread Manuel Sugawara
"Chad R. Larson" <[EMAIL PROTECTED]> writes: > At 01:31 PM 5/26/02 , Manuel Sugawara wrote: > >-RAID (5+0) A logical volume with several RAID 3 logical member > >drives. > > Perhaps a typo? Yes :-( Regards, Manuel. ---(end of broadcast)--- TIP 1

Re: [ADMIN] databases and RAID ...

2002-05-30 Thread Chad R. Larson
At 01:31 PM 5/26/02 , Manuel Sugawara wrote: >-RAID (5+0) A logical volume with several RAID 3 logical member >drives. Perhaps a typo? We built what we called a "plaid", in which we built RAID 5 arrays on Sun A3500 (hardware RAID with cache) [think horizontal] and then striped across the RAID

Re: [ADMIN] Mirroring ENTIRE DATABASE.

2002-05-30 Thread Rajesh Kumar Mallah.
Dear Bhuvan, Advanceded replication features although important are not currently available with postgresql. Some solutions do exists like pgreplicator, usogres rserv etc, but not sure of their status. Also i would like to ask the list if there exists some place where these are discussed,..