Re: [GENERAL] delete a file everytime pg server starts/crashes

> > On Thu, Oct 5, 2017 at 10:04 AM, athinivas wrote: > >> Hi, >> >> I'm having a requirement to delete a file in system whenever pg server is >> started/crashed. Any idea? >> >> Thanks, >> Athi >> >> If you’re running on Linux you can modify the init.d (or service) file and

[GENERAL] Prudent practices for PostgreSQL disk configuration?

Hello: I’m about to upgrade my disk configuration and looking for prudent disk configuration practices for running PostgreSQL 9.3 on RHEL6 in a VMWare environment in a shared hosting facility — physical disk not SSD. This is a write-heavy transactional application. 8 Cpu cores (if it matters)

Re: [GENERAL] PostgreSQL Developer Best Practices

On Sat, Aug 22, 2015 at 11:46 AM, Karsten Hilbert karsten.hilb...@gmx.net wrote: 1. Prefix ALL literals with an Escape EG: SELECT E'This is a \'quoted literal \''; SELECT E'This is an unquoted literal'; Doing so will prevent the annoying WARNING: nonstandard use of

Re: [GENERAL] On using doubles as primary keys

On Fri, Apr 17, 2015 at 11:56 AM, David G. Johnston david.g.johns...@gmail.com wrote: ​ MD ​ I'm not sure what you mean by doubles. Do you mean bigint data type, or do you mean use two columns for a primary key? Either way it's pretty simple. ​ MD ​ If you mean a bigint, then probably

[GENERAL] Database performs massive reads when I'm doing writes.

identifying the root cause of this problem. Thanks. --Ray -- Ray Cote, President Appropriate Solutions, Inc. We Build Software www.AppropriateSolutions.com 603.924.6079 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make

Re: [GENERAL] Database performs massive reads when I'm doing writes.

- Original Message - From: bricklen brick...@gmail.com To: Ray Cote rgac...@appropriatesolutions.com Cc: pgsql-general@postgresql.org Sent: Thursday, June 6, 2013 3:44:04 PM Subject: Re: [GENERAL] Database performs massive reads when I'm doing writes. On Thu, Jun 6, 2013 at 9:53

Re: [GENERAL] Database performs massive reads when I'm doing writes.

of read activity. The load_rets.py task is the Python script loading the database. --Ray - Original Message - From: Jeff Janes jeff.ja...@gmail.com To: Ray Cote rgac...@appropriatesolutions.com Cc: pgsql-general@postgresql.org Sent: Thursday, June 6, 2013 4:05:28 PM Subject: Re

Re: [GENERAL] Database performs massive reads when I'm doing writes.

everyone sent me. Learned a lot about Postgresql today. --Ray - Original Message - From: Ray Cote rgac...@appropriatesolutions.com To: Jeff Janes jeff.ja...@gmail.com Cc: pgsql-general@postgresql.org Sent: Thursday, June 6, 2013 5:12:51 PM Subject: Re: [GENERAL] Database performs massive

Re: [GENERAL] Database performs massive reads when I'm doing writes.

- Original Message - From: Jeff Janes jeff.ja...@gmail.com To: Ray Cote rgac...@appropriatesolutions.com Cc: pgsql-general@postgresql.org Sent: Thursday, June 6, 2013 5:41:00 PM Subject: Re: [GENERAL] Database performs massive reads when I'm doing writes. On Thu, Jun 6, 2013 at 2