vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| Dragan Zubac wrote: > Hello > > Does anybody knows the Postgres v8.0.3 data directory hierarchy ? > What is the purpose of the multiply files such as: > > 50000 > 50000.1 > 50000.2 > 50000.3 > > each of the same size ? > those are the 1 gigabyte segments of your table/index/relation. see the storage section of the documentation. -- Larry Rosenman Database Support Engineer PERVASIVE SOFTWARE. INC. 12365B RIATA TRACE PKWY 3015 AUSTIN TX 78727-6531 Tel: 512.231.6173 Fax: 512.231.6597 Email: Larry.Rosenman@pervasive.com Web: www.pervasive.com ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend |