pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedQuery in cache
8+ messages / 5 participants
[nested] [flat]
* Query in cache
@ 2013-11-18 16:38 Rogerio Pereira <rogerio.pereira@riosoft.com.br>
0 siblings, 3 replies; 8+ messages in thread
From: Rogerio Pereira @ 2013-11-18 16:38 UTC (permalink / raw)
To: pgsql-performance
Hi,
I am need help, about subject "Query cache in Postgres".
how is it possible to put sql statements cached in postgres ?
I did some tests and I can not get even with improved tuning
parameters in the postgresql.conf.
Regards,
--
Assinatura de E-mail padrão Riosoft 20 anos
*Rogerio Pereira *
rogerio.pereira@riosoft.com.br
Riosoft - Sistemas para Gestão Empresarial <http://www.riosoft.com.br;
Respeite o meio-ambiente, não desperdice papel, imprima somente o
necessário.
Esta mensagem, incluindo os seus anexos, contém informações
confidenciais destinadas a indivíduo e propósito específicos e é
protegida por lei. Caso você não seja o destinatário desta mensagem,
deve apagá-la. É proibida a utilização, acesso, cópia ou divulgação não
autorizada das informações presentes neste e-mail. As informações
contidas nesta mensagem e em seus anexos são de responsabilidade de seu
autor, não representando idéias, opiniões, pensamentos da Riosoft.
Attachments:
imgAssinaPadrao.jpg (image/jpeg, 7.1K) download
view image
* Re: Query in cache
@ 2013-11-18 16:43 Andreas Kretschmer <akretschmer@spamfence.net>
parent: Rogerio Pereira <rogerio.pereira@riosoft.com.br>
2 siblings, 1 reply; 8+ messages in thread
From: Andreas Kretschmer @ 2013-11-18 16:43 UTC (permalink / raw)
To: pgsql-performance
Rogerio Pereira <rogerio.pereira@riosoft.com.br> wrote:
> Hi,
>
> I am need help, about subject "Query cache in Postgres".
> how is it possible to put sql statements cached in postgres ?
> I did some tests and I can not get even with improved tuning
> parameters in the postgresql.conf.
No, there isn't something like a query cache. But you can use
materialized views, since 9.3.
Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknown)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Query in cache
@ 2013-11-18 16:57 ktm@rice.edu <ktm@rice.edu>
parent: Rogerio Pereira <rogerio.pereira@riosoft.com.br>
2 siblings, 1 reply; 8+ messages in thread
From: ktm@rice.edu @ 2013-11-18 16:57 UTC (permalink / raw)
To: Rogerio Pereira <rogerio.pereira@riosoft.com.br>; +Cc: pgsql-performance
On Mon, Nov 18, 2013 at 02:38:09PM -0200, Rogerio Pereira wrote:
> Hi,
>
> I am need help, about subject "Query cache in Postgres".
> how is it possible to put sql statements cached in postgres ?
> I did some tests and I can not get even with improved tuning
> parameters in the postgresql.conf.
>
> Regards,
>
Hi Rogerio,
PostgreSQL does not have a query cache. I think you would need to
roll your own.
Regards,
Ken
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Query in cache
@ 2013-11-19 00:36 salah jubeh <s_jubeh@yahoo.com>
parent: Andreas Kretschmer <akretschmer@spamfence.net>
0 siblings, 1 reply; 8+ messages in thread
From: salah jubeh @ 2013-11-19 00:36 UTC (permalink / raw)
To: Andreas Kretschmer <akretschmer@spamfence.net>; pgsql-performance
Hello,
pgpool supports memcache.
Regards
On Monday, November 18, 2013 6:29 PM, Andreas Kretschmer <akretschmer@spamfence.net> wrote:
Rogerio Pereira <rogerio.pereira@riosoft.com.br> wrote:
> Hi,
>
> I am need help, about subject "Query cache in Postgres".
> how is it possible to put sql statements cached in postgres ?
> I did some tests and I can not get even with improved tuning
> parameters in the postgresql.conf.
No, there isn't something like a query cache. But you can use
materialized views, since 9.3.
Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknown)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Query in cache
@ 2013-11-19 01:37 Sergey Konoplev <gray.ru@gmail.com>
parent: Rogerio Pereira <rogerio.pereira@riosoft.com.br>
2 siblings, 0 replies; 8+ messages in thread
From: Sergey Konoplev @ 2013-11-19 01:37 UTC (permalink / raw)
To: Rogerio Pereira <rogerio.pereira@riosoft.com.br>; +Cc: pgsql-performance
2013/11/18 Rogerio Pereira <rogerio.pereira@riosoft.com.br>
> I am need help, about subject "Query cache in Postgres".
> how is it possible to put sql statements cached in postgres ?
> I did some tests and I can not get even with improved tuning
> parameters in the postgresql.conf.
Are you talking about prepared statements or about query result caching?
If former then you need to look at the PREPARE for execute statement
[1], though it is probably implemented in your data adapter, for
example like it is in DBD::Pg [2]. Also take a look at the pre_prepare
module [3], that can conveniently be used with pgbouncer.
If later then there is an extension named pgmemcache [4] that will
allow you to interact with memcached directly from postgres, so you
could implement cashing in stored functions, for example. However my
advice is to use application level caching with memcached in this
case, not the database level one.
[1] http://www.postgresql.org/docs/9.3/static/sql-prepare.html
[2] http://search.cpan.org/dist/DBD-Pg/Pg.pm#prepare
[3] https://github.com/dimitri/preprepare
[4] https://github.com/ohmu/pgmemcache/
--
Kind regards,
Sergey Konoplev
PostgreSQL Consultant and DBA
http://www.linkedin.com/in/grayhemp
+1 (415) 867-9984, +7 (901) 903-0499, +7 (988) 888-1979
gray.ru@gmail.com
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Query in cache
@ 2013-11-19 14:00 ktm@rice.edu <ktm@rice.edu>
parent: salah jubeh <s_jubeh@yahoo.com>
0 siblings, 1 reply; 8+ messages in thread
From: ktm@rice.edu @ 2013-11-19 14:00 UTC (permalink / raw)
To: salah jubeh <s_jubeh@yahoo.com>; +Cc: Andreas Kretschmer <akretschmer@spamfence.net>; pgsql-performance
On Mon, Nov 18, 2013 at 04:36:20PM -0800, salah jubeh wrote:
> Hello,
>
> pgpool supports memcache.
> Regards
>
Very cool. I had missed that in the release announcement.
Regards,
Ken
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Query in cache
@ 2013-11-19 15:50 Rogerio Pereira <rogerio.pereira@riosoft.com.br>
parent: ktm@rice.edu <ktm@rice.edu>
0 siblings, 0 replies; 8+ messages in thread
From: Rogerio Pereira @ 2013-11-19 15:50 UTC (permalink / raw)
To: ktm@rice.edu <ktm@rice.edu>; salah jubeh <s_jubeh@yahoo.com>; +Cc: Andreas Kretschmer <akretschmer@spamfence.net>; pgsql-performance
Hi,
Is possible send howto to active 'feature' ?
Regards,
Rogerio
Em 19/11/2013 12:00, ktm@rice.edu escreveu:
> On Mon, Nov 18, 2013 at 04:36:20PM -0800, salah jubeh wrote:
>> Hello,
>>
>> pgpool supports memcache.
>> Regards
>>
> Very cool. I had missed that in the release announcement.
>
> Regards,
> Ken
>
>
--
Assinatura de E-mail padrão Riosoft 20 anos
*Rogerio Pereira *
Dba | Tel. 55 (17) 3215-9199 | rogerio.pereira@riosoft.com.br
Riosoft - Sistemas para Gestão Empresarial <http://www.riosoft.com.br;
Respeite o meio-ambiente, não desperdice papel, imprima somente o
necessário.
Esta mensagem, incluindo os seus anexos, contém informações
confidenciais destinadas a indivíduo e propósito específicos e é
protegida por lei. Caso você não seja o destinatário desta mensagem,
deve apagá-la. É proibida a utilização, acesso, cópia ou divulgação não
autorizada das informações presentes neste e-mail. As informações
contidas nesta mensagem e em seus anexos são de responsabilidade de seu
autor, não representando idéias, opiniões, pensamentos da Riosoft.
Attachments:
imgAssinaPadrao.jpg (image/jpeg, 7.1K) download
view image
* Re: Query in cache
@ 2013-11-22 12:06 Rogerio Pereira <rogerio.pereira@riosoft.com.br>
parent: ktm@rice.edu <ktm@rice.edu>
0 siblings, 0 replies; 8+ messages in thread
From: Rogerio Pereira @ 2013-11-22 12:06 UTC (permalink / raw)
To: ; +Cc: pgsql-performance
Hi,
What is the maximum amount of VM that can be created?
Version 9.3
Tks,
--
Assinatura de E-mail padrão Riosoft 20 anos
*Rogerio Pereira *
Dba | Tel. 55 (17) 3215-9199 | rogerio.pereira@riosoft.com.br
Riosoft - Sistemas para Gestão Empresarial <http://www.riosoft.com.br;
Respeite o meio-ambiente, não desperdice papel, imprima somente o
necessário.
Esta mensagem, incluindo os seus anexos, contém informações
confidenciais destinadas a indivíduo e propósito específicos e é
protegida por lei. Caso você não seja o destinatário desta mensagem,
deve apagá-la. É proibida a utilização, acesso, cópia ou divulgação não
autorizada das informações presentes neste e-mail. As informações
contidas nesta mensagem e em seus anexos são de responsabilidade de seu
autor, não representando idéias, opiniões, pensamentos da Riosoft.
Attachments:
imgAssinaPadrao.jpg (image/jpeg, 7.1K) download
view image
end of thread, other threads:[~2013-11-22 12:06 UTC | newest]
Thread overview: 8+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2013-11-18 16:38 Query in cache Rogerio Pereira <rogerio.pereira@riosoft.com.br>
2013-11-18 16:43 ` Andreas Kretschmer <akretschmer@spamfence.net>
2013-11-19 00:36 ` salah jubeh <s_jubeh@yahoo.com>
2013-11-19 14:00 ` ktm@rice.edu <ktm@rice.edu>
2013-11-19 15:50 ` Rogerio Pereira <rogerio.pereira@riosoft.com.br>
2013-11-18 16:57 ` ktm@rice.edu <ktm@rice.edu>
2013-11-22 12:06 ` Rogerio Pereira <rogerio.pereira@riosoft.com.br>
2013-11-19 01:37 ` Sergey Konoplev <gray.ru@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