Greetings Denise, * Ferrell, Denise D CTR NSWCDD, H11 (denise.ferrell.ctr@xxxxxxxx) wrote: > Running on Linux...has anyone else encountered this? > > Receiving the following error in the pg_log file: > > "could not extend the "pg_tblspc/23917/PG_9.3_201306121/16385/55041.5": wrote only 4096 of 8192 bytes at block 722183" That error indicates that the filesystem ran out of disk space. > I was under the impression that PostgreSQL allocates 1G per tablespace file. That is incorrect. In PostgreSQL, a "tablespace" is a directory. Every table in PostgreSQL consists of a set of files. None of the individual files for a PostgreSQL table will be larger than 1G, but PostgreSQL will use multiple files when it reaches 1G in size. In the above case, the table/index with relfilenode 55041 in the database with oid 16385 has grown to be over 5G in size. The files: 55041 55041.1 55041.2 55041.3 55041.4 55041.5 are all associated with that table/index. Thanks! Stephen
Attachment:
signature.asc
Description: Digital signature
