Skip site navigation (1) Skip section navigation (2)

Re: postgresql is slow with larger table even it is in RAM

From: "sathiya psql" <sathiya(dot)psql(at)gmail(dot)com>
To: "Bill Moran" <wmoran(at)collaborativefusion(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: postgresql is slow with larger table even it is in RAM
Date: 2008-03-25 13:27:12
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
> Yes.  It takes your hardware about 3 seconds to read through 700M of ram.

> Keep in mind that you're not just reading RAM.  You're pushing system
> requests through the VFS layer of your operating system, which is treating
> the RAM like a disk (with cylinder groups and inodes and blocks, etc) so
> you have all that processing overhead as well.  What filesystem did you
> format the RAM disk with?

> Why are you doing this?  If you have enough RAM to store the table, why
> not just allocate it to shared buffers?

just allocating will  make read from hdd to RAM at first time, to eliminate

are you saying it will take 3 seconds surely if i have 50 lakh record

In response to


pgsql-performance by date

Next:From: Jurgen HaanDate: 2008-03-25 13:33:23
Subject: Re: PostgreSQL NetApp and NFS
Previous:From: Ivan VorasDate: 2008-03-25 13:16:43
Subject: Re: what is the maximum number of rows in a table in postgresql 8.1

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group