Re: Regrading brin_index on required column of the table

2018-09-20 Thread Alban Hertroys
a lot of data. >> On Wed, 19 Sep 2018 at 16:23, Durgamahesh Manne >> wrote: >> > >> > >> > >> > >> > >> > >> > On Wed, Sep 19, 2018 at 7:41 PM Igor Neyman wrote: >> >> >> >> >> >> >&g

Re: Regrading brin_index on required column of the table

2018-09-20 Thread Durgamahesh Manne
ues are distributed very unevenly (say 99.9% has >> false and 0.1% has true), you may get better results by excluding the >> records with 'true' values (instead of including those that are >> 'false'), for example by using a where not exists(...) subquery. &

Re: Regrading brin_index on required column of the table

2018-09-20 Thread Durgamahesh Manne
are > 'false'), for example by using a where not exists(...) subquery. > > Obviously, that still won't help if you're just fetching a lot of data. > On Wed, 19 Sep 2018 at 16:23, Durgamahesh Manne > wrote: > > > > > > > > > > &

Re: Regrading brin_index on required column of the table

2018-09-19 Thread Alban Hertroys
postgr...@gmail.com] >> Sent: Wednesday, September 19, 2018 10:04 AM >> To: Igor Neyman >> Subject: Re: Regrading brin_index on required column of the table >> >> On Wed, Sep 19, 2018 at 7:19 PM Igor Neyman wrote: >> >> >> >> From: Durgamahe

Re: Regrading brin_index on required column of the table

2018-09-19 Thread Durgamahesh Manne
On Wed, Sep 19, 2018 at 7:41 PM Igor Neyman wrote: > > > *From:* Durgamahesh Manne [mailto:maheshpostgr...@gmail.com] > *Sent:* Wednesday, September 19, 2018 10:04 AM > *To:* Igor Neyman > *Subject:* Re: Regrading brin_index on required column of the table > > On Wed,

RE: Regrading brin_index on required column of the table

2018-09-19 Thread Igor Neyman
From: Durgamahesh Manne [mailto:maheshpostgr...@gmail.com] Sent: Wednesday, September 19, 2018 9:43 AM To: PostgreSQL mailing lists Subject: Regrading brin_index on required column of the table WARNING: This email originated from outside of Perceptron! Please be mindful of PHISHING and MALWARE