Hello Emi Lu,
The detailed discussion was just about two weeks ago on the plpgsql
list, worth of glance.
Actually it is quite difficult to say which one is better in your case
as it depends on utility (rapid file hostin or just storing but
transaction safety is important, etc.).
Generally it
Right!
The external binary file storage has another advantage (that may be
considered as disadvantage as well) - it is usually easier to develop
and test mechanism as you're able to browse uploaded file result using
os / application or even "exchange" file contents for test purposes,
while in
ains equal number of opening and
closing parenthesis, and if there are any of them.
Regards,
Piotr Czekalski
--
--
"TECHBAZA.PL" Sp. z o.o.
Technologie WEB, eDB& eCommerce
tel. (+4832) 7186081
fax. (+4832) 7003289
email:
W dniu 2011-02-24 01:03, manuel antonio ochoa pisze:
How Can I do to compare two structures of data bases ?
DBA != DBB I need wich functions and wich tables are not equals
thnks
I'd advise SQL Power Architect - very handy tool with graphical DB
design capability.
Will compare your databases
Are your IDs (in both tables) a subject of index?
If so, analyze tables and indexes. If not, create an index for each ID -
that may help.
Post an explain plan of the query as well. I guess there is full scan
instead of index scan, thus running over and over 800 rows vs 110mln
rows may take a lo
Gentelmen,
I follow this thread and I don't exactly get an idea of yours, but isn't
is as simple as (example: table "web.files" contains one column named
"fileurl" ):
select row_number() over(), X.fileurl from (select fileurl from
web.files order by fileurl) X
The only disadvantage is that
W dniu 2011-01-24 10:37, victor katemana pisze:
hi everyone, i have a problem of loosing data in my postgres database
whenever i restart my machine what could be the possible problem help
me out?
A plenty of reasons is possible, starting from uncommited transactions
on shutdown till invalid fsy
