TH &&, duration WITH &&)
WHERE (canceled IS FALSE AND user_ids IS NOT NULL AND duration IS NOT NULL);
# This takes forever minutes:
ALTER TABLE event_memberships2
ADD CONSTRAINT "exclude_overlap3" EXCLUDE
USING gist (user_ids WITH &&)
WHERE (canceled IS FALSE AND user_ids IS NOT NULL);
# This takes forever minutes:
ALTER TABLE event_memberships2
ADD CONSTRAINT "exclude_overlap3" EXCLUDE
USING gist (user_ids gist__intbig_ops WITH &&)
WHERE (canceled IS FALSE AND user_ids IS NOT NULL);
PostgreSQL: 9.6.2
So the question: does EXCLUDE CONSTRAINT works with array fields? Maybe I am
doing something wrong or don't understand problems with this indexes, which
building PostgreSQL.
In the meantime, thank you so much for your attention and participation.
--
Alexey Vasiliev
s to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
>
Ok. Just need to know what think another developers about this - should pgtune
care about this case? Because I am not sure, what users with 512GB will use
pgtune.
--
Alexey Vasiliev
--
Sent via pgsql
ed_buffers. This is archive of this chat:
http://www.postgresql.org/message-id/1395836511.796897...@f327.i.mail.ru
What is why so hard to understand what to do with pgtune calculation.
--
Alexey Vasiliev
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
(for
example).
But I don't know what type of calculation should be in this case. Does we have
in some place this information? Or someone can provide it? Because this
generator should be valid for most users.
Thanks.
---
Alexey Vasiliev
--
Sent via pgsql-performance mailing list (pgsql-
I read from several sources, what maximum shared_buffers is 8GB.
Does this true? If yes, why exactly this number is maximum number of
shared_buffers for good performance (on Linux 64-bits)?
Thanks!
