Re: [ODBC] [GENERAL] ODBC constructs

2013-05-20 Thread Heikki Linnakangas
On 21.05.2013 08:11, Dev Kumkar wrote: On Mon, May 20, 2013 at 9:12 PM, Atri Sharma wrote: If you wish to work in C,then,I would suggest libpq.I would wait for more replies on this,as I have little knowledge about psqlODBC. Thanks for the comments. Yes objective is to work in C and found l

Re: [GENERAL] ODBC constructs

2013-05-20 Thread Guy Rouillier
On 5/21/2013 1:11 AM, Dev Kumkar wrote: Thanks for the comments. Yes objective is to work in C and found libpq useful but am not sure about psqlODBC. It would be really great to get comments from community here regarding comparison between both of them and also performance perspective. Based on

Re: [GENERAL] ODBC constructs

2013-05-20 Thread John R Pierce
On 5/20/2013 11:04 PM, Atri Sharma wrote: Also,is it only me,or are we all a bit wary of ODBC? its clumsy.getting software working well with it requires more work. its promise of portability only holds true if you restrict yourself to SQL that works the same on different servers, and if

Re: [GENERAL] Cross compile custom data types for Linux and windows

2013-05-20 Thread John R Pierce
On 5/20/2013 10:58 PM, Daniel Migowski wrote: I intend to create some native data types for PostgreSQL, but since our servers run on Windows and Linux, I would have to compile the libraries for Windows and for Linux (will need nothing else than the standard C libs). Our build server is a Debian

Re: [GENERAL] ODBC constructs

2013-05-20 Thread Atri Sharma
Sent from my iPad On 21-May-2013, at 11:24, John R Pierce wrote: > libpq lets you talk directly to postgres in its native tongue. > > ODBC implements a sort of abstraction. IMHO, its like trying to type with > mittens on. > Also,I see no point in working using ODBC with Postgres if you

[GENERAL] Cross compile custom data types for Linux and windows

2013-05-20 Thread Daniel Migowski
Hello, I intend to create some native data types for PostgreSQL, but since our servers run on Windows and Linux, I would have to compile the libraries for Windows and for Linux (will need nothing else than the standard C libs). Our build server is a Debian 6 Linux system. Is there a way to also

Re: [GENERAL] ODBC constructs

2013-05-20 Thread John R Pierce
On 5/20/2013 10:11 PM, Dev Kumkar wrote: On Mon, May 20, 2013 at 9:12 PM, Atri Sharma > wrote: If you wish to work in C,then,I would suggest libpq.I would wait for more replies on this,as I have little knowledge about psqlODBC. Thanks for the comments.

Re: [GENERAL] ODBC constructs

2013-05-20 Thread Dev Kumkar
On Mon, May 20, 2013 at 9:12 PM, Atri Sharma wrote: > > If you wish to work in C,then,I would suggest libpq.I would wait for more > replies on this,as I have little knowledge > about psqlODBC. > Thanks for the comments. Yes objective is to work in C and found libpq useful but am not sure about p

Re: [GENERAL] ODBC constructs

2013-05-20 Thread Atri Sharma
Sent from my iPad On 21-May-2013, at 6:15, Dev Kumkar wrote: > Hello, > > My objective is to work with postgres from my linux box using C. Am not sure > whether psqlODBC or libpq should be used. > I was playing and used libpq successfully but not sure which route to go and > whats the diffe

Re: [GENERAL] Deploying PostgreSQL on CentOS with SSD and Hardware RAID

2013-05-20 Thread Toby Corkindale
On 21/05/13 00:16, Merlin Moncure wrote: On Sun, May 19, 2013 at 8:07 PM, Toby Corkindale wrote: On 11/05/13 02:25, Merlin Moncure wrote: On Fri, May 10, 2013 at 11:11 AM, Evan D. Hoffman wrote: Not sure of your space requirements, but I'd think a RAID 10 of 8x or more Samsung 840 Pro 256/

Re: [GENERAL] Deploying PostgreSQL on CentOS with SSD and Hardware RAID

2013-05-20 Thread Toby Corkindale
On 20/05/13 15:12, David Boreham wrote: On 5/19/2013 7:19 PM, Toby Corkindale wrote: On 13/05/13 11:23, David Boreham wrote: btw we deploy on CentOS6. The only things we change from the default are: 1. add "relatime,discard" options to the mount (check whether the most recent CentOS6 does this

Re: [GENERAL] ODBC constructs

2013-05-20 Thread Dev Kumkar
Also adding the pgsql-admin alias. Regards...

Re: [GENERAL] ODBC constructs

2013-05-20 Thread Dev Kumkar
Hello, My objective is to work with postgres from my linux box using C. Am not sure whether psqlODBC or libpqshould be used. I was playing and used libpq successfully but not sure which route to go and whats the difference. Also Can you please

Re: [GENERAL] cal I pass arguments directly to final function in aggregates

2013-05-20 Thread Nicklas Avén
Thank you Tom On 05/19/2013 01:26 AM, Tom Lane wrote: =?UTF-8?B?Tmlja2xhcyBBdsOpbg==?= writes: Perhaps you could construct your usage like this: post_process_function(aggregate_function(...), fixed_argument) where the aggregate_function just collects the varying values and then the p

Re: [GENERAL] Why does row estimation on nested loop make no sense to me

2013-05-20 Thread Amit Langote
On Tue, May 21, 2013 at 12:43 AM, Jeff Amiel wrote: > Thanks much! > (sorry for top-posting, yahoo email sucks) > I wonder if you could arrive at some conclusions with the statistics (pg_stats) you have and the join selectivity formulas described in the referred documentation link. I would like t

Re: [GENERAL] Why does row estimation on nested loop make no sense to me

2013-05-20 Thread Jeff Amiel
Thanks much! (sorry for top-posting, yahoo email sucks) - Original Message - From: Amit Langote To: Jeff Amiel Cc: "dep...@depesz.com" ; "pgsql-general@postgresql.org" Sent: Monday, May 20, 2013 9:51 AM Subject: Re: [GENERAL] Why does row estimation on nested loop make no sense to

Re: [GENERAL] Why does row estimation on nested loop make no sense to me

2013-05-20 Thread Amit Langote
I also found one other discussion which has similar issues addressed: http://postgresql.1045698.n5.nabble.com/Bogus-nestloop-rows-estimate-in-8-4-7-td5710254.html -- Amit Langote -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://

Re: [GENERAL] Why does row estimation on nested loop make no sense to me

2013-05-20 Thread Amit Langote
On Mon, May 20, 2013 at 11:01 PM, Jeff Amiel wrote: > Ok - I agree - > > Can somebody help me understand where the row estimates come from on a > nested-loop operation in postgres then? > In case you haven't noticed already in the documentation, there are following lines: "... It might appear f

Re: [GENERAL] Deploying PostgreSQL on CentOS with SSD and Hardware RAID

2013-05-20 Thread Merlin Moncure
On Sun, May 19, 2013 at 8:07 PM, Toby Corkindale wrote: > On 11/05/13 02:25, Merlin Moncure wrote: >> >> On Fri, May 10, 2013 at 11:11 AM, Evan D. Hoffman >> wrote: >>> >>> Not sure of your space requirements, but I'd think a RAID 10 of 8x or >>> more >>> Samsung 840 Pro 256/512 GB would be the b

Re: [GENERAL] Why does row estimation on nested loop make no sense to me

2013-05-20 Thread Jeff Amiel
Ok - I agree - Can somebody help me understand where the row estimates come from on a nested-loop operation in postgres then? - Original Message - From: hubert depesz lubaczewski To: Jeff Amiel Cc: "pgsql-general@postgresql.org" Sent: Saturday, May 18, 2013 3:39 AM Subject: Re: [GE