[HACKERS] is it possible to enlarge the TopMemoryContext?
Hello everybody, we've developed a function which reads a huge amount of data from postgres and, being recursive, does several memory-intensive elaborations and writes the results back on two postgres tables. No memory context switch has been done in our function. Now we have to compare this function with another one which performs the same elaborations but reads the data from a binary file and stores the results on another file. Both of them work exactly in the same way (as we've simply ported our postgres module to work in memory) but we've noticed a rather different memory usage in the two cases. The in-memory function seems to have a lot more of memory to work on, while the postgres one stops for memory exhausted as soon as the data size increases over a certain limit. As far as we know, this could be due to the limited size of the TopMemoryContext in which the dynamically loadable modules work. Is there a way to expand the size of memory available to our function? Thanks a lot! alice and lorena __ Yahoo! Mail: 6MB di spazio gratuito, 30MB per i tuoi allegati, l'antivirus, il filtro Anti-spam http://it.yahoo.com/mail_it/foot/?http://it.mail.yahoo.com/ ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
[HACKERS] disk pages, buffers and blocks
Hi, we'd like to know how disk pages map to disk blocks. In particular, looking at the code it seems that one page can be built on several disk blocks while in the first lines of bufpage.h it is said that a postgres disk page is an abstraction layered on top of *a* postgres disk block. As a matter of fact, it looks quite reasonable to have more than a block per page. We've also found out that a postgres buffer contains exactly one disk block, but we'd like to understand how pages, blocks and buffers relate to each other. Thank you very much for your help! regards, alice and lorena __ Yahoo! Cellulari: loghi, suonerie, picture message per il tuo telefonino http://it.yahoo.com/mail_it/foot/?http://it.mobile.yahoo.com/index2002.html ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] 7.4 Wishlist
Hi, although I'm just a novice in this mailing list I'd like to give my contribution to the 7.4 wishlist. I'd like to add to the PostgreSQL code some new low-level, primitive fuctions in order to give native support to FP-based algorithms for rule mining (Frequent Pattern Growth and extensions such as CLOSET and so on). As a matter of fact, this is more than just a wish to me... this is the task I have to accomplish for my thesis (I'm going to degree in Informatics Engineering at the Politecnico di Torino, Italy on next July), and so I can assure you that this will be done (and working) by the end of June. Obviously, any kind of hint and suggestion by you guruz is welcome! :) Bye, alice - Original Message - From: Christopher Kings-Lynne [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, November 29, 2002 7:51 PM Subject: [HACKERS] 7.4 Wishlist Hi guys, Just out of interest, if someone was going to pay you to hack on Postgres for 6 months, what would you like to code for 7.4? My ones are: * Compliant ADD COLUMN * Integrated full text indexes * pg_dump dependency ordering What would you guys do? Even if it isn't feasible right now... Chris ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html __ Scarica il nuovo Yahoo! Messenger: con webcam, nuove faccine e tante altre novità . http://it.yahoo.com/mail_it/foot/?http://it.messenger.yahoo.com/ ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly