[GENERAL] COPY FROM STDIN

2016-01-04 Thread Luke Coldiron
Is there a way to achieve the performance of the COPY FROM STDIN command within a C extension function connected to the db connection that called the C function? I have text that I would like to receive as input to a C function that contains many COPY command statements in the file that would be

Re: [GENERAL] COPY FROM STDIN

2016-01-06 Thread Luke Coldiron
> On 1/4/16 12:18 PM, Luke Coldiron wrote: > > Is there a way to achieve the performance of the COPY FROM STDIN command > > within a C extension function connected to the db connection that called > > the C function? I have text that I would like to receive as input to

Re: [GENERAL] COPY FROM STDIN

2016-01-08 Thread Luke Coldiron
> On 1/6/16 9:45 PM, Luke Coldiron wrote: > > In the example above I'm not sure if I can use some sub struct of the > > SPIPlanPtr and hand it off to the DoCopy function as the CopyStmt or > > if I need to go about this entirely different. Any advice on the > >

[GENERAL] large table

2014-09-22 Thread Luke Coldiron
I am trying to figure out what would have caused a table in a PostgreSQL 8.4.16 to get into a state where there is only 1 live tuple and has only ever had one 1 tuple but the size of the table is huge. CREATE TABLE public.myTable( myColumn timestamp with time zone NOT NULL); Note: there is no

Re: [GENERAL] large table

2014-09-22 Thread Luke Coldiron
> > From: ahodg...@simkin.ca > > To: pgsql-general@postgresql.org > > Subject: Re: [GENERAL] large table > > Date: Mon, 22 Sep 2014 11:34:45 -0700 > > > > On Monday, September 22, 2014 11:17:05 AM Luke Coldiron wrote: > > > The actual size of the tab

Re: [GENERAL] large table

2014-09-22 Thread Luke Coldiron
> Date: Mon, 22 Sep 2014 14:38:52 -0400 > From: wmo...@potentialtech.com > To: lukecoldi...@hotmail.com > CC: pgsql-general@postgresql.org > Subject: Re: [GENERAL] large table > > On Mon, 22 Sep 2014 11:17:05 -0700 > Luke Coldiron wrote: > > > I am trying to fi

Re: [GENERAL] large table

2014-09-22 Thread Luke Coldiron
> Date: Mon, 22 Sep 2014 12:46:21 -0700 > From: pie...@hogranch.com > To: pgsql-general@postgresql.org > Subject: Re: [GENERAL] large table > > On 9/22/2014 12:33 PM, Luke Coldiron wrote: > > > > It is possible and that is part of what I am trying to discover