zxo102 ouyang wrote:
Hi there,
Thanks for your suggestions. I do have an application running on the machine
all the time. In fact, the application keeps writing real-time monitoring
data into the database. Based on my understanding of your messages, I can't
do anything to speed up the
On Thu, May 28, 2009 01:23, Richard Huxton wrote:
zxo102 ouyang wrote:
Hi there,
Thanks for your suggestions. I do have an application running on the
machine
all the time. In fact, the application keeps writing real-time
monitoring
data into the database. Based on my understanding of your
Hi there,
Thanks for your suggestions. I do have an application running on the machine
all the time. In fact, the application keeps writing real-time monitoring
data into the database. Based on my understanding of your messages, I can't
do anything to speed up the first-time-searching. Probably I
Hi all,
I have a table which has more than 10millions records in pgsql which is
running on window 2003. During night, nobody search the database.
In morning, when people start to the application, it will take more than 30
seconds to get database back. After several times of same searching, the
zxo102 ouyang wrote:
Hi all,
I have a table which has more than 10millions records in pgsql
which is running on window 2003. During night, nobody search the
database. In morning, when people start to the application, it will
take more than 30 seconds to get database back. After several
On Tue, May 26, 2009 at 5:57 PM, zxo102 ouyang zxo...@gmail.com wrote:
Hi all,
I have a table which has more than 10millions records in pgsql which is
running on window 2003. During night, nobody search the database.
In morning, when people start to the application, it will take more than
On Tue, 26 May 2009, Scott Marlowe wrote:
Also, in the morning, have a cron job crank up that does select * from
mybigtable for each big table to load it into cache.
Just to clarify: on 8.3 and later versions, doing this doesn't do what
some people expect. Sequential scans like that will
Greg Smith gsm...@gregsmith.com writes:
On Tue, 26 May 2009, Scott Marlowe wrote:
Also, in the morning, have a cron job crank up that does select * from
mybigtable for each big table to load it into cache.
Just to clarify: on 8.3 and later versions, doing this doesn't do what
some people
On Tue, May 26, 2009 at 7:43 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Greg Smith gsm...@gregsmith.com writes:
On Tue, 26 May 2009, Scott Marlowe wrote:
Also, in the morning, have a cron job crank up that does select * from
mybigtable for each big table to load it into cache.
Just to clarify: