Unix Technical Forum

New feature proposal

This is a discussion on New feature proposal within the pgsql Hackers forums, part of the PostgreSQL category; --> Veil http://pgfoundry.org/projects/veil is currently not a very good Postgres citizen. It steals what little shared memory it needs from ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > pgsql Hackers

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-12-2008, 02:28 AM
Marc Munro
 
Posts: n/a
Default New feature proposal

Veil http://pgfoundry.org/projects/veil is currently not a very good
Postgres citizen. It steals what little shared memory it needs from
postgres' shared memory using ShmemAlloc().

For Postgres 8.2 I would like Veil to be a better citizen and use only
what shared memory has been reserved for postgres add-ins.

So, I would like to propose:
1) that a new shared memory area for add-ins be created
2) that it should be accessible only to add-ins specifically requesting
its use
3) that the size of this add-in memory be controlled through a new GUC
setting

If this proposal is acceptable, I'd like some suggestions for naming the
GUC. If not we will be stuck with add_in_shmem, specified in Kbytes.

My expectation is that this would be a very small change and one that I
am probably competent to make myself, with a little review from my
friends.

__
Marc



-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2.2 (GNU/Linux)

iD8DBQBEbROmUBr6u+c2wkERAo74AJ9DjJYCV1tRX3fbHg+OUT dAaqXLxQCePNzG
UuYAA/UuKrPCTfhqfd/GxMY=
=JCIU
-----END PGP SIGNATURE-----

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 04-12-2008, 02:29 AM
Simon Riggs
 
Posts: n/a
Default Re: New feature proposal

On Thu, 2006-05-18 at 17:39 -0700, Marc Munro wrote:

> For Postgres 8.2 I would like Veil to be a better citizen and use only
> what shared memory has been reserved for postgres add-ins.


How would Postgres ask the add-in how much memory it needs? How would
the add-in know how much has been reserved for it? How would an add-in
know whether it was the only add-in and whether it could take all of the
allocation?

--
Simon Riggs
EnterpriseDB http://www.enterprisedb.com


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

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 04-12-2008, 02:29 AM
Andreas Pflug
 
Posts: n/a
Default Re: New feature proposal

Marc Munro wrote:
> Veil http://pgfoundry.org/projects/veil is currently not a very good
> Postgres citizen. It steals what little shared memory it needs from
> postgres' shared memory using ShmemAlloc().
>
> For Postgres 8.2 I would like Veil to be a better citizen and use only
> what shared memory has been reserved for postgres add-ins.


Why should this be individually restricted? AFAICS Veil's functionality
would be essential to access row level ACL controlled tables, so if it
fails for low mem conditions it's much like a backend failure.

Regards,
Andreas

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 06:11 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com