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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-hackers by date

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