pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / 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