spectrogram index?
Hello, please can you help me? I like to build a little service aka Shazam. Does exists audio spectrogram / fuzzy matching index or library API? Thank you. Roberto Della Pasqua www.dellapasqua.com<http://www.dellapasqua.com>
R: Postgresql 12.x on Windows (vs Linux)
Well, on Windows you should try ReiserFS over a nvme optimized WHQL certified hardware. Da: Robert Ford Inviato: lunedì 2 marzo 2020 15:42 A: pgsql-general@lists.postgresql.org Oggetto: Postgresql 12.x on Windows (vs Linux) I am aware that this might be a broad question, but I am not expecting very specific answers either: When it come to running a modern PostgreSQL server, which serves say 1 TB of data, are there substantial differences in performance between Windows Server 2019 and Linux today? I know there are some issues with shared_buffers and windows, but does it manifest in real performance issues? I have searched the web for this question, but is surprised to find very few concrete benchmarks on this. Anyone with real world experience on this topic? best regards RF
dbeaver
Hello, please some questions about a newbie Postgresql user: - what is the best method to keep the data replicated (for backup purposes): Can be possible to deploy a master/slave with realtime data replication and adding a storage where do a journaled backup of the database, eg. a backup incremental or GTF schema files? Which commands works better at low level for background backup/restore? - does dbeaver is a good frontend for pg administration? Roberto Della Pasqua www.dellapasqua.com
R: dbeaver
On 4/1/20 9:17 AM, Roberto Della Pasqua wrote: > Hello, please some questions about a newbie Postgresql user: > > - what is the best method to keep the data replicated (for backup purposes): > Can be possible to deploy a master/slave with realtime data replication and > adding a storage where do a journaled backup of the database, eg. a backup > incremental or GTF schema files? Which commands works better at low level for > background backup/restore? The above is book in itself. To help more information is needed: Postgres version(s) involved? LATEST VERSION 12 Size of dataset? 1 million of records (varchar mainly x 10 columns) OS(es) involved? ClearLinux, XFS over nvmexpress Network distance between master standby(s)? Same network, 1Gbps, 1msec Does exist a common set of configurations to make the "select" op quicker? Does PG support in-memory tables (disk persisted) as MSSQL? For some high level overview: https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.postgresql.org%2Fdocs%2F12%2Fdifferent-replication-solutions.html&data=02%7C01%7C%7C2733978376ec4315c8a808d7d659978f%7C84df9e7fe9f640afb435%7C1%7C0%7C637213552584407018&sdata=naRegPRNIXs1zwv5I4K3o290qNQuxYLnz6Y3ocPJBn4%3D&reserved=0 https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.postgresql.org%2Fdocs%2F12%2Fhigh-availability.html&data=02%7C01%7C%7C2733978376ec4315c8a808d7d659978f%7C84df9e7fe9f640afb435%7C1%7C0%7C637213552584407018&sdata=cw%2Bk%2F1ifbZaOULKZpwdLRrbhjo1K7Vn58VOhx%2FkiUsk%3D&reserved=0 https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.postgresql.org%2Fdocs%2F12%2Fapp-pgdump.html&data=02%7C01%7C%7C2733978376ec4315c8a808d7d659978f%7C84df9e7fe9f640afb435%7C1%7C0%7C637213552584417025&sdata=vC8CAR8sCuTmhIEjNG9I7b51jLs0PwiDvu6kkCzxMWI%3D&reserved=0 https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.postgresql.org%2Fdocs%2F12%2Fapp-pgrestore.html&data=02%7C01%7C%7C2733978376ec4315c8a808d7d659978f%7C84df9e7fe9f640afb435%7C1%7C0%7C637213552584417025&sdata=MNyfy9r7Bp67vzoGWdHVM3nug7YMZ%2F1%2Fugyb6EnZ9vE%3D&reserved=0 > - does dbeaver is a good frontend for pg administration? I use the Postgres client psql for administration. I rarely use GUI frontends so I can't comment on DBeaver. > > Roberto Della Pasqua > https://nam02.safelinks.protection.outlook.com/?url=www.dellapasqua.co > m&data=02%7C01%7C%7C2733978376ec4315c8a808d7d659978f%7C84df9e7fe9f > 640afb435%7C1%7C0%7C637213552584417025&sdata=LPtWHn7e6 > at%2BvpLaIXEqn2yDcQuicRQd3UZ4RCu%2BZQ4%3D&reserved=0 > -- Adrian Klaver adrian.kla...@aklaver.com
full text
Please sorry because I'm newbie of PGSQL I need the best performing and overall quality full-text search, can be possible to have the data stored in pgsql and the index to elasticsearch? Can be in sync between? Thank you Btw. Do you suggest another engine than elastic? Roberto Della Pasqua www.dellapasqua.com<http://www.dellapasqua.com>
