pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
ext3 block size
2+ messages / 2 participants
[nested] [flat]

* ext3 block size
@ 2003-08-06 20:34  Wilson A. Galafassi Jr. <juniorlist@yahoo.com.br>
  0 siblings, 1 reply; 2+ messages in thread

From: Wilson A. Galafassi Jr. @ 2003-08-06 20:34 UTC (permalink / raw)
  To: pgsql-performance

hello.
my database size is 5GB. what is the block size recommend?
thanks
wilson

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: ext3 block size
@ 2003-08-06 20:37  scott.marlowe <scott.marlowe@ihs.com>
  parent: Wilson A. Galafassi Jr. <juniorlist@yahoo.com.br>
  0 siblings, 0 replies; 2+ messages in thread

From: scott.marlowe @ 2003-08-06 20:37 UTC (permalink / raw)
  To: Wilson A. Galafassi Jr. <juniorlist@yahoo.com.br>; +Cc: pgsql-performance

On Wed, 6 Aug 2003, Wilson A. Galafassi Jr. wrote:

> hello.
> my database size is 5GB. what is the block size recommend?

Well, the biggest block size currently supported by stock linux distros is 
4k, so I'd go with that.  Postgresql's default block size of 8k is fine 
also.  Note that linux page/system/file block sizes are NOT related to 
Postgresql block sizes.




^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2003-08-06 20:37 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-08-06 20:34 ext3 block size Wilson A. Galafassi Jr. <juniorlist@yahoo.com.br>
2003-08-06 20:37 ` scott.marlowe <scott.marlowe@ihs.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox