Skip site navigation (1) Skip section navigation (2)

Re: Transient plans versus the SPI API

From: Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: Transient plans versus the SPI API
Date: 2011-08-03 12:38:56
Message-ID: 87zkjqekkf.fsf@hi-media-techno.com (view raw or flat)
Thread:
Lists: pgsql-hackers
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:
> Anyone have an opinion about that?

I still have this application where PREPARE takes between 50ms and 300ms
and EXECUTE 5ms to 10ms, and I can handle 1 PREPARE for 10000 EXECUTE
quite easily.  (Yes the database fits in RAM, and yes when that's no
longer the case we just upgrade the hardware)

What does your proposal mean for such a use case?

Regards,
-- 
Dimitri Fontaine
http://2ndQuadrant.fr     PostgreSQL : Expertise, Formation et Support

In response to

Responses

pgsql-hackers by date

Next:From: Robert HaasDate: 2011-08-03 12:59:47
Subject: Re: WIP: Fast GiST index build
Previous:From: davegDate: 2011-08-03 11:57:31
Subject: Re: error: could not find pg_class tuple for index 2662

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group