Hi Friends,
Does anybody know the substitute of the oracle function 'connect by
prior' in postgre sql.
The query is basically being used to get a tree structure of records. The
query in oracle is :-
select pkmsgid
from mstmessage
connect by prior pkmsgid = msgparentid
start with msgparen
Hi,
I'am having major performance issues with post gre 7.3.1 db. Kindly suggest all
the possible means by which i can optimize the performance of this database. If not
all, some ideas (even if they are common) are also welcome. There is no optimisation
done to the default configuration of
Hi,
I'am having major performance issues with post gre 7.3.1 db. Kindly suggest all
the possible means by which i can optimize the performance of this database. If not
all, some ideas (even if they are common) are also welcome. There is no optimisation
done to the default configuration of
Hi,
I'am taking dump of a huge database and do not want the restoration of
that dump to take a lot of time as is the case when you take the dump in
text files. I want to take the dump as an archive file and get it restored
in very less time. I'am not able to figure out what is the command for
t