Am 10.02.2017 um 09:16 schrieb Mark Morgan Lloyd:
> On 09/02/17 23:00, Christoph Moench-Tegeder wrote:
>> ## Thomas Güttler (guettl...@thomas-guettler.de):
>>
>>> Is running linux with postgres on eMMC a bad idea in general?
>>
>> I'd say that running anything with a read-write load on eMMC will
>
https://www.youtube.com/watch?v=8mKpfutwD0U&t=1741s
Somewhere around 13th minute, Chris Tavers mentions this:
1 - In the queuing table, the application deletes lot of rows (typical for a
queuing table).
2 - Query trying to find out rows to be picked by the queue, accesses them via
indexes.
3 -
On Sun, Feb 19, 2017 at 1:19 AM, Sachin Srivastava
wrote:
> Thanks Alvaro for your suggestion !!
>
> Regards,
> Sachin Srivastava
> Mb.: 9811149139
>
>
>
> On Sun, Feb 19, 2017 at 11:40 AM, Alvaro Aguayo Garcia-Rada <
> aagu...@opensysperu.com> wrote:
>
>> Cleaning pg_log should be enough to be a
> On 02/18/2017 02:06, Tomas Vondra wrote:
>
> What do you mean by "became unavailable"? The restore_command may be called
> for segments that do not exist - that's expected, and I suspect the "gzip:
> stdin: unexpected end of file" error messages are caused by that.
>
Sorry for my unclear de
Hi Charles,
Your example worked just fine.
Thank you.
-Original Message-
From: Charles Clavadetscher [mailto:clavadetsc...@swisspug.org]
Sent: Sunday, February 19, 2017 2:04 PM
To: 'Ertan Küçükoğlu' ;
pgsql-general@postgresql.org
Subject: RE: [GENERAL] Listing missing records
As sugge
As suggested
> -Original Message-
> From: pgsql-general-ow...@postgresql.org
> [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Ertan Küçükoglu
> Sent: Sonntag, 19. Februar 2017 11:27
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] Listing missing records
>
> Hello,
>
>
On 2/19/2017 2:26 AM, Ertan Küçükoğlu wrote:
What I am looking for is a list of serial, branchcode , date columns just
for the missing days.
so are there other tables with all the valid serial, branchcode values ?
finding missing values generally revolves around doing an anti-join
('NOT IN')
Hello,
Using PostgreSQL 9.6.1 on a Windows 10 64bit, EnterpriseDB binaries.
I have following table:
CREATE TABLE report
(
id uuid NOT NULL,
no smallint NOT NULL,
serial character varying(15) NOT NULL,
branchcode character varying(10) NOT NULL,
date timestamp without time zone
