Extending tablespaces

Started by Gevik Babakhaniabout 19 years ago3 messages
#1Gevik Babakhani
pgdev@xs4all.nl

Recently I ran into a "disk full" problem with my database. I had to
play with the tablespaces and locations symlinks... until the disk could
be cleaned just enough for the database to continue operation. I had
plenty of space on another disk but found no *easy* way to humbly ask
postgres to continue using other empty disk.

I read the partitioning at
http://www.postgresql.org/docs/8.1/interactive/ddl-partitioning.html
but this unfortunately is not an option.

Now I am thinking what it would take to give pg the functionality to
extend tablespaces automatically.

Something like "ALTER TABLESPACE foo ADD LOCATION '/bar'" and then PG
can continue operation without notifying the disk is full...

I yet have to dive more deeply into the storage system to gain more
knowledge. I also realize that implementing something like this will
effect many things like VACUUM, pg_dump, indexing, sorting and the
entire storage system etc..etc..

I very much would like to know the communities opinion and thoughts
about this. Would this even be possible? Or I am just dreaming (again)
and scaring everyone else.

--
Regards,
Gevik Babakhani
www.postgresql.nl
www.truesoftware.nl

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Gevik Babakhani (#1)
Re: Extending tablespaces

Gevik Babakhani <pgdev@xs4all.nl> writes:

Now I am thinking what it would take to give pg the functionality to
extend tablespaces automatically.

It's called LVM ... and no, we are not interested in reimplementing
filesystem-level functionality ...

regards, tom lane

#3Gevik Babakhani
pgdev@xs4all.nl
In reply to: Tom Lane (#2)
Re: Extending tablespaces

Okay, thank you.

Show quoted text

On Thu, 2006-10-19 at 15:56 -0400, Tom Lane wrote:

Gevik Babakhani <pgdev@xs4all.nl> writes:

Now I am thinking what it would take to give pg the functionality to
extend tablespaces automatically.

It's called LVM ... and no, we are not interested in reimplementing
filesystem-level functionality ...

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly