tedia2sql 0.86 Released
tedia2sql 0.86 Released
От:
Tim Ellis <Tim.Ellis@gamet.com>
Дата:
Hello, lists,
I know I've posted about 7 release announcements for tedia2sql, but
features keep getting added! I'll try to keep announcements down to an
every-other-week frequency from now on.
Again, quick tedia2sql summary: Dia UML diagrams converted to SQL DDL for
Postgres, Oracle, DB2, Sybase. Others added as interest is shown. Homepage
at http://tedia2sql.tigris.org -- DBAs should be excited.
Jesus Sandoval writes:
"Very helpful tool tedia2sql, I'm beginning to use it (very easy to
install and use in my redhat 7.3 Linux, everything it needs is already
installed), I use it for Postgresql."
It appears if you run a later Redhat system (and I would assume a Mandrake
system as well), the prerequisites for tedia2sql are already installed.
The latest tedia2sql includes ability to add "RDBMS-specific" SQL,
specifically to allow creation of sequences. This functionality is
generic: you can specify "add this SQL for Postgres and Oracle, but add
that SQL for Sybase and DB2."
At this point, you can create a Dia diagram to give you:
1. Database schema w/ PK and FK statements
2. Insert statements to fill tables with initial data
3. Extra DB constructs like sequences or special stored procs
& triggers
Cheers,
--
Tim Ellis
DBA, Gamet
meaning of explain
От:
Auri Mason <amason@syntrex.com>
Дата:
in order to measure the improve of performances after a vacuum+reindex (do you suggest something more?), I want to understand exactly the output of the explain command. After a google search I found a broken link posted by Tom. Anyone of you can help me? TIA, Auri
Re: meaning of explain
От:
Stephan Szabo <sszabo@megazone23.bigpanda.com>
Дата:
On Tue, 9 Jul 2002, Auri Mason wrote: > in order to measure the improve of performances after a vacuum+reindex (do > you suggest something more?), I want to understand exactly the output of > the explain command. > After a google search I found a broken link posted by Tom. As a suggestion, vaccum analyze rather than vacuum to get the stats updated and I'd suggest checking chapter 11 of the user's guide if you're using 7.2 which appears to have a section on explain.