Re: [pgadmin-hackers] Postgresql 9.2, Memoy cache usage.

2014-12-17 Thread Gabriel Sánchez
On Tue, Dec 16, 2014 at 4:18 PM, Cristian Iturrieta wrote: > > Dear pgadmin-hackers, > > > >I have the following query: What could be due to a single query sql one > day run fast and another slow. > Hi Cristian. Since your question concerns the PostgreSQL database and not the pgAdmin client

[pgadmin-hackers] Postgresql 9.2, Memoy cache usage.

2014-12-17 Thread Cristian Iturrieta
Dear pgadmin-hackers, I have the following query: What could be due to a single query sql one day run fast and another slow. The database has massive loads overnight and the next day serves datawarehouse. This causes the first query is slower by having to go find all the information to disk.