!wtKWYahxzQAvirVEJG:matrix.org

pycsw

33 Members
2 Servers

Load older messages


SenderMessageTime
3 May 2021
@freenode_sigabrt:matrix.orgsigabrt joined the room.13:12:43
4 May 2021
@freenode_sigabrt:matrix.orgsigabrt left the room.13:12:02
@freenode_sigabrt:matrix.orgsigabrt joined the room.13:12:36
5 May 2021
@freenode_jmckenna:matrix.orgjmckenna left the room.01:35:11
@freenode_jmckenna:matrix.orgjmckenna joined the room.10:54:55
7 May 2021
@gitter-badger:gitter.immatrixbot (matrixbot) changed their display name from gitter-badger (The Gitter Badger) to matrixbot (matrixbot).05:42:12
@epifanio-531e6e9c5e986b0712efdca9:gitter.imepifanio (epifanio)

Hi,, I am tring to optimize a pycsw db using the command line tools - e.g.: pycsw-admin.py -c rebuild_db_indexes -f /etc/pycsw/pycsw.cfg

but it returns:

pycsw@98113894e734:~$ pycsw-admin.py -c rebuild_db_indexes -f /etc/pycsw/pycsw.cfg 
Traceback (most recent call last):
  File "/usr/local/bin/pycsw-admin.py", line 7, in <module>
    exec(compile(f.read(), __file__, 'exec'))
  File "/home/pycsw/pycsw/bin/pycsw-admin.py", line 281, in <module>
    admin.rebuild_db_indexes(DATABASE, TABLE)
  File "/home/pycsw/pycsw/pycsw/core/admin.py", line 486, in rebuild_db_indexes
    raise NotImplementedError
NotImplementedError

am I missing something, ot the functionality is not implemented?

13:29:04
@epifanio-531e6e9c5e986b0712efdca9:gitter.imepifanio (epifanio)Redacted or Malformed Event13:29:47
@tomkralidis-557c28e615522ed4b3e1db3b:gitter.imtomkralidis (Tom Kralidis) Looks like it’s really not implemented (contributions welcome), probably due to the complexity on the different backends. On PG you can run:
REINDEX TABLE my_table;
13:33:09
@epifanio-531e6e9c5e986b0712efdca9:gitter.imepifanio (epifanio) I will look into it thanks! 13:33:44
@epifanio-531e6e9c5e986b0712efdca9:gitter.imepifanio (epifanio) are the beckend only postgres amd sqlite, correct? 13:39:51
@tomkralidis-557c28e615522ed4b3e1db3b:gitter.imtomkralidis (Tom Kralidis) correct 13:44:58
@tomkralidis-557c28e615522ed4b3e1db3b:gitter.imtomkralidis (Tom Kralidis) in theory, anything that SQLAlchemy supports, but PostgreSQL and SQLite3 are the most used/tested/validated 13:45:41
@epifanio-531e6e9c5e986b0712efdca9:gitter.imepifanio (epifanio)

the syntax to run it should be the same via sqlalchemy orm
I executed:

psql -U postgis -d csw_db

and:

REINDEX TABLE records;
VACUUM(FULL, ANALYZE, VERBOSE) records;
13:49:06
@epifanio-531e6e9c5e986b0712efdca9:gitter.imepifanio (epifanio) i need some of my collegues to run some test on my testing endpoint .. but seems I no longer have the error in initializing the db 13:49:55
@epifanio-531e6e9c5e986b0712efdca9:gitter.imepifanio (epifanio) but I also added a postgresql.conf exposed as volume - with the instruction suggested by pgtune -- @tomkralidis thank you so much for the tips! 13:50:47
@freenode_jmckenna:matrix.orgjmckenna tomkralidis (Tom Kralidis): will fix backport.... 18:35:22
@freenode_jmckenna:matrix.orgjmckennamy fault18:35:23
@freenode_jmckenna:matrix.orgjmckennathanks man!18:35:25
10 May 2021
@freenode_sigabrt:matrix.orgsigabrt left the room.13:12:02
@freenode_sigabrt:matrix.orgsigabrt joined the room.13:12:41
@freenode_jmckenna:matrix.orgjmckenna left the room.15:34:54
@freenode_jmckenna:matrix.orgjmckenna joined the room.19:44:55
11 May 2021
@freenode_mgp:matrix.orgmgp left the room.03:33:39
@freenode_mgp:matrix.orgmgp joined the room.03:42:36
@epifanio-531e6e9c5e986b0712efdca9:gitter.imepifanio (epifanio) @tomkralidis testing the new addition for reindexing 09:48:32
@epifanio-531e6e9c5e986b0712efdca9:gitter.imepifanio (epifanio) thanks! 09:48:37
12 May 2021
@epifanio-531e6e9c5e986b0712efdca9:gitter.imepifanio (epifanio)Redacted or Malformed Event12:24:29
@epifanio-531e6e9c5e986b0712efdca9:gitter.imepifanio (epifanio) works great! just saw there is also the optimization -- would it make sense to have this exposed in the transaction API ? 12:25:56
@tomkralidis-557c28e615522ed4b3e1db3b:gitter.imtomkralidis (Tom Kralidis) what do you mean? 13:02:01

There are no newer messages yet.


Back to Room List