Re: [GENERAL] PostgreSQL Database performance

Hi. "shared_buffers" should be set to 30-40% of your system RAM. This param controls how much memory database may use. Please see https://www.postgresql.org/docs/9.1/static/runtime-config-resource.html Ilya Kazakevich JetBrains <http://www.jetbrai

Re: [GENERAL] Understanding Postgres Memory Usage

kernel). It will save you from OOM. If you face performance bottleneck after it, you fix it using tools like “log_min_duration_statement”, “track_io_timing” and system-provided tools. Ilya Kazakevich JetBrains <http://www.jetbrains.com/> http://www.jetbrains.co

Re: [GENERAL] pg_hba.conf : bad entry for ADDRESS

% psql --host=127.0.0.1/32 --dbname=mattermost --username=mmuser psql: could not translate host name "127.0.0.1/32" to address: Name or service not known % psql --host=127.0.0.1/24

Re: [GENERAL] pg_hba.conf : bad entry for ADDRESS

>How can I verify ? Can you connect as postgres (superuser)? If yes, connect and type "show hba_file;" If no, try adding "local all postgres peer" or even "local all postgres trust" to this file and restart postgres. Check again. -- Sent via pgsql-general mailing list

Re: [GENERAL] pg_hba.conf : bad entry for ADDRESS

>I entered this line in pg_hab.conf: Are you sure your file name is correct and it is really used by postgres? Ilya Kazakevich JetBrains http://www.jetbrains.com The Drive to Develop -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscript

Re: [GENERAL] question on error during COPY FROM

ilesystem but will be reused by database. You may run VACUUM FULL manually to return it to filesystem. https://www.postgresql.org/docs/9.1/static/routine-vacuuming.html Ilya Kazakevich JetBrains http://www.jetbrains.com The Drive to Develop -- Sent via pgsql-general mailing list (pgsql-general@postg

Re: [GENERAL] Sequential vs. random values - number of pages in B-tree

ld try) Better approach is to create index _after_ insertion, but it is not always possible. Ilya Kazakevich JetBrains http://www.jetbrains.com The Drive to Develop -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgres

Re: [GENERAL] Sequential vs. random values - number of pages in B-tree

g to huge data moving. https://en.wikipedia.org/wiki/B-tree#Insertions_and_deletions Ilya Kazakevich JetBrains http://www.jetbrains.com The Drive to Develop -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org

Re: [GENERAL] Permissions pg_dump / import

>> Owned by: public.accounts.id This is not owner but table this sequence depends on. See http://stackoverflow.com/questions/6941043/get-table-and-column-owning-a-sequence Use query provided on SO to get real owner Ilya Kazakevich JetBrains http://www.jetbrains.com

Re: [GENERAL] schema advice for event stream with tagging and filtering

d real-time data or, say, one-day old data is ok? In latter case it is better to load data to denormalized table to speed-up queries and use no index on normalized(OLTP) table because index update operation is not free) Ilya Kazakevich JetBrains http://www.jetbrains.com The Drive to Develop -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] schema advice for event stream with tagging and filtering

ut simple table with several columns and hstore field for tags? You may also normalize it (move hosts and categories to separate table). indexes should help you with fast filtering, or you may load data from this table to denormalized olap table once a day and build index there to speed-up qu

Re: [GENERAL] Looking for software to 'enqueue' connections

://wiki.postgresql.org/wiki/Bucardo) Ilya Kazakevich JetBrains <http://www.jetbrains.com/> http://www.jetbrains.com The Drive to Develop From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Edmundo Robles Sent: Monday, August 15, 2016 11:30 PM To: