Re: [PERFORM] Server slowing down over time

Could you check pg_locks table to see if there's any major difference between "healthy" state and "slowing down" state? On 3 September 2015 at 21:07, Igor Neyman wrote: > > > > > *From:* pgsql-performance-ow...@postgresql.org [mailto: > pgsql-performance-ow...@postgresql.org] *On Behalf Of *Jean

Re: [PERFORM] query with pg_trgm sometimes very slow

On Wed, Sep 2, 2015 at 4:29 PM, Jeff Janes wrote: > 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)::tex

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

With server configuration and application functional we cannot conclude postgresql.conf, application behavior need to consider(mandatory) but, can give some ideal way of calculation 1) shared_buffers can be 7-8% of database size under condition having proper indexes with size not greater then 10-

Re: [PERFORM] Server slowing down over time

From: pgsql-performance-ow...@postgresql.org [mailto:pgsql-performance-ow...@postgresql.org] On Behalf Of Jean Cavallo Sent: Thursday, August 27, 2015 1:21 PM To: pgsql-performance@postgresql.org Subject: [PERFORM] Server slowing down over time Hi, I am currently working on a data migration fo