Re: [HACKERS] Proposal: global index

On Fri, Aug 25, 2017 at 6:52 AM, Ildar Musin wrote: > I agree with you that garbage collection after partitions drop could be a > major downside of single index scheme. On the other hand not all > partitioning use-cases imply dropping partitions. What worries me about >

Re: [HACKERS] Proposal: global index

On Fri, Aug 25, 2017 at 12:15 PM, Petr Jelinek wrote: > On 25/08/17 10:28, Chris Travers wrote: > > > > > > On Thu, Aug 24, 2017 at 9:44 PM, Andres Freund > > wrote: > > > > Hi, > > > > On 2017-08-18 12:12:58

Re: [HACKERS] Proposal: global index

Hi, On 24.08.2017 22:44, Andres Freund wrote: Hi, On 2017-08-18 12:12:58 +0300, Ildar Musin wrote: While we've been developing pg_pathman extension one of the most frequent questions we got from our users was about global index support. We cannot provide it within an extension. And I couldn't

Re: [HACKERS] Proposal: global index

On 25/08/17 10:28, Chris Travers wrote: > > > On Thu, Aug 24, 2017 at 9:44 PM, Andres Freund > wrote: > > Hi, > > On 2017-08-18 12:12:58 +0300, Ildar Musin wrote: > > While we've been developing pg_pathman extension one of the most

Re: [HACKERS] Proposal: global index

On Thu, Aug 24, 2017 at 9:44 PM, Andres Freund wrote: > Hi, > > On 2017-08-18 12:12:58 +0300, Ildar Musin wrote: > > While we've been developing pg_pathman extension one of the most frequent > > questions we got from our users was about global index support. We cannot > >

Re: [HACKERS] Proposal: global index

Hi, On 2017-08-18 12:12:58 +0300, Ildar Musin wrote: > While we've been developing pg_pathman extension one of the most frequent > questions we got from our users was about global index support. We cannot > provide it within an extension. And I couldn't find any recent discussion > about someone

Re: [HACKERS] Proposal: global index

On 08/24/2017 10:52 AM, Adam Brusselback wrote: My understanding is that global indexes allow foreign keys to work naturally with partitioned tables, or tables in an inheritance hierarchy. That is pretty big IMO, as it allows you to partition a table without making a trade-off in your

Re: [HACKERS] Proposal: global index

My understanding is that global indexes allow foreign keys to work naturally with partitioned tables, or tables in an inheritance hierarchy. That is pretty big IMO, as it allows you to partition a table without making a trade-off in your database integrity.

Re: [HACKERS] Proposal: global index

On Aug 21, 2017 07:47, "Simon Riggs" wrote: On 18 August 2017 at 15:40, Alvaro Herrera wrote: > Ildar Musin wrote: > >> While we've been developing pg_pathman extension one of the most frequent >> questions we got from our users was about global

Re: [HACKERS] Proposal: global index

On 18 August 2017 at 15:40, Alvaro Herrera wrote: > Ildar Musin wrote: > >> While we've been developing pg_pathman extension one of the most frequent >> questions we got from our users was about global index support. We cannot >> provide it within an extension. And I

Re: [HACKERS] Proposal: global index

Ildar Musin wrote: > I found the thread about indirect indexes > (https://www.postgresql.org/message-id/20161018182843.xczrxsa2yd47pnru%40alvherre.pgsql), > but it seems that it haven't been updated for some time and I couldn't > find InMemoryIndexTuple in the latest patch. Is there a newer

Re: [HACKERS] Proposal: global index

18/08/2017 17:40, Alvaro Herrera пишет: > Ildar Musin wrote: > >> While we've been developing pg_pathman extension one of the most frequent >> questions we got from our users was about global index support. We cannot >> provide it within an extension. And I couldn't find any recent discussion >>

Re: [HACKERS] Proposal: global index

18/08/2017 17:45, Alvaro Herrera пишет: > Erikjan Rijkers wrote: >> On 2017-08-18 11:12, Ildar Musin wrote: >>> Hi hackers, >>> >>> While we've been developing pg_pathman extension one of the most >>> frequent questions we got from our users was about global index >>> support. We cannot provide

Re: [HACKERS] Proposal: global index

Erikjan Rijkers wrote: > On 2017-08-18 11:12, Ildar Musin wrote: > > Hi hackers, > > > > While we've been developing pg_pathman extension one of the most > > frequent questions we got from our users was about global index > > support. We cannot provide it within an extension. And I couldn't find

Re: [HACKERS] Proposal: global index

Ildar Musin wrote: > While we've been developing pg_pathman extension one of the most frequent > questions we got from our users was about global index support. We cannot > provide it within an extension. And I couldn't find any recent discussion > about someone implementing it. So I'm thinking

Re: [HACKERS] Proposal: global index

On 2017-08-18 11:12, Ildar Musin wrote: Hi hackers, While we've been developing pg_pathman extension one of the most frequent questions we got from our users was about global index support. We cannot provide it within an extension. And I couldn't find any recent discussion about someone

Re: [HACKERS] Proposal: global index

Hi Chris, On 18.08.2017 16:15, Chris Travers wrote: I would really like to see global indexes. It would make things a lot easier for things like unique constraints across table inheritance trees. On Fri, Aug 18, 2017 at 11:12 AM, Ildar Musin

Re: [HACKERS] Proposal: global index

I would really like to see global indexes. It would make things a lot easier for things like unique constraints across table inheritance trees. On Fri, Aug 18, 2017 at 11:12 AM, Ildar Musin wrote: > Hi hackers, > > While we've been developing pg_pathman extension one of

[HACKERS] Proposal: global index

Hi hackers, While we've been developing pg_pathman extension one of the most frequent questions we got from our users was about global index support. We cannot provide it within an extension. And I couldn't find any recent discussion about someone implementing it. So I'm thinking about giving