By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,852 Members | 2,220 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,852 IT Pros & Developers. It's quick & easy.

PostGreSql database features questions

P: n/a
Hi:

I'm very new to PostGreSql database and actually looking to evaluate for
one of our project needs. Below please find some questions. I'm hoping
if I can get some insight into these questions.

Thanks.

Ish...

1) Does PostGreSql allows for multiple databases to be open at the same
time?

2) Does PostGreSql have the ability to tag a Database/Table to be a
persistent or non-persistent database/table? By this question I mean,
that I may need to have a table that I don't want to be saved to the
hard disk/ flash file system and only want to keep it in memory and
other tables/database I may want to save to hard disk or flash. Does
PostGreSql allow for that?

Nov 11 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Ish Ahluwalia <ah*******@erinc.com> writes:
1) Does PostGreSql allows for multiple databases to be open at the same
time?
The backend supports access to multiple databases at the same time.
2) Does PostGreSql have the ability to tag a Database/Table to be a
persistent or non-persistent database/table? By this question I
mean, that I may need to have a table that I don't want to be saved
to the hard disk/ flash file system and only want to keep it in
memory and other tables/database I may want to save to hard disk or
flash. Does PostGreSql allow for that?


There has been discussion of this, but no implementation has emerged.
--
let name="cbbrowne" and tld="libertyrms.info" in name ^ "@" ^ tld;;
<http://dev6.int.libertyrms.com/>
Christopher Browne
(416) 646 3304 x124 (land)
Nov 11 '05 #2

P: n/a
Ish Ahluwalia <ah*******@erinc.com> writes:
1) Does PostGreSql allows for multiple databases to be open at the same
time?
The backend supports access to multiple databases at the same time.
2) Does PostGreSql have the ability to tag a Database/Table to be a
persistent or non-persistent database/table? By this question I
mean, that I may need to have a table that I don't want to be saved
to the hard disk/ flash file system and only want to keep it in
memory and other tables/database I may want to save to hard disk or
flash. Does PostGreSql allow for that?


There has been discussion of this, but no implementation has emerged.
--
let name="cbbrowne" and tld="libertyrms.info" in name ^ "@" ^ tld;;
<http://dev6.int.libertyrms.com/>
Christopher Browne
(416) 646 3304 x124 (land)
Nov 11 '05 #3

P: n/a
On Friday 12 September 2003 18:38, Ish Ahluwalia wrote:
Hi:

I'm very new to PostGreSql database and actually looking to evaluate for
one of our project needs. Below please find some questions. I'm hoping
if I can get some insight into these questions.

Thanks.

Ish...

1) Does PostGreSql allows for multiple databases to be open at the same
time?
Yes, multiple clients to multiple databases.
2) Does PostGreSql have the ability to tag a Database/Table to be a
persistent or non-persistent database/table? By this question I mean,
that I may need to have a table that I don't want to be saved to the
hard disk/ flash file system and only want to keep it in memory and
other tables/database I may want to save to hard disk or flash. Does
PostGreSql allow for that?


You can mark a table as TEMPORARY which means it will only survive for the
length of a connection (and only be visible to that connection). I'm not sure
it makes sense to run the database from flash, but you could copy the data to
flash when you shut PG down.

--
Richard Huxton
Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Nov 11 '05 #4

P: n/a
On Friday 12 September 2003 18:38, Ish Ahluwalia wrote:
Hi:

I'm very new to PostGreSql database and actually looking to evaluate for
one of our project needs. Below please find some questions. I'm hoping
if I can get some insight into these questions.

Thanks.

Ish...

1) Does PostGreSql allows for multiple databases to be open at the same
time?
Yes, multiple clients to multiple databases.
2) Does PostGreSql have the ability to tag a Database/Table to be a
persistent or non-persistent database/table? By this question I mean,
that I may need to have a table that I don't want to be saved to the
hard disk/ flash file system and only want to keep it in memory and
other tables/database I may want to save to hard disk or flash. Does
PostGreSql allow for that?


You can mark a table as TEMPORARY which means it will only survive for the
length of a connection (and only be visible to that connection). I'm not sure
it makes sense to run the database from flash, but you could copy the data to
flash when you shut PG down.

--
Richard Huxton
Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Nov 11 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.