Re: Out of Memory

On Tue, 25 Sep 2018 11:34:19 -0700 (MST) greigwise wrote: > Well, I've been unsuccessful so far on creating a standalone test. > > I have put some scripting in place to capture some additional information on > the server with the out of memory issues. I have a script which just > periodical

Re: How to find the hits on the databases and tables in Postgres

On Fri, 4 May 2018 17:14:39 +0530 nikhil raj wrote: > Hi, > Any one can please help me out > > How to monitor the Hits on database and how many hits on each user tables > Through query. > Is there any other tools for that so it can full fill my requirement for it pgBadger has always been my go

Re: Using enum instead of join tables

On Tue, 10 Apr 2018 11:24:49 +0100 hmidi slim wrote: > Hi, > Is it a good thing to use enum type such a column in a table instead of > making a foreign key which references to another table? > I found these links talking about enum and when I will use them: > http://komlenic.com/244/8-reasons-why

Re: Not sure if I should CREATE INDEX for text columns on which I plan to filter later

On Fri, 23 Feb 2018 17:10:56 +1300 David Rowley wrote: > On 23 February 2018 at 04:00, Bill Moran wrote: > > 2) The negative impact of an unused index is tiny compared to the negative > > impact of a missing index. > > I'd say that would entirely depend on the workload of the table and > the e

Re: Performance issues during backup

On Fri, 23 Feb 2018 01:46:22 + Dylan Luong wrote: > Hi > Thanks for the rely. > I have trialed the ionice -c 2 -n 7 tar…. change to our backup script and it > appears to have helped but not by much. If "ionice -c 2 -n 7" helped some, maybe try "ionice -c 3" to set IO priority to the lowest

Re: query performance

On Sun, 18 Feb 2018 00:35:18 +0100 hmidi slim wrote: > Hi, > I have two tables: establishment which contains these columns: id, name, > longitude, latitude, geom (Geometric column) > Product contains: id, name, establishment_id > First of all I want to select the establishment within a radius. >

Re: query's performance

On Thu, 15 Feb 2018 22:43:59 +0100 hmidi slim wrote: > Hi, > I have a table establishment which contains these columns: id, name, > longitude, latitude. > I want to select all the establishments in the table establishment within a > radius from a reference point which is a given establishment. >

Re: Can parallel vacuum commands lead to a lock in Postgres 10.2

On Thu, 15 Feb 2018 17:40:48 +0100 Meikel Bisping wrote: > Hello, > > we have lots of scripts which issue individual vacuum commands to tables > like "vacuum full gxstage_bs" but also general "vaccum full" commands. > Until now these scripts run sequentially and there are no problems. > Now the

Re: best way to storing logs

On Tue, 30 Jan 2018 00:38:02 +0300 Ibrahim Edib Kokdemir wrote: > Hi, > In our environment, we are logging "all" statements because of the security > considerations (future auditing if necessary). But the system is very big > and produces 100GB logs for an hour and we expect that this will be muc

Re: Adding an extra boolean column to "information_schema.columns" or "pg_attribute"

On Sat, 30 Dec 2017 20:33:28 +0100 GPT wrote: > Please visit the following link: > > https://stackoverflow.com/q/48028501/8895614 > > but thing may go further/deeper than it seems. Adding columns to a built-in system table is liable to cause all sorts of problems in the future: when you upgrad