pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: -EXT-Re: Table not using tsvector gin index and performance much worse than when it uses it.
4+ messages / 3 participants
[nested] [flat]
* Re: -EXT-Re: Table not using tsvector gin index and performance much worse than when it uses it.
@ 2017-04-06 00:09 Sfiligoi, Igor <Igor.Sfiligoi@ga.com>
2017-04-06 00:26 ` Re: -EXT-Re: Table not using tsvector gin index and performance much worse than when it uses it. rverghese <riyav@hotmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: Sfiligoi, Igor @ 2017-04-06 00:09 UTC (permalink / raw)
To: rverghese <riyav@hotmail.com>; pgsql-performance
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: -EXT-Re: Table not using tsvector gin index and performance much worse than when it uses it.
2017-04-06 00:09 Re: -EXT-Re: Table not using tsvector gin index and performance much worse than when it uses it. Sfiligoi, Igor <Igor.Sfiligoi@ga.com>
@ 2017-04-06 00:26 ` rverghese <riyav@hotmail.com>
2017-04-06 01:08 ` Re: -EXT-Re: Table not using tsvector gin index and performance much worse than when it uses it. Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 4+ messages in thread
From: rverghese @ 2017-04-06 00:26 UTC (permalink / raw)
To: pgsql-performance
Ok, appreciate the feedback.
Will play around with those settings as well. Maybe start with default which
is 50 I believe.
Thanks!
RV
--
View this message in context: http://www.postgresql-archive.org/Table-not-using-tsvector-gin-index-and-performance-much-worse-than...
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: -EXT-Re: Table not using tsvector gin index and performance much worse than when it uses it.
2017-04-06 00:09 Re: -EXT-Re: Table not using tsvector gin index and performance much worse than when it uses it. Sfiligoi, Igor <Igor.Sfiligoi@ga.com>
2017-04-06 00:26 ` Re: -EXT-Re: Table not using tsvector gin index and performance much worse than when it uses it. rverghese <riyav@hotmail.com>
@ 2017-04-06 01:08 ` Tom Lane <tgl@sss.pgh.pa.us>
2017-04-06 01:10 ` Re: -EXT-Re: Table not using tsvector gin index and performance much worse than when it uses it. rverghese <riyav@hotmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: Tom Lane @ 2017-04-06 01:08 UTC (permalink / raw)
To: rverghese <riyav@hotmail.com>; +Cc: pgsql-performance
rverghese <riyav@hotmail.com> writes:
> Will play around with those settings as well. Maybe start with default which
> is 50 I believe.
If you're on 9.5, auto-analyze does not result in a pending list flush,
so it's irrelevant to fixing your problem. (Assuming I've identified
the problem correctly.) But you do have gin_pending_list_limit, so see
what that does for you. Note you can set it either globally or per-index.
regards, tom lane
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: -EXT-Re: Table not using tsvector gin index and performance much worse than when it uses it.
2017-04-06 00:09 Re: -EXT-Re: Table not using tsvector gin index and performance much worse than when it uses it. Sfiligoi, Igor <Igor.Sfiligoi@ga.com>
2017-04-06 00:26 ` Re: -EXT-Re: Table not using tsvector gin index and performance much worse than when it uses it. rverghese <riyav@hotmail.com>
2017-04-06 01:08 ` Re: -EXT-Re: Table not using tsvector gin index and performance much worse than when it uses it. Tom Lane <tgl@sss.pgh.pa.us>
@ 2017-04-06 01:10 ` rverghese <riyav@hotmail.com>
0 siblings, 0 replies; 4+ messages in thread
From: rverghese @ 2017-04-06 01:10 UTC (permalink / raw)
To: pgsql-performance
Yup, I just found the per index option. Pretty cool. Will see what value is
optimal...
Thanks
RV
--
View this message in context: http://www.postgresql-archive.org/Table-not-using-tsvector-gin-index-and-performance-much-worse-than...
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2017-04-06 01:10 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2017-04-06 00:09 Re: -EXT-Re: Table not using tsvector gin index and performance much worse than when it uses it. Sfiligoi, Igor <Igor.Sfiligoi@ga.com>
2017-04-06 00:26 ` rverghese <riyav@hotmail.com>
2017-04-06 01:08 ` Tom Lane <tgl@sss.pgh.pa.us>
2017-04-06 01:10 ` rverghese <riyav@hotmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox