亚洲av成人无遮挡网站在线观看,少妇性bbb搡bbb爽爽爽,亚洲av日韩精品久久久久久,兔费看少妇性l交大片免费,无码少妇一区二区三区

  免費(fèi)注冊 查看新帖 |

Chinaunix

  平臺(tái) 論壇 博客 文庫
最近訪問板塊 發(fā)新帖
查看: 2008 | 回復(fù): 0
打印 上一主題 下一主題

pg 7.4.2 estimate disk usage [復(fù)制鏈接]

論壇徽章:
0
跳轉(zhuǎn)到指定樓層
1 [收藏(0)] [報(bào)告]
發(fā)表于 2004-06-05 08:54 |只看該作者 |倒序?yàn)g覽
sorry to type english.

is there a general rule of counting disk space usage?

for example, one table with 3 integer columns, no index.
what's the expected disk usage of 100k rows, 1M rows, 10M rows, etc.

integer is 32 bit, so 4 bytes.  and with some overhead..

but it seems like pg is using more space than i expect.

i have installed oid2name and dbsize.  but don't seem to tell me why it's taking more space.

also, it's brand new inserts.  no updates, no deletes.  so should be nothing really to vacuum.

any suggestions?
您需要登錄后才可以回帖 登錄 | 注冊

本版積分規(guī)則 發(fā)表回復(fù)

  

北京盛拓優(yōu)訊信息技術(shù)有限公司. 版權(quán)所有 京ICP備16024965號(hào)-6 北京市公安局海淀分局網(wǎng)監(jiān)中心備案編號(hào):11010802020122 niuxiaotong@pcpop.com 17352615567
未成年舉報(bào)專區(qū)
中國互聯(lián)網(wǎng)協(xié)會(huì)會(huì)員  聯(lián)系我們:huangweiwei@itpub.net
感謝所有關(guān)心和支持過ChinaUnix的朋友們 轉(zhuǎn)載本站內(nèi)容請注明原作者名及出處

清除 Cookies - ChinaUnix - Archiver - WAP - TOP