>
> 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
add a line to delete t
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)
Thi
On Sat, Aug 22, 2015 at 11:46 AM, Karsten Hilbert
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
> escape in a stri
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, t
- Original Message -
> From: "Jeff Janes"
> To: "Ray Cote"
> 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
leads everyone sent me.
Learned a lot about Postgresql today.
--Ray
- Original Message -
> From: "Ray Cote"
> To: "Jeff Janes"
> Cc: pgsql-general@postgresql.org
> Sent: Thursday, June 6, 2013 5:12:51 PM
> Subject: Re: [GENERAL] Database performs massive
of read activity.
The load_rets.py task is the Python script loading the database.
--Ray
- Original Message -
> From: "Jeff Janes"
> To: "Ray Cote"
> Cc: pgsql-general@postgresql.org
> Sent: Thursday, June 6, 2013 4:05:28 PM
> Subject: Re: [GENER
- Original Message -
> From: "bricklen"
> To: "Ray Cote"
> 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
pointers as to how I go about 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-g
