Kris Kewley wrote:
Does postgres have the concept of "pinning" procs, functions, etc to
cache.
No. Everything that's in PostgreSQL's cache gets a usage count attached
to is. When the buffer is used by something else, that count gets
incremented. And when new buffers need to be allocated, t
Does postgres have the concept of "pinning" procs, functions, etc to
cache.
As you mention, typically frequently used statements are cached
improving performance.
If waiting for the DBMS to do this is not an option then pinning
critical ones should improve performance immediately followin
I have a very bit big database around 15 million in size, and the dump
file
is around 12 GB.
While importing this dump in to database I have noticed that initially
query
response time is very slow but it does improves with time.
Any suggestions to improve performance after dump in importe
On Sat, Dec 5, 2009 at 7:16 AM, "Ing . Marcos Luís Ortíz Valmaseda"
wrote:
> Ashish Kumar Singh escribió:
>>
>> Hello Everyone,
>>
>>
>> I have a very bit big database around 15 million in size, and the dump
>> file is around 12 GB.
>>
>> While importing this dump in to database I have noticed tha
On Wed, Dec 2, 2009 at 4:31 PM, Ashish Kumar Singh
wrote:
> Hello Everyone,
>
> I have a very bit big database around 15 million in size, and the dump file
> is around 12 GB.
>
> While importing this dump in to database I have noticed that initially query
> response time is very slow but it does i
Ashish Kumar Singh escribió:
Hello Everyone,
I have a very bit big database around 15 million in size, and the dump
file is around 12 GB.
While importing this dump in to database I have noticed that initially
query response time is very slow but it does improves with time.
Any suggesti
On 12/02/2009 11:31 PM, Ashish Kumar Singh wrote:
While importing this dump in to database I have noticed that initially
query response time is very slow but it does improves with time.
Any suggestions to improve performance after dump in imported in to
database will be highly appreciated!
Ana
