Postgres Pro
Downloads
Home   >   mailing lists

Re: Transient plans versus the SPI API - Mailing list pgsql-hackers

From Dimitri Fontaine
Subject Re: Transient plans versus the SPI API
Date
Msg-id 87zkjqekkf.fsf@hi-media-techno.com
Whole thread Raw
In response to Transient plans versus the SPI API  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Transient plans versus the SPI API
List pgsql-hackers
Tree view 
Tom Lane <tgl@sss.pgh.pa.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

pgsql-hackers by date:

Previous
From: daveg
Date:
Subject: Re: error: could not find pg_class tuple for index 2662
Next
From: Robert Haas
Date:
Subject: Re: WIP: Fast GiST index build