From: Scott Alexander <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Tuesday, June 08, 1999 5:57 PM
Subject: [GENERAL] Newbie questions
>Database design - CASE tools
>
>For people who *don't* use a CASE tool: what do you find to be the most
>effic
60 secs vs 10 minutes tho! I don't think that can be explained away with OS
speed differences unless you have the Solaris installation horribly mangled.
It sounds like the Sparc's test was run on an existing database thats been
in use...perhaps the indexes need to be cleaned up a little with a va
I second the opinion that postgreSQL implements a very flexible and
extensive set of SQL functionality.
$2000 is chump change if the application is a mission critical one. The
Costs of losing the data or downtime of the database easily exceed $2000 (in
probably the first minutes of downtime). I
Personally, I find PostgreSQL to be good for non mission critical databases.
I have used it for many commercial sites, but none that are "heavy" usage,
zero down time. PostgreSQL is a fine database with many features, but there
are database recovery/space usage issues that, I think, keep it from
I had same problem...tables that have heavy deletes/inserts start to eat up
tons of disk space and the vacuum seemed to hang. I posted too, but got no
replies...so my solution was to dump the table and delete the database and
recreate it all. Also I run the vaccum more often to avoid the prob in
I didn't see any replies for this...forgive me if I dupe someone elses
reply.
Create user will automatically add a record into the system tables. If you
can specify exactly what the error you are getting I can give you some other
ideas.
Password in PostgreSQL is authenticated via the operating s
How about...
select field1 where primary_key = select max(primary_key) from table;
or something like that :) I always mess up the parenthesis...cant remember
whether or not they are needed here around the second select.
-Original Message-
From: hoelc <[EMAIL PROTECTED]>
To: [EMAIL PROT
select var1, count(*) from table1 group by var1;
will get you the count of how many of each number there is...
I think the only way is to get the max and manually loop thru the rows and
calc the percentage.
-Original Message-
From: Sze Yuen Wong <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Before anyone asks...I tried shutting down Postgres and restarting it to
disconnect any connections and I made all of my CGI scripts (the only users)
"000" so the database could not be accessed.
-Original Message-----
From: K.T. <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] &
Title: selects on datetime
Ugg more HTMLized email...
If your fields are defined separately as Year,
Month, Day, then index on those fields and your query should use the index to
find the records matching where clause.
If you want a single date field...compose the
date field as a string
Vacuum cammand seems to hang (I waited 1-2 hours) on a table that is empty,
but is still using over 66 MB of disk space. This is due to deletes because
this table is completely reloaded from text files.
The command I am using is "vacuum verbose analyze" from the psql prompt.
Anyone experience th
I think this is another one that falls under the general fix all:
run the "vacuum" command.
-Original Message-
From: Karl Auer <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Wednesday, March 03, 1999 3:56 AM
Subject: [GENERAL] what on earth does this mean?!?
>Hi all
Its been a while since I wrote this and its kinda fuzzy at this hour, but
this will give you a general direction to go and you can work out the
specifics...
If you know the depth of the tree then you can create a field of a specified
length and store something like:
tree_field varchar(16)
A
AA
AB
Ummm...no news group exists that I know of...whis there was one. Easier
than this mailing list.
To restrict users from accessing other accounts just make them type in their
old password before you ask for the new... I am not sure if this is the
answer to your question as it is kinda obvious...no
Commit.
-Original Message-
From: Sebestyen Zoltan <[EMAIL PROTECTED]>
To: PostgreSQL general mailinglist <[EMAIL PROTECTED]>
Date: Sunday, February 07, 1999 12:40 PM
Subject: [GENERAL] The multiuser capabilities of PgSQL...
>I've noticed that when I fill up a database by some app, I can'
15 matches
Mail list logo
