[PERFORM] Server slowing down over time

Hi, I am currently working on a data migration for a client. The general plan is : - Read data from a postgresql database - Convert them to the new application - Insert in another database (same postgresql instance). The source database is rather big (~40GB, wo indexes), and the conversion

Re: [PERFORM] query with pg_trgm sometimes very slow

On Wed, Sep 2, 2015 at 7:00 AM, Volker Böhm wrote: > > > CREATE INDEX trgm_adresse ON adressen.adresse USING gist > (normalize_string((btrimnormalize_stringCOALESCE((vorname)::text, > ''::text) || ' '::text) || (name1)::text))::character varying, > (-1)))::text || ' '::text) || (nor

[PERFORM] query with pg_trgm sometimes very slow

Hi, I have a table for addresses: CREATE TABLE adressen.adresse ( pool_pk integer NOT NULL, adressnr_pk integer NOT NULL, anrede varchar(8), vorname varchar(50) DEFAULT ''::character varying NOT NULL, name1varchar(100)NOT NULL, na

[PERFORM] PostgreSQL Tuning for Messaging/Messenger/Chatting Application

Dear all, I have server as below: - OS Debian 7.0 (Wheezy) - CPU 24 cores - RAM 128GB - SSD 128GB - 1 Gigabit Ethernet I need to tune the Postgres with hardware specification above for my Messaging/Messenger/Chatting Application that will run separately in another server. Can you give me the rec