tablespace and sequences?

Поиск
Список
Период
Сортировка
От Fabien COELHO
Тема tablespace and sequences?
Дата
Msg-id Pine.LNX.4.58.0408171615180.30419@sablons.cri.ensmp.fr
обсуждение исходный текст
Ответы Re: tablespace and sequences?  (Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>)
Re: tablespace and sequences?  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: tablespace and sequences?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Dear hackers,

Some minor comments about the new tablespace feature in 8.0beta1:

It seems to me that tablespaces and sequences are not yet prefectly
integrated.

(1) the "CREATE SEQUENCE foo TABLESPACE disk2" syntax does not seem   to be implemented.

(2) when creating an implicit sequence with SERIAL, the sequence   is created in the tablespace of the schema/database,
notthe one   of the table, although indexes are added to the tablespace   of the table. It would seem more logical to
putit in   the same table space as the table by default?
 

(3) psql auto completion does not have "CREATE/DROP TABLESPACE" in   its list.

Maybe these non-important issues could be added to the TODO list.
I've noticed some todos about tablespaces, but not these.

Have a nice day,

-- 
Fabien Coelho - coelho@cri.ensmp.fr


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Gaetano Mendola
Дата:
Сообщение: vacuums and ctid
Следующее
От: Tom Lane
Дата:
Сообщение: Re: too short string for SQL in pg_stat_backend_activity