No problem, we are doing vaccume different tables at different times.
Because if you do vaccume it will decrease the performace of data base
you can write scripts like this.
-cleanTable.sh
#!/sbin/shecho "## START:## Clean Table $1 ##"/usr/local/pgsql/bin/psql
On Thu, 29 Nov 2001, Jodi Kanter wrote:
> I need to create a diagram of our schema. I recently obtained a copy
> of Visio. Has anyone used Visio to reverse engineer a model diagram
> from a Postgres database?? If not, can anyone recommend the best way
> to create a schema from Postgres without
I have modified pgmonitor to work on Solaris. You can download version
0.54 from:
http://gborg.postgresql.org/project/pgmonitor/download/download.php
Would some Solaris folks please test it. See the Solaris notes in the
README file.
--
Bruce Momjian| http:/
May I suggest Visible Analyst ? I'm using It and supports postgres
Jodi Kanter wrote:
I
need to create a diagram of our schema. I recently obtained a copy of Visio.Has
anyone used Visio to reverse engineer a model diagram from a Postgres database??If
not, can anyone recommend the best way to cre
On Thu, Nov 29, 2001 at 03:25:48PM -0500, Jodi Kanter wrote:
> I need to create a diagram of our schema. I recently obtained a copy of Visio.
> Has anyone used Visio to reverse engineer a model diagram from a Postgres database??
> If not, can anyone recommend the best way to create a schema from
I've never used visio, but DBvisualizer works well if you have the key
relationships defined. You can get it free at http://www.minq.se
>Has anyone used Visio to reverse engineer a model diagram from a Postgres
database??
-Nick
---
Jodi-
I should have mentioned on that last post that you need to be running V7.1.x
of PGSQL & use the JDBC driver for JDBC 2. Somebody recently added a fix to
metadata in the JDBC driver that makes it all work, so earlier versions
won't cut it.
-Nick
I need to create a diagram of our schema. I
recently obtained a copy of Visio.
Has anyone used Visio to reverse engineer a model
diagram from a Postgres database??
If not, can anyone recommend the best way to create
a schema from Postgres without having to manually draw tables, add fields,
On Thu, 29 Nov 2001, Tom Lane wrote:
> bangh <[EMAIL PROTECTED]> writes:
> > However I noticed the index grows also very fast. Does anyone have a way to
> > compress the index?
>
> REINDEX, or just drop and recreate the indexes.
>
> regards, tom lane
>
>
"Leong, Fushan" wrote:
> Thanks for everyone input. So let me reply in here to make sure I
> understand it
>
> 1) If I run "vaccum all" or "vaccum tablename", it will just delete the
> expired rows from the file but not free the physical disk space.
Why not? it is the same thing as vacuumdb,
Thanks for everyone input. So let me reply in here to make sure I
understand it
1) If I run "vaccum all" or "vaccum tablename", it will just delete the
expired rows from the file but not free the physical disk space. However,
it will not free the index
2) Vaccumdb will delete the expired rows f
On Thu, 29 Nov 2001, bangh wrote:
> HI,
>
> This is not necessary true, but you might feel understandable.
>
> To delete records, just seems as the records are marked as voided. Space is not
> collected. To run vaccum might do this kind space garbage collection.
>
> To run vacummdb really save th
Peralta Miguel-MPERALT1 <[EMAIL PROTECTED]> writes:
> COPY release_data FROM '/home/mperalta/release_data' USING DELIMITERS '|'
> When I issue this command, the response afte a while is the following:
> ERROR; Bad date external representation '9'
> The external file is rather large and I've tried
His original post is hard to understand.
I guess the registers he said are records.
But what type of a table does he want to know. table type? Is there a table
type?
Bangh
Nick Fankhauser wrote:
> I did not understand the question. Can you restate your purpose or tell us
> more about what you
You said "when you delete the records, the space does not get compressed".
Can you explain
more for me. The reason I want to run vacuumdb is to free up some space so
the database will
not grow forever..
-Original Message-
From: bangh [mailto:[EMAIL PROTECTED]]
Sent: Thursday, Nov
bangh <[EMAIL PROTECTED]> writes:
> However I noticed the index grows also very fast. Does anyone have a way to
> compress the index?
REINDEX, or just drop and recreate the indexes.
regards, tom lane
---(end of broadcast)--
HI,
This is not necessary true, but you might feel understandable.
To delete records, just seems as the records are marked as voided. Space is not
collected. To run vaccum might do this kind space garbage collection.
To run vacummdb really save the space, but it works at only some extent. e.g.
I did not understand the question. Can you restate your purpose or tell us
more about what you are trying to achieve?
(No entendía la pregunta. ¿Puede usted exponer su propósito en forma
modificada o decirnos más sobre lo que usted está intentando alcanzar?)
-Nick (with the aid of http://www.go
Hello,
You can use vacuum at different levels.
As a command you can use vacuumdb database_name.
In psql, you can use
psql> vacuum table_name;
I don't think it is going to delete records. To delete records you need to
issue SQL command:
like: delete from table_name where condi.
It must delete
Suggest:
create another table, use text, instead of date type for that filed. AFter you
get imported and fix invalid data for that filed, in pgsql, you can convert it
to date type
In pgsql, this is easy to find those invalid data.
Bangh
Peralta Miguel-MPERALT1 wrote:
> Hello everyone:
>
> Wou
Hi :
Want to get your opinion.
I am thinking to schedule to run Vaccum everynight.
1) As I understand, Vaccum is the command to delete old data, right?
1) Do I have to stop the postmaster before run the Vaccum command?
2) Should I run it everynight? How often should I run it?
thanks
Fushan
-
You could use a perl script to read your data and do a pattern match for
consistency with your date output. Or you could import the data into a
temp table which has a text field instead of date. You could query
against your temp table to find offending data. Then use SQL to insert
the data into yo
Hello everyone:
Would anyone know how to find a bad date field in an external file? I have
an external file that I am using to populate a table using the following
command:
COPY release_data FROM '/home/mperalta/release_data' USING DELIMITERS '|'
When I issue this command, the response afte a w
On Thu, Nov 29, 2001 at 09:20:09AM -0600, Eric Johnson wrote:
> We cannot help you unless you specify 'better for what'. Either
> arrangement can be fine depending on what you are doing.
Is for "a web site proposals".
I only want to know what type is more fastest. Any field contain BLOB's, only
Hello,
Using vacuum a table is very usefull to compress the space of a table .
However I noticed the index grows also very fast. Does anyone have a way to
compress the index? I know if I dump the database, and destroy the orginal
database, then create new one using the same database, and restory
> [EMAIL PROTECTED] writes:
>> Ok! And does the new version correct my character sequences error?
> Which was ...?
Oh, never mind (for some reason my first search for your previous
messages didn't turn up anything).
I'm not sure. The LIKE queries you were complaining of didn't look like
they c
On Wed, Nov 28, 2001 at 10:53:45AM +0100, Manuel Trujillo wrote:
Please, anybody can help me with this :(((
> Hi.
>
> I need to know howto make a test for know the best accuracy of two types of tables:
> 1- a table with three fields, and with seven registers or more, and
> 2- a table with t
Tom Lane a écrit :
> [EMAIL PROTECTED] writes:
> > Ok! And does the new version correct my character sequences error?
>
> Which was ...?
Refer to " [ADMIN] character sequence problem"
Thanks for your help.
regards, Vincent.
---(end of broadcast)-
[EMAIL PROTECTED] writes:
> Ok! And does the new version correct my character sequences error?
Which was ...?
regards, tom lane
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/
I just spent a week or so working on FailSafe without much luck.
have a look on
http://www.sgi.com/software/failsafe/
http://oss.sgi.com/projects/failsafe/mail.html
you can get it at:
ftp://ftp.suse.com/pub/projects/failsafe/
I think using the RedHat 7.2 Distribution gave me the problems in bu
I am aware of the initlocation command that allows me to set up a new
directory location for a database
CREATE DATABASE xxx WITH LOCATION = 'xxx';
I am interested a finer level of control for performance reasons.
Specifying that this table belongs on this disk pack whiles it corresponding
index
Tom Lane a écrit :
> [EMAIL PROTECTED] writes:
> >> Er ... *what* version did you say you were running? That doesn't look
> >> like a 7.1 pg_control to me.
>
> > No, I have an 7.0.2 on Linux Mandrake 7.2.
>
> Time to update then. 7.0 doesn't freeze the LC_COLLATE setting at
> initdb, which me
32 matches
Mail list logo
