pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
PostgreSQL 9.3 ERROR 2+ messages / 2 participants [nested] [flat]
* PostgreSQL 9.3 ERROR @ 2017-01-18 20:01 Ferrell, Denise D CTR NSWCDD, H11 <denise.ferrell.ctr@navy.mil> 2017-01-18 20:16 ` Re: PostgreSQL 9.3 ERROR Stephen Frost <sfrost@snowman.net> 0 siblings, 1 reply; 2+ messages in thread From: Ferrell, Denise D CTR NSWCDD, H11 @ 2017-01-18 20:01 UTC (permalink / raw) To: pgsql-admin 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" I was under the impression that PostgreSQL allocates 1G per tablespace file. Thank you in advance. Denise Ferrell Attachments: smime.p7s (application/pkcs7-signature, 5.3K) download ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: PostgreSQL 9.3 ERROR 2017-01-18 20:01 PostgreSQL 9.3 ERROR Ferrell, Denise D CTR NSWCDD, H11 <denise.ferrell.ctr@navy.mil> @ 2017-01-18 20:16 ` Stephen Frost <sfrost@snowman.net> 0 siblings, 0 replies; 2+ messages in thread From: Stephen Frost @ 2017-01-18 20:16 UTC (permalink / raw) To: Ferrell, Denise D CTR NSWCDD, H11 <denise.ferrell.ctr@navy.mil>; +Cc: pgsql-admin Greetings Denise, * Ferrell, Denise D CTR NSWCDD, H11 (denise.ferrell.ctr@navy.mil) 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 Attachments: signature.asc (application/pgp-signature, 818B) download ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2017-01-18 20:16 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2017-01-18 20:01 PostgreSQL 9.3 ERROR Ferrell, Denise D CTR NSWCDD, H11 <denise.ferrell.ctr@navy.mil> 2017-01-18 20:16 ` Stephen Frost <sfrost@snowman.net>
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