Does PG has its own data cache? I don't think so.
I think PG just using the filesystem cache.
On Fri, Jul 10, 2015 at 2:06 AM, Andy Colson wrote:
> On 7/9/2015 12:41 PM, Tom Lane wrote:
>
>> Andy Colson writes:
>>
>>> My question is: Will PG cache only the index (assuming it can always do
>>>
dex.
>
>
>
> Bye
>
> Charles
>
>
>
>
>
> *From:* pgsql-general-ow...@postgresql.org [mailto:
> pgsql-general-ow...@postgresql.org] *On Behalf Of *John R Pierce
> *Sent:* Montag, 29. Juni 2015 07:51
> *To:* pgsql-general@postgresql.org
> *Subject:* Re: [GEN
/2015 10:08 PM, Shujie Shang wrote:
>
> create type info as (id int, name text);
> I want to create index on info.id.
>
>
> you can't create an index on a type, just on a table.
>
> create table info (id serial primary key, name text);
>
> or
>
> crea
Hi, All:
I want to create a index on one field of udt, how can I do that?
e.g
create type info as (id int, name text);
I want to create index on info.id.
Thanks
Hi,
I want to ask a question about json index.
Can I make a index on a field of a json column?
e.g, for table 'json_tab' you given, can I run something like "create index
'json_index' on json_tab::key"?
On Mon, Mar 30, 2015 at 6:11 PM, Michael Paquier
wrote:
>
>
> On Mon, Mar 30, 2015 at 6:54 PM
