469,291 Members | 1,782 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,291 developers. It's quick & easy.

PostGreSql database features questions

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
4 3041
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
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
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
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.

Similar topics

1 post views Thread by Otis Green | last post: by
1 post views Thread by Mateusz [PEYN] Adamus | last post: by
reply views Thread by Ish Ahluwalia | last post: by
3 posts views Thread by Robert Abi Saab | last post: by
10 posts views Thread by Laimis K | last post: by
1 post views Thread by John Wells | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
reply views Thread by harlem98 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.