Jira (PDB-5252) Determine size impact of trigram indexes on facts
Title: Message Title Andrei Filipovici commented on PDB-5252 Re: Determine size impact of trigram indexes on facts In summary: how much space does an index for a fact take (sandbox size on disk and index size obtain with SQL query)? The used space for a GIN index is between 3 to 9 mb and for a GIST index is between 3 and 10 mb. how much space do 10 indexes take? 10 GIN indexers used 56 mb and the GIST indexers used 77 mb. is there any performance decrease on ingestion? When we first run the ingestion benchmark we got a time of 263 seconds and after we added a GIN index we got a time of 49 sec. The time remained the same with 10 GIN indexers. With 10 GIST indexers the time increased to 51 sec. I think the impact of 10 indexers in negligible. Add Comment This message was sent by Atlassian Jira (v8.13.2#813002-sha1:c495a97) -- You received this message because you are subscribed to the Google Groups "Puppet Bugs" group. To unsubscribe from this group and stop receiving emails from it, send an email to puppet-bugs+unsubscr...@googlegroups.com. To view this discussion on the web visit
Jira (PDB-5252) Determine size impact of trigram indexes on facts
Title: Message Title Andrei Filipovici commented on PDB-5252 Re: Determine size impact of trigram indexes on facts After that I deleted all the GIN indexes, run a vacuum full and recreated all indexes as GIST. Add Comment This message was sent by Atlassian Jira (v8.13.2#813002-sha1:c495a97) -- You received this message because you are subscribed to the Google Groups "Puppet Bugs" group. To unsubscribe from this group and stop receiving emails from it, send an email to puppet-bugs+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/puppet-bugs/JIRA.413371.1629877927000.117345.1629988140145%40Atlassian.JIRA.
Jira (PDB-5252) Determine size impact of trigram indexes on facts
Title: Message Title Andrei Filipovici commented on PDB-5252 Re: Determine size impact of trigram indexes on facts After I started PDB the sandbox shrunk to 22729 mb / 23832150982 bytes. After adding the remaining 9 indexes the sandbox size was 22766 mb / 23871586932 bytes. Total indexes size on table factsets was 151 mb / 158687232 bytes. Individual index size was: relation |size ---+ public.idx_factsets_jsonb_merged | 90 MB public.factsets | 37 MB public.factsets_hash_expr_idx | 8848 kB public.factsets_operating_system_idx | 7312 kB public.factsets_fqdn_idx | 5112 kB public.factsets_os_family_idx | 4840 kB public.factsets_system_uptime_idx | 4824 kB public.factsets_virtual_idx | 4712 kB public.factsets_puppetversion_idx | 4680 kB public.factsets_kernel_idx
Jira (PDB-5252) Determine size impact of trigram indexes on facts
Title: Message Title Andrei Filipovici updated an issue PuppetDB / PDB-5252 Determine size impact of trigram indexes on facts Change By: Andrei Filipovici Summary: Determine size impact of trigram index indexes on facts Add Comment This message was sent by Atlassian Jira (v8.13.2#813002-sha1:c495a97) -- You received this message because you are subscribed to the Google Groups "Puppet Bugs" group. To unsubscribe from this group and stop receiving emails from it, send an email to puppet-bugs+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/puppet-bugs/JIRA.413371.1629877927000.117237.1629977220037%40Atlassian.JIRA.
