Heads up: native fulltext search on pgsql

Development-related discussion, including bundled plugins
User avatar
fox
^ me reading your posts ^
Posts: 6318
Joined: 27 Aug 2005, 22:53
Location: Saint-Petersburg, Russia
Contact:

Heads up: native fulltext search on pgsql

Postby fox » 04 Aug 2015, 14:09


nameless
Bear Rating Master
Bear Rating Master
Posts: 126
Joined: 28 Aug 2013, 20:33

Re: Heads up: native fulltext search on pgsql

Postby nameless » 04 Aug 2015, 18:24

This is probably gonna annoy some user on shared hosting :mrgreen:
Not that anyone here would care :lol:

User avatar
fox
^ me reading your posts ^
Posts: 6318
Joined: 27 Aug 2005, 22:53
Location: Saint-Petersburg, Russia
Contact:

Re: Heads up: native fulltext search on pgsql

Postby fox » 04 Aug 2015, 18:46

tbf i'm sure they are all using mysql

nameless
Bear Rating Master
Bear Rating Master
Posts: 126
Joined: 28 Aug 2013, 20:33

Re: Heads up: native fulltext search on pgsql

Postby nameless » 04 Aug 2015, 18:49

thats probably true
btw. update.php is processing more articles than it initially told me. is that something thats supposed to happen?

User avatar
fox
^ me reading your posts ^
Posts: 6318
Joined: 27 Aug 2005, 22:53
Location: Saint-Petersburg, Russia
Contact:

Re: Heads up: native fulltext search on pgsql

Postby fox » 04 Aug 2015, 18:57

anything is possible with my garbage coding

nameless
Bear Rating Master
Bear Rating Master
Posts: 126
Joined: 28 Aug 2013, 20:33

Re: Heads up: native fulltext search on pgsql

Postby nameless » 04 Aug 2015, 19:28

well i did breake some things, not all.
ttrss is now slow as fuck and the system tab in preferences keeps telling me an error occurred.

User avatar
fox
^ me reading your posts ^
Posts: 6318
Joined: 27 Aug 2005, 22:53
Location: Saint-Petersburg, Russia
Contact:

Re: Heads up: native fulltext search on pgsql

Postby fox » 04 Aug 2015, 19:36

you probably shouldn't run reindex in the background if your server can't handle it

nameless
Bear Rating Master
Bear Rating Master
Posts: 126
Joined: 28 Aug 2013, 20:33

Re: Heads up: native fulltext search on pgsql

Postby nameless » 04 Aug 2015, 19:40

i dunno, its a pretty big machine.
i still got two cores almost idling also theres still lots of ram unused.

edit: anyways i will the have the indexer running for some time. i still might go back to a backup tomorrow
is there a reason why the indexer did processing for 500 articles at once when i started and now dropped to one article?

User avatar
sleeper_service
Bear Rating Overlord
Bear Rating Overlord
Posts: 884
Joined: 30 Mar 2013, 23:50
Location: Dallas, Texas

Re: Heads up: native fulltext search on pgsql

Postby sleeper_service » 04 Aug 2015, 22:10


pcause
Bear Rating Master
Bear Rating Master
Posts: 144
Joined: 23 Aug 2013, 19:52

Re: Heads up: native fulltext search on pgsql

Postby pcause » 04 Aug 2015, 22:23


User avatar
fox
^ me reading your posts ^
Posts: 6318
Joined: 27 Aug 2005, 22:53
Location: Saint-Petersburg, Russia
Contact:

Re: Heads up: native fulltext search on pgsql

Postby fox » 04 Aug 2015, 23:51

it took me maybe about 15 minutes on a shitty vm with about 200k articles

it should be running by 500 idk (if there's enough of them left without indexes)

nameless
Bear Rating Master
Bear Rating Master
Posts: 126
Joined: 28 Aug 2013, 20:33

Re: Heads up: native fulltext search on pgsql

Postby nameless » 05 Aug 2015, 01:23


User avatar
fox
^ me reading your posts ^
Posts: 6318
Joined: 27 Aug 2005, 22:53
Location: Saint-Petersburg, Russia
Contact:

Re: Heads up: native fulltext search on pgsql

Postby fox » 05 Aug 2015, 01:51

keep us informed

User avatar
sleeper_service
Bear Rating Overlord
Bear Rating Overlord
Posts: 884
Joined: 30 Mar 2013, 23:50
Location: Dallas, Texas

Re: Heads up: native fulltext search on pgsql

Postby sleeper_service » 05 Aug 2015, 02:20


nameless
Bear Rating Master
Bear Rating Master
Posts: 126
Joined: 28 Aug 2013, 20:33

Re: Heads up: native fulltext search on pgsql

Postby nameless » 05 Aug 2015, 13:38



Return to “Development”

Who is online

Users browsing this forum: No registered users and 3 guests