| From: | Dani Oderbolz <oderbolz(at)ecologic(dot)de> |
|---|---|
| To: | "Wilson A(dot) Galafassi Jr(dot)" <juniorlist(at)yahoo(dot)com(dot)br> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: ext3 block size |
| Date: | 2003-08-08 15:39:46 |
| Message-ID: | 3F33C442.2000809@ecologic.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Wilson A. Galafassi Jr. wrote:
> hello.
> my database size is 5GB. what is the block size recommend?
> thanks
> wilson
Hmm, IMHO this depends more on your IO System
rather than on the DB size.
It doesnt make sense to have a blocksize which your IO System
(HD, Controller...) cannot fetch in one read.
And it also depends on the type of Processing you are doing.
If you will have mostly big tablescans, a big blocksize is good,
whereas if you will be doing lots of Index acess, a lower one
can make more sense.
(And also if you store lots of data in one row).
In general I guess 8K (the default) is ok,
but 16K can make sense.
Regards,
Dani
| From | Date | Subject | |
|---|---|---|---|
| Next Message | scott.marlowe | 2003-08-08 15:51:56 | Re: ext3 block size |
| Previous Message | Matt Clark | 2003-08-08 15:38:55 | Re: Cost estimates consistently too high - does it matter? |