pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / 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>
  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:16  Stephen Frost <sfrost@snowman.net>
  parent: Ferrell, Denise D CTR NSWCDD, H11 <denise.ferrell.ctr@navy.mil>
  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