[ADMIN] vacuum - verbose

Hi, What's the meaning of the following line when I make # vacuumdb -v -d dbname NOTICE: Pages 58094: Changed 319, Empty 0; Tup 77163: Vac 4428, Keep 0, UnUsed 2455413. Total CPU 8.84s/1.17u sec elapsed 108.12 sec. I'm specially focused on "UnUsed -> 2455413". Thanks in advance, M.P.Garcia

[ADMIN] Controlling performance impact of multiple users

This is an issue that I have never seen we;; ved with other databases I have used: We have an on-line application that is PSQL based. Users want to be able to get reports from this database - both canned reports that we might write for them, and ad-hoc reports where they use an odbc-based repo

[ADMIN] unsubscribe

[EMAIL PROTECTED] __ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [ADMIN] Forcing Disconnection

At 09:17 AM 7/11/02 , Stephane Schildknecht wrote: >Is it possible to force people disconnect before shutting down the >postmaster ? >I don't have time enough to wait 'til eveybody leaves the connection. Check the fast/smart/immediate options to "pg_ctl stop" and "pg_ctl restart" commands.

Re: [ADMIN] Forcing Disconnection

Stephane Schildknecht wrote: > Hi, > > Is it possible to force people disconnect before shutting down the > postmaster ? > I don't have time enough to wait 'til eveybody leaves the connection. Yes, there is a pg_ctl flag to force them all to exit. -- Bruce Momjian

Re: FW: [ADMIN] FW: Linking databases.

Geoff wrote: > I don't think either COPY or PG_DUMP will help in this case... > > I have a users table in database ADMIN with a primary key user_id. I have a > users_access table in database LIVE which I was hoping to have a foreign key > user_id reference the user_id column in the ADMIN database

[ADMIN] Forcing Disconnection

Hi, Is it possible to force people disconnect before shutting down the postmaster ? I don't have time enough to wait 'til eveybody leaves the connection. Thanks S@S -- _Stéphane SCHILDKNECHT___ | AurorA-SAS 69-71, Av. Pierre Grenier 92100 BOULOGNE

Re: [ADMIN] Vaccuming on 7.1.3

On Thu, 11 Jul 2002, Auri Mason wrote: > Good, but the documentation reports: > - Beginning in PostgreSQL 7.2, the standard form of VACUUM can run in > parallel with normal database operations. If my DB is a 7.1.3 what > happens? IIRC, it grabs an exclusive lock on the table it's working on, so

Re: FW: [ADMIN] FW: Linking databases.

On Thu, 11 Jul 2002, Geoff wrote: > I don't think either COPY or PG_DUMP will help in this case... > > I have a users table in database ADMIN with a primary key user_id. I have a > users_access table in database LIVE which I was hoping to have a foreign key > user_id reference the user_id column

Re: [ADMIN] redhat 7.3 problem

On Wed, 2002-07-10 at 22:58, Edgar Castanedo wrote: > I just installed redhat linux 7.3. During the initial installation, I had it > install postgresql. After I su as postgres, I then run the command 'psql > template1'. At the psql command prompt, I try to run various command, but > none of them w

[ADMIN] redhat 7.3 problem

I just installed redhat linux 7.3. During the initial installation, I had it install postgresql. After I su as postgres, I then run the command 'psql template1'. At the psql command prompt, I try to run various command, but none of them work. When I hit enter, the command line just opens up anothe

[ADMIN] Case sensitive

Hi I have a problem with the case sensitive, is there any form or procedure to desabled this? ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html

FW: [ADMIN] FW: Linking databases.

I don't think either COPY or PG_DUMP will help in this case... I have a users table in database ADMIN with a primary key user_id. I have a users_access table in database LIVE which I was hoping to have a foreign key user_id reference the user_id column in the ADMIN database, so If I deleted a use

[ADMIN] Vaccuming on 7.1.3

Hi group! I've seen the page http://www.postgresql.org/idocs/index.php?routine-vacuuming.html where is explained the benefit offered by the vaccum. I've made a test with my software: before vaccuming: 478 "operations" after vaccuming: 1378 "operations" Good, but the documentation reports: - Be

[ADMIN] FW: Linking databases.

Sorry if this seems a little trivial, but I can't find any thing in the docs about using references in seperate db's. I need to reference columns in databaseA with columns in databaseB... is this possible? I've tried the usual way link "column integer references databaseb.column", but just can'