[ADMIN] pg_dump, pg_restore and tablespaces

Hi: Let's say I have a database comprised of tables scattered over several tablespaces. Suppose I need to move the database to another server and I can't use the same pathnames for the tablespaces. Am I out of luck when it comes to using pg_dump and pg_restore? Thanks! -

[ADMIN] query planning and partitioned tables

Hi: I have a 440 million row table that I'm attempting to partition. The table is named 'pressure' and holds pressure data from an undersea sensor measuring wave height. The sensor reports every half second. The partitions are named 'p0', 'p1' ... 'pN' and are divvied according to measure

[ADMIN] pgstattuple, vacuum and free_space

Hi: I did the following after installing the pgstattuple contrib code: select * from pgstattuple('wind'); -[ RECORD 1 ]--+-- table_len | 224854016 tuple_count| 1492601 tuple_len | 207535124 tuple_percent | 92.3 dead_tuple_count | 11569 dead_tuple_len

[ADMIN] query concerning vacuum and tablespaces

Hi I have two general questions: Let's say I vacuum a table called 'foo'. Does that release memory for subsequent reuse by table 'barr'? Or is the marked memory restricted solely for later reuse by table 'foo'? I get the impression the latter is the case. I'm I mistaken? Is it possible