pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
System Area 3+ messages / 3 participants [nested] [flat]
* System Area @ 2007-02-01 11:11 Alexander B. <burbello3000@yahoo.com.br> 0 siblings, 1 reply; 3+ messages in thread From: Alexander B. @ 2007-02-01 11:11 UTC (permalink / raw) To: pgsql-admin Hi, I would like to know if Postgres has shared memory like Library Cache (avoid to do parse the same sql), Dictionary Cache (metadata information), Sort Area and so on? Oracle has this structures. And Postgres? I couldn't find anything about memory on Postgres. Thanks. _______________________________________________________ Yahoo! Mail - Sempre a melhor opção para você! Experimente já e veja as novidades. http://br.yahoo.com/mailbeta/tudonovo/ ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: System Area @ 2007-02-01 12:23 Achilleas Mantzios <achill@matrix.gatewaynet.com> parent: Alexander B. <burbello3000@yahoo.com.br> 0 siblings, 1 reply; 3+ messages in thread From: Achilleas Mantzios @ 2007-02-01 12:23 UTC (permalink / raw) To: pgsql-admin Στις Πέμπτη 01 Φεβρουάριος 2007 13:11, ο/η Alexander B. έγραψε: > Hi, > > I would like to know if Postgres has shared memory like Library Cache > (avoid to do parse the same sql), Dictionary Cache (metadata > information), Sort Area and so on? Yes, PostgreSQL makes use of SYSV IPC shared mem and semaphores. > > Oracle has this structures. And Postgres? > I couldn't find anything about memory on Postgres. > > Thanks. > > > > > > _______________________________________________________ > Yahoo! Mail - Sempre a melhor opção para você! > Experimente já e veja as novidades. > http://br.yahoo.com/mailbeta/tudonovo/ > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org -- Achilleas Mantzios ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: System Area @ 2007-02-01 13:54 Jonah H. Harris <jonah.harris@gmail.com> parent: Achilleas Mantzios <achill@matrix.gatewaynet.com> 0 siblings, 0 replies; 3+ messages in thread From: Jonah H. Harris @ 2007-02-01 13:54 UTC (permalink / raw) To: Achilleas Mantzios <achill@matrix.gatewaynet.com>; +Cc: pgsql-admin On 2/1/07, Achilleas Mantzios <achill@matrix.gatewaynet.com> wrote: > > I would like to know if Postgres has shared memory like Library Cache > > (avoid to do parse the same sql), Dictionary Cache (metadata > > information), Sort Area and so on? > > Yes, PostgreSQL makes use of SYSV IPC shared mem and semaphores. That's not the question that was asked though. The correct answer is no, PostgreSQL does not have a global statement caching subsystem like Oracle's Library Cache. The majority of PostgreSQL caches are backend-local... which means that each backend maintains its own cache. PostgreSQL has no algorithms similar to a hard, soft, or soft-soft parse; it's all hard parsing in PostgreSQL unless you explicitly prepare a statement. Keep in mind that, once your session is terminated, so is all of your cache data (including prepared statements). This isn't too much of an issue on a connection-pooled system, but if you have lots of client/server activity, you'll want to make sure you use prepared statements. > > Oracle has this structures. And Postgres? > > I couldn't find anything about memory on Postgres. PostgreSQL uses shared memory, but it's primarily for the buffer cache and some shared variables. -- Jonah H. Harris, Software Architect | phone: 732.331.1324 EnterpriseDB Corporation | fax: 732.331.1301 33 Wood Ave S, 3rd Floor | jharris@enterprisedb.com Iselin, New Jersey 08830 | http://www.enterprisedb.com/ ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2007-02-01 13:54 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2007-02-01 11:11 System Area Alexander B. <burbello3000@yahoo.com.br> 2007-02-01 12:23 ` Achilleas Mantzios <achill@matrix.gatewaynet.com> 2007-02-01 13:54 ` Jonah H. Harris <jonah.harris@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox