Walterce
  Home FAQ Contact Sign in
 
Advanced search
MATCHING GROUPS



more...
POPULAR GROUPS

more...

found 8 articles for 0.302 sec
walterc@indiana.edu (Carol Walter) writes: > I have some questions about tuning. The PostgreSQL documentation > says that you don't need to worry about index maintenance and tuning > with PostgreSQL. I'm used to systems that work a lot better if they > are periodically re-orged or re-indexed. Is it true that one need > not be concerned with this? I'm certain that the databases must > require     

Group: mailing.database.pgsqladmin · Group Profile · Search for Walterce in mailing.database.pgsqladmin
Author: Chris Browne
Date: Apr 7, 2008 10:26

--Apple-Mail-5--162654882 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed FYI, We're on Solaris 10. Begin forwarded message: From: "Scott Marlowe" <scott.marlowe@gmail.com> Date: February 21, 2008 4:21:24 PM EST To: "Carol Walter" <walterc@indiana.edu> Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] Stable Release
Show full article (1.90Kb)
--_fe92fa18-f423-465a-96fa-7fa02b22e512_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable From the psql client, you can view ACL permission summaries by using the \z= slash command. This command displays all access permissions in the current= ly connected database. To see permissions on a specific object, specify tha= t object's name as a parameter     

Group: mailing.database.pgsqladmin · Group Profile · Search for Walterce in mailing.database.pgsqladmin
Author: Carol Walter
Date: Feb 21, 2008 13:49

--Apple-Mail-6--519457666 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Chris, Perhaps I wasn't clear on what we did. We loaded the 8.2 and got it running on a different zone on the same machine running Solaris. I should have said we did a pg_dumpall using the 8.1 data. ( I know there is a big difference.) Anyway, I
Show full article (10.88Kb)
------=_Part_31846_19197877.1190311596456 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline On 9/20/07, Carol Walter <walterc@indiana.edu> wrote: > > We just did this. I did a pg_dumpall using 8.1. Then we fired up > 8.2 while 8.1 was still running. Uploaded the data to 8.2. Then > shut 8.1 down. This allowed us to have the database     

Group: mailing.database.pgsqladmin · Group Profile · Search for Walterce in mailing.database.pgsqladmin
Author: Vishal Arora
Date: Nov 12, 2007 23:34

Thanks so much fro the info. I've done as you suggested and I've got the correct directories. I have a second question now. There are forty-four numeric entries in the directory for the first databases that I looked at. The database in question has only eight tables. There are eight tables that have recent dates. Do I need the total of all the files or just the eight that appear
Show full article (2.90Kb)
walterc@indiana.edu (Carol Walter) writes: > Is there a way to tell what the raw disk space used by a single > database is? I know that databases are fluid, but if there is way to > do even a snap shot view that is a "ball park" figure, I'd be happy. > My user keeps clammering for this figure. Sure, you can identify the database via "select oid, * from pg_catalog.pg_database;" Then you     

Group: mailing.database.pgsqladmin · Group Profile · Search for Walterce in mailing.database.pgsqladmin
Author: Carol Walter
Date: Sep 21, 2007 08:38

walterc@indiana.edu (Carol Walter) writes: I don't want to add gas to the flamewar, but I gotta ask. What is in the the 90 to 95%% referred to in this email. I'd say, look at the Oracle feature set for things that it has that PostgreSQL doesn't. Four that come to mind: - ORAC = multimaster replication - Integration with hardware vendors' High Availability systems - Full fledged table
Show full article (4.67Kb)
    

Group: mailing.database.pgsqladmin · Group Profile · Search for Walterce in mailing.database.pgsqladmin
Author: "Chris Hoover"
Date: Sep 20, 2007 11:14

Show full article (1.95Kb)
    

Group: mailing.database.pgsqladmin · Group Profile · Search for Walterce in mailing.database.pgsqladmin
Author: Carol Walter
Date: Aug 1, 2007 09:41

Show full article (1.94Kb)
    

Group: mailing.database.pgsqladmin · Group Profile · Search for Walterce in mailing.database.pgsqladmin
Author: Chris Browne
Date: Aug 1, 2007 07:13

Show full article (1.22Kb)
    

Group: mailing.database.pgsqladmin · Group Profile · Search for Walterce in mailing.database.pgsqladmin
Author: Chris Browne
Date: Jun 19, 2007 07:00

Show full article (2.42Kb)