--0016361640c542882b0473938744
Content-Type: text/plain; charset=ISO-8859-1
On Fri, Sep 11, 2009 at 9:29 AM, Kevin Kempter
<kevink [at] consistentstate.com>wrote:
> Hi all;
>
> How / where can I find which tablespace the indexes live in?
>
>
>
you can find which tablespace the indexes live in, by using below sql
command:-
postgres=# select c.relname,t.spcname from pg_class c,pg_tablespace t where
relkind='i' and c.reltablespace=t.oid ;
Regards
Raghu Ram
--0016361640c542882b0473938744
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
<br><br><div class=3D"gmail_quote">On Fri, Sep 11, 2009 at 9:29 AM, Kevin K=
empter <span dir=3D"ltr"><<a href=3D"mailto:kevink [at] consistentstate.com">=
kevink [at] consistentstate.com</a>></span> wrote:<br><blockquote class=3D"gm=
ail_quote" style=3D"border-left: 1px solid rgb(204, 204, 204); margin: 0pt =
0pt 0pt 0.8ex; padding-left: 1ex;">
Hi all;<br>
<br>
How / where can I find which tablespace the indexes live in?<br>
<br>
<font color=3D"#888888"><br></font></blockquote><div><br>you can find which=
tablespace the indexes live in, by using below sql command:-<br><br></div>=
</div>postgres=3D# select c.relname,t.spcname from pg_class c,pg_tablespace=
t where relkind=3D'i' and c.reltablespace=3Dt.oid ;<br>
<br><br>Regards<br>Raghu Ram<br><input id=3D"gwProxy" type=3D"hidden"><inpu=
t onclick=3D"jsCall();" id=3D"jsProxy" type=3D"hidden"><div id=3D"refHTML">=
</div>
--0016361640c542882b0473938744--
