Re: [PERFORM] Best design for performance

2017-03-28 Thread Riaan Stander
On 2017-03-28 07:15 PM, Claudio Freire wrote: On Tue, Mar 28, 2017 at 9:41 AM, Riaan Stander wrote: CREATE TABLE [dbo].[usrUserRights] ( [UserId] [dbo].[dm_Id] NOT NULL, [SiteId] [dbo].[dm_Id] NOT NULL, [RightId] [dbo].[dm_Id] NOT NULL, CONSTRAINT [pk_usrUserRights

Re: [PERFORM] Best design for performance

2017-03-28 Thread Claudio Freire
On Tue, Mar 28, 2017 at 9:41 AM, Riaan Stander wrote: > CREATE TABLE [dbo].[usrUserRights] ( > [UserId] [dbo].[dm_Id] NOT NULL, > [SiteId] [dbo].[dm_Id] NOT NULL, > [RightId] [dbo].[dm_Id] NOT NULL, > CONSTRAINT [pk_usrUserRights_UserId_RightId_SiteId] PRIMARY KEY > CLUST

Re: [PERFORM] Best design for performance

2017-03-28 Thread Riaan Stander
On 28 Mar 2017 4:22 AM, Claudio Freire wrote: From: Claudio Freire [mailto:klaussfre...@gmail.com] How did you query the table's size? You're probably failing to account for TOAST tables. I'd suggest using pg_total_relation_size. ... On Mon, Mar 27, 2017 at 10:17 PM, Riaan Stander wrote: I'