Re: [GENERAL] question about varchar

2012-12-18 Thread Gavan Schneider
On Tuesday, December 18, 2012 at 10:15, Rui Li wrote: /* ** text 'cleaned' to remove message digest cruft ** apologies for any errors */ In postgresql, we can create column as varchar(n)=94 where n is the sizeof the char, or we can just define column as varchar=94 rli=3D# CREATE T

[GENERAL]

2012-12-18 Thread News Subsystem
Tue, 18 Dec 2012 15:15:41 -0800 (PST) Received: by 10.50.5.174 with SMTP id t14mr1993997igt.11.1355872541437; Tue, 18 Dec 2012 15:15:41 -0800 (PST) X-Newsgroups: pgsql.general Date: Tue, 18 Dec 2012 15:15:41 -0800 (PST) Complaints-To: groups-ab...@google.com Injection-Info: glegroupsg2000g

[GENERAL] can one speed up a custom aggregate by using native ones

2012-12-18 Thread Rhys A.D. Stewart
Greetings, I have an aggregate function which basically concatenates a whole bunch of rows (that would be the sfunc) and then wraps it in a header and footer (the finalunc). It is however for fairly large set many orders of magnitude slower than running string_agg and then the finalfunc. Is the

Re: [GENERAL] data type - import problem

2012-12-18 Thread Steve Crawford
On 12/17/2012 05:46 PM, Adrian Klaver wrote: On 12/17/2012 05:30 PM, Kirk Wythers wrote: Thanks. Is there a way to use the float4 data type for a variable when empty records contain "NA", instead of nothing? As you can see below the variable "A_TC_AVG1" has the first record filled with "NA" sig

Re: [GENERAL] evaluating expressions stored in table

2012-12-18 Thread Joe Conway
On 12/18/2012 08:50 AM, Merlin Moncure wrote: > On Tue, Dec 18, 2012 at 10:03 AM, Little, Douglas > Anybody have any comments? > > probably you need a pl/pgsql function which wraps your argument table, > builds the query, and invokes the query with EXECUTE. For an example see slide 19 here: h

Re: [GENERAL] evaluating expressions stored in table

2012-12-18 Thread Merlin Moncure
On Tue, Dec 18, 2012 at 10:03 AM, Little, Douglas wrote: > Hi, > > ** ** > > I need to evaluate an expression that I have stored in a table, and not > sure how to force evaluation of a column value. > > ** ** > > Some background. This is a generic testing application that we’re using >

[GENERAL] evaluating expressions stored in table

2012-12-18 Thread Little, Douglas
Hi, I need to evaluate an expression that I have stored in a table, and not sure how to force evaluation of a column value. Some background. This is a generic testing application that we're using to test source to target ETL's. The specifics of the test expression depend on the actual tables

Re: [GENERAL] Moving some of Postgres off a SSD

2012-12-18 Thread Christoph Berg
Re: Robert James 2012-12-18 > I have Postgres running on a SSD. The data is now almost 50GB, which > is filling up the drive. > > How can I move some of the data to my HDD? Use a TABLESPACE. Christoph -- c...@df7cb.de | http://www.df7cb.de/ -- Sent via pgsql-general mailing list (pgsql-ge

[GENERAL] Moving some of Postgres off a SSD

2012-12-18 Thread Robert James
I have Postgres running on a SSD. The data is now almost 50GB, which is filling up the drive. How can I move some of the data to my HDD? My priorities are, in this order: 1. Reliable - I don't want anything that will corrupt the data 2. Easy - I have a few dozen databases, I don't want to do too

[GENERAL] Re: [COMMITTERS] pgsql: Allow a streaming replication standby to follow a timeline switc

2012-12-18 Thread hubert depesz lubaczewski
On Mon, Dec 17, 2012 at 02:01:20PM +0200, Heikki Linnakangas wrote: > Hmm, is it possible that some WAL was generated in the old master, > and streamed to the standby, after the new master was already > promoted? It's important to kill the old master before promoting the > new master. Otherwise the